| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | CIPRIM | General Ledger Explanation | Character | UDC (H41 PR) | 1 | 0 | Allow NULL? |
| 2 | CISYM1 | Symbol to Identify Short Inv Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | CISYM2 | Symbol to Identify Long Inv Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | CISYM3 | Symbol to Identify 3rd Inv Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | CISYM5 | Symbol to Identify Customer Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | CISECD | Configurator Segment Delimiter | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | CISEPL | Separator - Location | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | CISE01 | Number - Characters (Aisle) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | CISE02 | Number - Characters (Bin) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | CISE03 | Number - Characters (Code 3) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | CISE04 | Number - Characters (Code 4) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | CISE05 | Number - Characters (Code 5) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | CISE06 | Number - Characters (Code 6) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | CISE07 | Number - Characters (Code 7) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | CISE08 | Number - Characters (Code 8) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | CISE09 | Number - Characters (Code 9) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | CISE10 | Number - Characters (Code 10) | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | CILR01 | Justify - Aisle | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 19 | CILR02 | Justify - Bin | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 20 | CILR03 | Justify - Code 3 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 21 | CILR04 | Justify - Code 4 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 22 | CILR05 | Justify - Code 5 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 23 | CILR06 | Justify - Code 6 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 24 | CILR07 | Justify - Code 7 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 25 | CILR08 | Justify - Code 8 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 26 | CILR09 | Justify - Code 9 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 27 | CILR10 | Justify - Code 10 | Character | UDC (H40 LR) | 1 | 0 | Allow NULL? |
| 28 | CIAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | CIPOCS | Purchase Order Issue Cost | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 30 | CIINCS | Inventory Carrying Cost (%) | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 31 | CIIALP | Leadtime Weight Factor | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 32 | CIBSDY | Number of Days in Year | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 33 | CIIA1 | ABC Code 1 - Sales % | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 34 | CIIB1 | ABC Code 1 - Gross Margin % | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 35 | CIIC1 | ABC Code 1 - Average Investment | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 36 | CIIA2 | ABC Code 2 - Sales % | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 37 | CIIB2 | ABC Code 2 - Gross Margin % | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 38 | CIIC2 | ABC Code 2 - Average Investment | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 39 | CIIA3 | ABC Code 3 - Sales % | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 40 | CIIB3 | ABC Code 3 - Gross Margin % | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | CIIC3 | ABC Code 3 - Average Investment | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 42 | CIPNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 43 | CIGLPO | Interface G/L (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 44 | CIUNGL | Write Units to Journal Entries Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | CICMGL | Commitment Method | Character | UDC (H40 CM) | 1 | 0 | Allow NULL? |
| 46 | CICSMT | Costing Method - Sales | String | UDC (40 CM) | 2 | 0 | Allow NULL? |
| 47 | CIPCSM | Costing Method - Purchasing | String | UDC (40 CM) | 2 | 0 | Allow NULL? |
| 48 | CIBACK | Backorders Allowed (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 49 | CICOMH | Commitment - Specific (Days) | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 50 | CIICRI | Batch Control Required (Y/N) - Inv | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 51 | CIIARI | Batch Management Approval Required - Inv | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 52 | CIMATY | Type - Match Type | Character | UDC (H40 MB) | 1 | 0 | Allow NULL? |
| 53 | CIXRT | Type - Cross-Reference Type Code | String | UDC (41 DT) | 2 | 0 | Allow NULL? |
| 54 | CIXRT2 | Type - Cross-Reference Type Code | String | UDC (41 DT) | 2 | 0 | Allow NULL? |
| 55 | CIARTG | Code - Approval Routing | String | Generic Edit | 12 | 0 | Allow NULL? |
| 56 | CIDA01 | Quantity Soft Committed to SO & WO | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 57 | CIDA02 | Quantity Hard Committed to SO | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 58 | CIDA03 | Quantity Future Committed to SO | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 59 | CIDA04 | Quantity Hard Committed to WO | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 60 | CIDA05 | Other Quantity 1 SO | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 61 | CIDA06 | Other Quantity 2 SO | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 62 | CIDA07 | Quantity on Hold | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 63 | CIDA08 | Quantity on Purchase Order Receipts | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 64 | CIDA09 | Quantity on Work Order Receipts | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 65 | CIDA10 | Other Quantity 1 PO | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 66 | CIDA11 | Quantity on Safety Stock | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 67 | CIDA12 | Quantity in Inspection | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 68 | CIDA13 | Quantity in Transit | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 69 | CIDA14 | Quantity in Operation 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 70 | CIDA15 | Quantity in Operation 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 71 | CIDA16 | Quantity on Loan to Manufacturing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 72 | CISYM4 | Update Primary Location Last In Cost | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 73 | CIWIUM | Unit of Measure - Dimension | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 74 | CIVUMD | Unit of Measure - Volume Display | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 75 | CIUWUM | Unit of Measure - Weight | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 76 | CIULOT | Allow Duplicate Lots | Character | UDC (40 DU) | 1 | 0 | Allow NULL? |
| 77 | CILCTL | Control Code - Locations | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 78 | CIWCTL | Control Code - Warehouse Management | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 79 | CIMVER | Version | String | UDC (40 RV) | 3 | 0 | Allow NULL? |
| 80 | CICLOC | Location - Shipping | String | Generic Edit | 20 | 0 | Allow NULL? |
| 81 | CIXLOC | Location - Receiving | String | Generic Edit | 20 | 0 | Allow NULL? |
| 82 | CISTPU | Temperature Type | Character | UDC (41B TP) | 1 | 0 | Allow NULL? |
| 83 | CIDNTP | Density Type - At Standard Temperature | Character | UDC (41B DT) | 1 | 0 | Allow NULL? |
| 84 | CITMPS | Temperature - Standard | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 85 | CIUSMT | Measurement - U.S. or Metric | Character | UDC (41B MU) | 1 | 0 | Allow NULL? |
| 86 | CIOT1Y | Potency Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 87 | CIOT2Y | Grade Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 88 | CIOT3Y | Foreign Depot | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 89 | CIOT4Y | Quality Management | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 90 | CIOT5Y | Detail Costing Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 91 | CIUSID | U.S. Increments Delimeter | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 92 | CIUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 93 | CIPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 94 | CIJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 95 | CIUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 96 | CITDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 97 | CISY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 98 | CIMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 99 | CIOT6Y | Inventory Lot Creation Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 100 | CISCTL | Location Segment Control(Y/N) - Inv | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 101 | CISEPS | Separator - Segment | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 102 | CISYM6 | Symbol to Identify Segmented Item | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 103 | CILAF | Lot Audit Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 104 | CILTFM | Special Lot Format | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 105 | CIRWLA | Restrict Work Order Lot Assignment | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 106 | CILNPA | Lot Number Pre-Assignment | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 107 | CINCOOC | Branch Country Of Origin Code | String | UDC (40R CO) | 3 | 0 | Allow NULL? |
| 108 | CICSNBF | Outbound Inventory Branch | Character | Generic Edit | 1 | 0 | Allow NULL? |
