|
|
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
Element: 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
Element: Location Code 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
Element: 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
Element: Work Order SufThis 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
Element: Sequence NumbeThis 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
Element: 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 (Right Justified) WO30.1 WO35.1
Element: Vendor ID 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 18.2 WO30.1 WOEX.1
Element: Intl Amt This is the estimated flat amount
burden costs of the finished good for
this work order.
WBN-EST-AMT-PER-U Signed 18.2 WO30.1 WOEX.1
Element: Intl Amt This is the estimated amount used in
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
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 when the work
order is created.
WBN-EST-MULT Signed 4.1 WO30.1 WOEX.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 when the work
order is created.
WBN-EST-PCT Percent 5.2 (Percent) WO30.1 WOEX.1
Element: Percent 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 18.2 WO35.1 WO40.1
Element: Intl Amt 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 18.2 WO35.1 WO40.1
Element: Intl Amt This is the actual amount per unit used WO40.2 WO40.3
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
Element: Act Qty 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
Element: Act Mult 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
Element: Percent 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
Element: All 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
Element: Perfgesttot The system displays the result of
estimated amount per unit * planned
quantity (computed as EST-AMT-PER-U *
WOR-PLAN-QTY).
WBN-PERBRDNESTTOT Derived
Element: Perbrdnesttot The system displays the result of
estimated amount per unit * estimated
quantity * estimated multiplier
(computed as EST-AMT-PER-U * EST-QTY *
EST-MULT).
WBN-PCTINVESTTOT Derived
Element: Pctinvesttot The system displays the result of
estimated percentage * (estimated
component cost + estimated packaging
cost). Computed as EST-PCT *
(WOR-EST-COMP-COST + WOR-EST-PACK-COST).
WBN-ESTIMATEDTOT Derived
Element: Estimatedtot 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
Element: Perfgacttot The system displays the result of
actual amount per unit * actual quantity
(computed as ACT-AMT-PER-U *
WOR-ACTUAL-QTY).
WBN-PERBRDNACTTOT Derived
Element: Perbrdnacttot The system displays the result of
actual amount per unit * actual quantity
* actual multiplier (computed as
ACT-AMT-PER-U * ACT-QTY * ACT-MULT).
WBN-PCTINVACTTOT Derived
Element: Pctinvacttot The system displays the result of
actual percentage * (actual component
cost + actual packaging cost). Computed
as ACT-PCT * (WOR-ACT-COMP-COST +
WOR-ACT-PACK-COST).
WBN-ACTUALTOT Derived
Element: Actualtot 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
Element: Est Uom A unit of measure other than stock
(alternate UOM), that is used to
determine burden costs associated with
producing a finished good. This amount
is an estimate, defaulted from the
finished good definition.
WBN-ACT-UOM Alpha 4 WO40.1
Element: Act Uom This field is the actual unit of
measure.
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
Wowbnuf WOWBNUF Not Required
WBN-COMPANY -> WBU-COMPANY
WBN-LOCATION -> WBU-LOCATION
WBN-WORK-ORDER -> WBU-WORK-ORDER
WBN-WORK-ORDER-SUF -> WBU-WORK-ORDER-SUF
WBN-SEQ -> WBU-SEQ
|
