| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP48S: Service Billing |
| 1 | F4812 | Billing Detail Workfile | 200 | WD | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| 2 | F4812H | Billing Workfile History | 200 | WD | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| 3 | F4812HS | Billing Workfile History Purged Save | 200 | WD | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| 4 | F4822 | Invoice Summary Work File | 12 | W4 | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| 5 | F48SUI01 | Billing Detail Print Workfile | 196 | WD | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| TOP52: Contract Billing |
| 6 | F5202 | Contract Billing Line Detail | 24 | G6 | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| 7 | F5217 | Revenue Billing Line Cross Reference | 8 | A7 | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| 8 | F5280W | Contract Revenue Summary Work File | 39 | GY | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
| TOP52G: Government Contracting |
| 9 | F4822H | Invoice Summary History | 12 | IH | PRTP | Pricing Type - Contracts | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 52 / PT (Pricing Types) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Time and Material | | N |
| 2 | 2 | Unit Price | | N |
| 3 | 3 | Lump Sum | | N |
| 4 | 4 | Fee Line | | N |
| 5 | 5 | Component | | N |
| 6 | 6 | Milestone | | N |
| 7 | 7 | Progress | | N |
| 8 | 8 | Direct Draw | | N |
| 9 | 9 | Rated Draw | | N |
| 10 | A | Award Fee | | Y |
| 11 | C | Component | | N |
| 12 | D | Direct Draw | | N |
| 13 | E | Percent Complete Method | | Y |
| 14 | F | Fee Line | | N |
| 15 | G | Applied Burdens | | Y |
| 16 | H | Percent of Billing Method | | Y |
| 17 | L | Lump Sum | | N |
| 18 | M | Milestone | | N |
| 19 | P | Progress | | N |
| 20 | R | Rated Draw | | N |
| 21 | S | Cost Plus | | Y |
| 22 | T | Time and Material | | N |
| 23 | U | Unit Price | | N |
| 24 | X | Limit Exceeded Adjustment | | Y |
