Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICFGBRDN


                             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     WOEX.1    IC63.1

UPDATED BY

IC62.1    IC62.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IBR-COMPANY            Numeric 4                                 IC62.1  IC62.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.

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

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

IBR-SEQ                Numeric 3                                 IC62.1  IC62.4
Element: Sequence NumbeThis field contains the record sequence
                       number of the burden on the finished
                       good template.

IBR-BURDEN-CODE        Alpha 4                                   IC62.1  IC62.4
Element: 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  IC62.4
Element: Vendor ID     The vendor's identification code that
                       the burden is associated with.

IBR-EST-AMT            Signed 18.2                               IC62.1  IC62.4
Element: Intl Amt      This is the estimated amount for flat
                       amount burdens.

IBR-EST-AMT-PER-U      Signed 18.2                               IC62.1  IC62.4
Element: Intl Amt      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  IC62.4
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.

IBR-EST-MULT           Signed 4.1                                IC62.1  IC62.4
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.

IBR-EST-PCT            Percent 5.2  (Percent)                    IC62.1  IC62.4
Element: Percent       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  IC62.4
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  IC62.4
Element: All 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  IC62.4
Element: Est Uom

                         ICFGBRDN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IBRSET1   COMPANY                                                IC262   IC62.1
          LOCATION                                               IC62.4  WOEX.1
          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