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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IBR-COMPANY PKCOMPANY | Numeric 4 | 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. | IC62.1, IC62.4 |
IBR-LOCATION PKLOCATION | Alpha 5 | 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. | IC62.1, IC62.4 |
IBR-ITEM PKITEM | Alpha 32 | This field contains the item identifier of the finished good that this burden is associated with. | IC62.1, IC62.4 |
IBR-SEQ PKSEQ | Numeric 3 | This field contains the record sequence number of the burden on the finished good template. | IC62.1, IC62.4 |
IBR-BURDEN-CODEBURDEN_CODE | Alpha 4 | 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. | IC62.1, IC62.4 |
IBR-VENDORVENDOR | Alpha 9 (Right Justified) | The vendor's identification code that the burden is associated with. | IC62.1, IC62.4 |
IBR-EST-AMTEST_AMT | Signed 18.2 | — | IC62.1, IC62.4 |
IBR-EST-AMT-PER-UEST_AMT_PER_U | Signed 18.2 | — | IC62.1, IC62.4 |
IBR-EST-QTYEST_QTY | Signed 13.2 | This 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-MULTEST_MULT | Signed 4.1 | This 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-PCTEST_PCT | Percent 5.2 (Percent) | — | IC62.1, IC62.4 |
IBR-COST-TOL-PCTCOST_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-FLZERO_COST_FL | Alpha 1 | 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.
| IC62.1, IC62.4 |
IBR-EST-UOMEST_UOM | Alpha 4 | — | IC62.1, IC62.4 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IBRSET1 | COMPANY, LOCATION, ITEM, SEQ | Primary | IC262, IC62.1, IC62.4 | |
IBRSET2 | COMPANY, LOCATION, BURDEN-CODE, ITEM, SEQ | KeyChange | IC63.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |