|
|
WOBRDN FILE
Work Order Burdens
The Work Order Burdens file contains burdens associated with a work order to
designate non-inventory costs associated with producing the finished good.
REFERENCED BY
WO120 WO133 WO140 WO20.1 WO252 WO255
UPDATED BY
WO30.1 WO300 WO35.1 WO40.1 WO40.2 WO40.3
WO40.4 WO40.5 WO41.1 WO41.2 WO41.3 WO41.4
WO42.1 WO42.2 WO42.3 WO42.4 WO42.5 WO45.1
WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WBN-COMPANY Numeric 4 WO30.1 WO35.1
Company This field contains the company number, WO40.1 WOEX.1
as defined in the Inventory Control
system.
WBN-LOCATION Alpha 5 WO30.1 WO35.1
Location This field contains a valid stock WO40.1 WOEX.1
location within the company inventory.
It is also the production facility
where finished goods are produced.
WBN-WORK-ORDER Numeric 8 WO30.1 WO35.1
Work Order This identifies the work order and may WO40.1 WO45.1
be automatically assigned or manually WOEX.1
assigned, depending on the option
defined for each production (inventory)
location.
WBN-WORK-ORDER-SUF Numeric 2 WO30.1 WO35.1
Work Order Suffix This will normally be zero for a work WO40.1 WO45.1
order. If you chose to split a work WOEX.1 WOSP.1
order so the completed part of the
finished good can be available for
allocation, the work order created for
the remaining quantity will have a
non-zero value in this field.
WBN-SEQ Numeric 3 WO30.1 WO35.1
Sequence This field contains the record sequence WO40.1 WOEX.1
number of the burden for this work
order.
WBN-BURDEN-CODE Alpha 4 WO30.1 WO35.1
Burden Code Burden code identifies a burden that WO40.1 WOEX.1
has cost and rate information which is
used to determine costs in addition to
inventory item costs associated with a
simple production process.
WBN-VENDOR Alpha 9 WO30.1 WO35.1
Vendor This field contains the identification WO40.1 WOEX.1
code of the vendor who performs all or
part of the production process offsite
for this work order.
WBN-EST-AMT Signed 13.2 WO30.1 WOEX.1
Estimated Amount This is the estimated flat amount
burden costs of the finished good for
this work order.
WBN-EST-AMT-PER-U Signed 13.2 WO30.1 WOEX.1
Estimated Amount This is the estimated amount used in
per Unit the calculation of per finished good
burdens and per burden unit burdens when
the work order is created.
WBN-EST-QTY Signed 13.2 WO30.1 WOEX.1
Estimated Quantity This is the estimated quantity used
along with estimated amount per unit and
estimated multiplier for the calculation
of per burden unit burdens when the work
order is created.
WBN-EST-MULT Signed 4.1 WO30.1 WOEX.1
Estimated Multiplier This is the estimated multiplier used
along with estimated amount per unit and
estimated quantity for calculation of
per burden unit burdens when the work
order is created.
WBN-EST-PCT Percent 5.2 (Percent) WO30.1 WOEX.1
Estimated Percentage This is the estimated percentage used
along with inventory cost for the
calculation of percentage of inventory
cost burdens when the work order is
created.
WBN-ACT-AMT Signed 13.2 WO35.1 WO40.1
Actual Amount This is the actual amount for flat WO40.2 WO40.3
amount burdens, determined after WO40.4 WO40.5
production has been completed. WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WBN-ACT-AMT-PER-U Signed 13.2 WO35.1 WO40.1
Actual Amount per This is the actual amount per unit used WO40.2 WO40.3
Unit in the calculation of per finished good WO40.4 WO40.5
burdens and per burden unit burdens, WO41.1 WO41.2
determined after production has been WO41.3 WO41.4
completed. WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WBN-ACT-QTY Signed 13.2 WO35.1 WO40.1
Actual Quantity This is the actual quantity used along WO40.2 WO40.3
with actual amount per unit and actual WO40.4 WO40.5
multiplier for the calculation of per WO41.1 WO41.2
burden unit burdens, determined after WO41.3 WO41.4
production has been completed. WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WBN-ACT-MULT Signed 4.1 WO35.1 WO40.1
Actual Multiplier This is the actual multiplier used WO40.2 WO40.3
along with actual amount per unit and WO40.4 WO40.5
actual quantity for calculation of per WO41.1 WO41.2
burden unit burdens, determined after WO41.3 WO41.4
production has been completed. WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WBN-ACT-PCT Percent 5.2 (Percent) WO35.1 WO40.1
Actual Percentage This is the actual percentage used WO40.2 WO40.3
along with inventory cost for the WO40.4 WO40.5
calculation of percentage of inventory WO41.1 WO41.2
cost burdens, determined after WO41.3 WO41.4
production has been completed. WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WBN-COST-TOL-PCT Percent 5.3 (Percent) WO30.1 WO35.1
Unit Cost Tolerance This is the cost tolerance percent for WOEX.1
Percent a burden on a work order.
WBN-ZERO-COST-FL Alpha 1 WO30.1 WO35.1
Zero Cost Flag The zero cost tolerance flag is used to WOEX.1
indicate if zero tolerance is allowed
for burden cost tolerance checking. If
no tolerance checking is needed, this
field defaults to No.
Y = Yes
N = No
WBN-PERFGESTTOT Derived
Per Finished Good The system displays the result of
Total estimated amount per unit * planned
quantity (computed as EST-AMT-PER-U *
WOR-PLAN-QTY).
WBN-PERBRDNESTTOT Derived
Per Burden The system displays the result of
Estimated Total estimated amount per unit * estimated
quantity * estimated multiplier
(computed as EST-AMT-PER-U * EST-QTY *
EST-MULT).
WBN-PCTINVESTTOT Derived
Percent Inventory The system displays the result of
Est. Total estimated percentage * (estimated
component cost + estimated packaging
cost). Computed as EST-PCT *
(WOR-EST-COMP-COST + WOR-EST-PACK-COST).
WBN-ESTIMATEDTOT Derived
Estimated Total The system displays a conditional field
that will contain the estimated burden
cost based on the burden type and the
appropriate computed field.
WBN-PERFGACTTOT Derived
Per Finished Good The system displays the result of
Total actual amount per unit * actual quantity
(computed as ACT-AMT-PER-U *
WOR-ACTUAL-QTY).
WBN-PERBRDNACTTOT Derived
Per Burder Actual The system displays the result of
Total actual amount per unit * actual quantity
* actual multiplier (computed as
ACT-AMT-PER-U * ACT-QTY * ACT-MULT).
WBN-PCTINVACTTOT Derived
Percent Inventory The system displays the result of
Actual Total actual percentage * (actual component
cost + actual packaging cost). Computed
as ACT-PCT * (WOR-ACT-COMP-COST +
WOR-ACT-PACK-COST).
WBN-ACTUALTOT Derived
Actual Total The system displays a conditional field
that will contain the actual burden cost
based on the burden type and the
appropriate computed field.
WBN-EST-UOM Alpha 4 WO30.1 WOEX.1
Estimated Unit of A unit of measure other than stock,
Measure which is used to determine burden costs
associated with producing a finished
good. This amount is an estimate
defaulted from the finished good.
WBN-ACT-UOM Alpha 4 WO35.1 WO40.1
Actual Unit of A unit of measure, other than stock,
Measure which is used to determine burden costs
associated with producing a specific
finished good. This unit of measure is
an actual, recorded during production
feedback.
WOBRDN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WBNSET1 COMPANY This index is used to access Work Order WO120 WO133
LOCATION burden records for a specific work order WO140 WO20.1
WORK-ORDER and burden sequence number for a WO252 WO255
WORK-ORDER-SUFproduction location. WO30.1 WO300
SEQ WO35.1 WO40.1
WO40.2 WO40.3
WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WO45.1
WOEX.1 WOSP.1
WBNSET2 COMPANY This index is used to access Work Order
LOCATION burden records for a specific burden
BURDEN-CODE code, work order, and burden sequence
WORK-ORDER number for a production location.
WORK-ORDER-SUFKeyChange
SEQ
WOBRDN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Not Required
Valid When WBN-VENDOR != Spaces
WBN-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Not Required
Valid When WBN-VENDOR != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
WBN-VENDOR -> VEN-VENDOR
Icbrdntmpl ICBRDNTMPL Required
WBN-COMPANY -> IBT-COMPANY
WBN-LOCATION -> IBT-LOCATION
WBN-BURDEN-CODE -> IBT-BURDEN-CODE
Worder WORDER Required
WBN-COMPANY -> WOR-COMPANY
WBN-LOCATION -> WOR-LOCATION
WBN-WORK-ORDER -> WOR-WORK-ORDER
WBN-WORK-ORDER-SUF -> WOR-WORK-ORDER-SUF
Wosgblk WOSGBLK Not Required
WBN-COMPANY -> WSB-COMPANY
WBN-LOCATION -> WSB-LOCATION
WBN-WORK-ORDER -> WSB-WORK-ORDER
WBN-WORK-ORDER-SUF -> WSB-WORK-ORDER-SUF
Zeroes -> WSB-COMPONENT-SEQ
WBN-SEQ -> WSB-SEQ
|