Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            KTINSTRUCT FILE

                            Kit Instructions

The Kit Instructions file contains the assembly instructions for
make-to-order and finished good kits.  They can be added to any component item
in the kit.

REFERENCED BY

IC260     WH130

UPDATED BY

IC60.1    IC60.3    IC61.1    IC62.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

KTI-COMPANY          Numeric 4                                   IC60.3
Company              The company number represents an
                     established company and is entered on
                     all function codes.

KTI-LOCATION         Alpha 5                                     IC60.3
Location Code        This field contains a valid stocking
                     location within the company inventory.

KTI-KIT-ITEM         Alpha 32                                    IC60.1  IC60.3
Kit Item             This field contains the parent item
                     made up of component items.

KTI-SEQ              Numeric 3                                   IC60.1  IC60.3
Sequence Number      This field contains the sequence number
                     of the component item line.

KTI-INST-LINE        Numeric 3                                   IC60.3
Instruction Line     This field contains the number of the
                     instruction line.

KTI-INSTRUCTION      Alpha 40  (Lower Case)                      IC60.3
Instruction Text     This field contains the one line of
                     instruction text.

                         KTINSTRUCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

KTISET1   ITEM-GROUP                                             IC260   IC60.1
          COMPANY                                                IC60.3  IC61.1
          LOCATION                                               IC62.1  WH130
          KIT-ITEM
          SEQ
          INST-LINE

                         KTINSTRUCT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Component      COMPONENT    Required
                            When KTI-SEQ != Zeroes

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

Itemmast       ITEMMAST     Required

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

Kititem        KITITEM      Required
                            When KTI-SEQ = Zeroes

                            KTI-ITEM-GROUP    -> KIT-ITEM-GROUP
                            KTI-COMPANY       -> KIT-COMPANY
                            KTI-LOCATION      -> KIT-LOCATION
                            KTI-KIT-ITEM      -> KIT-ITEM