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
WO133 WO232 WO250 WO256 WO293 WO35.1
WO131 WO252
UPDATED BY
WO120 WO132 WO140 WO20.1 WO30.1 WO300
WO32.1 WO32.2 WO32.3 WO32.4 WO32.5 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
WOI-COMPANY Numeric 4 WO30.1 WO32.1
Company This field contains the company number, WO40.1 WOEX.1
as defined in the Inventory Control
system.
WOI-LOCATION Alpha 5 WO30.1 WO32.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.
WOI-WORK-ORDER Numeric 8 WO30.1 WO32.1
Work Order This field identifies the work order WO40.1 WO45.1
and may be automatically assigned or WOEX.1
manually assigned, depending on the
option defined for each production
(inventory) location.
WOI-WORK-ORDER-SUF Numeric 2 WO30.1 WO32.1
Work Order Suffix This field will normally be zero for a WO40.1 WO45.1
work order. If you chose to split a WOEX.1 WOSP.1
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 WO30.1 WO32.1
Component Sequence The component sequence number is the WO40.1 WOEX.1
order in which this component is added
to the finished good during the
production process.
WOI-COMPONENT-TYPE Alpha 1 WO30.1 WOEX.1
Component Type The 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
WOI-ITEM Alpha 32 WO30.1 WOEX.1
Item This field contains the item identifier
of the component, as defined in the
Inventory Control system.
WOI-INV-LOCATION Alpha 5 WO30.1 WO32.1
Inventory Location This field contains the location from WOEX.1
which inventory is taken.
WOI-PLAN-QTY Signed 13.4 WO30.1 WO40.1
Plan Quantity This field contains the planned WO40.2 WO40.3
quantity for an item for a work order. WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOEX.1
WOSP.1
WOI-ACTUAL-QTY Signed 13.4 WO40.1 WO40.2
Actual Quantity This is the actual quantity of the WO40.3 WO40.4
component used to make the finished WO40.5 WO41.1
goods for this work order. WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
WOI-ACT-CTW-QTY Signed 13.4 WO40.1 WO40.2
Actual Catch Weight This is the actual catch weight WO40.3 WO40.4
Quantity quantity of the component used to make WO40.5 WO41.1
the finished goods for this work order. WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
WOI-PICKED-QTY Signed 13.4 WO32.1 WO40.1
Picked Quantity This is the quantity of the component WO40.2 WO40.3
that was picked for the work order. WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WOI-DETAIL-QTY Signed 13.4 WO32.2 WO32.3
Detail Quantity This field shows the total quantity of WO32.4 WO32.5
details defined for a detail tracked WO40.1 WO40.2
item. It is matched against the line WO40.3 WO40.4
quantity field to determine if details WO40.5 WO41.1
are in balance. WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
WOI-CATCH-WT-QTY Signed 13.4 WO32.1 WO40.1
Catch Weight This is the catch weight quantity of WO40.2 WO40.3
Quantity the component that was picked for the WO40.4 WO40.5
work order. WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WOI-DTL-CTW-QTY Signed 13.4 WOSP.1
Detail Catch Weight This field is not currently used by the
Quantity Work Order system.
WOI-WST-ACCT-UNIT Alpha 15 WO30.1 WOEX.1
Waste Account 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 WO30.1 WOEX.1
Waste 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 WO30.1 WOEX.1
Waste Subaccount 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 WO40.1 WO40.2
Waste Quantity This is the quantity of the component WO40.3 WO40.4
that was wasted during the work order WO40.5 WO41.1
production process and was not used in WO41.2 WO41.3
the finished good. WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
WOI-WST-CTW-QTY Signed 13.4 WO40.1 WO40.2
Waste Catch Weight This is the catch weight quantity of WO40.3 WO40.4
Quantity the component that was wasted during the WO40.5 WO41.1
work order production process and was WO41.2 WO41.3
not used in the finished good. WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
WOI-EST-COMP-COST Signed 13.5 WO30.1 WOEX.1
Estimated Component This is the estimated unit cost of the
Cost component.
WOI-ACT-COMP-COST Signed 13.5 WO140 WO40.1
Actual Component This is the actual unit cost of WO40.2 WO40.3
Cost components that were not picked but were WO40.4 WO40.5
consumed, that is, used in the finished WO41.1 WO41.2
good or wasted. This field will be zero WO41.3 WO41.4
if the picked quantity is greater than WO42.1 WO42.2
the sum of the actual quantity and the WO42.3 WO42.4
waste quantity. WO42.5 WOSP.1
WOI-PICKED-COST Signed 13.5 WO132 WO40.1
Picked Cost This is the unit cost for components WO40.2 WO40.3
that were picked. WO40.4 WO40.5
WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5
WOI-TOT-ACT-COST Signed 13.5 WO140
Total Actual 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 13.5 WO140
Total Waste 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) WO30.1 WOEX.1
Quantity Tolerance This field contains the quantity
Percent tolerance percent of the component.
WOI-ZERO-QTY-FL Alpha 1 WO30.1 WOEX.1
Zero Quantity 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 WO120 WO20.1
Walkthroug Required This field indicates that a transaction WO30.1 WO32.1
line is out of balance. For example, WO32.2 WO32.3
if lot, bin, or serial number quantities WO32.4 WO32.5
do not equal the transaction quantity, WO40.1 WO40.2
select the WalkThru form action to WO40.3 WO40.4
balance the transaction quantities. WO40.5 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOEX.1
WOI-DISP-INV-LOC Derived
Display Inventory The system displays a string that
Location contains inventory location
(INV-LOCATION) preceded by a label for
the inventory location.
WOI-DISP-LOCATION Derived
Display 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 WO30.1 WOEX.1
Account Unit The material expense account unit is an
income statement account unit used to
accrue expenses related to the assembly
of finished goods.
WOI-ME-ACCOUNT Numeric 6 WO30.1 WOEX.1
Account The material expense account is an
income statement account used to accrue
expenses related to the assembly of
finished goods.
WOI-ME-SUB-ACCT Numeric 4 WO30.1 WOEX.1
Subaccount The material expense subaccount is an
income statement subaccount used to
accrue expenses related to the assembly
of finished goods.
WOITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOISET1 COMPANY This index is used to access component WO120 WO132
LOCATION records for a specific work order and WO133 WO140
WORK-ORDER component sequence number for a WO20.1 WO232
WORK-ORDER-SUFproduction location. WO250 WO256
COMPONENT-SEQ WO293 WO30.1
WO300 WO32.1
WO32.2 WO32.3
WO32.4 WO32.5
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
...
WOISET2 COMPANY This index is used to access component WO131 WO32.1
LOCATION records for a specific work order,
WORK-ORDER inventory location, and component
WORK-ORDER-SUFsequence number for a production
INV-LOCATION location.
COMPONENT-SEQ KeyChange
WOISET3 COMPANY This index is used to access component WO252
LOCATION records for a specific work order and
WORK-ORDER component type and sequence for a
WORK-ORDER-SUFproduction location.
COMPONENT-TYPEKeyChange
COMPONENT-SEQ
WOISET4 COMPANY This index is used to access component WO120 WO20.1
LOCATION records for a specific work order and WO30.1 WO32.1
WORK-ORDER component sequence number (within the WO32.2 WO32.3
WORK-ORDER-SUFfeedback process if WalkThru is WO32.4 WO32.5
COMPONENT-SEQ required) for a production location. WO40.1 WO40.2
KeyChange, Subset WO40.3 WO40.4
Where (WALK-THRU-REQ = "Y" ) WO40.5 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOISET5 COMPANY This index is used to access regular WO40.1
LOCATION and packaging component records for a
WORK-ORDER specific work order and component
WORK-ORDER-SUFsequence number for a production
COMPONENT-SEQ location.
KeyChange, Subset
Where COMPONENT-TYPE != "O"
WOITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WOI-COMPANY -> ICC-COMPANY
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
Wosgblk WOSGBLK Not Required
WOI-COMPANY -> WSB-COMPANY
WOI-LOCATION -> WSB-LOCATION
WOI-WORK-ORDER -> WSB-WORK-ORDER
WOI-WORK-ORDER-SUF -> WSB-WORK-ORDER-SUF
WOI-COMPONENT-SEQ -> WSB-COMPONENT-SEQ
Zeroes -> WSB-SEQ
WOITEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bins WODETAIL
Valid When WOI-LOT-TRACK-FL = "N"
And WOI-SER-TRACK-FL = "N"
And WOI-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
ITS-SUB-ITEM
Itserial ITSERIAL
Valid When WOI-SER-TRACK-FL != "N"
WOI-COMPANY -> SER-COMPANY
WOI-ITEM -> SER-ITEM
SER-SERIAL
Lots WODETAIL
Valid When WOI-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 WOI-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 WOI-LOT-TRACK-FL = "N"
And WOI-SER-TRACK-FL = "N"
And WOI-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 WOI-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
|