| 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) | 312 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
2 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 312 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
TOPBank Accounting |
3 | BSEGC | Document: Data on Payment Card Payments | 25 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
TOPPayment Cards |
4 | CCARDEC | Encrypted Payment Card Numbers | 2 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
5 | FPLTC | Payment cards: Transaction data - SD | 23 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
6 | VCKUN | Assign customer-credit card | 7 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
7 | VCNUM | Credit card master | 12 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
TOPPeriodical Sales and Distribution |
8 | JFRKCC | IS-M/SD: Billing - Payment Card Data | 23 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |
9 | JKAPCC | Sales Order: Payment Card Data | 24 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | |