|
|
WHDEMNDDTL FILE
Demand Detail
The Demand Detail file contains details (bin, lot, serial number, and
multiple unit of measure) assigned to the document line.
REFERENCED BY
CX100 WH210
UPDATED BY
WH20.3 WH20.4 WH20.5 WH20.6 WH962 WO140
BL92.1 OE114 WH130 WH132 WH190 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WDD-COMPANY Numeric 4 WH20.3 WH20.4
Company This field contains the company number. WH20.5 WH20.6
WH962 WO140
WDD-SYSTEM-CD Alpha 2 WH20.3 WH20.4
System Code This field indicates on which Lawson WH20.5 WH20.6
system the document originated. WH962 WO140
OE = Customer Order
RQ = Requisitions
CX = Case Cart
WDD-DOC-NBR Alpha 10 (Right Justified) WH20.3 WH20.4
Document Number This field contains the document number WH20.5 WH20.6
for the document line requiring details. WH962 WO140
WDD-DOC-NBR-NUM Numeric 10 WH962 WO140
Document Number This field contains the numeric value
Numeric Value of the document number.
WDD-LINE-NBR Numeric 6 WH20.3 WH20.4
Line Number This field contains the document line WH20.5 WH20.6
number. WH962 WO140
WDD-COMPONENT-SEQ Numeric 3 WH20.3 WH20.4
Component Sequence This field contains the component WH20.5 WH20.6
sequence number for kit component items WH962 WO140
on the document line.
WDD-BIN Alpha 7 WH20.3 WH20.4
Bin This field contains the bin assigned to WH20.5 WH20.6
the document line. WH962 WO140
WDD-LOT Alpha 10 WH20.3 WH20.4
Lot This field contains the lot assigned to WH20.5 WH20.6
the document line. WH962 WO140
WDD-SUBLOT Alpha 6 WH20.3 WH20.4
Sublot This field contains the sublot assigned WH20.5 WH20.6
to the document line. WH962 WO140
WDD-SERIAL Alpha 16 WH20.3 WH20.4
Serial This field contains the serial number WH20.5 WH962
assigned to the document line. WO140
WDD-UOM Alpha 4 WH20.3 WH20.4
Unit of Measure This field contains the unit of measure WH20.5 WH20.6
assigned to the document line. WH962 WO140
WDD-UOM-MULT Signed 13.7 WH20.3 WH20.4
Unit of Measure This field contains the multiplier for WH20.5 WH20.6
Multiplier converting this unit of measure to the WH962 WO140
stock unit of measure.
WDD-QUANTITY Signed 13.4 WH20.3 WH20.4
Quantity This field contains the requested WH20.5 WH20.6
document line quantity. WH962 WO140
WDD-CATCH-WT-QTY Signed 13.4 WH962 WO140
Catch Weight This field contains the catch weight
Quantity quantity in secondary unit of measure.
WDD-UPDATE-DATE Numeric 8 (yyyymmdd) WH962 WO140
Update Date This field contains the date the record
was updated.
WDD-UPDATE-TIME Numeric 6 WH962 WO140
Update Time This field contains the system time
when the record was updated.
WHDEMNDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDDSET1 COMPANY Primary index used for accessing and BL92.1 CX100
SYSTEM-CD updating the table. OE114 WH130
DOC-NBR WH132 WH190
LINE-NBR WH20.3 WH20.4
COMPONENT-SEQ WH20.5 WH20.6
BIN WH210 WH30.1
LOT WH30.2 WH30.3
SUBLOT WH31.1 WH31.2
SERIAL WH31.3 WH32.1
UOM WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
WHDEMNDDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WDD-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
WDD-COMPANY -> ICL-COMPANY
WDM-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
WDD-COMPANY -> ITL-COMPANY
WDM-LOCATION -> ITL-LOCATION
WDM-ITEM -> ITL-ITEM
Sohdetail SOHDETAIL Required
WDD-COMPANY -> SDT-COMPANY
WDM-LOCATION -> SDT-LOCATION
WDM-ITEM -> SDT-ITEM
WDD-UOM -> SDT-UOM
WDD-LOT -> SDT-LOT
WDD-SUBLOT -> SDT-SUBLOT
WDD-BIN -> SDT-BIN
Whdemand WHDEMAND Required
WDD-COMPANY -> WDM-COMPANY
WDD-SYSTEM-CD -> WDM-SYSTEM-CD
WDD-DOC-NBR -> WDM-DOC-NBR
WDD-LINE-NBR -> WDM-LINE-NBR
WDD-COMPONENT-SEQ -> WDM-COMPONENT-SEQ
|