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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#COU-COMPANY PKCOMPANY | 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 PKORDER_NBR | Numeric 8 | This field contains the unique order number identifier. | WH20.7 |
#COU-LINE-NBR PKLINE_NBR | Numeric 6 | System assigned number indicating which line this item is in the sequence of lines on the order. | WH20.7 |
#COU-UOMUOM | 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-FLSELL_PRICE_FL | Alpha 1 Occurs 10 Times ×10 | This field indicates if this unit of measure is valid for pricing. | — |
#COU-UOM-MULTUOM_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-QTYSPR_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-PRICEUNIT_PRICE | Signed 18.5 Occurs 10 Times ×10 | This field contains the price for each pricing unit of measure. | WH20.7 |
#COU-SPR-SHIP-QTYSPR_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-1UOM_1 | Derived | This field contains the first selling unit of measure quantity for the line in this array. | — |
#COU-UOM-2UOM_2 | Derived | This field contains the second selling unit of measure quantity for the line in this array. | — |
#COU-UOM-3UOM_3 | Derived | This field contains the third selling unit of measure quantity for the line in this array. | — |
#COU-UOM-4UOM_4 | Derived | This field contains the fourth selling unit of measure quantity for the line in this array. | — |
#COU-UOM-5UOM_5 | Derived | This field contains the fifth selling unit of measure quantity for the line in this array. | — |
#COU-UOM-6UOM_6 | Derived | This field contains the sixth selling unit of measure quantity for the line in this array. | — |
#COU-UOM-7UOM_7 | Derived | — | — |
#COU-UOM-8UOM_8 | Derived | — | — |
#COU-UOM-9UOM_9 | Derived | — | — |
#COU-UOM-10UOM_10 | Derived | — | — |
#COU-SPR-QTY-1SPR_QTY_1 | Derived | This field contains the quantity of the first unit of measure in the array. | — |
#COU-SPR-QTY-2SPR_QTY_2 | Derived | This field contains the quantity of the second selling unit of measure in the array. | — |
#COU-SPR-QTY-3SPR_QTY_3 | Derived | This field contains the quantity of the third selling unit of measure in the array. | — |
#COU-SPR-QTY-4SPR_QTY_4 | Derived | This field contains the quantity of the fourth selling unit of measure in the array. | — |
#COU-SPR-QTY-5SPR_QTY_5 | Derived | This field contains the quantity of the fifth selling unit of measure in the array. | — |
#COU-SPR-QTY-6SPR_QTY_6 | Derived | This field contains the quantity of the sixth selling unit of measure in the array. | — |
#COU-SPR-QTY-7SPR_QTY_7 | Derived | — | — |
#COU-SPR-QTY-8SPR_QTY_8 | Derived | — | — |
#COU-SPR-QTY-9SPR_QTY_9 | Derived | — | — |
#COU-SPR-QTY-10SPR_QTY_10 | Derived | — | — |
#COU-UNIT-PRICE-1UNIT_PRICE_1 | Derived | This field contains the unit price of the line in the first unit of measure. | — |
#COU-UNIT-PRICE-2UNIT_PRICE_2 | Derived | This field contains the unit price of the line in the second unit of measure. | — |
#COU-UNIT-PRICE-3UNIT_PRICE_3 | Derived | This field contains the unit price of the line in the third unit of measure. | — |
#COU-UNIT-PRICE-4UNIT_PRICE_4 | Derived | This field contains the unit price of the line in the fourth unit of measure. | — |
#COU-UNIT-PRICE-5UNIT_PRICE_5 | Derived | This field contains the unit price of the line in the fifth unit of measure. | — |
#COU-UNIT-PRICE-6UNIT_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-7UNIT_PRICE_7 | Derived | — | — |
#COU-UNIT-PRICE-8UNIT_PRICE_8 | Derived | — | — |
#COU-UNIT-PRICE-9UNIT_PRICE_9 | Derived | — | — |
#COU-UNIT-PRICE-10UNIT_PRICE_10 | Derived | — | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
COUSET1 |
| Primary | WH20.7 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcustomer | ARCUSTOMER | Required |
| |||||||||||||
| Coline | COLINE | Required |
| |||||||||||||
| Contract | OEPRCLIST | Required | When COL-CONTRACT-NBR != Spaces |
| ||||||||||||
| Custorder | CUSTORDER | Required |
| |||||||||||||
| Iccompany | ICCOMPANY | Required |
| |||||||||||||
| Itemmast | ITEMMAST | Required | When (COL-LINE-TYPE != "N") |
|
Programs
Updated by (1)
- WH20.7 Substitute Location