Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ICFGBRDN FILE

                         Finished Goods Burden

The Finished Goods Burden file contains burdens that are normally associated
with producing a specific finished good.

REFERENCED BY

IC262     IC63.1

UPDATED BY

IC62.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IBR-COMPANY          Numeric 4                                   IC62.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

IBR-LOCATION         Alpha 5                                     IC62.1
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.

IBR-ITEM             Alpha 32                                    IC62.1
Item Number          This field contains the item identifier
                     of the finished good that this burden is
                     associated with.

IBR-SEQ              Numeric 3                                   IC62.1
Sequence Number      This field contains the record sequence
                     number of the burden on the finished
                     good template.

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

IBR-VENDOR           Alpha 9  (Right Justified)                  IC62.1
Vendor ID            The vendor's identification code that
                     the burden is associated with.

IBR-EST-AMT          Signed 13.2                                 IC62.1
Est Amt              This is the estimated amount for flat
                     amount burdens.

IBR-EST-AMT-PER-U    Signed 13.2                                 IC62.1
Est Amt Per U        This is the estimated amount per unit
                     used in the calculation of per finished
                     good burdens and per burden unit
                     burdens.

IBR-EST-QTY          Signed 13.2                                 IC62.1
Est Qty              This is the estimated quantity used
                     along with estimated amount per unit and
                     estimated multiplier for the calculation
                     of per burden unit burdens.

IBR-EST-MULT         Signed 4.1                                  IC62.1
Est Mult             This is the estimated multiplier used
                     along with estimated amount per unit and
                     estimated quantity for calculation of
                     per burden unit burdens.

IBR-EST-PCT          Percent 5.2  (Percent)                      IC62.1
Est Pct              This is the estimated percentage used
                     along with inventory cost for the
                     calculation of percentage of inventory
                     cost burdens.

IBR-COST-TOL-PCT     Percent 5.3  (Percent)                      IC62.1
Unit Cost Tolerance  This is the cost tolerance percent for
Percent              a burden assigned to a finished good
                     template.

IBR-ZERO-COST-FL     Alpha 1                                     IC62.1
Zero Cost Flag       Zero cost tolerance flag is used to
                     indicate if zero tolerance is allowed
                     for burden cost tolerance checking.  If
                     no tolerance checking is requested, this
                     field would have a value of No.
                     Y = Yes
                     N = No

IBR-EST-UOM          Alpha 4                                     IC62.1
Est Uom

                         ICFGBRDN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IBRSET1   COMPANY                                                IC262   IC62.1
          LOCATION
          ITEM
          SEQ

IBRSET2   COMPANY       KeyChange                                IC63.1
          LOCATION
          BURDEN-CODE
          ITEM
          SEQ

                         ICFGBRDN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                            IBR-COMPANY         -> CPY-COMPANY

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

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            IBR-VENDOR          -> VEN-VENDOR

Icbrdntmpl     ICBRDNTMPL   Required

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