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
WH130 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WDD-COMPANY Numeric 4
Company This field contains the company number.
WDD-SYSTEM-CD Alpha 2
System Code This field indicates on which Lawson
system the document originated.
OE = Customer Order
RQ = Requisitions
CX = Case Cart
WDD-DOC-NBR Alpha 10 (Right Justified)
Doc Nbr This field contains the document number
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
Line Number This field contains the document line
number.
WDD-COMPONENT-SEQ Numeric 3
Component Sequence This field contains the component
Number sequence number for kit component items
on the document line.
WDD-BIN Alpha 7
Bin This field contains the bin assigned to
the document line.
WDD-LOT Alpha 10
Lot Number This field contains the lot assigned to
the document line.
WDD-SUBLOT Alpha 6
Sublot Number This field contains the sublot assigned
to the document line.
WDD-SERIAL Alpha 16
Serial Number This field contains the serial number
assigned to the document line.
WDD-UOM Alpha 4
Unit of Measure This field contains the unit of measure
assigned to the document line.
WDD-LOCATION Alpha 5
Location Code This field contains a valid stocking
location within the company inventory.
WDD-UOM-MULT Signed 13.7
Unit of Measure This field contains the multiplier for
Multiplier converting this unit of measure to the
stock unit of measure.
WDD-QUANTITY Signed 13.4
Quantity This field contains the requested
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 WH210
LOCATION updating the table. WH33.1 WH33.2
SYSTEM-CD WH33.3 WH33.4
DOC-NBR WH33.5 WH33.6
LINE-NBR WH33.8 WH33.9
COMPONENT-SEQ WH34.1 WH34.2
BIN WH34.3 WH34.4
LOT
SUBLOT
SERIAL
UOM
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
|
