COLINEUOM

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
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
WH20.7
COU-ORDER-NBR
Element: Order Nbr
Numeric 8
This field contains the unique order number identifier.
WH20.7
COU-LINE-NBR
Element: Line Nbr
Numeric 6
System assigned number indicating which line this item is in the sequence of lines on the order.
WH20.7
COU-UOM
Element: Uom
Alpha 4 Occurs 10 Times
The selling unit of measure used on this order line. There can be up to six different sell units of measure for each item.
WH20.7
COU-SELL-PRICE-FL
Element: Account Flag
Alpha 1 Occurs 10 Times
This field indicates if this unit of measure is valid for pricing.
COU-UOM-MULT
Element: Uom Mult
Signed 13.7 Occurs 10 Times
This field contains the multiplier used to convert this unit of measure to the item's stock unit of measure.
WH20.7
COU-SPR-QTY
Element: Quantity
Signed 13.4 Occurs 10 Times
This field contains the quantity priced in this unit of measure. This item can have up to six units of measure.
WH20.7
COU-UNIT-PRICE
Element: Intl Cost
Signed 18.5 Occurs 10 Times
This field contains the price for each pricing unit of measure.
WH20.7
COU-SPR-SHIP-QTY
Element: Quantity
Signed 13.4 Occurs 10 Times
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
Element: Uom 1
Derived
This field contains the first selling unit of measure quantity for the line in this array.
COU-UOM-2
Element: Uom 2
Derived
This field contains the second selling unit of measure quantity for the line in this array.
COU-UOM-3
Element: Uom 3
Derived
This field contains the third selling unit of measure quantity for the line in this array.
COU-UOM-4
Element: Uom 4
Derived
This field contains the fourth selling unit of measure quantity for the line in this array.
COU-UOM-5
Element: Uom 5
Derived
This field contains the fifth selling unit of measure quantity for the line in this array.
COU-UOM-6
Element: Uom 6
Derived
This field contains the sixth selling unit of measure quantity for the line in this array.
COU-UOM-7
Element: Uom 7
Derived
COU-UOM-8
Element: Uom 8
Derived
COU-UOM-9
Element: Uom 9
Derived
COU-UOM-10
Element: Uom 10
Derived
COU-SPR-QTY-1
Element: Spr Qty 1
Derived
This field contains the quantity of the first unit of measure in the array.
COU-SPR-QTY-2
Element: Spr Qty 2
Derived
This field contains the quantity of the second selling unit of measure in the array.
COU-SPR-QTY-3
Element: Spr Qty 3
Derived
This field contains the quantity of the third selling unit of measure in the array.
COU-SPR-QTY-4
Element: Spr Qty 4
Derived
This field contains the quantity of the fourth selling unit of measure in the array.
COU-SPR-QTY-5
Element: Spr Qty 5
Derived
This field contains the quantity of the fifth selling unit of measure in the array.
COU-SPR-QTY-6
Element: Spr Qty 6
Derived
This field contains the quantity of the sixth selling unit of measure in the array.
COU-SPR-QTY-7
Element: Spr Qty 7
Derived
COU-SPR-QTY-8
Element: Spr Qty 8
Derived
COU-SPR-QTY-9
Element: Spr Qty 9
Derived
COU-SPR-QTY-10
Element: Spr Qty 10
Derived
COU-UNIT-PRICE-1
Element: Unit Price 1
Derived
This field contains the unit price of the line in the first unit of measure.
COU-UNIT-PRICE-2
Element: Unit Price 2
Derived
This field contains the unit price of the line in the second unit of measure.
COU-UNIT-PRICE-3
Element: Unit Price 3
Derived
This field contains the unit price of the line in the third unit of measure.
COU-UNIT-PRICE-4
Element: Unit Price 4
Derived
This field contains the unit price of the line in the fourth unit of measure.
COU-UNIT-PRICE-5
Element: Unit Price 5
Derived
This field contains the unit price of the line in the fifth unit of measure.
COU-UNIT-PRICE-6
Element: Unit Price 6
Derived
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
Element: Unit Price 7
Derived
COU-UNIT-PRICE-8
Element: Unit Price 8
Derived
COU-UNIT-PRICE-9
Element: Unit Price 9
Derived
COU-UNIT-PRICE-10
Element: Unit Price 10
Derived


COLINEUOM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COUSET1 COMPANY
ORDER-NBR
LINE-NBR
WH20.7


COLINEUOM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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 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


File created: Thu Jun 09 11:21:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.