WHDEMNDDTL

Demand Detail

The Demand Detail file contains details (bin, lot, serial number, and multiple unit of measure) assigned to the document line.
UPDATED BY
CX100 RQD0.1 WH130 WH132 WH190 WH20.3
WH20.4 WH20.5 WH20.6 WH210 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 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 WHD0.1 WHD2.1 WHD3.1
ZW130

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


WHDEMNDDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDDSET1 COMPANY
LOCATION
SYSTEM-CD
DOC-NBR
LINE-NBR
COMPONENT-SEQ
BIN
LOT
SUBLOT
SERIAL
UOM
...
CX100 RQD0.1
WH130 WH132
WH190 WH20.3
WH20.4 WH20.5
WH20.6 WH210
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8


WHDEMNDDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:30:04 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.