| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP03: Accounts Receivable |
1 | F03012 | Customer Master by Line of Business | 132 | AI | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
2 | F03012Z1 | Customer Master LOB-Batch File | 140 | VO | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
TOP40: Inventory/OP Base |
3 | F4009 | Distribution/Manufacturing Constants | 8 | CP | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
4 | F40302 | Preference Profile - Unit of Measure | 26 | PU | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
5 | F40347 | Preference Profile - Pricing UOM (Branch) | 16 | RI | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
6 | F40347R | Preference Resolution Ledger - Pricing UOM (Branch) | 18 | RI | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
7 | F49211 | Sales Order Detail File - Tag File | 33 | UD | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
8 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 46 | S1 | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
9 | F49219 | Sales Order Detail - Tag History File | 33 | UD | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
TOP42: Sales Management |
10 | F42UI01 | SO Header Cache File (MBF) | 101 | ZH | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
TOP42B: Sales Order Entry |
11 | F49299 | S.O. Detail Tag Ledger File | 33 | UD | CP01 | Sales Price Based On Date | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.