ICBRDNTMPL – Burden Template
- System
- Inventory Control (IC)
- Prefix
IBT- Primary key
COMPANY,LOCATION,BURDEN-CODE- Fields
- 20
- Updated by
- 3 programs
- Referenced by
- 2 programs
ICBRDNTMPL is the Burden Template table in Lawson Inventory Control (prefix IBT). It is indexed by COMPANY, LOCATION, BURDEN-CODE (IBTSET1); alternate indexes: IBTSET2. It is related 1:1 to APCOMPANY, APVENMAST, GLMASTER, ICCOMPANY and ICLOCATION and 1:M to ICFGBRDN. It is updated by IC62.1, IC62.4 and IC63.1 and referenced by IC262 and IC263. The table has 20 fields, 2 indexes and 6 documented relations.
About ICBRDNTMPL
Burden templates are set up by inventory location (production facility) to represent non-inventory costs included in the total cost of producing finished goods.
Fields (20)
Column = COBOL field name without the IBT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IBT-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. | IC63.1 |
IBT-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. | IC63.1 |
IBT-BURDEN-CODE PKBURDEN_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. | IC63.1 |
IBT-BURDEN-TYPEBURDEN_TYPE | Alpha 1 | Burden type is used to determine the type of calculation that is used to arrive at the total cost associated with a specific burden.
| IC63.1 |
IBT-ACCT-UNITACCT_UNIT | Alpha 15 | The accounting unit (along with the account and subaccount fields) are used to default to burdens as they are added to finished good templates when no account information is entered. The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | IC63.1 |
IBT-ACCOUNTACCOUNT | Numeric 6 | This field, along with the accounting unit and subaccount, make up the location (account) where amounts and other account information are stored. These fields are defaulted to burdens added to finished good templates when no account information is entered. | IC63.1 |
IBT-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | This field, along with the accounting unit and subaccount, make up the location (account) where amounts and other account information is stored. These fields are defaulted to burdens added to finished good templates when no account information is entered. | IC63.1 |
IBT-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the burden description. | IC63.1 |
IBT-VENDORVENDOR | Alpha 9 (Right Justified) | This field contains the vendor's identification code that the burden is associated with. | IC63.1 |
IBT-EST-AMTEST_AMT | Signed 18.2 | — | IC63.1 |
IBT-EST-AMT-PER-UEST_AMT_PER_U | Signed 18.2 | — | IC63.1 |
IBT-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. | IC63.1 |
IBT-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. | IC63.1 |
IBT-EST-PCTEST_PCT | Percent 5.2 (Percent) | — | IC63.1 |
IBT-AMT-PER-U-LBLAMT_PER_U_LBL | Alpha 10 (Lower Case) | Amount per unit label can be used to describe the measurement of the amount per unit field for 'per burden unit' burdens. 'Hourly Rt' is an example for this label. | IC63.1 |
IBT-QTY-LBLQTY_LBL | Alpha 10 (Lower Case) | Quantity label can be used to describe the measurement of the quantity field for 'per burden unit' burdens. 'Hours' is an example for this label. | IC63.1 |
IBT-MULT-LBLMULT_LBL | Alpha 10 (Lower Case) | Multiplier label can be used to describe the measurement of the multiplier field for 'per burden unit' burdens. 'Employees' is an example for this label. | IC63.1 |
IBT-ACTIVE-STATUSACTIVE_STATUS | Alpha 1 | The status of the burden. If Inactive, it cannot be used as a burden on any finished good template and cannot be added to a work order as an additional burden.
| IC63.1 |
IBT-USED-FLUSED_FL | Alpha 1 | The used flag indicates if the burden has been used as a burden on a finished good template or work order at any time. If it has, this burden template record cannot be deleted.
| IC62.1, IC62.4, IC63.1 |
IBT-EST-UOMEST_UOM | Alpha 4 | — | IC63.1 |
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 |
|---|---|---|---|---|
IBTSET1 | COMPANY, LOCATION, BURDEN-CODE | Primary | IC262, IC263, IC62.1, IC62.4, IC63.1 | |
IBTSET2 | COMPANY, LOCATION, DESCRIPTION, BURDEN-CODE | KeyChange | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apcompany | APCOMPANY | Not Required | Valid When IBT-VENDOR != Spaces | IBT-COMPANY → CPY-COMPANY |
| Apvenmast | APVENMAST | Not Required | Valid When IBT-VENDOR != Spaces | CPY-VENDOR-GROUP → VEN-VENDOR-GROUP, IBT-VENDOR → VEN-VENDOR |
| Glmaster | GLMASTER | Required | IBT-COMPANY → GLM-COMPANY, IBT-ACCT-UNIT → GLM-ACCT-UNIT, IBT-ACCOUNT → GLM-ACCOUNT, IBT-SUB-ACCOUNT → GLM-SUB-ACCOUNT | |
| Iccompany | ICCOMPANY | Required | IBT-COMPANY → ICC-COMPANY | |
| Iclocation | ICLOCATION | Required | IBT-COMPANY → ICL-COMPANY, IBT-LOCATION → ICL-LOCATION |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Icfgbrdn | ICFGBRDN | IBT-COMPANY → IBR-COMPANY, IBT-LOCATION → IBR-LOCATION, IBT-BURDEN-CODE → IBR-BURDEN-CODE, IBR-ITEM, IBR-SEQ |