Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICBRDNTMPL


                            ICBRDNTMPL FILE

                            Burden Template

Burden templates are set up by inventory location (production facility) to
represent non-inventory costs included in the total cost of producing finished
goods.

REFERENCED BY

IC262     IC263     WO120     WO133     WO140     WO20.1
WO252     WO255     WOSP.1

UPDATED BY

IC62.1    IC63.1    WO30.1    WO35.1    WO40.1    WOEX.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IBT-COMPANY            Numeric 4                                 IC63.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

IBT-LOCATION           Alpha 5                                   IC63.1
Element: Location Code This field contains a valid stock
                       location within the company inventory.
                       It is also the production facility where
                       finished goods are produced for work
                       orders.

IBT-BURDEN-CODE        Alpha 4                                   IC63.1
Accounts Receivable    A burden code identifies a burden that
Code                   has cost and rate information that is
                       used to determine costs in addition to
                       inventory item costs associated with a
                       simple production process.

IBT-BURDEN-TYPE        Alpha 1                                   IC63.1
Element: Burden Type   Burden type is used to determine the
                       type of calculation that is used to
                       arrive at the total cost associated with
                       a specific burden.

                       A = Flat Amount
                       F = Amount Per FG Unit
                       U = Amount Per Burden Unit
                       P = Percent Of FG Inventory Cost

IBT-ACCT-UNIT          Alpha 15                                  IC63.1
Element: Accounting UniThe accounting unit (along with the
                       account and subaccount fields) are used
                       to default to burdens as they are added
                       to finished good templates when no
                       account information is entered.

                       The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.



IBT-ACCOUNT            Numeric 6                                 IC63.1
Element: Account       This field, along with the accounting
                       unit and subaccount, make up the
                       location (account) where amounts and
                       other account information are stored.
                       These fields are defaulted to burdens
                       added to finished good templates when no
                       account information is entered.



IBT-SUB-ACCOUNT        Numeric 4                                 IC63.1
Element: Subaccount    This field, along with the accounting
                       unit and subaccount, make up the
                       location (account) where amounts and
                       other account information is stored.
                       These fields are defaulted to burdens
                       added to finished good templates when no
                       account information is entered.


IBT-DESCRIPTION        Alpha 30  (Lower Case)                    IC63.1
Element: Description   This field contains the burden
                       description.

IBT-VENDOR             Alpha 9  (Right Justified)                IC63.1
Element: Vendor ID     This field contains the vendor's
                       identification code that the burden is
                       associated with.

IBT-EST-AMT            Signed 13.2                               IC63.1
Element: Act Amt

IBT-EST-AMT-PER-U      Signed 13.2                               IC63.1
Element: Act Amt

IBT-EST-QTY            Signed 13.2                               IC63.1
Element: Act Qty       This is the estimated quantity used
                       along with estimated amount per unit and
                       estimated multiplier for the calculation
                       of per burden unit burdens.

IBT-EST-MULT           Signed 4.1                                IC63.1
Element: Act Mult      This is the estimated multiplier used
                       along with estimated amount per unit and
                       estimated quantity for calculation of
                       per burden unit burdens.

IBT-EST-PCT            Percent 5.2  (Percent)                    IC63.1
Element: Percent

IBT-AMT-PER-U-LBL      Alpha 10  (Lower Case)                    IC63.1
Element: Mult Lbl      Amount per unit label can be used to
                       describe the measurement of the amount
                       per unit field for 'per burden unit'
                       burdens.  'Hourly Rt' is an example for
                       this label.

IBT-QTY-LBL            Alpha 10  (Lower Case)                    IC63.1
Element: Mult Lbl      Quantity label can be used to describe
                       the measurement of the quantity field
                       for 'per burden unit' burdens.  'Hours'
                       is an example for this label.

IBT-MULT-LBL           Alpha 10  (Lower Case)                    IC63.1
Element: Mult Lbl      Multiplier label can be used to
                       describe the measurement of the
                       multiplier field for 'per burden unit'
                       burdens. 'Employees' is an example for
                       this label.

IBT-ACTIVE-STATUS      Alpha 1                                   IC63.1
Element: Status        The status of the burden. If Inactive,
                       it cannot be used as a burden on any
                       finished good template and cannot be
                       added to a work order as an additional
                       burden.
                       A = Active
                       I = Inactive

IBT-USED-FL            Alpha 1                                   IC62.1  IC63.1
Element: Used          The used flag indicates if the burden     WO30.1  WO35.1
                       has been used as a burden on a finished   WO40.1  WOEX.1
                       good template or work order at any time.
                       If it has, this burden template record
                       cannot be deleted.
                       N = No
                       Y = Yes

IBT-EST-UOM            Alpha 4                                   IC63.1
Element: Est Uom

                         ICBRDNTMPL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IBTSET1   COMPANY                                                IC262   IC263
          LOCATION                                               IC62.1  IC63.1
          BURDEN-CODE                                            WO120   WO133
                                                                 WO140   WO20.1
                                                                 WO252   WO255
                                                                 WO30.1  WO35.1
                                                                 WO40.1  WOEX.1
                                                                 WOSP.1

IBTSET2   COMPANY       KeyChange
          LOCATION
          DESCRIPTION
          BURDEN-CODE

                         ICBRDNTMPL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Not Required
                            Valid When IBT-VENDOR != Spaces

                            IBT-COMPANY         -> CPY-COMPANY

Apvenmast      APVENMAST    Not Required
                            Valid When IBT-VENDOR != Spaces

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            IBT-VENDOR          -> VEN-VENDOR

Glmaster       GLMASTER     Required

                            IBT-COMPANY         -> GLM-COMPANY
                            IBT-ACCT-UNIT       -> GLM-ACCT-UNIT
                            IBT-ACCOUNT         -> GLM-ACCOUNT
                            IBT-SUB-ACCOUNT     -> GLM-SUB-ACCOUNT

Iccompany      ICCOMPANY    Required

                            IBT-COMPANY         -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            IBT-COMPANY         -> ICL-COMPANY
                            IBT-LOCATION        -> ICL-LOCATION

                         ICBRDNTMPL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icfgbrdn       ICFGBRDN

                            IBT-COMPANY         -> IBR-COMPANY
                            IBT-LOCATION        -> IBR-LOCATION
                            IBT-BURDEN-CODE     -> IBR-BURDEN-CODE
                                                   IBR-ITEM
                                                   IBR-SEQ