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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

IBR-ITEM               Alpha 32                                  IC62.1
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
Element: Sequence NumbeThis field contains the record sequence
                       number of the burden on the finished
                       good template.

IBR-BURDEN-CODE        Alpha 4                                   IC62.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.

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

IBR-EST-AMT            Signed 13.2                               IC62.1
Element: Act Amt

IBR-EST-AMT-PER-U      Signed 13.2                               IC62.1
Element: Act Amt

IBR-EST-QTY            Signed 13.2                               IC62.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.

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

IBR-EST-PCT            Percent 5.2  (Percent)                    IC62.1
Element: Percent

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

IBR-ZERO-COST-FL       Alpha 1                                   IC62.1
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
Element: Est Uom

                         ICFGBRDN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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