COLINEUOM FILE Order Line Pricing UOM's This file contains order quantity break up by unit of measure, if the item is set up with multiple unit of measure pricing. REFERENCED BY BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL940 OE112 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950 UPDATED BY BL92.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE310 OE510 OE810 OE920 WH20.7 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY COU-COMPANY Numeric 4 BL92.1 OE10.1 Company The company number represents an OE10.2 OE10.3 established company and is entered on OE10.4 OE10.5 all function codes. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COU-ORDER-NBR Numeric 8 BL92.1 OE10.1 Order Number This field contains the unique order OE10.2 OE10.3 number identifier. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COU-LINE-NBR Numeric 6 BL92.1 OE10.1 Line Number System assigned number indicating which OE10.2 OE10.3 line this item is in the sequence of OE10.4 OE10.5 lines on the order. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COU-UOM Alpha 4 Occurs 6 Times BL92.1 OE10.1 Unit of Measure The selling unit of measure used on OE10.2 OE10.3 this order line. There can be up to six OE10.4 OE10.5 different sell units of measure for each OE10.6 OE10.7 item. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COU-SELL-PRICE-FL Alpha 1 Occurs 6 Times OE810 OE920 Sell Price Flag This field indicates if this unit of measure is valid for pricing. COU-UOM-MULT Signed 13.7 Occurs 6 Times BL92.1 OE10.1 Unit of Measure This field contains the multiplier used OE10.2 OE10.3 Multiplier to convert this unit of measure to the OE10.4 OE10.5 item's stock unit of measure. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COU-SPR-QTY Signed 13.4 Occurs 6 Times BL92.1 OE10.1 Spr Qty This field contains the quantity priced OE10.2 OE10.3 in this unit of measure. This item can OE10.4 OE10.5 have up to six units of measure. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COU-UNIT-PRICE Signed 13.5 Occurs 6 Times BL92.1 OE10.1 Unit Price This field contains the price for each OE10.2 OE10.3 pricing unit of measure. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COU-SPR-SHIP-QTY Signed 13.4 Occurs 6 Times OE114 OE129 Spr Ship Qty This field contains the quantity OE810 OE920 already shipped for this line in the pricing unit of measure used to price the line. This is used only if this item has been priced with different units of measure. COU-UOM-1 Derived UOM 1 This field contains the first selling unit of measure quantity for the line in this array. COU-UOM-2 Derived UOM 2 This field contains the second selling unit of measure quantity for the line in this array. COU-UOM-3 Derived UOM 3 This field contains the third selling unit of measure quantity for the line in this array. COU-UOM-4 Derived UOM 4 This field contains the fourth selling unit of measure quantity for the line in this array. COU-UOM-5 Derived UOM 5 This field contains the fifth selling unit of measure quantity for the line in this array. COU-UOM-6 Derived UOM 6 This field contains the sixth selling unit of measure quantity for the line in this array. COU-SPR-QTY-1 Derived Spr Qty-1 This field contains the quantity of the first unit of measure in the array. COU-SPR-QTY-2 Derived Spr Qty-2 This field contains the quantity of the second selling unit of measure in the array. COU-SPR-QTY-3 Derived Spr Qty-3 This field contains the quantity of the third selling unit of measure in the array. COU-SPR-QTY-4 Derived Spr Qty-4 This field contains the quantity of the fourth selling unit of measure in the array. COU-SPR-QTY-5 Derived Spr Qty-5 This field contains the quantity of the fifth selling unit of measure in the array. COU-SPR-QTY-6 Derived Spr Qty-6 This field contains the quantity of the sixth selling unit of measure in the array. COU-UNIT-PRICE-1 Derived Unit Price 1 This field contains the unit price of the line in the first unit of measure. COU-UNIT-PRICE-2 Derived Unit Price 2 This field contains the unit price of the line in the second unit of measure. COU-UNIT-PRICE-3 Derived Unit Price 3 This field contains the unit price of the line in the third unit of measure. COU-UNIT-PRICE-4 Derived Unit Price 4 This field contains the unit price of the line in the fourth unit of measure. COU-UNIT-PRICE-5 Derived Unit Price 5 This field contains the unit price of the line in the fifth unit of measure. COU-UNIT-PRICE-6 Derived Unit Price 6 This field contains the unit price of the line in the sixth unit of measure. The Customer Order Miscellaneous file stores add-on charges attached to orders or order lines. COLINEUOM FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN COUSET1 COMPANY BL120 BL130 ORDER-NBR BL20.1 BL20.3 LINE-NBR BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE112 OE113 OE114 OE129 OE14.4 ... COLINEUOM FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Arcustomer ARCUSTOMER Required COU-COMPANY -> ACM-COMPANY COL-CUSTOMER -> ACM-CUSTOMER Coline COLINE Required COU-COMPANY -> COL-COMPANY COU-ORDER-NBR -> COL-ORDER-NBR COU-LINE-NBR -> COL-LINE-NBR Contract OEPRCLIST Required When COU-CONTRACT-NBR != Spaces COU-COMPANY -> OPL-COMPANY COR-CUSTOMER -> OPL-CUSTOMER COL-CONTRACT-NBR -> OPL-LIST-NAME Spaces -> OPL-PROMOTION Custorder CUSTORDER Required COU-COMPANY -> COR-COMPANY COU-ORDER-NBR -> COR-ORDER-NBR Iccompany ICCOMPANY Required COU-COMPANY -> ICC-COMPANY Itemmast ITEMMAST Required When (COU-LINE-TYPE != "N" ) ICC-ITEM-GROUP -> ITE-ITEM-GROUP COL-ITEM -> ITE-ITEM |