Report on old tickets of Kingdee Industry

I. Basic Document Template
1. ictransactiontype: This table reflects the overall situation of all documents of the supply chain.
2. icclasstype: Document category table
3. ictemplate: This table reflects the details of the headers of all documents.
4. ictemplateentry: This table reflects the details of the entries in all documents.
Ii. Document menu Template
1. icselbills: The table that records the relationship between menus. What values should be obtained in the menu, how these values come from, and the corresponding control to which they should be refilled.
2. ictablerelation: the connection relationship between all tables in the menu.
3. icwritebacktemplate: reverse write table for document Backfilling
4. iclisttemplate: document list template
5. icclasslink: Document process definition table
Iii. Document Control
1. icbillno document number table
2. icmaxnum maximum document internal code (finterid) number table
Iv. Document Packaging
1. glnotetype: form a document, and record the relationship between the document and the document number.
2. glnotecitation.
V. Document sequence table
1. icchatbilltitle: Document sequence table
I. Introduction to the industrial documents
1. ictransactiontype
2. Document Template table ictemplate
3. ictemplateentry
4. sequence book template iclisttemplate
5. icchatbilltitle
6. ictablerelation
7. Menu template table (corresponding relationship table containing data between documents when using the menu) icselbills
8. Table description table t_tabledescription
9. Field description table t_fielddescription
10. The credential amount comes from icvouchertfield
11. Description of the Appendix to the accounting project t_itempropdesc
12. glnotecitation
Note:
I. The custom information of Industrial documents is stored in ictemplate and ictemplateentry, And the custom menu relationship is defined in icselbills and ictablerelation tables. The menu template table defines the correspondence between the table and field of the source ticket and the target document to write the source ticket information to the target document.
2. II. Basic relationships
Ictransactiontype. ftemplateid = ictemplate. FID
Ictemplate. FID = ictemplateentry. FID
Ictemplateentry. ffieldname = icselbills. ffieldname
Icselbills. FID = ictablerelation. fbillid
Icselbills. ffieldname = ictablerelation. ffieldid
13. Receiving and picking tickets: icstockbill and icstockbillentry;
14. Purchase invoice: icpurchase and icpurchaseentry;
15. Sales invoices: icsale and icsaleentry;
16. Purchase orders: poorder and poorderentry;
17. Sales Orders: seorder and seorderentry;
18. Logistics document encoding rules: icbillno
19. Schedule of the internal code of the document: icmaxnum
Note: In the icbillno table, the system uses the fcurno field of this table to track the "document number progress" of various transaction types of documents, so that the document number can be automatically added 1 when the next new document is added. In the icmaxnum table, the fmaxnum field is the current maximum ID. Icbillno. fcurno and icmaxnum. fmaxnum fall behind with the actual document Code The internal code will cause the document to be unable to be saved. The prompt "pk_xxxx is repeated and the duplicate value cannot be inserted in the XXXX table" or the prompt "Cannot delete the reviewed document"
20. Document hooks: ichookrelations
21. fhooktype: 0. write off the purchase invoice and purchase warehouse receiving ticket;
1. Write off the sales invoice and sales order;
2. Fee invoice and off-warehouse receiving;
3. Procurement peer verification;
4 Sales peer verification;
5. write off procurement invoices and outsourced warehouse receiving orders;
22. Fiber Tag: 0 purchase and sales invoice;
1. warehouse receiving and picking ticket;
2. Invoice
23. fequityhook:
0 is non-peer verification;
1 peer verification
Note: The main issue of writing off is that ichookrelations lose the write-off relationship or the relationship ID of the document is lost. You need to write SQL queries based on the preceding description and different situations.