| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | C3KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | C3MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | C3DSPI | Display Item Number | Character | UDC (32 YN) | 1 | 0 | Allow NULL? |
| 4 | C3TXTS | Text String or Custom Format | Character | UDC (32 YN) | 1 | 0 | Allow NULL? |
| 5 | C3CIDN | Transaction Type | Character | UDC (32 DE) | 1 | 0 | Allow NULL? |
| 6 | C3CMCU | Component Branch | String | Generic Edit | 12 | 0 | Allow NULL? |
| 7 | C3LNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 8 | C3PCFC | Print Configuration Components | Character | UDC (32 YN) | 1 | 0 | Allow NULL? |
| 9 | C3URCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 10 | C3URDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 11 | C3URAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | C3URAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | C3URRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | C3USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 15 | C3PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | C3JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 17 | C3UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 18 | C3TDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 19 | C3SOBD | Sales Order Based-on Date | Character | UDC (32 SB) | 1 | 0 | Allow NULL? |
| 20 | C3POBD | Purchase Order Based-on Date | Character | UDC (32 PB) | 1 | 0 | Allow NULL? |
| 21 | C3WOBD | Work Order Based-on Date | Character | UDC (32 WB) | 1 | 0 | Allow NULL? |
| 22 | C3DYN | Dynamic Configuration Entry | Character | UDC (32 RP) | 1 | 0 | Allow NULL? |
| 23 | C3UIDD | Disable UI Drop Down Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | C3DDTEXT | Drop Down Text | Character | Generic Edit | 1 | 0 | Allow NULL? |