| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CPSY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 2 | CPBUMC | Process UOM Conversions by Branch | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | CPBSDB | Process Supplemental Data Base by Branch | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | CPULOT | Allow Duplicate Lots | Character | UDC (40 DU) | 1 | 0 | Allow NULL? |
| 5 | CPAVGC | Update Average Cost On-Line | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | CPADVP | Advanced Sales Pricing (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | CPUMB1 | Sales Price Retrieval UOM | Character | UDC (40 SU) | 1 | 0 | Allow NULL? |
| 8 | CPCP01 | Sales Price Based On Date | Character | UDC (40 DB) | 1 | 0 | Allow NULL? |
| 9 | CPCP02 | Symbol to Identify Variable Table | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | CPCP03 | Symbol to Identify Unit of Measure | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | CPCP04 | Symbol to Identify Currency Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | CPCP05 | Symbol to Identify Data Base Field | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | CPCP06 | Purchase Price Retrieval UOM | Character | UDC (40 PU) | 1 | 0 | Allow NULL? |
| 14 | CPCP07 | Purchase Rebate Category Code | Character | Generic Edit (43 RU) | 1 | 0 | Allow NULL? |
| 15 | CPCP08 | Pricing Audit (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | CPCP09 | Enable Internet PPAT Message Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | CPCP10 | Non Coexisting Lot Processing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | CPCCTL | Control Code - ECS | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | CPSADR | Ship Ascending Date Rule | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | CPCP11 | Advanced Procurement Pricing (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | CPCP12 | Scientific Rounding | Character | UDC (00 OO) | 1 | 0 | Allow NULL? |
| 22 | CPCP13 | Require Price Approval | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | CPCP14 | Procurement Cost Based On Date | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | CPCP15 | System Constants Code 15 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | CPCP16 | Use Audit Log for Sales Order Changes | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | CPCP17 | Reason Code Required | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | CPCP18 | Approval Process Required | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | CPCP19 | Use Customer Set | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | CPCP20 | Prepayment Processing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | CPCHDC | Critical Hold Decoupling | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | CPELOT | Enhanced Lot Processing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | CPAJRM | Adjustment Retrieval Method | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | CPOSTP | Organization Structure Type | String | UDC (01 TS) | 3 | 0 | Allow NULL? |
| 34 | CPPRAD | Pricing Address Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 35 | CPCP22 | Preference Retrieval UOM | Character | UDC (40 RU) | 1 | 0 | Allow NULL? |
| 36 | CPPRSN | Preference Schedule | String | Generic Edit | 8 | 0 | Allow NULL? |
| 37 | CPPMRF | Multiple Promotions Resolution Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 38 | CPPRSF | Promotions System Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 39 | CPCP23 | Flag For Future 23 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 40 | CPCP24 | Flag For Future 24 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 41 | CPCP25 | Flag For Future 25 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | CPCP26 | Flag For Future 26 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 43 | CPCP27 | Flag For Future 27 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 44 | CPCP28 | Sales Pricing On Override Price | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | CPCP29 | Procurement Pricing On Override Price | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | CPCP30 | Symbol to Identify Test Result Name | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | CPCP31 | Symbol to Identify Function Name | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | CPCP32 | Symbol to Identify Func. Arg. Separator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 49 | CPCP33 | Symbol to Identify Adjustment Detail Ref | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 50 | CPCP34 | Accelerated Pricing Resolution Engine | Character | Generic Edit | 1 | 0 | Allow NULL? |