|
|
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.
UPDATED BY
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COU-COMPANY Numeric 4 WH20.7
Element: Company The company number represents an
established company and is entered on
all function codes.
COU-ORDER-NBR Numeric 8 WH20.7
Element: Order Number This field contains the unique order
number identifier.
COU-LINE-NBR Numeric 6 WH20.7
Element: Line Number System assigned number indicating which
line this item is in the sequence of
lines on the order.
COU-UOM Alpha 4 Occurs 10 Times WH20.7
Element: Unit of MeasurThe selling unit of measure used on
this order line. There can be up to six
different sell units of measure for each
item.
COU-SELL-PRICE-FL Alpha 1 Occurs 10 Times
Element: Account Flag This field indicates if this unit of
measure is valid for pricing.
COU-UOM-MULT Signed 13.7 Occurs 10 Times WH20.7
Unit of Measure This field contains the multiplier used
Multiplier to convert this unit of measure to the
item's stock unit of measure.
COU-SPR-QTY Signed 13.4 Occurs 10 Times WH20.7
Element: Quantity This field contains the quantity priced
in this unit of measure. This item can
have up to six units of measure.
COU-UNIT-PRICE Signed 13.5 Occurs 10 Times WH20.7
Element: Base Price This field contains the price for each
pricing unit of measure.
COU-SPR-SHIP-QTY Signed 13.4 Occurs 10 Times
Element: Quantity This field contains the quantity
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
Element: Uom 1 This field contains the first selling
unit of measure quantity for the line in
this array.
COU-UOM-2 Derived
Element: Uom 2 This field contains the second selling
unit of measure quantity for the line in
this array.
COU-UOM-3 Derived
Element: Uom 3 This field contains the third selling
unit of measure quantity for the line in
this array.
COU-UOM-4 Derived
Element: Uom 4 This field contains the fourth selling
unit of measure quantity for the line in
this array.
COU-UOM-5 Derived
Element: Uom 5 This field contains the fifth selling
unit of measure quantity for the line in
this array.
COU-UOM-6 Derived
Element: Uom 6 This field contains the sixth selling
unit of measure quantity for the line in
this array.
COU-UOM-7 Derived
Element: Uom 7
COU-UOM-8 Derived
Element: Uom 8
COU-UOM-9 Derived
Element: Uom 9
COU-UOM-10 Derived
Element: Uom 10
COU-SPR-QTY-1 Derived
Element: Spr Qty 1 This field contains the quantity of the
first unit of measure in the array.
COU-SPR-QTY-2 Derived
Element: Spr Qty 2 This field contains the quantity of the
second selling unit of measure in the
array.
COU-SPR-QTY-3 Derived
Element: Spr Qty 3 This field contains the quantity of the
third selling unit of measure in the
array.
COU-SPR-QTY-4 Derived
Element: Spr Qty 4 This field contains the quantity of the
fourth selling unit of measure in the
array.
COU-SPR-QTY-5 Derived
Element: Spr Qty 5 This field contains the quantity of the
fifth selling unit of measure in the
array.
COU-SPR-QTY-6 Derived
Element: Spr Qty 6 This field contains the quantity of the
sixth selling unit of measure in the
array.
COU-SPR-QTY-7 Derived
Element: Spr Qty 7
COU-SPR-QTY-8 Derived
Element: Spr Qty 8
COU-SPR-QTY-9 Derived
Element: Spr Qty 9
COU-SPR-QTY-10 Derived
Element: Spr Qty 10
COU-UNIT-PRICE-1 Derived
Element: Unit Price 1 This field contains the unit price of
the line in the first unit of measure.
COU-UNIT-PRICE-2 Derived
Element: Unit Price 2 This field contains the unit price of
the line in the second unit of measure.
COU-UNIT-PRICE-3 Derived
Element: Unit Price 3 This field contains the unit price of
the line in the third unit of measure.
COU-UNIT-PRICE-4 Derived
Element: Unit Price 4 This field contains the unit price of
the line in the fourth unit of measure.
COU-UNIT-PRICE-5 Derived
Element: Unit Price 5 This field contains the unit price of
the line in the fifth unit of measure.
COU-UNIT-PRICE-6 Derived
Element: 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.
COU-UNIT-PRICE-7 Derived
Element: Unit Price 7
COU-UNIT-PRICE-8 Derived
Element: Unit Price 8
COU-UNIT-PRICE-9 Derived
Element: Unit Price 9
COU-UNIT-PRICE-10 Derived
Element: Unit Price 10
COLINEUOM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COUSET1 COMPANY WH20.7
ORDER-NBR
LINE-NBR
COLINEUOM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustomer ARCUSTOMER Required
COU-COMPANY -> -COMPANY
COL-CUSTOMER -> -CUSTOMER
Coline COLINE Required
COU-COMPANY -> COL-COMPANY
COU-ORDER-NBR -> COL-ORDER-NBR
COU-LINE-NBR -> COL-LINE-NBR
Contract OEPRCLIST Required
When COL-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 (COL-LINE-TYPE != "N" )
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
COL-ITEM -> ITE-ITEM
|
