Lawson Insight Technical Documentation |
|
WOITEM
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
Element: 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
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.
WOI-WORK-ORDER Numeric 8 WO30.1 WO32.1
Element: 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
Element: Work Order SufThis 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
Element: Sequence NumbeThe 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
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 WO30.1 WOEX.1
Element: Item Number 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
Element: Location Code This field contains the location from WOEX.1
which inventory is taken.
WOI-PLAN-QTY Signed 13.4 WO30.1 WO40.1
Element: 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
Element: 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
Element: Quantity This is the actual catch weight WO40.3 WO40.4
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
Element: 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
Element: 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
Element: Quantity This is the catch weight quantity of WO40.2 WO40.3
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
Element: Quantity This field is not currently used by the
Work Order system.
WOI-WST-ACCT-UNIT Alpha 15 WO30.1 WOEX.1
Element: Accounting UniThe 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
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 WO30.1 WOEX.1
Element: 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
Element: 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
Element: Quantity This is the catch weight quantity of WO40.3 WO40.4
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 18.5 WO30.1 WOEX.1
Element: Intl Cost This is the estimated unit cost of the
component.
WOI-ACT-COMP-COST Signed 18.5 WO140 WO40.1
Element: Intl Cost This is the actual unit cost of WO40.2 WO40.3
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 18.5 WO132 WO40.1
Element: Intl 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 18.5 WO140
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 WO140
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) WO30.1 WOEX.1
Element: Qty Tol Pct This field contains the quantity
tolerance percent of the component.
WOI-ZERO-QTY-FL Alpha 1 WO30.1 WOEX.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 WO120 WO20.1
Element: Req Comments 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
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 WO30.1 WOEX.1
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 WO30.1 WOEX.1
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 WO30.1 WOEX.1
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 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 WO132
LOCATION records for a specific work order, WO140 WO32.1
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
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
|