 |
Lawson Insight Technical Documentation |
|
WHDEMAND FILE
Demand
The Demand file contains all the records that the Lawson Warehouse system
needs for processing demands.
REFERENCED BY
POIF.1 RQ140 RQ300 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 WH220 WH221 IC12.1 IC145
IC330 IC45.1 PO228 WH226
UPDATED BY
CXCP.1 DR100 IC141 IC142 IC22.1 IC22.2
IC23.1 IC23.2 IC25.1 IC500 IC83.1 IC850
POIJ.1 RQ12.1 RQ13.1 WH110 WH120 WH130
WH21.1 WH21.2 WH21.3 WH21.4 WH210 WH22.1
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
WDM-COMPANY Numeric 4 CXCP.1 DR100
Company This field contains the company number. IC141 IC142
IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-SYSTEM-CD Alpha 2 CXCP.1 DR100
System Code This field indicates from which Lawson IC141 IC142
system the document originated. IC22.1 IC22.2
OE = Customer Order IC23.1 IC23.2
RQ = Requisition IC25.1 IC500
IC = Intransit IC83.1 IC850
PO = Purchase Order POIJ.1 RQ12.1
CX = Case Cart RQ13.1 WH110
WO = Work Order WH120 WH130
PH = Pharmacy WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-DOC-NBR Alpha 10 (Right Justified) CXCP.1 DR100
Doc Nbr This field contains the document number IC141 IC142
for the shipment line. If this record IC22.1 IC22.2
was created from a PO, it will be the IC23.1 IC23.2
object id from the POLINE since the PO IC25.1 IC500
Number is too long for this field. IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-DOC-NBR-NUM Numeric 10 CXCP.1 DR100
Doc Nbr Num This field contains the numeric version IC141 IC142
of the document number. The system codes IC83.1 POIJ.1
of OE & RQ use this field. For PO, this RQ12.1 RQ13.1
field will be the PLI-PO-RELEASE field. WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-LINE-NBR Numeric 6 CXCP.1 DR100
Line Number This field contains the document line IC141 IC142
number. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-COMPONENT-SEQ Numeric 3 CXCP.1 DR100
Component Sequence This field contains the component IC141 IC142
Number sequence number of the component item. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-DOC-TYPE Alpha 2 CXCP.1 DR100
Document Type This field contains the type of IC141 IC142
document. For warehouse purposes, this IC22.1 IC22.2
is the shipping document. IC23.1 IC23.2
DT = Direct Transfer IC25.1 IC500
IR = Intransit Receiving IC83.1 IC850
IS = Issue POIJ.1 RQ12.1
IT = Transfer Issue RQ13.1 WH110
SH = Shipment WH120 WH130
PO = Purchase Order WH21.1 WH21.2
WO = Work Order WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-RECORD-TYPE Alpha 1 CXCP.1 DR100
Record Type This field identifies the type of IC141 IC142
demand record defined. Demand records IC22.1 IC22.2
are processed in the Lawson Warehouse IC23.1 IC23.2
system and supply records are not. IC25.1 IC500
D = Demand IC83.1 IC850
S = Supply POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-ITEM Alpha 32 CXCP.1 DR100
Item Number This field contains the item IC141 IC142
identifier. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-ITEM-DESC Alpha 30 CXCP.1 DR100
Item Description This field contains the description for IC141 IC142
inventoried and nonstock items. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-LOCATION Alpha 5 CXCP.1 DR100
Location Code This field contains a valid stock IC141 IC142
location within the company inventory. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-DESTINATION Alpha 15 CXCP.1 DR100
Destination This field contains the destination IC141 IC142
name for the shipment (ship-to IC83.1 POIJ.1
customer). RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-ROUTE Numeric 4 CXCP.1 DR100
Route This field contains the route number. IC141 IC142
The route assigned to the ship-to IC83.1 POIJ.1
customer defaults from the Order Entry RQ12.1 RQ13.1
Route file. WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-STOP Numeric 4 CXCP.1 DR100
Stop This field contains the stop within the IC141 IC142
route. If left blank, the stop IC83.1 POIJ.1
associated with the ship-to customer RQ12.1 RQ13.1
defaults from the Route file. WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-RTE-CREATE-FL Alpha 1 CXCP.1 DR100
Route Create Flag This field indicates whether a route IC141 IC142
record exists for this document line. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-STATUS Numeric 1 CXCP.1 DR100
Status This field contains the demand status. IC141 IC142
0 = Unreleased IC83.1 POIJ.1
1 = Released for Processing RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-ALLOCABLE-FL Alpha 1 CXCP.1 DR100
Allocatable Flag This field indicates whether demand IC141 IC142
lines are ready to be allocated or not. IC83.1 POIJ.1
Y = Allocatable RQ12.1 RQ13.1
N = Not Ready for Allocation WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-ALLOC-BASIS Alpha 1
Allocation Basis This field is used to determine if the
batch allocation program should allocate
demand based on requested date or the
priority.
WDM-LINE-TYPE Alpha 1 CXCP.1 DR100
Line Type This field contains the type of item on IC141 IC142
this demand line. IC22.1 IC22.2
I = Inventoried IC23.1 IC23.2
N = Nonstock IC25.1 IC500
X = Special IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-QUANTITY Signed 13.4 CXCP.1 DR100
Quantity This field contains the demand IC141 IC142
quantity. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-ALLOC-QTY Signed 13.4 CXCP.1 DR100
Allocated Quantity This field contains the quantity that IC141 IC142
has been allocated for this demand line. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-BACKORD-QTY Signed 13.4 CXCP.1 DR100
Backordered Quantity This field contains the backordered IC141 IC142
quantity that is not available in IC83.1 POIJ.1
inventory for allocation. RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-PRINTED-QTY Signed 13.4 CXCP.1 DR100
Printed on Pick This field contains the quantity that IC141 IC142
List Quantity was printed on the pick list to be IC83.1 POIJ.1
picked. RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-IN-PROC-QTY Signed 13.4 CXCP.1 DR100
In-Process Quantity This field contains the in-process IC141 IC142
quantity for the demand. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-SHIPPED-QTY Signed 13.4 CXCP.1 DR100
Shipped Quantity This field contains the quantity that IC141 IC142
was shipped. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-PRE-ASMBLD-KIT Signed 13.4 CXCP.1 DR100
Pre-Assembled Kit This field contains the quantity of IC141 IC142
make-to-order kits you want to IC83.1 POIJ.1
preassemble. RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-DETAIL-QTY Signed 13.4 CXCP.1 DR100
Detail Qty This field shows the quantity of demand IC141 IC142
lines with details. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-UNIT-COST Signed 13.5 CXCP.1 DR100
Unit Cost This field contains the unit cost for IC141 IC142
the document line. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-TRAN-UOM Alpha 4 CXCP.1 DR100
Document Unit of This field contains the unit of measure IC141 IC142
Measure used for the document. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-TRAN-UOM-MULT Signed 13.7 CXCP.1 DR100
Document UOM This field contains the multiplier used IC141 IC142
Multiplier to convert the document unit of measure IC22.1 IC22.2
to the stock unit of measure. IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-FUTURE-FL Alpha 1 CXCP.1 DR100
Future Document Flag This field indicates if the document IC141 IC142
line has a future status. IC83.1 POIJ.1
Y = Future Demand RQ12.1 RQ13.1
N = Current Demand WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-FIRM-FL Alpha 1 CXCP.1 DR100
Firm Flag This field indicates whether allocation IC141 IC142
is firm or not for a document line item. IC83.1 POIJ.1
If the allocation is set to Confirmed RQ12.1 RQ13.1
Demand, WH110 (Batch Allocation) will WH110 WH120
not let you deallocate this item later. WH130 WH21.1
Y = Confirmed Demand WH21.2 WH21.3
N = Open For Confirmation WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-SHIP-COMP-FL Alpha 1 CXCP.1 DR100
Ship Comp Fl This field indicates whether or not the IC141 IC142
customer requires complete shipments. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-BACK-ORD-FL Alpha 1 CXCP.1 DR100
Backorders Allowed This field indicates whether or not the IC141 IC142
Flag customer accepts backorders. IC83.1 POIJ.1
Y = Backorder Allowed RQ12.1 RQ13.1
N = Backorder Not Allowed WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-KIT-FL Alpha 1 CXCP.1 DR100
Kit Flag This field indicates the kind of kit IC141 IC142
item found on the document line. IC83.1 POIJ.1
O = Make-to-Order Kit RQ12.1 RQ13.1
S = Make-to-Stock Kit WH110 WH120
N = Not a Kit WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-KIT-COMPLETE Alpha 1 CXCP.1 DR100
Kit Complete This field indicates whether or not all IC141 IC142
kit options have been reviewed and IC83.1 POIJ.1
selected for a kit item. RQ12.1 RQ13.1
Y = All kit options are reviewed WH110 WH120
N = All kit options not reviewed WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-PO-FLAG Alpha 1 CXCP.1 DR100
PO Flag This field indicates whether or not the IC141 IC142
line is related to a purchase order. IC83.1 POIJ.1
Y = Based on PO Receipt RQ12.1 RQ13.1
N = Not Related to PO WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-PICKING-REQ Alpha 1 CXCP.1 DR100
Picking Required This field indicates whether the IC141 IC142
process type for the document requires IC83.1 POIJ.1
picking feedback. RQ12.1 RQ13.1
Y = Picking is Required WH110 WH120
N = Picking is not Required WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-PACKING-REQ Alpha 1 CXCP.1 DR100
Packing Required This field indicates whether or not the IC141 IC142
process type for this document requires IC83.1 POIJ.1
packing feedback. RQ12.1 RQ13.1
Y = Packing is Required WH110 WH120
N = Packing is not Required WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-DETAIL-REQ Alpha 1 CXCP.1 DR100
Detail Required This field indicates whether or not IC141 IC142
details are required for the document IC83.1 POIJ.1
line item. RQ12.1 RQ13.1
Y = Details are Required WH110 WH120
N = Details are not Required WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-ALLOC-PRI Numeric 2 CXCP.1 DR100
Allocation Priority This field indicates what allocation IC141 IC142
priority you gave to a document line. IC83.1 POIJ.1
00 = Priority of Allocation RQ12.1 RQ13.1
99 = Priority of Allocation WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-HOLD-FL Alpha 1 CXCP.1 DR100
Hold Flag This field indicates if the document IC141 IC142
line is on hold. The source for this IC83.1 POIJ.1
field is the originating Lawson system. RQ12.1 RQ13.1
Y = Document Line is on Hold WH110 WH120
N = Document Line is not on Hold WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-MSDS-REQ-FL Alpha 1
MSDS Required Flag MSDS required flag. When this flag is
set, a MSDS acknowledgment is required
for the first shipment of the order
containing the item even if the item has
a MSDS acknowledgment within a year for
this customer.
Y = Yes
N = No
WDM-VENDOR Alpha 9 (Right Justified) CXCP.1 DR100
Vendor ID The vendor's identification code. IC141 IC142
IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-CARRIER Alpha 9 (Right Justified) CXCP.1 DR100
Carrier Vendor This is the carrier vendor number. It IC141 IC142
Number must be a valid vendor. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-CUST-SHIP-TO Numeric 4 CXCP.1 DR100
Customer Ship-To This field contains the ship-to IC141 IC142
Number customer number. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-REQ-LOCATION Alpha 5 CXCP.1 DR100
To Location The location that is requesting items. IC141 IC142
This location can be an inventory or IC22.1 IC22.2
nonstock location. IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-REQ-COMPANY Numeric 4 CXCP.1 DR100
Requesting Company This field contains the requesting IC141 IC142
company. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC83.1 IC850
POIJ.1 RQ12.1
RQ13.1 WH110
WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-ALLOCATE-DT Numeric 8 (yyyymmdd) CXCP.1 DR100
Allocation Date This field contains the date that you IC141 IC142
want the document line to be allocated. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-EST-TRAN-DT Numeric 8 (yyyymmdd) CXCP.1 DR100
Expected Ship Date This field contains the expected ship IC141 IC142
date for the line. If you leave the IC22.1 IC22.2
field blank and no ship days are defined IC23.1 IC23.2
on the document's process level, the IC25.1 IC500
document date defaults. If ship dates IC83.1 IC850
exist on the process level, ship days POIJ.1 RQ12.1
are added to the document date to RQ13.1 WH110
calculate the expected ship date. WH120 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH210 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WDM-SUGGESTED-LOT Alpha 10 CXCP.1 DR100
Suggested Lot This field contains the suggested lot IC141 IC142
for lot-tracked items. IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-SHIP-ACCT-UNIT Alpha 15
Ship Acct Unit This field contains a temporary general
ledger shipping account unit.
WDM-SHIP-ACCOUNT Numeric 6
Ship Account This field contains a temporary general
ledger shipping account.
WDM-SHIP-SUB-ACCT Numeric 4
Ship Sub Acct This field contains a temporary general
ledger shipping subaccount.
WDM-RUSH-FL Alpha 1 CXCP.1 DR100
Rush Fl The rush flag indicates if the document IC141 IC142
has a 'rush' placed on it. IC83.1 POIJ.1
Y = Yes RQ12.1 RQ13.1
N = No WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-OBJ-ID-DMND Numeric 12
Obj Id Dmnd This field contains the demand object
identifier.
WDM-SEQ Numeric 3
Sequence Number This field is used to create a value
that is associated with the demand
object id in the access path that gets
demand records by demand object id.
WDM-FILL-OR-KILL Alpha 1 CXCP.1 DR100
Fill Or Kill F = Fill Backorders IC141 IC142
K = Kill Backorders IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WDM-ORIGIN Derived
Origin This literal helps to determine from
which Lawson system a document
originated.
WDM-DOC-ALPHA Derived
Doc Alpha This field contains the alpha version
of the document number.
WDM-OPEN-DEMAND Derived
Open Demand This field contains the total of the
in-process quantity and the backorder
quantity for a document line.
WDM-SRC-ITEM-DESC Derived
Src Item Desc This field contains either the item
master description or the document line
description of an item.
WDM-TRAN-QUANTITY Derived
Transaction Quantity This field shows the transaction
quantity.
WDM-TRAN-ALLOCATED Derived
Transaction This field shows the transaction
Allocated quantity allocated.
WDM-TRAN-BACKORD Derived
Transaction This field shows the amount of the
Backordered transaction that is backordered.
WDM-TRAN-PRINTED Derived
Transaction Printed This field shows the transaction amount
that is printed.
WDM-TRAN-IN-PROC Derived
Transaction in This field shows the transaction that
Process is currently in process.
WDM-TRAN-SHIPPED Derived
Transaction Shipped This field shows the transaction that
has been shipped.
WDM-DISP-QUANTITY Derived
Display Quantity This field shows the displayed line
quantity.
WDM-DISP-ALLOCATED Derived
Display Allocated This field shows the displayed line
quantity that is allocated.
WDM-DISP-BACKORD Derived
Display Backordered This field shows the displayed line
quantity that is backordered.
WDM-DISP-PRINTED Derived
Display Printed This field shows the displayed line
quantity that is printed.
WDM-DISP-IN-PROC Derived
Display in Process This field shows the displayed line
quantity that is currently in process.
WDM-DISP-SHIPPED Derived
Display Shipped This field shows the displayed line
quantity that has been shipped.
WDM-DISP-DOC-NBR Derived
Disp Doc Nbr
WDM-ENTERED-ITEM Alpha 25 CXCP.1 DR100
Entered Item IC141 IC142
IC83.1 POIJ.1
RQ12.1 RQ13.1
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHDEMAND FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDMSET1 COMPANY Used to find all demand line records. CXCP.1 DR100
SYSTEM-CD Subset IC141 IC142
DOC-NBR Where (RECORD-TYPE = "D" ) IC83.1 POIF.1
LINE-NBR POIJ.1 RQ12.1
COMPONENT-SEQ RQ13.1 RQ140
LOCATION RQ300 RQ40.1
RQ41.1 RQ42.1
RQ44.1 RQ44.2
WH110 WH120
WH130 WH21.1
WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
...
WDMSET2 COMPANY Used to find all demand lines that are WH110 WH220
LOCATION ready to allocate. WH221
LINE-TYPE KeyChange, Subset
ITEM Where (RECORD-TYPE = "D" )
ALLOC-PRI And (ALLOCABLE-FL = "Y" )
DOC-NBR And (COMPONENT-SEQ = Zeroes )
LINE-NBR And (QUANTITY > PRINTED-QTY)
ALLOCATE-DT
SYSTEM-CD
WDMSET3 COMPANY Used to find all demand lines that are WH130
LOCATION ready to print.
SYSTEM-CD KeyChange, Subset
DOC-NBR Where (RECORD-TYPE = "D" )
LINE-NBR And (STATUS = 1 )
And (COMPONENT-SEQ = Zeroes )
And (ALLOC-QTY > PRINTED-QTY)
And (SYSTEM-CD != "WO" )
WDMSET4 COMPANY Used to find demand lines that need to WH130 WH33.1
SYSTEM-CD have details assigned. WH33.2 WH33.3
DOC-NBR KeyChange, Subset WH33.4 WH33.5
LINE-NBR Where (RECORD-TYPE = "D" ) WH33.6 WH33.8
COMPONENT-SEQ And (LINE-TYPE = "I" ) WH33.9 WH34.1
ITEM And (DETAIL-REQ = "Y" ) WH34.2 WH34.3
LOCATION WH34.4
WDMSET5 COMPANY Primary index used for accessing and DR100 IC12.1
LOCATION updating the table. IC141 IC142
ITEM KeyChange IC145 IC22.1
EST-TRAN-DT IC22.2 IC23.1
DOC-TYPE IC23.2 IC25.1
SYSTEM-CD IC330 IC45.1
DOC-NBR IC500 IC83.1
LINE-NBR IC850 PO228
COMPONENT-SEQ POIJ.1 RQ12.1
RQ13.1 WH130
WH226 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
...
WDMSET6 COMPANY KeyChange, Subset
LOCATION Where (RECORD-TYPE = "D"
ITEM And ALLOCABLE-FL = "Y"
EST-TRAN-DT And BACKORD-QTY > Zeroes
SYSTEM-CD And KIT-FL = "S"
DOC-NBR And STATUS = 1
LINE-NBR And OBJ-ID-DMND = Zeroes )
COMPONENT-SEQ
WDMSET7 COMPANY KeyChange, Subset
LOCATION Where RECORD-TYPE = "S"
SYSTEM-CD
DOC-NBR
LINE-NBR
COMPONENT-SEQ
WDMSET8 OBJ-ID-DMND KeyChange, Subset
SEQ Where (OBJ-ID-DMND > Zeroes
And OBJ-ID-DMND < 999999999999 )
WDMSET9 COMPANY This index was created as a solution to CXCP.1 DR100
SYSTEM-CD the Find Next/Prev Flag error. It is IC141 IC142
DOC-NBR only used where a modify must be done IC83.1 POIJ.1
LINE-NBR within a 850-FIND-NLT or 850-FIND-BEGRNG RQ12.1 RQ13.1
LOCATION loop. WH110 WH120
COMPONENT-SEQ Subset WH130 WH21.1
Where (RECORD-TYPE = "D" ) WH21.2 WH21.3
WH21.4 WH210
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHDEMAND FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Not Required
Valid When WDM-RECORD-TYPE = "S"
And WDM-SYSTEM-CD = "PO"
WDM-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Not Required
Valid When WDM-RECORD-TYPE = "S"
And WDM-SYSTEM-CD = "PO"
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
WDM-VENDOR -> VEN-VENDOR
Caseheader CXCASEHEAD Required
When WDM-SYSTEM-CD = "CX"
WDM-COMPANY -> CXH-COMPANY
WDM-REQ-LOCATION -> CXH-REQ-LOCATION
WDM-DOC-NBR -> CXH-CASE
Caseline CXPREFITEM Required
When WDM-SYSTEM-CD = "CX"
WDM-COMPANY -> CPI-COMPANY
WDM-REQ-LOCATION -> CPI-REQ-LOCATION
WDM-DOC-NBR -> CPI-CASE
WDM-LINE-NBR -> CPI-IF-REF-NBR
Coline COLINE Required
When WDM-SYSTEM-CD = "OE"
WDM-COMPANY -> COL-COMPANY
WDM-DOC-NBR-NUM -> COL-ORDER-NBR
WDM-LINE-NBR -> COL-LINE-NBR
Custorder CUSTORDER Required
When WDM-SYSTEM-CD = "OE"
WDM-COMPANY -> COR-COMPANY
WDM-DOC-NBR-NUM -> COR-ORDER-NBR
Iccompany ICCOMPANY Required
WDM-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
When WDM-LINE-TYPE = "I"
WDM-COMPANY -> ICL-COMPANY
WDM-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
When WDM-LINE-TYPE = "I"
WDM-COMPANY -> ITL-COMPANY
WDM-LOCATION -> ITL-LOCATION
WDM-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When WDM-LINE-TYPE = "I"
Or WDM-LINE-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WDM-ITEM -> ITE-ITEM
Poline POLINE Required
When WDM-RECORD-TYPE = "S"
And WDM-SYSTEM-CD = "PO"
WDM-DOC-NBR -> PLI-PO-OBJ-ID
WDM-LINE-NBR -> PLI-LINE-NBR
Reqheader REQHEADER Required
When WDM-SYSTEM-CD = "RQ"
WDM-REQ-COMPANY -> RQH-COMPANY
WDM-DOC-NBR-NUM -> RQH-REQ-NUMBER
Reqline REQLINE Required
When WDM-SYSTEM-CD = "RQ"
WDM-REQ-COMPANY -> RLN-COMPANY
WDM-DOC-NBR-NUM -> RLN-REQ-NUMBER
WDM-LINE-NBR -> RLN-LINE-NBR
Returnhdr RETURNHDR Required
When WDM-SYSTEM-CD = "RT"
WDM-COMPANY -> RTN-COMPANY
WDM-DOC-NBR-NUM -> RTN-AUTH-NO
Whdemndhdr WHDEMNDHDR Required
WDM-COMPANY -> WDH-COMPANY
WDM-SYSTEM-CD -> WDH-SYSTEM-CD
WDM-DOC-NBR -> WDH-DOC-NBR
WHDEMAND FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bins WHDEMNDDTL
WDM-COMPANY -> WDD-COMPANY
WDM-LOCATION -> WDD-LOCATION
WDM-SYSTEM-CD -> WDD-SYSTEM-CD
WDM-DOC-NBR -> WDD-DOC-NBR
WDM-LINE-NBR -> WDD-LINE-NBR
WDM-COMPONENT-SEQ -> WDD-COMPONENT-SEQ
WDD-BIN
WDD-LOT
WDD-SUBLOT
WDD-SERIAL
WDD-UOM
Itemlocs ITEMLOC
Valid When WDM-LINE-TYPE = "I"
WDM-COMPANY -> ITL-COMPANY
WDM-ITEM -> ITL-ITEM
ITL-LOCATION
Lots WHDEMNDDTL
WDM-COMPANY -> WDD-COMPANY
WDM-LOCATION -> WDD-LOCATION
WDM-SYSTEM-CD -> WDD-SYSTEM-CD
WDM-DOC-NBR -> WDD-DOC-NBR
WDM-LINE-NBR -> WDD-LINE-NBR
WDM-COMPONENT-SEQ -> WDD-COMPONENT-SEQ
WDD-BIN
WDD-LOT
WDD-SUBLOT
WDD-SERIAL
WDD-UOM
Serials WHDEMNDDTL
WDM-COMPANY -> WDD-COMPANY
WDM-LOCATION -> WDD-LOCATION
WDM-SYSTEM-CD -> WDD-SYSTEM-CD
WDM-DOC-NBR -> WDD-DOC-NBR
WDM-LINE-NBR -> WDD-LINE-NBR
WDM-COMPONENT-SEQ -> WDD-COMPONENT-SEQ
WDD-BIN
WDD-LOT
WDD-SUBLOT
WDD-SERIAL
WDD-UOM
Sohdetail SOHDETAIL
WDM-COMPANY -> SDT-COMPANY
WDM-LOCATION -> SDT-LOCATION
WDM-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Subloc ITEMLOC
WDM-COMPANY -> ITL-COMPANY
WDM-ITEM -> ITL-ITEM
ITL-LOCATION
Uoms WHDEMNDDTL
WDM-COMPANY -> WDD-COMPANY
WDM-LOCATION -> WDD-LOCATION
WDM-SYSTEM-CD -> WDD-SYSTEM-CD
WDM-DOC-NBR -> WDD-DOC-NBR
WDM-LINE-NBR -> WDD-LINE-NBR
WDM-COMPONENT-SEQ -> WDD-COMPONENT-SEQ
WDD-BIN
WDD-LOT
WDD-SUBLOT
WDD-SERIAL
WDD-UOM
Whdemnddtl WHDEMNDDTL
WDM-COMPANY -> WDD-COMPANY
WDM-LOCATION -> WDD-LOCATION
WDM-SYSTEM-CD -> WDD-SYSTEM-CD
WDM-DOC-NBR -> WDD-DOC-NBR
WDM-LINE-NBR -> WDD-LINE-NBR
WDM-COMPONENT-SEQ -> WDD-COMPONENT-SEQ
WDD-BIN
WDD-LOT
WDD-SUBLOT
WDD-SERIAL
WDD-UOM
|