 |
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 POIG.1 RQ140 RQ300 RQ40.1 RQ41.1
RQ42.1 RQ44.1 RQ44.2 WH224 WH220 WH221
IC12.1 IC145 IC330 IC45.1 PO228 WH226
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 DR100 IC141 IC142 IC22.1
IC22.2 IC23.1 IC23.2 IC25.1 IC28.1 IC500
IC83.1 IC850 MA180 MA43.9 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.3 MA67.1
MA67.2 MA70.1 MAI1.1 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ35.1 RQ500 RQIB.1 RQIF.1 WH110 WH120
WH130 WH132 WH190 WH20.1 WH20.2 WH20.3
WH20.4 WH20.5 WH20.6 WH20.7 WH21.1 WH21.2
WH21.3 WH21.4 WH210 WH22.1 WH222 WH25.1
WH25.2 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
WDM-COMPANY Numeric 4 AP125 AP126
Company This field contains the company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-SYSTEM-CD Alpha 2 AP125 AP126
System Code This field indicates from which Lawson AP131 AP25.1
system the document originated. AP25.2 AP26.1
OE = Customer Order AP27.1 CXCP.1
RQ = Requisition DR100 IC141
IC = Intransit IC142 IC22.1
PO = Purchase Order IC22.2 IC23.1
CX = Case Cart IC23.2 IC25.1
WO = Work Order IC28.1 IC500
PH = Pharmacy IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-DOC-NBR Alpha 10 (Right Justified) AP125 AP126
Doc Nbr This field contains the document number AP131 AP25.1
for the shipment line. If this record AP25.2 AP26.1
was created from a PO, it will be the AP27.1 CXCP.1
object id from the POLINE since the PO DR100 IC141
Number is too long for this field. IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-DOC-NBR-NUM Numeric 10 AP125 AP126
Doc Nbr Num This field contains the numeric version AP131 AP25.1
of the document number. The system codes AP25.2 AP26.1
of OE & RQ use this field. For PO, this AP27.1 CXCP.1
field will be the PLI-PO-RELEASE field. DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the document line AP131 AP25.1
number. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-COMPONENT-SEQ Numeric 3 AP125 AP126
Component Sequence This field contains the component AP131 AP25.1
Number sequence number of the component item. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-DOC-TYPE Alpha 2 AP125 AP126
Document Type This field contains the type of AP131 AP25.1
document. For warehouse purposes, this AP25.2 AP26.1
is the shipping document. AP27.1 CXCP.1
DT = Direct Transfer DR100 IC141
IR = Intransit Receiving IC142 IC22.1
IS = Issue IC22.2 IC23.1
IT = Transfer Issue IC23.2 IC25.1
SH = Shipment IC28.1 IC500
PO = Purchase Order IC83.1 IC850
WO = Work Order MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-RECORD-TYPE Alpha 1 AP125 AP126
Record Type This field identifies the type of AP131 AP25.1
demand record defined. Demand records AP25.2 AP26.1
are processed in the Lawson Warehouse AP27.1 CXCP.1
system and supply records are not. DR100 IC141
D = Demand IC142 IC22.1
S = Supply IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-ITEM-DESC Alpha 30 AP125 AP126
Item Description This field contains the description for AP131 AP25.1
inventoried and nonstock items. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stock AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-DESTINATION Alpha 15 AP125 AP126
Destination This field contains the destination AP131 AP25.1
name for the shipment (ship-to AP25.2 AP26.1
customer). AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-ROUTE Numeric 4 AP125 AP126
Route This field contains the route number. AP131 AP25.1
The route assigned to the ship-to AP25.2 AP26.1
customer defaults from the Order Entry AP27.1 CXCP.1
Route file. DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-STOP Numeric 4 AP125 AP126
Stop This field contains the stop within the AP131 AP25.1
route. If left blank, the stop AP25.2 AP26.1
associated with the ship-to customer AP27.1 CXCP.1
defaults from the Route file. DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-RTE-CREATE-FL Alpha 1 AP125 AP126
Route Create Flag This field indicates whether a route AP131 AP25.1
record exists for this document line. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-STATUS Numeric 1 AP125 AP126
Status This field contains the demand status. AP131 AP25.1
0 = Unreleased AP25.2 AP26.1
1 = Released for Processing AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-ALLOCABLE-FL Alpha 1 AP125 AP126
Allocatable Flag This field indicates whether demand AP131 AP25.1
lines are ready to be allocated or not. AP25.2 AP26.1
Y = Allocatable AP27.1 CXCP.1
N = Not Ready for Allocation DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
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 AP125 AP126
Line Type This field contains the type of item on AP131 AP25.1
this demand line. AP25.2 AP26.1
I = Inventoried AP27.1 CXCP.1
N = Nonstock DR100 IC141
X = Special IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-QUANTITY Signed 13.4 AP125 AP126
Quantity This field contains the demand AP131 AP25.1
quantity. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-ALLOC-QTY Signed 13.4 AP125 AP126
Allocated Quantity This field contains the quantity that AP131 AP25.1
has been allocated for this demand line. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-BACKORD-QTY Signed 13.4 AP125 AP126
Backordered Quantity This field contains the backordered AP131 AP25.1
quantity that is not available in AP25.2 AP26.1
inventory for allocation. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-PRINTED-QTY Signed 13.4 AP125 AP126
Printed on Pick This field contains the quantity that AP131 AP25.1
List Quantity was printed on the pick list to be AP25.2 AP26.1
picked. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-IN-PROC-QTY Signed 13.4 AP125 AP126
In-Process Quantity This field contains the in-process AP131 AP25.1
quantity for the demand. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-SHIPPED-QTY Signed 13.4 AP125 AP126
Shipped Quantity This field contains the quantity that AP131 AP25.1
was shipped. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-PRE-ASMBLD-KIT Signed 13.4 AP125 AP126
Pre-Assembled Kit This field contains the quantity of AP131 AP25.1
make-to-order kits you want to AP25.2 AP26.1
preassemble. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-DETAIL-QTY Signed 13.4 AP125 AP126
Detail Qty This field shows the quantity of demand AP131 AP25.1
lines with details. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-UNIT-COST Signed 13.5 AP125 AP126
Unit Cost This field contains the unit cost for AP131 AP25.1
the document line. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-TRAN-UOM Alpha 4 AP125 AP126
Document Unit of This field contains the unit of measure AP131 AP25.1
Measure used for the document. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-TRAN-UOM-MULT Signed 13.7 AP125 AP126
Document UOM This field contains the multiplier used AP131 AP25.1
Multiplier to convert the document unit of measure AP25.2 AP26.1
to the stock unit of measure. AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-FUTURE-FL Alpha 1 AP125 AP126
Future Document Flag This field indicates if the document AP131 AP25.1
line has a future status. AP25.2 AP26.1
Y = Future Demand AP27.1 CXCP.1
N = Current Demand DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-FIRM-FL Alpha 1 AP125 AP126
Firm Flag This field indicates whether allocation AP131 AP25.1
is firm or not for a document line item. AP25.2 AP26.1
If the allocation is set to Confirmed AP27.1 CXCP.1
Demand, WH110 (Batch Allocation) will DR100 IC141
not let you deallocate this item later. IC142 IC28.1
Y = Confirmed Demand IC83.1 MA180
N = Open For Confirmation MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-SHIP-COMP-FL Alpha 1 AP125 AP126
Ship Comp Fl This field indicates whether or not the AP131 AP25.1
customer requires complete shipments. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-BACK-ORD-FL Alpha 1 AP125 AP126
Backorders Allowed This field indicates whether or not the AP131 AP25.1
Flag customer accepts backorders. AP25.2 AP26.1
Y = Backorder Allowed AP27.1 CXCP.1
N = Backorder Not Allowed DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-KIT-FL Alpha 1 AP125 AP126
Kit Flag This field indicates the kind of kit AP131 AP25.1
item found on the document line. AP25.2 AP26.1
O = Make-to-Order Kit AP27.1 CXCP.1
S = Make-to-Stock Kit DR100 IC141
N = Not a Kit IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-KIT-COMPLETE Alpha 1 AP125 AP126
Kit Complete This field indicates whether or not all AP131 AP25.1
kit options have been reviewed and AP25.2 AP26.1
selected for a kit item. AP27.1 CXCP.1
Y = All kit options are reviewed DR100 IC141
N = All kit options not reviewed IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-PO-FLAG Alpha 1 AP125 AP126
PO Flag This field indicates whether or not the AP131 AP25.1
line is related to a purchase order. AP25.2 AP26.1
Y = Based on PO Receipt AP27.1 CXCP.1
N = Not Related to PO DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-PICKING-REQ Alpha 1 AP125 AP126
Picking Required This field indicates whether the AP131 AP25.1
process type for the document requires AP25.2 AP26.1
picking feedback. AP27.1 CXCP.1
Y = Picking is Required DR100 IC141
N = Picking is not Required IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-PACKING-REQ Alpha 1 AP125 AP126
Packing Required This field indicates whether or not the AP131 AP25.1
process type for this document requires AP25.2 AP26.1
packing feedback. AP27.1 CXCP.1
Y = Packing is Required DR100 IC141
N = Packing is not Required IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-DETAIL-REQ Alpha 1 AP125 AP126
Detail Required This field indicates whether or not AP131 AP25.1
details are required for the document AP25.2 AP26.1
line item. AP27.1 CXCP.1
Y = Details are Required DR100 IC141
N = Details are not Required IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-ALLOC-PRI Numeric 2 AP125 AP126
Allocation Priority This field indicates what allocation AP131 AP25.1
priority you gave to a document line. AP25.2 AP26.1
00 = Priority of Allocation AP27.1 CXCP.1
99 = Priority of Allocation DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-HOLD-FL Alpha 1 AP125 AP126
Hold Flag This field indicates if the document AP131 AP25.1
line is on hold. The source for this AP25.2 AP26.1
field is the originating Lawson system. AP27.1 CXCP.1
Y = Document Line is on Hold DR100 IC141
N = Document Line is not on Hold IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-MSDS-REQ-FL Alpha 1 AP125 AP126
MSDS Required Flag MSDS required flag. When this flag is AP131 AP25.1
set, a MSDS acknowledgment is required AP25.2 AP26.1
for the first shipment of the order AP27.1 CXCP.1
containing the item even if the item has DR100 IC141
a MSDS acknowledgment within a year for IC142 IC28.1
this customer. IC83.1 MA180
Y = Yes MA43.9 MA530
N = No MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-VENDOR Alpha 9 (Right Justified) AP125 AP126
Vendor ID The vendor's identification code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-CARRIER Alpha 9 (Right Justified) AP125 AP126
Carrier Vendor This is the carrier vendor number. It AP131 AP25.1
Number must be a valid vendor. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-CUST-SHIP-TO Numeric 4 AP125 AP126
Customer Ship-To This field contains the ship-to AP131 AP25.1
Number customer number. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-REQ-LOCATION Alpha 5 AP125 AP126
To Location The location that is requesting items. AP131 AP25.1
This location can be an inventory or AP25.2 AP26.1
nonstock location. AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-REQ-COMPANY Numeric 4 AP125 AP126
Requesting Company This field contains the requesting AP131 AP25.1
company. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-ALLOCATE-DT Numeric 8 (yyyymmdd) AP125 AP126
Allocation Date This field contains the date that you AP131 AP25.1
want the document line to be allocated. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-EST-TRAN-DT Numeric 8 (yyyymmdd) AP125 AP126
Expected Ship Date This field contains the expected ship AP131 AP25.1
date for the line. If you leave the AP25.2 AP26.1
field blank and no ship days are defined AP27.1 CXCP.1
on the document's process level, the DR100 IC141
document date defaults. If ship dates IC142 IC22.1
exist on the process level, ship days IC22.2 IC23.1
are added to the document date to IC23.2 IC25.1
calculate the expected ship date. IC28.1 IC500
IC83.1 IC850
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
...
WDM-SUGGESTED-LOT Alpha 10 AP125 AP126
Suggested Lot This field contains the suggested lot AP131 AP25.1
for lot-tracked items. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
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 AP125 AP126
Rush Fl The rush flag indicates if the document AP131 AP25.1
has a 'rush' placed on it. AP25.2 AP26.1
Y = Yes AP27.1 CXCP.1
N = No DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
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 AP125 AP126
Fill Or Kill F = Fill Backorders AP131 AP25.1
K = Kill Backorders AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
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 AP125 AP126
Entered Item AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-ENTRY-FL Alpha 1 AP125 AP126
Entry Fl 1 = Item AP131 AP25.1
2 = UPC AP25.2 AP26.1
3 = UPN1 AP27.1 CXCP.1
4 = UPN2 DR100 IC141
5 = NDC IC142 IC28.1
6 = SKU IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
...
WDM-RQSRC-MACHINE Alpha 6
Rqsrc Machine ESIOB
DROYAL
HBOC
OMNICL
PAREXE
PERSE
PYXIS
SSI
WDM-PAR-ORDER-ID Alpha 20
Par Order Id
WHDEMAND FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDMSET1 COMPANY Used to find all demand line records. AP125 AP126
SYSTEM-CD Subset AP131 AP25.1
DOC-NBR Where (RECORD-TYPE = "D" ) AP25.2 AP26.1
LINE-NBR AP27.1 CXCP.1
COMPONENT-SEQ DR100 IC141
LOCATION IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
WDMSET2 COMPANY Used to find all demand lines that are MA531 PO21.2
LOCATION ready to allocate. PO21.4 PO21.5
LINE-TYPE KeyChange, Subset PO30.1 PO30.2
ITEM Where (RECORD-TYPE = "D" ) PO30.3 PO33.1
ALLOC-PRI And (ALLOCABLE-FL = "Y" ) PO34.1 PO35.1
DOC-NBR And (COMPONENT-SEQ = Zeroes ) PO52.1 WH110
LINE-NBR And (QUANTITY > PRINTED-QTY) WH20.1 WH20.2
ALLOCATE-DT WH220 WH221
SYSTEM-CD WH25.1
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 WH132
SYSTEM-CD have details assigned. WH190 WH30.1
DOC-NBR KeyChange, Subset WH30.2 WH30.3
LINE-NBR Where (RECORD-TYPE = "D" ) WH30.4 WH31.1
COMPONENT-SEQ And (LINE-TYPE = "I" ) WH31.2 WH31.3
ITEM And (DETAIL-REQ = "Y" ) WH31.4 WH32.1
LOCATION 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
...
WDMSET5 COMPANY Primary index used for accessing and AP125 AP126
LOCATION updating the table. AP131 AP25.1
ITEM KeyChange AP25.2 AP26.1
EST-TRAN-DT AP27.1 DR100
DOC-TYPE IC12.1 IC141
SYSTEM-CD IC142 IC145
DOC-NBR IC22.1 IC22.2
LINE-NBR IC23.1 IC23.2
COMPONENT-SEQ IC25.1 IC28.1
IC330 IC45.1
IC500 IC83.1
IC850 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
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 AP125 AP126
SYSTEM-CD the Find Next/Prev Flag error. It is AP131 AP25.1
DOC-NBR only used where a modify must be done AP25.2 AP26.1
LINE-NBR within a 850-FIND-NLT or 850-FIND-BEGRNG AP27.1 CXCP.1
LOCATION loop. DR100 IC141
COMPONENT-SEQ Subset IC142 IC28.1
Where (RECORD-TYPE = "D" ) IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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
|