| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40051 | Return Material Authorization | 12 | RD | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
TOP48S: Service Billing |
2 | F48091 | Billing System Constants | 17 | WZ | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
3 | F4812 | Billing Detail Workfile | 128 | WD | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
4 | F48121 | Generation Control File - Service Billing | 8 | WY | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
5 | F4812G | Retro Adjustment Workfile | 10 | WD | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
6 | F4812H | Billing Workfile - History | 128 | WD | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
7 | F4812HS | Billing Workfile History Purged Save | 128 | WD | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
8 | F4822 | Invoice Summary Work File | 29 | W4 | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
9 | F48221 | Service Billing Retention Release Cross Reference File | 5 | WH | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
10 | F48229 | Delete Invoices Audit Table | 2 | W8 | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
11 | F4823 | Voucher Summary | 27 | W0 | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
12 | F48S001 | Draft and Final Invoice Document | 1 | WL | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
13 | F48S002 | Draft and Final Cross Reference Work File | 3 | WM | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
14 | F48S411 | CSB Pay When Paid Table | 13 | BZ | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
15 | F48SUI01 | Billing Detail Print Workfile | 128 | WD | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
TOP52: Contract Billing |
16 | F5216 | Milestone/Progress Billing Information | 22 | A6 | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |
17 | F52161 | Mileston/Progress Billing Line Cross Reference Details | 9 | A7 | DCTI | Document Type - Invoice Only | String | UDC | 2 | 0 |