| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Interface |
1 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 301 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
2 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 301 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
TOPAdvertising Management |
3 | JHAGA2 | IS-M/AM: JHAGA Enhancement | 16 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
4 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 56 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
TOPBank Accounting |
5 | BSEGC | Document: Data on Payment Card Payments | 14 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
6 | TCCLG | Payment Cards: Settlement Run Log | 7 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
TOPContract Accounts Receivable and Payable |
7 | DFKKEXC_PAYINFO | Information for Payment Medium | 21 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
8 | DFKKOPC | Card Data Supplement for Business Partner Item | 16 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
9 | DFKKOPKC | Card Data Appendix for FICA Document | 16 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
10 | DFKK_PCARD | Card Data Supplement | 15 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
TOPPayment Cards |
11 | FPLTC | Payment cards: Transaction data - SD | 12 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
TOPPeriodical Sales and Distribution |
12 | JFRKCC | IS-M/SD: Billing - Payment Card Data | 12 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |
13 | JKAPCC | Sales Order: Payment Card Data | 13 | CCWAE | Currency Key | nvarchar | 5 | 0 | | |