ICBRDNTMPL FILE
Burden Template
Burden templates are set up by inventory location (production facility) to
represent non-inventory costs included in the total cost of producing finished
goods.
REFERENCED BY
IC262 IC263
UPDATED BY
IC62.1 IC63.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IBT-COMPANY Numeric 4 IC63.1
Company The company number represents an
established company and is entered on
all function codes.
IBT-LOCATION Alpha 5 IC63.1
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.
IBT-BURDEN-CODE Alpha 4 IC63.1
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.
IBT-BURDEN-TYPE Alpha 1 IC63.1
Burden Type Burden type is used to determine the
type of calculation that is used to
arrive at the total cost associated with
a specific burden.
A = Flat Amount
F = Amount Per FG Unit
U = Amount Per Burden Unit
P = Percent Of FG Inventory Cost
IBT-ACCT-UNIT Alpha 15 IC63.1
Accounting Unit 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.
IBT-ACCOUNT Numeric 6 IC63.1
Account 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.
IBT-SUB-ACCOUNT Numeric 4 IC63.1
Subaccount 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.
IBT-DESCRIPTION Alpha 30 (Lower Case) IC63.1
Description This field contains the burden
description.
IBT-VENDOR Alpha 9 (Right Justified) IC63.1
Vendor ID This field contains the vendor's
identification code that the burden is
associated with.
IBT-EST-AMT Signed 13.2 IC63.1
Est Amt This is the estimated amount for flat
amount burdens.
IBT-EST-AMT-PER-U Signed 13.2 IC63.1
Est Amt Per U This is the estimated amount per unit
used in the calculation of per finished
good burdens and per burden unit
burdens.
IBT-EST-QTY Signed 13.2 IC63.1
Est Qty This is the estimated quantity used
along with estimated amount per unit and
estimated multiplier for the calculation
of per burden unit burdens.
IBT-EST-MULT Signed 4.1 IC63.1
Est Mult This is the estimated multiplier used
along with estimated amount per unit and
estimated quantity for calculation of
per burden unit burdens.
IBT-EST-PCT Percent 5.2 (Percent) IC63.1
Est Pct This is the estimated percentage used
along with inventory cost for the
calculation of percentage of inventory
cost burdens.
IBT-AMT-PER-U-LBL Alpha 10 (Lower Case) IC63.1
Amt Per U Lbl 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.
IBT-QTY-LBL Alpha 10 (Lower Case) IC63.1
Qty Lbl 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.
IBT-MULT-LBL Alpha 10 (Lower Case) IC63.1
Mult Lbl 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.
IBT-ACTIVE-STATUS Alpha 1 IC63.1
Status 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.
A = Active
I = Inactive
IBT-USED-FL Alpha 1 IC62.1 IC63.1
Used 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.
N = No
Y = Yes
IBT-EST-UOM Alpha 4 IC63.1
Est Uom
ICBRDNTMPL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IBTSET1 COMPANY IC262 IC263
LOCATION IC62.1 IC63.1
BURDEN-CODE
IBTSET2 COMPANY KeyChange
LOCATION
DESCRIPTION
BURDEN-CODE
ICBRDNTMPL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
ICBRDNTMPL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Icfgbrdn ICFGBRDN
IBT-COMPANY -> IBR-COMPANY
IBT-LOCATION -> IBR-LOCATION
IBT-BURDEN-CODE -> IBR-BURDEN-CODE
IBR-ITEM
IBR-SEQ
|
