| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F12002 | Default Accounting Constants | 22 | FD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 2 | F43147 | Freight Distribution Workfile | 42 | FD | FDSBLT | Freight Distribution Subledger Type | Character | UDC | 1 | 0 |
| 3 | F43147 | Freight Distribution Workfile | 26 | FD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
| TOP51: Job Costing |
| 4 | F5111 | Forecast Detail | 127 | FD | SBLT | Subledger Type | Character | UDC | 1 | 0 |
| TOP76B: Brazil |
| 5 | F7611B | Nota Fiscal Detail - BRA - 42 | 94 | FD | SBLT | Subledger Type | 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 00 / ST (Subledger Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Blank | | N |
| 2 | A | Address Book Number | | Y |
| 3 | C | Business Unit Number | | Y |
| 4 | E | Equipment Number | | Y |
| 5 | F | Case Number | | Y |
| 6 | G | Service Contract Header | | Y |
| 7 | I | Item Number (Short) | | Y |
| 8 | J | Job Change Request | | |
| 9 | L | Lease Number | | Y |
| 10 | M | Summarized Work Order Number | | N |
| 11 | O | Order Number | | Y |
| 12 | S | Structured Subledger | | |
| 13 | U | Unit Number | | |
| 14 | W | Work Order Number | | Y |
| 15 | X | User Defined Subledger Type | | |
| 16 | Y | - Another User Defined Type | | |
| 17 | Z | - Define Types As Needed | | |
