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.