| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CCCYNO | Cycle Count Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | CCTGG | Tag Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | CCITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | CCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | CCLOCN | Location | String | Generic Edit | 20 | 0 | Allow NULL? |
| 6 | CCLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 7 | CCLPNU | License Plate Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 8 | CCTQCT | Quantity - Total Primary Counted | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 9 | CCTQOH | Quantity - Total Primary on Hand | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 10 | CCUOM1 | Unit of Measure - Primary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 11 | CCSQOR | Units - Secondary Quantity Ordered | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 12 | CCSQOH | Quantity on Hand - in Secondary units | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | CCUOM2 | Unit of Measure - Secondary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 14 | CCQTY1 | Future Use Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 15 | CCQTY2 | Future Use Quantity 2 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 16 | CCUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 17 | CCRCDJ | Date - Received | Date | Generic Edit | 6 | 0 | |
| 18 | CCMMEJ | Date - Lot Expiration | Date | Generic Edit | 6 | 0 | |
| 19 | CCNDTL | New Location Detail Record Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | CCWTTY | Warehouse Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | CCSMOD | Location Selection Mode | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | CCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | CCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | CCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | CCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 26 | CCTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 27 | CCLPNDC | License Plate - Date Last Updated | JDE UTime | Generic Edit | 11 | 0 | |