COLINEUOM – Order Line Pricing UOM's

System: OE (OE)
Prefix: COU
Primary key: COMPANY, ORDER-NBR, LINE-NBR
Fields: 39
Updated by: 1 program
Referenced by: 0 programs

COLINEUOM is the Order Line Pricing UOM's table in Lawson OE (prefix COU). It is indexed by COMPANY, ORDER-NBR, LINE-NBR (COUSET1). It is related 1:1 to ARCUSTOMER, COLINE, OEPRCLIST, CUSTORDER, ICCOMPANY and ITEMMAST. It is updated by WH20.7. The table has 39 fields, 1 index and 6 documented relations.

About COLINEUOM

No description in the Lawson data dictionary.

Fields (39)

Column = COBOL field name without the COU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`COU-COMPANY` PK 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` PK ORDER_NBR	Numeric 8	This field contains the unique order number identifier.	WH20.7
`COU-LINE-NBR` PK 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` UOM	Alpha 4 Occurs 10 Times ×10	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` SELL_PRICE_FL	Alpha 1 Occurs 10 Times ×10	This field indicates if this unit of measure is valid for pricing.	—
`COU-UOM-MULT` UOM_MULT	Signed 13.7 Occurs 10 Times ×10	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` SPR_QTY	Signed 13.4 Occurs 10 Times ×10	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` UNIT_PRICE	Signed 18.5 Occurs 10 Times ×10	This field contains the price for each pricing unit of measure.	WH20.7
`COU-SPR-SHIP-QTY` SPR_SHIP_QTY	Signed 13.4 Occurs 10 Times ×10	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` UOM_1	Derived	This field contains the first selling unit of measure quantity for the line in this array.	—
`COU-UOM-2` UOM_2	Derived	This field contains the second selling unit of measure quantity for the line in this array.	—
`COU-UOM-3` UOM_3	Derived	This field contains the third selling unit of measure quantity for the line in this array.	—
`COU-UOM-4` UOM_4	Derived	This field contains the fourth selling unit of measure quantity for the line in this array.	—
`COU-UOM-5` UOM_5	Derived	This field contains the fifth selling unit of measure quantity for the line in this array.	—
`COU-UOM-6` UOM_6	Derived	This field contains the sixth selling unit of measure quantity for the line in this array.	—
`COU-UOM-7` UOM_7	Derived	—	—
`COU-UOM-8` UOM_8	Derived	—	—
`COU-UOM-9` UOM_9	Derived	—	—
`COU-UOM-10` UOM_10	Derived	—	—
`COU-SPR-QTY-1` SPR_QTY_1	Derived	This field contains the quantity of the first unit of measure in the array.	—
`COU-SPR-QTY-2` SPR_QTY_2	Derived	This field contains the quantity of the second selling unit of measure in the array.	—
`COU-SPR-QTY-3` SPR_QTY_3	Derived	This field contains the quantity of the third selling unit of measure in the array.	—
`COU-SPR-QTY-4` SPR_QTY_4	Derived	This field contains the quantity of the fourth selling unit of measure in the array.	—
`COU-SPR-QTY-5` SPR_QTY_5	Derived	This field contains the quantity of the fifth selling unit of measure in the array.	—
`COU-SPR-QTY-6` SPR_QTY_6	Derived	This field contains the quantity of the sixth selling unit of measure in the array.	—
`COU-SPR-QTY-7` SPR_QTY_7	Derived	—	—
`COU-SPR-QTY-8` SPR_QTY_8	Derived	—	—
`COU-SPR-QTY-9` SPR_QTY_9	Derived	—	—
`COU-SPR-QTY-10` SPR_QTY_10	Derived	—	—
`COU-UNIT-PRICE-1` UNIT_PRICE_1	Derived	This field contains the unit price of the line in the first unit of measure.	—
`COU-UNIT-PRICE-2` UNIT_PRICE_2	Derived	This field contains the unit price of the line in the second unit of measure.	—
`COU-UNIT-PRICE-3` UNIT_PRICE_3	Derived	This field contains the unit price of the line in the third unit of measure.	—
`COU-UNIT-PRICE-4` UNIT_PRICE_4	Derived	This field contains the unit price of the line in the fourth unit of measure.	—
`COU-UNIT-PRICE-5` UNIT_PRICE_5	Derived	This field contains the unit price of the line in the fifth unit of measure.	—
`COU-UNIT-PRICE-6` 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` UNIT_PRICE_7	Derived	—	—
`COU-UNIT-PRICE-8` UNIT_PRICE_8	Derived	—	—
`COU-UNIT-PRICE-9` UNIT_PRICE_9	Derived	—	—
`COU-UNIT-PRICE-10` UNIT_PRICE_10	Derived	—	—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`COUSET1`	`COMPANY`, `ORDER-NBR`, `LINE-NBR`	Primary		WH20.7

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (1)

WH20.7 Substitute Location