|
|
WOITEM FILE
Work Order Items
The Work Order Items file contains information about components used in the
process of producing a finished good for a specific work order.
REFERENCED BY
WHD2.1
UPDATED BY
WHD3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOI-COMPANY Numeric 4
Element: Company This field contains the company number,
as defined in the Inventory Control
system.
WOI-LOCATION Alpha 5
Element: Location This field contains a valid stock
location within the company inventory.
It is also the production facility
where finished goods are produced.
WOI-WORK-ORDER Numeric 8
Element: Work Order This field identifies the work order
and may be automatically assigned or
manually assigned, depending on the
option defined for each production
(inventory) location.
WOI-WORK-ORDER-SUF Numeric 2
Element: Work Order SufThis field will normally be zero for a
work order. If you chose to split a
work order so the completed part of the
finished goods can be available for
allocation, the work order created for
the remaining quantity will have a
non-zero value in this field.
WOI-COMPONENT-SEQ Numeric 3
Element: Seq The component sequence number is the
order in which this component is added
to the finished good during the
production process.
WOI-COMPONENT-TYPE Alpha 1
Element: Component TypeThe component type specifies whether
the component is an inventory component
used in the production of the finished
good, a packaging item, or an offsite
item.
C = Component
P = Packaging
O = Offsite Component
R = Rework
WOI-ITEM Alpha 32
Element: Item This field contains the item identifier
of the component, as defined in the
Inventory Control system.
WOI-INV-LOCATION Alpha 5
Element: Location This field contains a valid stocking
location within the company inventory.
WOI-PLAN-QTY Signed 13.4
Element: Quantity This field contains the planned
quantity for an item for a work order.
WOI-ACTUAL-QTY Signed 13.4
Element: Quantity This is the actual quantity of the
component used to make the finished
goods for this work order.
WOI-ACT-CTW-QTY Signed 13.4
Element: Quantity This is the actual catch weight
quantity of the component used to make
the finished goods for this work order.
WOI-PICKED-QTY Signed 13.4
Element: Quantity This is the quantity of the component
that was picked for the work order.
WOI-DETAIL-QTY Signed 13.4
Element: Quantity This field shows the total quantity of
details defined for a detail tracked
item. It is matched against the line
quantity field to determine if details
are in balance.
WOI-CATCH-WT-QTY Signed 13.4
Element: Quantity This is the catch weight quantity of
the component that was picked for the
work order.
WOI-DTL-CTW-QTY Signed 13.4
Element: Quantity This field is not currently used by the
Work Order system.
WOI-WST-ACCT-UNIT Alpha 15
Element: Acct Unit The waste account unit is part of the
account where the cost of components
that were wasted during the work order
production process are posted. The cost
of wasted components are not included in
the cost of the finished good.
WOI-WST-ACCOUNT Numeric 6
Element: Account The waste account is part of the
account where the cost of the components
that were wasted during the work order
production process are posted. The cost
of wasted components are not included in
the cost the finished good.
WOI-WST-SUB-ACCT Numeric 4
Element: Sub Acct The waste subaccount is part of the
account where the cost of components
that were wasted during the work order
process are posted. The cost of wasted
components are not included in the cost
of the finished good.
WOI-WASTE-QTY Signed 13.4
Element: Quantity This is the quantity of the component
that was wasted during the work order
production process and was not used in
the finished good.
WOI-WST-CTW-QTY Signed 13.4
Element: Quantity This is the catch weight quantity of
the component that was wasted during the
work order production process and was
not used in the finished good.
WOI-EST-COMP-COST Signed 18.5
Element: Intl Cost This is the estimated unit cost of the
component.
WOI-ACT-COMP-COST Signed 18.5
Element: Intl Cost This is the actual unit cost of
components that were not picked but were
consumed, that is, used in the finished
good or wasted. This field will be zero
if the picked quantity is greater than
the sum of the actual quantity and the
waste quantity.
WOI-PICKED-COST Signed 18.5
Element: Intl Cost This is the unit cost for components
that were picked.
WOI-TOT-ACT-COST Signed 18.5
Element: Intl Cost This is the extended cost of the
components used to make the finished
goods for this work order. The cost of
any wasted components is not included in
this field.
WOI-TOT-WASTE-COST Signed 18.5
Element: Intl Cost This is the extended cost of components
that were wasted during the production
process for this work order. This cost
is not included in the inventory costs
of the finished good produced.
WOI-QTY-TOL-PCT Percent 5.3 (Percent)
Element: Qty Tol Pct This field contains the quantity
tolerance percent of the component.
WOI-ZERO-QTY-FL Alpha 1
Element: All Flag The zero quantity tolerance flag is
used to indicate if zero tolerance is
allowed for the component on this work
order. This field is loaded from the
component definition on the finished
good template when the component is
added to the work order through work
order explosion or another entry method.
Y = Yes
N = No
WOI-WALK-THRU-REQ Alpha 1
Element: Req Comments This field indicates that a transaction
line is out of balance. For example,
if lot, bin, or serial number quantities
do not equal the transaction quantity,
select the WalkThru form action to
balance the transaction quantities.
WOI-DISP-INV-LOC Derived
Element: Disp Inv Loc The system displays a string that
contains inventory location
(INV-LOCATION) preceded by a label for
the inventory location.
WOI-DISP-LOCATION Derived
Element: Disp Location The system displays a conditional field
that will contain display inventory
location (DISP-INV-LOC) if the value of
inventory location (INV-LOCATION) is
different than location (LOCATION).
WOI-ME-ACCT-UNIT Alpha 15
Element: Me Acct Unit The material expense account unit is
used to record component costs
associated with the production of
finished goods.
WOI-ME-ACCOUNT Numeric 6
Element: Me Account The material expense account is used to
record component costs associated with
the production of finished goods.
WOI-ME-SUB-ACCT Numeric 4
Element: Me Sub Acct The material expense subaccount is used
to record component costs associated
with the production of finished goods.
WOITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOISET1 COMPANY WHD2.1 WHD3.1
LOCATION
WORK-ORDER
WORK-ORDER-SUF
COMPONENT-SEQ
WOISET2 COMPANY KeyChange
LOCATION
WORK-ORDER
WORK-ORDER-SUF
INV-LOCATION
COMPONENT-SEQ
WOISET3 COMPANY KeyChange
LOCATION
WORK-ORDER
WORK-ORDER-SUF
COMPONENT-TYPE
COMPONENT-SEQ
WOISET4 COMPANY KeyChange, Subset
LOCATION Where (WALK-THRU-REQ = "Y" )
WORK-ORDER
WORK-ORDER-SUF
COMPONENT-SEQ
WOISET5 COMPANY KeyChange, Subset
LOCATION Where COMPONENT-TYPE != "O"
WORK-ORDER
WORK-ORDER-SUF
COMPONENT-SEQ
WOITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WOI-COMPANY -> ICC-COMPANY (ICCSET1)
Iclocation ICLOCATION Required
WOI-COMPANY -> ICL-COMPANY
WOI-INV-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Not Required
WOI-COMPANY -> ITL-COMPANY
WOI-INV-LOCATION -> ITL-LOCATION
WOI-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WOI-ITEM -> ITE-ITEM
Waste Account GLMASTER Not Required
Valid When WOI-WST-ACCT-UNIT != Spaces
Or WOI-WST-ACCOUNT != Zeroes
Or WOI-WST-SUB-ACCT != Zeroes
WOI-COMPANY -> GLM-COMPANY
WOI-WST-ACCT-UNIT -> GLM-ACCT-UNIT
WOI-WST-ACCOUNT -> GLM-ACCOUNT
WOI-WST-SUB-ACCT -> GLM-SUB-ACCOUNT
Wo Location ICLOCATION Required
WOI-COMPANY -> ICL-COMPANY
WOI-LOCATION -> ICL-LOCATION
Worder WORDER Required
WOI-COMPANY -> WOR-COMPANY
WOI-LOCATION -> WOR-LOCATION
WOI-WORK-ORDER -> WOR-WORK-ORDER
WOI-WORK-ORDER-SUF -> WOR-WORK-ORDER-SUF
Wowoiuf WOWOIUF Not Required
WOI-COMPANY -> WIU-COMPANY
WOI-LOCATION -> WIU-LOCATION
WOI-WORK-ORDER -> WIU-WORK-ORDER
WOI-WORK-ORDER-SUF -> WIU-WORK-ORDER-SUF
WOI-COMPONENT-SEQ -> WIU-COMPONENT-SEQ
WOITEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bins WODETAIL
Valid When ITE-LOT-TRACK-FL = "N"
And ITE-SER-TRACK-FL = "N"
And ITL-BIN-TRACK-FL = "Y"
WOI-COMPANY -> WOD-COMPANY
WOI-LOCATION -> WOD-LOCATION
WOI-WORK-ORDER -> WOD-WORK-ORDER
WOI-WORK-ORDER-SUF -> WOD-WORK-ORDER-SUF
"C" -> WOD-DETAIL-TYPE
WOI-COMPONENT-SEQ -> WOD-COMPONENT-SEQ
WOD-BIN
WOD-LOT
WOD-SUBLOT
WOD-SERIAL
WOD-UOM
Itemsub ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
WOI-ITEM -> ITS-ITEM
"S" -> ITS-SUBTYPE
ITS-SUB-ITEM
Itserial ITSERIAL
Valid When ITE-SER-TRACK-FL != "N"
WOI-COMPANY -> SER-COMPANY
WOI-ITEM -> SER-ITEM
SER-SERIAL
Lots WODETAIL
Valid When ITE-LOT-TRACK-FL = "Y"
WOI-COMPANY -> WOD-COMPANY
WOI-LOCATION -> WOD-LOCATION
WOI-WORK-ORDER -> WOD-WORK-ORDER
WOI-WORK-ORDER-SUF -> WOD-WORK-ORDER-SUF
"C" -> WOD-DETAIL-TYPE
WOI-COMPONENT-SEQ -> WOD-COMPONENT-SEQ
WOD-BIN
WOD-LOT
WOD-SUBLOT
WOD-SERIAL
WOD-UOM
Serials WODETAIL
Valid When ITE-SER-TRACK-FL != "N"
WOI-COMPANY -> WOD-COMPANY
WOI-LOCATION -> WOD-LOCATION
WOI-WORK-ORDER -> WOD-WORK-ORDER
WOI-WORK-ORDER-SUF -> WOD-WORK-ORDER-SUF
"C" -> WOD-DETAIL-TYPE
WOI-COMPONENT-SEQ -> WOD-COMPONENT-SEQ
WOD-BIN
WOD-LOT
WOD-SUBLOT
WOD-SERIAL
WOD-UOM
Sohbins SOHDETAIL
Valid When ITE-LOT-TRACK-FL = "N"
And ITE-SER-TRACK-FL = "N"
And ITL-BIN-TRACK-FL = "Y"
WOI-COMPANY -> SDT-COMPANY
WOI-LOCATION -> SDT-LOCATION
WOI-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Sohlots SOHDETAIL
Valid When ITE-LOT-TRACK-FL = "Y"
WOI-COMPANY -> SDT-COMPANY
WOI-LOCATION -> SDT-LOCATION
WOI-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Uoms WODETAIL
WOI-COMPANY -> WOD-COMPANY
WOI-LOCATION -> WOD-LOCATION
WOI-WORK-ORDER -> WOD-WORK-ORDER
WOI-WORK-ORDER-SUF -> WOD-WORK-ORDER-SUF
"C" -> WOD-DETAIL-TYPE
WOI-COMPONENT-SEQ -> WOD-COMPONENT-SEQ
WOD-BIN
WOD-LOT
WOD-SUBLOT
WOD-SERIAL
WOD-UOM
Wodetail WODETAIL
WOI-COMPANY -> WOD-COMPANY
WOI-LOCATION -> WOD-LOCATION
WOI-WORK-ORDER -> WOD-WORK-ORDER
WOI-WORK-ORDER-SUF -> WOD-WORK-ORDER-SUF
"C" -> WOD-DETAIL-TYPE
WOI-COMPONENT-SEQ -> WOD-COMPONENT-SEQ
WOD-BIN
WOD-LOT
WOD-SUBLOT
WOD-SERIAL
WOD-UOM
|
