| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollectionsDisbursements |
1 | ITAGCYPAYMET_ADD | Agency Collections: Additional Payment Methods | 8 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
2 | ITAGCYPM_ADD | Agency Collections: Payt Method Info. Addtl Payt Methods | 6 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
3 | DFKKEXCJ | Cash Journal: Data Store for Inbound Services | 12 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
4 | DFKKMOP | Items in contract account document | 72 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
5 | DFKKMOPK | Items in contract account document | 41 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
6 | DFKKOP | Items in contract account document | 72 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
7 | DFKKOPK | Items in contract account document | 41 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
8 | DFKKOP_REP | Open Items from FPO4 | 76 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
9 | DFKKORDERPOS | Requests: Items | 86 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
10 | DFKKORDERPOS_S | Request Templates: Items | 62 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
11 | DFKKRK | Returns lot: Header data | 19 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
12 | DFKKRP | Returns lot: Data for payment | 33 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
13 | DFKKZK | Payment lot: Header data | 17 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
14 | DFKKZP | Payment lot: Data for payment | 27 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
15 | TFK020B | Short Account Assignments for Transfer Postings to Cash Desk | 8 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
16 | TFK020C | Short Acct Assignments for Write-Offs from Clarif. Worklist | 7 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
17 | TFK020K | Short Account Assignments for Transfer Postings | 8 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |
TOPInvoicing |
18 | DEABPS | Customer change table: Logical view of BB amounts | 65 | XEIPH | Create Line Item in General Ledger | nvarchar | 1 | 0 | | |