|
|
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 WO140 BL92.1
OE114 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
WO140
WDD-SYSTEM-CD Alpha 2 WH20.3 WH20.4
Element: System Code This field indicates on which Lawson WH20.5 WH20.6
system the document originated. WO140
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. WO140
WDD-DOC-NBR-NUM Numeric 10 WO140
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 Number This field contains the document line WH20.5 WH20.6
number. WO140
WDD-COMPONENT-SEQ Numeric 3 WH20.3 WH20.4
Element: Sequence NumbeThis field contains the component WH20.5 WH20.6
sequence number for kit component items WO140
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. WO140
WDD-LOT Alpha 10 WH20.3 WH20.4
Element: Lot Number This field contains the lot assigned to WH20.5 WH20.6
the document line. WO140
WDD-SUBLOT Alpha 6 WH20.3 WH20.4
Element: Sublot Number This field contains the sublot assigned WH20.5 WH20.6
to the document line. WO140
WDD-SERIAL Alpha 16 WH20.3 WH20.4
Element: Serial Number This field contains the serial number WH20.5 WO140
assigned to the document line.
WDD-UOM Alpha 4 WH20.3 WH20.4
Element: Unit of MeasurThis field contains the unit of measure WH20.5 WH20.6
assigned to the document line. WO140
WDD-LOCATION Alpha 5 WH20.3 WH20.4
Element: 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 WO140
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. WO140
WDD-CATCH-WT-QTY Signed 13.4 WO140
Element: Quantity This field contains the catch weight
quantity in secondary unit of measure.
WDD-UPDATE-DATE Numeric 8 (yyyymmdd) WO140
Element: Update Date This field contains the date the record
was updated.
WDD-UPDATE-TIME Numeric 6 WO140
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 Primary index used for accessing and BL92.1 OE114
LOCATION updating the table. 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
|
