| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP34A: Advanced Planning & Scheduling |
| 1 | F34A40 | APS Integration Group Setup Table | 27 | N0 | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
| TOP41: Inventory Management |
| 2 | F4101 | Item Master | 54 | IM | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
| 3 | F4101C | Item Category Codes | 34 | IM | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
| 4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 69 | SZ | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
| 5 | F4102 | Item Branch File | 70 | IB | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
| 6 | F4160 | Tag Inventory File | 21 | IT | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
| 7 | F41UI001 | Inventory Transactions Detail File | 78 | IT | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
| TOPF30L: DFM Line Design |
| 8 | FF30L501 | DFM Item Definition Master | 48 | IB | CYCL | Cycle Count Category | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 41 / 8 (Cycle Count Category) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Half yearly | | N |
| 2 | 2 | Yearly | | N |
| 3 | DAY | Daily Count - special case | | N |
| 4 | MON | Monthly Count | | |
| 5 | QTR | Quarterly Count | | |
| 6 | VOL | Weekly Count - High Volume | | |
