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
WH210
UPDATED BY
WH20.3 WH20.4 WH20.5 WH20.6 WH130 WH132
WH190 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 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
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.
OE = Customer Order
RQ = Requisitions
CX = Case Cart
WDD-DOC-NBR Alpha 10 (Right Justified) WH20.3 WH20.4
Doc Nbr This field contains the document number WH20.5 WH20.6
for the document line requiring details.
WDD-DOC-NBR-NUM Numeric 10
Doc Nbr Num This field contains the 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.
WDD-COMPONENT-SEQ Numeric 3 WH20.3 WH20.4
Component Sequence This field contains the component WH20.5 WH20.6
Number sequence number for kit component items
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.
WDD-LOT Alpha 10 WH20.3 WH20.4
Lot Number This field contains the lot assigned to WH20.5 WH20.6
the document line.
WDD-SUBLOT Alpha 6 WH20.3 WH20.4
Sublot Number This field contains the sublot assigned WH20.5 WH20.6
to the document line.
WDD-SERIAL Alpha 16 WH20.3 WH20.4
Serial Number This field contains the serial number WH20.5
assigned to the document line.
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.
WDD-LOCATION Alpha 5 WH20.3 WH20.4
Location Code This field contains a valid stocking WH20.5 WH20.6
location within the company inventory.
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
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.
WDD-CATCH-WT-QTY Signed 13.4
Catch Weight This field contains the catch weight
Quantity quantity in secondary unit of measure.
WDD-UPDATE-DATE Numeric 8 (yyyymmdd)
Update Date This field contains the date the record
was updated.
WDD-UPDATE-TIME Numeric 6
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 WH130 WH132
LOCATION updating the table. WH190 WH20.3
SYSTEM-CD WH20.4 WH20.5
DOC-NBR WH20.6 WH210
LINE-NBR WH30.1 WH30.2
COMPONENT-SEQ WH30.3 WH30.4
BIN WH31.1 WH31.2
LOT WH31.3 WH31.4
SUBLOT WH32.1 WH32.2
SERIAL WH32.3 WH32.4
UOM 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
WDD-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
WDD-COMPANY -> ITL-COMPANY
WDD-LOCATION -> ITL-LOCATION
WDM-ITEM -> ITL-ITEM
Sohdetail SOHDETAIL Required
WDD-COMPANY -> SDT-COMPANY
WDD-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
WDD-LOCATION -> WDM-LOCATION
|
