|
|
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 WO120 WO133 WO140 WO20.1
WO252 WO255 WOSP.1
UPDATED BY
IC62.1 IC62.4 IC63.1 WO30.1 WO35.1 WO40.1
WOEX.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IBT-COMPANY Numeric 4 IC63.1
Element: Company 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.
IBT-LOCATION Alpha 5 IC63.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.
IBT-BURDEN-CODE Alpha 4 IC63.1
Element: 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
Element: 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
Element: Accounting UniThe 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
Element: 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
Element: 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
Element: Description This field contains the burden
description.
IBT-VENDOR Alpha 9 (Right Justified) IC63.1
Element: Vendor ID This field contains the vendor's
identification code that the burden is
associated with.
IBT-EST-AMT Signed 18.2 IC63.1
Element: Intl Amt This is the estimated amount for flat
amount burdens.
IBT-EST-AMT-PER-U Signed 18.2 IC63.1
Element: Intl Amt 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
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.
IBT-EST-MULT Signed 4.1 IC63.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.
IBT-EST-PCT Percent 5.2 (Percent) IC63.1
Element: Percent 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
Element: 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
Element: 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
Element: 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
Element: 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 IC62.4
Element: Used The used flag indicates if the burden IC63.1 WO30.1
has been used as a burden on a finished WO35.1 WO40.1
good template or work order at any time. WOEX.1
If it has, this burden template record
cannot be deleted.
N = No
Y = Yes
IBT-EST-UOM Alpha 4 IC63.1
Element: Est Uom
ICBRDNTMPL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IBTSET1 COMPANY IC262 IC263
LOCATION IC62.1 IC62.4
BURDEN-CODE IC63.1 WO120
WO133 WO140
WO20.1 WO252
WO255 WO30.1
WO35.1 WO40.1
WOEX.1 WOSP.1
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
|
