| 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) | 303 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
2 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 303 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
3 | JHAGA2 | IS-M/AM: JHAGA Enhancement | 17 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
4 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 57 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
5 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 75 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
TOPBank Accounting |
6 | BSEGC | Document: Data on Payment Card Payments | 16 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
7 | ITAGCYPYMETSET | Setting Payment Methods in Agency Collections | 16 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
8 | DFKKEXC_PAYINFO | Information for Payment Medium | 15 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | |
9 | DFKKIP_GRP | Payment Specification: Header Data | 49 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | |
10 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 51 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | |
11 | DFKKOPC | Card Data Supplement for Business Partner Item | 10 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | |
12 | DFKKOPKC | Card Data Appendix for FICA Document | 10 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | |
13 | DFKKZP | Payment lot: Data for payment | 66 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | |
14 | DFKK_PCARD | Card Data Supplement | 9 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | |
TOPMedia Sales and Distribution |
15 | /NAM/PAY_CC | Workload for Credit Card Payment | 22 | AUNUM | Payment cards: Previous authorization number | nvarchar | 10 | 0 | | |
TOPPayment Cards |
16 | FPLTC | Payment cards: Transaction data - SD | 14 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
TOPPayment Transactions |
17 | CRFILEPOS | Payment Card File: Individual Records | 19 | AUNUM | Payment Cards: Authorization Number | nvarchar | 15 | 0 | | |
TOPPeriodical Sales and Distribution |
18 | JFRKCC | IS-M/SD: Billing - Payment Card Data | 14 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
19 | JKAPCC | Sales Order: Payment Card Data | 15 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
20 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 101 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |
21 | JKWWWTEMP_PAY | IS-M: Temporary Internet Table: Payment Data Change | 27 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | |