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    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL85.1    BL85.2
BL90.1    BL92.1    CXCP.1    IC11.1    IC12.1    IC330
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PO100     PO101     PO122     PO131
PO190     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.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    PO32.4
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    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1    RQ13.2
RQ35.1    RQ500     RQIC.1    RQID.1    RQIF.1    RQIG.1
RQIH.1    RQIJ.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     RQD1.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

KIT-COMPANY            Numeric 4
Element: Company       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.

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

KIT-ITEM               Alpha 32
Element: Item          This field contains the item
                       identifier.

KIT-ORDER-SIZE         Numeric 8
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)
Element: Notes         This field contains notes about the
                       kit. This information is for reference
                       purposes only.

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

KIT-MAKE-CD            Alpha 1
Element: Make Cd       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
Element: Active Status This field contains the status to
                       control the use of the kit.
                       A = Active
                       I = Inactive

KIT-SEQ                Numeric 3
Element: Seq           This 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
Element: Inst Line     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
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)
Element: Cost Tol Pct  This field contains the cost tolerance
                       percent for a finished good.

KIT-ZERO-COST-FL       Alpha 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)
Element: Qty Tol Pct   This is the quantity tolerance percent
                       for a finished good.

KIT-ZERO-QTY-FL        Alpha 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
Element: Seq           This field contains the last burden
                       sequence.

KIT-LAST-BYPRO-SEQ     Numeric 3
Element: Seq           This field contains the last byproduct
                       sequence.

KIT-CAPACITY           Numeric 8
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
Element: Acct Unit     The 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
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
Element: Sub Acct      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
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
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
Element: Pc Acct Unit

KIT-PC-ACCOUNT         Numeric 6
Element: Pc Account

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

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

KIT-BA-ACCOUNT         Numeric 6
Element: Ba Account

KIT-BA-SUB-ACCT        Numeric 4
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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL85.1  BL85.2
                                                                 ...

KITSET2   MAKE-CD       KeyChange                                RQD1.1
          ITEM-GROUP
          COMPANY
          LOCATION
          ITEM

                         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

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