| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKPDC | FI-CA: Postdated Checks | 13 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
2 | DFKK_TRIGX_PAY | Outbound Interface: New Trigger Table for Payment Info | 11 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
TOPCollectionsDisbursements |
3 | ITAGCYBNKTRTRIGG | Trigger Table Bank Deposits for Agencies | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
4 | VVKKKDTRIG | Trigger for Cust. Field Check DME Media | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
TOPContract Accounts Receivable and Payable |
5 | DFK006B | Note to Payee - Texts | 19 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
6 | DFK006BX | Note to Payee - Texts | 19 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
7 | DFK006E | Note to Payee - Accounts | 12 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
8 | DFK006EX | Note to Payee - Accounts New | 10 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
9 | DFKKCDLOTS | Lot Management for Cash Desk and External Cash Desk Services | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
10 | DFKKCFZST | Clarification Cases from Payment Lot | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
11 | DFKKCJT | Transaction Data for Cash Journal | 13 | KEYZ1 | Cash Journal: Number of Special Posting Document | nvarchar | 12 | 0 | | |
12 | DFKKCOLLPAYMLINK | Assignment of Collection Payments to Collection Units | 16 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
13 | DFKKEXC | External Payment Information | 26 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
14 | DFKKZF | Payment lot: Reconciliation key | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
15 | DFKKZK | Payment lot: Header data | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
16 | DFKKZN | Payment Lot: Notes for Clarification | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
17 | DFKKZP | Payment lot: Data for payment | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
18 | DFKKZPE | Payment lot: Error message for payment item | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
19 | DFKKZPT | Payment Lot: Data for Partial Clearing of a Payment | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
20 | DFKKZP_ARCIND | Link between Document Number and Archived Payment Lot | 3 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
21 | DFKKZS | Payment lot: Further selections | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
22 | DFKKZV | Payment Lot: Enhancement of Note to Payee | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
23 | DFKK_TRIGGER_PAY | Outbound Interface: Trigger Table for Payment Information | 10 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
24 | FKKBSTMV | Acct Statement Transfer: Admin. Records | 10 | KEYZ1 | Last Payment Lot to Which Data was Transferred (Restart) | nvarchar | 12 | 0 | | |
TOPIntercompany Data Exchange |
25 | IUEEDPPLOTATHEAD | Distribution Lot Header | 2 | KEYZ1 | Distribution Lot | nvarchar | 12 | 0 | | |
26 | IUEEDPPLOTATREF | Distr. Aggr. Payments: Ref. btwn MR and Distributed Objects | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
27 | IUEEDPPLOTATREF1 | Distr. Aggr. Payments: Ref. Between Pymt St. and Aggr. Pymt | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
28 | IUEEDPPLOTATREF2 | Distribution of Aggr. Payments: Special Distribution Lot | 2 | KEYZ1 | Distribution Lot | nvarchar | 12 | 0 | | |
TOPLease Accounting |
29 | /LSIERP/TQ_P_DET | Payment Details and Test Results for Cost Estimate | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
30 | /LSIERP/TQ_P_HDR | Payment Status | 2 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
TOPMedia Sales and Distribution |
31 | /NAM/PAY_CC | Workload for Credit Card Payment | 11 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
32 | /NAM/PAY_CH | Workload for Check Payments | 11 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
33 | /NAM/PAY_LK | Workload for Lockbox kick-outs | 11 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | | |
TOPProduction Orders |
34 | T496Z | CIM order: Table-controlled table access | 7 | KEYZ1 | Field Name | nvarchar | 10 | 0 | | |