ICBRDNTMPL

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 IC62.4 IC63.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IBT-COMPANY
Element: Company
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
Element: Location
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
Element: Burden 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-TYPE
Element: Burden 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.
A = Flat Amount
F = Amount Per FG Unit
U = Amount Per Burden Unit
P = Percent Of FG Inventory Cost
IC63.1
IBT-ACCT-UNIT
Element: Acct 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-ACCOUNT
Element: Account
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-ACCOUNT
Element: Sub Acct
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-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the burden description.
IC63.1
IBT-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
This field contains the vendor's identification code that the burden is associated with.
IC63.1
IBT-EST-AMT
Element: Intl Amt
Signed 18.2
IC63.1
IBT-EST-AMT-PER-U
Element: Intl Amt
Signed 18.2
IC63.1
IBT-EST-QTY
Element: Act 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-MULT
Element: Act 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-PCT
Element: Pct
Percent 5.2 (Percent)
IC63.1
IBT-AMT-PER-U-LBL
Element: Amt 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-LBL
Element: Qty 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-LBL
Element: Mult 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-STATUS
Element: Active 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.
A = Active
I = Inactive
IC63.1
IBT-USED-FL
Element: Used 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.
N = No
Y = Yes
IC62.1 IC62.4
IC63.1
IBT-EST-UOM
Element: Est Uom
Alpha 4
IC63.1


ICBRDNTMPL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IBTSET1 COMPANY
LOCATION
BURDEN-CODE
IC262 IC263
IC62.1 IC62.4
IC63.1
IBTSET2 COMPANY
LOCATION
DESCRIPTION
BURDEN-CODE
KeyChange


ICBRDNTMPL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:18:32 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.