|
|
WOSCHEDULE FILE
Work Order Schedule
The Work Order Schedule file is used to hold demand scheduling information
during the Work Order production scheduling process. It will contain records
for detail document demand, summary document demand and/or forecast demand,
depending on the options selected regarding demand source and whether to get
detail document demand.
UPDATED BY
WO20.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOS-OBJ-ID-DMND Numeric 12 WO20.1
Demand Object ID The demand object ID is the identifier
used to associate records of this file
to demand records based on a unique
value for the records to be associated
with each other.
WOS-OBJ-ID-HDR Numeric 12 WO20.1
Header Object ID The header object ID is used to
associate records in this file to a
schedule header record.
WOS-OBJ-ID-DTL Numeric 12 WO20.1
Detail Object ID The detail object ID is used to
associate one or more schedule detail
records to one or more records in this
file by using a common value in the
records to be linked that is unique to
these records.
WOS-DATE Numeric 8 (yyyymmdd) WO20.1
Date This is the date needed for the demand.
WOS-DEMAND-TYPE Numeric 1 WO20.1
Demand Type The three types of demand schedule
records are as follows.
1 = Document Detail
2 = Document Summary
3 = Forecast
WOS-SYSTEM-CD Alpha 2 WO20.1
System Code This field indicates on which Lawson
system the transaction originated
whenever the demand type is for document
detail.
OE = Order Entry
RQ = Requisitions
WOS-DOC-NBR Alpha 10 (Right Justified) WO20.1
Dcoument Number This is the document number from the
demand when the demand type of this
record is document detail.
WOS-LINE-NBR Numeric 6 WO20.1
Line Number This field contains the line number for
document detail demand records.
WOS-RUSH-FL Alpha 1 WO20.1
Rush Flag The rush flag will come from the
document demand record (when document
detail is the record type).
Y = Yes
N = No
WOS-QUANTITY Signed 13.4 WO20.1
Quantity This field contains the requested
quantity of the finished good from the
demand record(s) that a schedule record
entails.
WOS-ACTION-CD Alpha 1 WO20.1
Action Code The action code is used to hold the
action requested during the selection
process of production scheduling. This
value is used to determine what records
to use during the release of the
schedule.
G = Group
S = Separate
WOSCHEDULE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOSSET1 OBJ-ID-DMND This index is used to access Work Order
schedule records for a specific demand
object ID.
WOSSET2 OBJ-ID-HDR This index is used to access Work Order WO20.1
DEMAND-TYPE schedule records for a specific header
DATE object ID, demand type, date needed,
SYSTEM-CD system code, document number, and line
DOC-NBR number.
LINE-NBR KeyChange, Duplicates
WOSSET3 OBJ-ID-DTL This index is used to access Work Order
schedule records for a specific detail
object ID.
KeyChange, Duplicates, Subset
Where (OBJ-ID-DTL != Zeroes )
WOSSET4 OBJ-ID-HDR This index is used to access Work Order WO20.1
OBJ-ID-DTL schedule records for a specific header
DATE object ID, detail object ID, and date
needed.
KeyChange, Duplicates, Subset
Where (OBJ-ID-DTL != Zeroes )
WOSSET5 OBJ-ID-HDR This index is used to access Work Order WO20.1
DEMAND-TYPE schedule records for a specific header
SYSTEM-CD object ID, demand type, system code,
DOC-NBR document number, line number, and date
LINE-NBR needed.
DATE KeyChange, Duplicates
WOSCHEDULE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Whdemand Doc WHDEMAND Not Required
Valid When (WOS-SYSTEM-CD = "OE"
Or WOS-SYSTEM-CD = "RQ" )
And WOS-DOC-NBR != Spaces
And WOS-LINE-NBR != Zeroes
WOH-COMPANY -> WDM-COMPANY
WOS-SYSTEM-CD -> WDM-SYSTEM-CD
WOS-DOC-NBR -> WDM-DOC-NBR
WOS-LINE-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
Woschedhdr WOSCHEDHDR Required
WOS-OBJ-ID-HDR -> WOH-OBJ-ID-HDR
WOSCHEDULE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Whdemand WHDEMAND
WOS-OBJ-ID-DMND -> WDM-OBJ-ID-DMND
WDM-SEQ
Wodmndfcst WODMNDFCST
WOS-OBJ-ID-DMND -> WDF-OBJ-ID-DMND
WDF-SEQ
Woscheddtl WOSCHEDDTL
WOS-OBJ-ID-DTL -> WOT-OBJ-ID-DTL
WOT-SEQ
|