| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F41001 | Inventory Constants | 47 | CI | PCSM | Costing Method - Purchasing | String | UDC | 2 | 0 |
TOP41: Inventory Management |
2 | F41UI001 | Inventory Transactions Detail File | 177 | IT | PCSM | Costing Method - Purchasing | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 40 / CM (Cost Method) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | 01 - 19 Reserved for PS | | Y |
2 | 01 | Last In | | Y |
3 | 02 | Weighted Average | | Y |
4 | 03 | Memo | | Y |
5 | 04 | Current | | Y |
6 | 05 | Future | | Y |
7 | 06 | Lot | | Y |
8 | 07 | Standard | | Y |
9 | 08 | Purchasing-Base Cost No Adds | | Y |
10 | 09 | Manufacturing Last Cost | N | Y |
11 | 20 | Historical Average | | N |