| 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) | 304 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
2 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 304 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
TOPAdvertising Management |
3 | JHAGA2 | IS-M/AM: JHAGA Enhancement | 18 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
4 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 58 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
5 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 76 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
TOPBank Accounting |
6 | BSEGC | Document: Data on Payment Card Payments | 17 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
TOPContract Accounts Receivable and Payable |
7 | DFKKEXC_PAYINFO | Information for Payment Medium | 16 | AUTRA | Payment Cards: Authorization Reference Number | nvarchar | 25 | 0 | | |
8 | DFKKOPC | Card Data Supplement for Business Partner Item | 11 | AUTRA | Payment Cards: Authorization Reference Number | nvarchar | 25 | 0 | | |
9 | DFKKOPKC | Card Data Appendix for FICA Document | 11 | AUTRA | Payment Cards: Authorization Reference Number | nvarchar | 25 | 0 | | |
10 | DFKK_PCARD | Card Data Supplement | 10 | AUTRA | Payment Cards: Authorization Reference Number | nvarchar | 25 | 0 | | |
TOPMedia Sales and Distribution |
11 | /NAM/PAY_CC | Workload for Credit Card Payment | 28 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
TOPPayment Cards |
12 | FPLTC | Payment cards: Transaction data - SD | 15 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
TOPPeriodical Sales and Distribution |
13 | JFRKCC | IS-M/SD: Billing - Payment Card Data | 15 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
14 | JKAPCC | Sales Order: Payment Card Data | 16 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
15 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 102 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |
16 | JKWWWTEMP_PAY | IS-M: Temporary Internet Table: Payment Data Change | 28 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | |