| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CCCMDCDE | Commodity Code | String | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | CCCMDDSC | Commodity Code Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | CCCMDPRT | Commodity Code Parent | String | Generic Edit | 15 | 0 | Allow NULL? |
| 4 | CCCATLVL | Catalog Tree Level | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 5 | CCCMDPOS | Commodity Code Product Or Service Flag | Character | UDC (40 C1) | 1 | 0 | Allow NULL? |
| 6 | CCLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 7 | CCANBY | Buyer Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | CCGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 9 | CCCMDCDE01 | Commodity Code 01 | String | Generic Edit | 15 | 0 | Allow NULL? |
| 10 | CCCMDDSC01 | Commodity Code Description 01 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 11 | CCCMDCDE02 | Commodity Code 02 | String | Generic Edit | 15 | 0 | Allow NULL? |
| 12 | CCCMDDSC02 | Commodity Code Description 02 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 13 | CCCMDCDE03 | Commodity Code 03 | String | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | CCCMDDSC03 | Commodity Code Description 03 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 15 | CCCMDCDE04 | Commodity Code 04 | String | Generic Edit | 15 | 0 | Allow NULL? |
| 16 | CCCMDDSC04 | Commodity Code Description 04 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 17 | CCCMDCDE05 | Commodity Code 05 | String | Generic Edit | 15 | 0 | Allow NULL? |
| 18 | CCCMDDSC05 | Commodity Code Description 05 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | CCCMDCDE06 | Commodity Code 06 | String | Generic Edit | 15 | 0 | Allow NULL? |
| 20 | CCCMDDSC06 | Commodity Code Description 06 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 21 | CCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | CCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | CCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | CCUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 25 | CCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |