Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

KITITEM


                              KITITEM FILE

                                Kit Item

The Kit Item file contains the valid kit or parent items for a make-to-order
or finished good kit.

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    CXCP.1    IC10.2
IC11.1    IC12.1    IC143     IC28.1    IC330     IC61.1
IC63.1    IC67.1    IC68.1    IC68.2    IC83.1    MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.2    MA66.3    MA67.1    MA67.2    MA70.1    MA75.1
MA80.1    MAI1.1    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1
RQ13.1    RQ35.1    RQ500     RQIE.1    RQIF.1    WH110
WH130     WH132     WH190     WH20.1    WH20.2    WH20.7
WH22.1    WH222     WH25.1    WH25.2    WH30.1    WH30.2
WH30.3    WH30.4    WH31.1    WH31.2    WH31.3    WH31.4
WH32.1    WH32.2    WH32.3    WH32.4    WH33.1    WH33.2
WH33.3    WH33.4    WH33.5    WH33.6    WH33.8    WH33.9
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830     WO120     WO132     WO140     WO20.1
WO20.2    WO30.1    WO32.1    WO40.1    WO40.2    WO40.3
WO40.4    WO40.5    WO41.1    WO41.2    WO41.3    WO41.4
WO42.1    WO42.2    WO42.3    WO42.4    WO42.5    WO45.1
WOEX.1    WOPR.1    WOSP.1    IC260     IC262     RQD1.1
WO10.1    WO220     WO255     WO510     WO82.1

UPDATED BY

IC60.1    IC60.3    IC60.2    IC62.1    IC62.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

KIT-ITEM-GROUP         Alpha 5                                   IC60.1  IC62.1
Element: Item Group    This field contains the identifier for    IC62.2
                       a group of items that can be shared by
                       one or more companies.

KIT-COMPANY            Numeric 4                                 IC60.1  IC62.1
Element: Company       The company number represents an          IC62.2
                       established company and is entered on
                       all function codes.

KIT-LOCATION           Alpha 5                                   IC60.1  IC62.1
Element: Location Code This field contains a valid stocking      IC62.2
                       location within the company inventory.

KIT-ITEM               Alpha 32                                  IC60.1  IC62.1
Element: Item Number   This field contains the item              IC62.2
                       identifier.

KIT-ORDER-SIZE         Numeric 8                                 IC60.1
Element: Order Size    This field contains the standard order
                       size for the kit. The component quantity
                       specifies the number of required kit
                       components needed for each kit. This
                       field is for reference purposes only.

KIT-NOTES              Alpha 20  (Lower Case)                    IC60.1
Element: Notes         This field contains notes about the
                       kit. This information is for reference
                       purposes only.

KIT-PROCEDURE-CD       Alpha 7  (Lower Case)                     IC60.1  IC62.1
Element: Procedure CodeThis field contains the procedure code
                       for the kit. This information is for
                       reference purposes only.

KIT-MAKE-CD            Alpha 1                                   IC60.1  IC62.1
Element: Make Code     This field contains the code that
                       specifies whether a kit is a
                       make-to-order or a finished good kit.
                       O = Make to Order
                       S = Make to Stock

KIT-ACTIVE-STATUS      Alpha 1                                   IC60.1  IC62.1
Element: Status        This field contains the status to
                       control the use of the kit.
                       A = Active
                       I = Inactive

KIT-SEQ                Numeric 3                                 IC60.1  IC62.1
Element: Sequence NumbeThis field contains the last sequence
                       number of the last component line. This
                       field is used when adding new component
                       lines.

KIT-INST-LINE          Numeric 3                                 IC60.3  IC62.1
Element: Hdr Dtl Lines This field contains the number of the
                       last instruction line. This field is
                       used when adding new instruction lines.

KIT-CTG-PROD-FLAG      Alpha 1                                   IC62.1
Element: All Flag      This field contains the contiguous
                       production flag, used if production
                       spans multiple days.  Set its value to
                       Yes if production must occur on
                       consecutive days - there cannot be any
                       non-work days between the start and end
                       production dates.
                       Y = Yes
                       N = No

KIT-COST-TOL-PCT       Percent 5.3  (Percent)                    IC62.1
Element: Cost Pct      This field contains the cost tolerance
                       percent for a finished good.

KIT-ZERO-COST-FL       Alpha 1                                   IC62.1
Element: All Flag      The zero cost tolerance flag is used to
                       indicate if zero tolerance is allowed
                       for finished good cost tolerance
                       checking.  If no tolerance checking is
                       needed, this field's value is No.
                       Y = Yes
                       N = No

KIT-QTY-TOL-PCT        Percent 5.3  (Percent)                    IC62.1
Element: Cost Pct      This is the quantity tolerance percent
                       for a finished good.

KIT-ZERO-QTY-FL        Alpha 1                                   IC62.1
Element: All Flag      The zero quantity tolerance flag is
                       used to indicate if zero tolerance is
                       allowed for finished good quantity
                       tolerance checking.  If no tolerance
                       checking is desired, this field's value
                       is No.
                       Y = Yes
                       N = No

KIT-LAST-BRDN-SEQ      Numeric 3                                 IC62.1
Element: Sequence NumbeThis field contains the last burden
                       sequence.

KIT-LAST-BYPRO-SEQ     Numeric 3                                 IC62.2
Element: Sequence NumbeThis field contains the last byproduct
                       sequence.

KIT-CAPACITY           Numeric 8                                 IC62.1
Element: Capacity      Capacity describes the maximum quantity
                       of a finished good that can be produced
                       for a work order.

KIT-FGV-ACCT-UNIT      Alpha 15                                  IC60.1  IC62.1
Element: Accounting UniThe finished good variance accounting
                       unit is used to post variances in
                       finished good cost when there is a
                       difference between the cost from an
                       original work order and the cost
                       returned from inventory for a reversed
                       work order.

KIT-FGV-ACCOUNT        Numeric 6                                 IC60.1  IC62.1
Element: Account       The finished good variance account is
                       used to post variances in finished good
                       cost when there is a difference between
                       the cost from an original work order and
                       the cost returned from inventory for a
                       reversed work order.

KIT-FGV-SUB-ACCT       Numeric 4                                 IC60.1  IC62.1
Element: Subaccount    The finished good variance subaccount
                       is used to post variances in finished
                       good cost when there is a difference
                       between the cost from an original work
                       order and the cost returned from
                       inventory for a reversed work order.

KIT-SCHED-INCR         Numeric 2                                 IC62.1  WO20.1
Element: Sched Incr    Schedule increment is used with
                       schedule frequency to indicate the
                       length of a scheduling period for work
                       orders.  The increment is the number of
                       days, weeks or months in a period.

KIT-SCHED-FREQ         Alpha 1                                   IC62.1
Element: Sched Freq    Schedule frequency is used with
                       schedule increment to indicate the
                       length of a scheduling period for work
                       orders.  The frequency defines whether
                       the period is in days, weeks or months.
                       D = Daily
                       W = Weekly
                       M = Monthly

KIT-PC-ACCT-UNIT       Alpha 15                                  IC62.1
Element: Pc Acct Unit

KIT-PC-ACCOUNT         Numeric 6                                 IC62.1
Element: Pc Account

KIT-PC-SUB-ACCT        Numeric 4                                 IC62.1
Element: Pc Sub Acct

KIT-BA-ACCT-UNIT       Alpha 15                                  IC62.1
Element: Ba Acct Unit

KIT-BA-ACCOUNT         Numeric 6                                 IC62.1
Element: Ba Account

KIT-BA-SUB-ACCT        Numeric 4                                 IC62.1
Element: Ba Sub Acct

KIT-ITEM-CODE-USED     Derived
Element: Item Code Used

                         KITITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

KITSET1   ITEM-GROUP                                             AP125   AP126
          COMPANY                                                AP131   AP20.1
          LOCATION                                               AP20.2  AP20.3
          ITEM                                                   AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC10.2
                                                                 IC11.1  IC12.1
                                                                 IC143   IC28.1
                                                                 IC330   IC60.1
                                                                 IC60.2  IC60.3
                                                                 IC61.1  IC62.1
                                                                 IC62.2  IC63.1
                                                                 ...

KITSET2   MAKE-CD       KeyChange                                IC260   IC262
          ITEM-GROUP                                             IC60.1  IC62.1
          COMPANY                                                IC62.2  RQD1.1
          LOCATION                                               WO10.1  WO120
          ITEM                                                   WO20.1  WO20.2
                                                                 WO220   WO255
                                                                 WO40.1  WO510
                                                                 WO82.1

                         KITITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required
                            When KIT-COMPANY != Zeroes

                            KIT-COMPANY       -> ICC-COMPANY

Iclocation     ICLOCATION   Required
                            When KIT-LOCATION != Spaces

                            KIT-COMPANY       -> ICL-COMPANY
                            KIT-LOCATION      -> ICL-LOCATION

Itemgroup      ITEMGROUP    Required

                            KIT-ITEM-GROUP    -> ITG-ITEM-GROUP

Itemmast       ITEMMAST     Required

                            KIT-ITEM-GROUP    -> ITE-ITEM-GROUP
                            KIT-ITEM          -> ITE-ITEM

                         KITITEM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Component      COMPONENT    Delete Cascades

                            KIT-ITEM-GROUP    -> COM-ITEM-GROUP
                            KIT-COMPANY       -> COM-COMPANY
                            KIT-LOCATION      -> COM-LOCATION
                            KIT-ITEM          -> COM-KIT-ITEM
                                                 COM-SEQ
                                                 COM-OPT-SEQ

Fgburden       ICFGBRDN

                            KIT-COMPANY       -> IBR-COMPANY
                            KIT-LOCATION      -> IBR-LOCATION
                            KIT-ITEM          -> IBR-ITEM
                                                 IBR-SEQ

Fgbyprod       ICFGBYPROD   Delete Restricted

                            KIT-COMPANY       -> ICP-COMPANY
                            KIT-LOCATION      -> ICP-LOCATION
                            KIT-ITEM          -> ICP-FG-ITEM
                                                 ICP-SEQ

Ktinstruct     KTINSTRUCT   Delete Cascades

                            KIT-ITEM-GROUP    -> KTI-ITEM-GROUP
                            KIT-COMPANY       -> KTI-COMPANY
                            KIT-LOCATION      -> KTI-LOCATION
                            KIT-ITEM          -> KTI-KIT-ITEM
                            Zeroes            -> KTI-SEQ
                                                 KTI-INST-LINE

Worder         WORDER

                            KIT-COMPANY       -> WOR-COMPANY
                            KIT-LOCATION      -> WOR-LOCATION
                            KIT-ITEM          -> WOR-ITEM
                                                 WOR-WORK-ORDER
                                                 WOR-WORK-ORDER-SUF