| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_11_SAMP3 | Sample table 3 for TDMS demo package - Rules Platform | 4 | KEYNO | Single-Character Indicator | nvarchar | 1 | 0 | | |
2 | COPC_PAYRQ | Payment Request for Cash Operation Center | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
3 | COPC_PAYRQ_DTL | COPC: PAYRQ Detail | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
4 | COPC_PAYRQ_T | COPC: Payment request text | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
5 | COPC_RPR_VAR_VL | COPC: RPR variant value | 3 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
6 | EPIC_EBR_FEB | Additional Data on Bank Statement Line Item for Bank Receipt | 54 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
7 | EPIC_EBR_HDR | OBSOLETE!!! | 29 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
8 | REGUP | Processed items from payment program | 167 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
TOPAutomatic Payments |
9 | FDZA | Cash Management line items in payment requests | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
10 | PAYRQ | Payment Requests | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
11 | PAYRQP | PAYRQ Enhancement (Cross-Country Bank Account Transfers) | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
12 | PAYRQT | Reference Texts for Payment Request | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
TOPDistributor-Reseller-Management |
13 | /SAPHT/DRMCPACNV | DRM Partner Conversion | 5 | KEYNO | Address number | nvarchar | 10 | 0 | | |
14 | /SAPHT/DRMPARTAD | DRM Resale link additional address data table. | 2 | KEYNO | Address number | nvarchar | 10 | 0 | | |
TOPFunds Management |
15 | RESCT | Additional Criteria per Line Item | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
16 | PAYBU | Header Supplement for Payment Requests Without Vendor | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
17 | PAYCT | Additional Criteria per Line Item | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
18 | PAYKO | Additional FM Data for Payment Request | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
19 | PAYOA | Payment Order - Additional Data | 2 | KEYNO | Number of a collective payment request | nvarchar | 10 | 0 | | |
20 | PAYOH | Payment Order - Header Data | 2 | KEYNO | Number of a collective payment request | nvarchar | 10 | 0 | | |
21 | PAYRC | Additional Header Data for Recovery Order | 2 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
TOPPayment Transactions |
22 | FPRL_ITEM | Item Data | 83 | KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | |
TOPPayroll |
23 | T7UAT9 | Tax scale according to feature 36TXU | 6 | KEYNO | Key value from 36TXU | nvarchar | 8 | 0 | | |