| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPublic Sector Contract Accounts Receivable and Payable |
1 | DFMCAINV | Invoice in IS-PS-CA: Header Data | 3 | INVTP | Invoice Type | nvarchar | 2 | 0 | | |
2 | DPSOB_BP_ACC | Data for Contract Object for Each Partner & Cont. Acct Cat. | 40 | INVTP | Invoice Type | nvarchar | 2 | 0 | | |
3 | TFICA_DEF | Samples for Contract Account Types | 53 | INVTP | Invoice Type | nvarchar | 2 | 0 | | |
4 | TFMCA003 | Invoice Types | 2 | INVTP | Invoice Type | nvarchar | 2 | 0 | | |
5 | TFMCA003T | Invoice Types Texts | 3 | INVTP | Invoice Type | nvarchar | 2 | 0 | | |
6 | TPSOB_DEF | Samples for Contract Object Types | 25 | INVTP | Invoice Type | nvarchar | 2 | 0 | | |
TOPSales and Distribution |
7 | IDCN_DOTY | Country-Specific Document Classes | 3 | INVTP | Form Type | nvarchar | 2 | 0 | | |
8 | IDCN_DOTYT | Country-Specific Document Classes - Texts | 4 | INVTP | Form Type | nvarchar | 2 | 0 | | |
9 | IDCN_LOMA | Lots for Prenumbered Documents | 4 | INVTP | Form Type | nvarchar | 2 | 0 | | |