ICFGBRDN – Finished Goods Burden

System
Inventory Control (IC)
Prefix
IBR
Primary key
COMPANY, LOCATION, ITEM, SEQ
Fields
14
Updated by
2 programs
Referenced by
2 programs

ICFGBRDN is the Finished Goods Burden table in Lawson Inventory Control (prefix IBR). It is indexed by COMPANY, LOCATION, ITEM, SEQ (IBRSET1); alternate indexes: IBRSET2. It is related 1:1 to APCOMPANY, APVENMAST and ICBRDNTMPL. It is updated by IC62.1 and IC62.4 and referenced by IC262 and IC63.1. The table has 14 fields, 2 indexes and 3 documented relations.

About ICFGBRDN

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

Fields (14)

Column = COBOL field name without the IBR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#IBR-COMPANY PK
COMPANY		Numeric 4Identifies 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.IC62.1, IC62.4
#IBR-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory. It is also the production facility where finished goods are produced for work orders.IC62.1, IC62.4
#IBR-ITEM PK
ITEM		Alpha 32This field contains the item identifier of the finished good that this burden is associated with.IC62.1, IC62.4
#IBR-SEQ PK
SEQ		Numeric 3This field contains the record sequence number of the burden on the finished good template.IC62.1, IC62.4
#IBR-BURDEN-CODE SET2
BURDEN_CODE		Alpha 4A 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.IC62.1, IC62.4
#IBR-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code that the burden is associated with.IC62.1, IC62.4
#IBR-EST-AMT
EST_AMT		Signed 18.2—IC62.1, IC62.4
#IBR-EST-AMT-PER-U
EST_AMT_PER_U		Signed 18.2—IC62.1, IC62.4
#IBR-EST-QTY
EST_QTY		Signed 13.2This is the estimated quantity used along with estimated amount per unit and estimated multiplier for the calculation of per burden unit burdens.IC62.1, IC62.4
#IBR-EST-MULT
EST_MULT		Signed 4.1This is the estimated multiplier used along with estimated amount per unit and estimated quantity for calculation of per burden unit burdens.IC62.1, IC62.4
#IBR-EST-PCT
EST_PCT		Percent 5.2 (Percent)—IC62.1, IC62.4
#IBR-COST-TOL-PCT
COST_TOL_PCT		Percent 5.3 (Percent)This is the cost tolerance percent for a burden assigned to a finished good template.IC62.1, IC62.4
#IBR-ZERO-COST-FL
ZERO_COST_FL		Alpha 1Zero 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
IC62.1, IC62.4
#IBR-EST-UOM
EST_UOM		Alpha 4—IC62.1, IC62.4

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IBRSET1
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. SEQ
PrimaryIC262, IC62.1, IC62.4
IBRSET2
  1. COMPANY
  2. LOCATION
  3. BURDEN-CODE
  4. ITEM
  5. SEQ
KeyChangeIC63.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYAPVENMASTICBRDNTMPLICFGBRDN

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYNot RequiredValid When IBR-VENDOR != Spaces
IBR-COMPANY→CPY-COMPANY
ApvenmastAPVENMASTNot RequiredValid When IBR-VENDOR != Spaces
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
IBR-VENDOR→VEN-VENDOR
IcbrdntmplICBRDNTMPLRequired
IBR-COMPANY→IBT-COMPANY
IBR-LOCATION→IBT-LOCATION
IBR-BURDEN-CODE→IBT-BURDEN-CODE

Programs

Updated by (2)

Referenced by (2)