| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKBIXPABIT_REL | Release Order for Partner BITs for Billing | 3 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
2 | DFKKINVBILL_AD | Discount: Additional Items of Billing Document | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
3 | DFKKINVBILL_REV | Reversal Request for Billing Document | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
4 | DFKKINVBILL_X | Object Relationships for Billing Document | 5 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
5 | DFKKPARTREL | Release Order of Partner Items for Partner Settlement | 3 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
6 | DFMCA_OBT_HIS | Storage of Lean Trace history for object based tax | 3 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
TOPBilling in Contract Accounts Receivable and Payable |
7 | DFKKBIBILLACC_B | Billing Account Billing History | 3 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
8 | DFKKBIBILLACC_FI | Billing Account Facts Items | 15 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
TOPGrantor Management |
9 | GTRFIBILLREL | Relationship Table Grantor Billing Doc <-> AP/AR Doc | 5 | BILLDOCNO | Grantor Billing Doc Number | nvarchar | 12 | 0 | | |
10 | GTRFIBILL_H | Header of Grantor FI AP/AR Billing Doc | 2 | BILLDOCNO | Grantor Billing Doc Number | nvarchar | 12 | 0 | | |
11 | GTRFIBILL_HT | Grantor FI AP/AR Billing Doc Header Text Table | 3 | BILLDOCNO | Grantor Billing Doc Number | nvarchar | 12 | 0 | | |
12 | GTRFIBILL_I | Grantor Billing Document Items | 2 | BILLDOCNO | Grantor Billing Doc Number | nvarchar | 12 | 0 | | |
13 | GTRFIBILL_IT | Grantor FI AP/AR Billing Doc Header Text Table | 3 | BILLDOCNO | Grantor Billing Doc Number | nvarchar | 12 | 0 | | |
TOPInvoicing |
14 | DBEOSB | IS-U On-Site Billing | 6 | BILLDOCNO | Number of a billing document | nvarchar | 12 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
15 | DFKKINVBILL_A | Additional Items of Billing Document | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
16 | DFKKINVBILL_H | Billing Document Header | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
17 | DFKKINVBILL_I | Billing Document Items | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
18 | DFKKINVBILL_PY | Payment Data Items of Billing Document | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
19 | DFKKINVBILL_R | Reversal Data for Billing Document | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
20 | DFKKINVBILL_S | Source Items in Billing Document | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
21 | DFKKINVBILL_T | Tax Items of Billing Document | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
22 | DFKKPREPACC_BALT | Obsolete | 3 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
23 | FKKPREPACC_BALT | Update Requests for Balance Carryfwd for Prepaid Account | 4 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
24 | DFMCA_INV_TXT_PA | Text Parameter for Additional Item on Billing Documents | 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |
TOPSocial Services and Social Security |
25 | PSSCD_NCD | Net Calculation Document Header Data | 16 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | | |