Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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.

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
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
                                                                 WH20.7

COU-ORDER-NBR          Numeric 8                                 BL120   BL122
Element: Order Nbr     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
                                                                 WH20.7

COU-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Nbr      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
                                                                 WH20.7

COU-UOM                Alpha 4 Occurs 10 Times                   BL120   BL122
Element: Uom           The 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
                                                                 WH20.7

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               BL120   BL122
Element: Uom Mult      This field contains the multiplier used   BL130   BL20.1
                       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
                                                                 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
                                                                 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
                                                                 WH20.7

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                                                BL120   BL122
          ORDER-NBR                                              BL130   BL20.1
          LINE-NBR                                               BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

                         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