| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F46010 | Item Profile | 11 | IP | DEFI | Definition | String | UDC | 10 | 0 |
TOP41: Inventory Management |
2 | F4101W | Item Profile Data | 15 | IM | DEFI | Definition | String | UDC | 10 | 0 |
3 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 95 | SZ | DEFI | Definition | String | UDC | 10 | 0 |
TOP46: Warehouse Management |
4 | F46021 | Location Characteristics | 4 | LQ | DEFI | Definition | String | UDC | 10 | 0 |
5 | F46822 | Random Tables | 3 | RQ | DEFI | Definition | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 46 / DF (Random Characteristic Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | A | `A` Sales Items | | |
3 | AVERAGE | Average Random Characteristic | | |
4 | B | `B` Sales Items | | |
5 | BOOMER | Explosive Item Characteristic | | N |
6 | BULK | Bulk Characteristic | | N |
7 | C | `C` Sales Items | | |
8 | CASE | Case Random Characteristic | | |
9 | COLD | Cold | | |
10 | CONTROL | Controlled Item Characteristic | | |
11 | DARK | Low Light | | |
12 | DRY | Dry | | |
13 | EASY | Easy Access | | |
14 | EXPENSIVE | Hi Value Item Characteristic | | |
15 | FAST | Fast Random Characteristic | | |
16 | FROZEN | Frozen Temperature Charact. | | |
17 | GOOD | Good Random Characteristic | | |
18 | HAZ | Hazardous | | |
19 | HEAVY | Heavy Characteristic | | |
20 | HIGH | High Rack Storage | | |
21 | HIVALU | Hi Value Item Characteristic | | |
22 | L | Large Pallet 48"x48" | | |
23 | LARGE | Oversize Item Characteristic | | |
24 | LEVEL1 | Level 1 Characteristic | | N |
25 | LEVEL2 | Level 2 Characteristic | | N |
26 | LEVEL3 | Level 3 Characteristic | | N |
27 | LEVEL4 | Level 4 Characteristic | | N |
28 | LEVEL5 | Level 5 Characteristic | | N |
29 | LOW | Low Random Characteristic | | |
30 | MID | Mid Random Characteristic | | |
31 | MSDS | MSDS Sheet Storage | | |
32 | PICK | Pick Random Characteristic | | |
33 | Q | Quarantine | | |
34 | RACK | Rack Storage | | |
35 | RAND | Rand Random Characteristic | | |
36 | RETURN | Returned Item Characteristic | | N |
37 | RTK | Right to Know Characteristic | | |
38 | S | Small Pallet 36"x48" | | |
39 | SECURE | Security Required | | N |
40 | SLOW | Slow Random Characteristic | | |
41 | STD | Standard Item Characteristic | | |
42 | TALL | Tall Item Characteristic | | |
43 | TOPSEL | Top Seller or Fast Mover | | |
44 | UFO | Unidentified Foreign Object | | |