|
|
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
RQD0.1 WH20.3 WH20.4 WH20.5 WH20.6 WHD0.1
WHD2.1 WHD3.1 BL92.1 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
Element: Company This field contains the company number. WH20.5 WH20.6
WHD3.1
WDD-SYSTEM-CD Alpha 2 WH20.3 WH20.4
Element: System Cd This field indicates on which Lawson WH20.5 WH20.6
system the document originated. WHD3.1
OE = Customer Order
RQ = Requisitions
CX = Case Cart
WDD-DOC-NBR Alpha 10 (Right Justified) WH20.3 WH20.4
Element: Doc Nbr This field contains the document number WH20.5 WH20.6
for the document line requiring details. WHD3.1
WDD-DOC-NBR-NUM Numeric 10 WHD3.1
Element: Doc Nbr Num This field contains the numeric value
of the document number.
WDD-LINE-NBR Numeric 6 WH20.3 WH20.4
Element: Line Nbr This field contains the document line WH20.5 WH20.6
number. WHD3.1
WDD-COMPONENT-SEQ Numeric 3 WH20.3 WH20.4
Element: Seq This field contains the component WH20.5 WH20.6
sequence number for kit component items WHD3.1
on the document line.
WDD-BIN Alpha 7 WH20.3 WH20.4
Element: Bin This field contains the bin assigned to WH20.5 WH20.6
the document line. WHD3.1
WDD-LOT Alpha 10 WH20.3 WH20.4
Element: Lot This field contains the lot assigned to WH20.5 WH20.6
the document line.
WDD-SUBLOT Alpha 6 WH20.3 WH20.4
Element: Sublot This field contains the sublot assigned WH20.5 WH20.6
to the document line. WHD3.1
WDD-SERIAL Alpha 16 WH20.3 WH20.4
Element: Serial This field contains the serial number WH20.5 WHD3.1
assigned to the document line.
WDD-UOM Alpha 4 WH20.3 WH20.4
Element: Uom This field contains the unit of measure WH20.5 WH20.6
assigned to the document line. WHD3.1
WDD-LOCATION Alpha 5 WH20.3 WH20.4
Element: Location This field contains a valid stocking WH20.5 WH20.6
location within the company inventory. WHD3.1
WDD-UOM-MULT Signed 13.7 WH20.3 WH20.4
Element: Uom Mult This field contains the multiplier for WH20.5 WH20.6
converting this unit of measure to the WHD3.1
stock unit of measure.
WDD-QUANTITY Signed 13.4 WH20.3 WH20.4
Element: Quantity This field contains the requested WH20.5 WH20.6
document line quantity. WHD3.1
WDD-CATCH-WT-QTY Signed 13.4 WHD3.1
Element: Quantity This field contains the catch weight
quantity in secondary unit of measure.
WDD-UPDATE-DATE Numeric 8 (yyyymmdd) WHD3.1
Element: Update Date This field contains the date the record
was updated.
WDD-UPDATE-TIME Numeric 6 WHD3.1
Element: 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 BL92.1 RQD0.1
LOCATION WH130 WH132
SYSTEM-CD WH190 WH20.3
DOC-NBR WH20.4 WH20.5
LINE-NBR WH20.6 WH210
COMPONENT-SEQ WH30.1 WH30.2
BIN WH30.3 WH30.4
LOT WH31.1 WH31.2
SUBLOT WH31.3 WH31.4
SERIAL WH32.1 WH32.2
UOM WH32.3 WH32.4
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
...
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
|
