| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKPDC | FI-CA: Postdated Checks | 14 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
2 | DFKK_TRIGX_PAY | Outbound Interface: New Trigger Table for Payment Info | 12 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
TOPCollectionsDisbursements |
3 | ITAGCYBNKTRTRIGG | Trigger Table Bank Deposits for Agencies | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
4 | VVKKKDTRIG | Trigger for Cust. Field Check DME Media | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
TOPContract Accounts Receivable and Payable |
5 | DFK006B | Note to Payee - Texts | 20 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
6 | DFK006BX | Note to Payee - Texts | 20 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
7 | DFK006E | Note to Payee - Accounts | 13 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
8 | DFK006EX | Note to Payee - Accounts New | 11 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
9 | DFKKCFZST | Clarification Cases from Payment Lot | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
10 | DFKKCMP | Manually Issued Checks Lot: Item Data | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
11 | DFKKCMP2P | Manually Issued Checks Lot: Two Party Checks Data | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
12 | DFKKCMPE | Manually Entered Checks Lot: Error Messages | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
13 | DFKKEXC | External Payment Information | 27 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
14 | DFKKZP | Payment lot: Data for payment | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
15 | DFKKZPE | Payment lot: Error message for payment item | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
16 | DFKKZPT | Payment Lot: Data for Partial Clearing of a Payment | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
17 | DFKKZP_ARCIND | Link between Document Number and Archived Payment Lot | 4 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
18 | DFKK_TRIGGER_PAY | Outbound Interface: Trigger Table for Payment Information | 11 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
TOPIntercompany Data Exchange |
19 | IUEEDPPLOTATREF | Distr. Aggr. Payments: Ref. btwn MR and Distributed Objects | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
20 | IUEEDPPLOTATREF1 | Distr. Aggr. Payments: Ref. Between Pymt St. and Aggr. Pymt | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
TOPLease Accounting |
21 | /LSIERP/TQ_P_DET | Payment Details and Test Results for Cost Estimate | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |
22 | /LSIERP/TQ_P_HDR | Payment Status | 3 | POSZA | Item number in a payment lot | nvarchar | 6 | 0 | | |