Lawson Insight Technical Documentation |
|
COLINEUOM
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
OE112 OE229
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 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 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE310 OE510 OE530 OE810 OE830
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COU-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COU-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Number This field contains the unique order BL130 BL20.1
number identifier. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COU-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number System assigned number indicating which BL130 BL20.1
line this item is in the sequence of BL20.3 BL21.2
lines on the order. BL21.5 BL29.1
BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COU-UOM Alpha 4 Occurs 10 Times BL120 BL122
Element: Unit of MeasurThe selling unit of measure used on BL130 BL20.1
this order line. There can be up to six BL20.3 BL21.2
different sell units of measure for each BL21.5 BL29.1
item. BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COU-SELL-PRICE-FL Alpha 1 Occurs 10 Times OE810
Element: Account Flag This field indicates if this unit of
measure is valid for pricing.
COU-UOM-MULT Signed 13.7 Occurs 10 Times BL120 BL122
Unit of Measure This field contains the multiplier used BL130 BL20.1
Multiplier to convert this unit of measure to the BL20.3 BL21.2
item's stock unit of measure. BL21.5 BL29.1
BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COU-SPR-QTY Signed 13.4 Occurs 10 Times BL120 BL122
Element: Quantity This field contains the quantity priced BL130 BL20.1
in this unit of measure. This item can BL20.3 BL21.2
have up to six units of measure. BL21.5 BL29.1
BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COU-UNIT-PRICE Signed 18.5 Occurs 10 Times BL120 BL122
Element: Intl Cost This field contains the price for each BL130 BL20.1
pricing unit of measure. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
COU-SPR-SHIP-QTY Signed 13.4 Occurs 10 Times OE114 OE129
Element: Quantity This field contains the quantity OE810
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 BL120 BL122
ORDER-NBR BL130 BL20.1
LINE-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 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 OE111
OE112 OE113
OE114 OE116
...
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 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
|