| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40315 | Preference Profile - Invoice Cycling | 14 | PI | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
2 | F40315R | Preference Resolution Ledger - Invoice Cycle | 16 | PI | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
3 | F49080 | Invoice Cycle Calculation | 1 | IC | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
4 | F49085 | Scheduled Invoice Date | 1 | ID | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
5 | F49211 | Sales Order Detail File - Tag File | 19 | UD | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
6 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 32 | S1 | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
7 | F49219 | Sales Order Detail - Tag History File | 19 | UD | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
TOP42: Sales Management |
8 | F42UI800 | Sales Detail Work File - Sales Update | 80 | SD | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
TOP42B: Sales Order Entry |
9 | F49299 | S.O. Detail Tag Ledger File | 19 | UD | INCY | Invoice Cycle Code | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.