| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollectionsDisbursements |
1 | IBROSTMCF | Clarif. Cases from Broker Report | 20 | SELT1 | Selection Category for Broker Report | nvarchar | 1 | 0 | | |
2 | IBROSTMDFLT | ISCD: Broker Report - Default Values Per Item Category | 14 | SELT1 | Selection Category for Broker Report | nvarchar | 1 | 0 | | |
3 | IBROSTMP | ISCD: Broker Report - Item Data | 62 | SELT1 | Selection Category for Broker Report | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
4 | DFK006B | Note to Payee - Texts | 7 | SELT1 | Selection Category | nvarchar | 1 | 0 | | |
5 | DFK006BX | Note to Payee - Texts | 7 | SELT1 | Selection Category | nvarchar | 1 | 0 | | |
6 | DFKKAVK | Payment Advice: Header Data | 8 | SELT1 | Default Value for Selection Category | nvarchar | 1 | 0 | | |
7 | DFKKAVP | Payment Advice: Items | 4 | SELT1 | Selection Category | nvarchar | 1 | 0 | | |
8 | DFKKCFCVS | Clarification Cases from Payment Transfer - Ext. Pymt Coll. | 7 | SELT1 | CVS: Error Type | nvarchar | 1 | 0 | | |
9 | DFKKCFRLS | Clarification Cases: Returns Lots | 4 | SELT1 | Selection Category | nvarchar | 1 | 0 | | |
10 | DFKKCFZST | Clarification Cases from Payment Lot | 4 | SELT1 | 1. Selection Category | nvarchar | 1 | 0 | | |
11 | DFKKRK | Returns lot: Header data | 21 | SELT1 | Default Value for Selection Category | nvarchar | 1 | 0 | | |
12 | DFKKRP | Returns lot: Data for payment | 4 | SELT1 | Selection Category | nvarchar | 1 | 0 | | |
13 | DFKKZK | Payment lot: Header data | 19 | SELT1 | Default Value for Selection Category | nvarchar | 1 | 0 | | |
14 | DFKKZP | Payment lot: Data for payment | 4 | SELT1 | 1. Selection Category | nvarchar | 1 | 0 | | |
15 | DFKKZS | Payment lot: Further selections | 5 | SELT1 | 1. Selection Category | nvarchar | 1 | 0 | | |
TOPIntercompany Data Exchange |
16 | IUEEDPPLOTACPPV | Distribute Aggregated Payments: Parameters | 5 | SELT1 | 1. Selection Category | nvarchar | 1 | 0 | | |