WHDEMAND FILE
Demand
The Demand file contains all the records that the Lawson Warehouse system
needs for processing demands.
REFERENCED BY
WH967 WH220 WH221 IC12.1 IC145 IC45.1
WH226 WO215 WO220 WO82.1
UPDATED BY
BL92.1 CX05.1 CX05.2 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CX805 CXCP.1 DR100 IC141 IC142 IC22.1
IC22.2 IC23.1 IC23.2 IC25.1 IC500 IC83.1
IC850 IC963 IN20.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE81.1
OE810 OE830 OE90.1 OE90.2 OE920 OE950
PO100 PO20.1 PO21.1 PO21.6 PO22.2 PO22.3
PO30.1 PO31.1 PO33.1 PO34.1 PO35.1 PO530
PO821 PO990 RQ10.1 RQ10.3 RQ11.1 RQ12.1
RQ120 RQ13.1 RQ20.1 RQ20.4 RQ35.1 RQ500
RQ961 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 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 WH961 WO120 WO131
WO132 WO133 WO140 WO20.1 WO30.1 WO32.1
WO32.2 WO32.3 WO32.4 WO32.5 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO41.1 WO41.2 WO41.3
WO41.4 WO42.1 WO42.2 WO42.3 WO42.4 WO42.5
WO45.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WDM-COMPANY Numeric 4 BL92.1 CX05.1
Company This field contains the company number. CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-SYSTEM-CD Alpha 2 BL92.1 CX05.1
System Code This field indicates on which Lawson CX05.2 CX100
system the document originated. CX20.1 CX20.2
OE = Customer Order CX20.4 CX20.5
RQ = Requisition CX220 CX30.1
IC = Intransit CX300 CX506
PO = Purchase Order CX805 CXCP.1
CX = Case Cart DR100 IC141
WO = Work Order IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-DOC-NBR Alpha 10 (Right Justified) BL92.1 CX05.1
Document Number This field contains the document number CX05.2 CX100
for the shipment line. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-DOC-NBR-NUM Numeric 10 BL92.1 CX05.1
Document Number This field contains the numeric version CX05.2 CX100
Numeric Value of the document number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-LINE-NBR Numeric 6 BL92.1 CX05.1
Line Number This field contains the document line CX05.2 CX100
number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-COMPONENT-SEQ Numeric 3 BL92.1 CX05.1
Component Sequence This field contains the component CX05.2 CX100
sequence number of the component item. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-DOC-TYPE Alpha 2 BL92.1 CX05.1
Document Type This field contains the type of CX05.2 CX100
document. For warehouse purposes, this CX20.1 CX20.2
is the shipping document. CX20.4 CX20.5
SH = Shipping Document CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-RECORD-TYPE Alpha 1 BL92.1 CX05.1
Record Type This field identifies the type of CX05.2 CX100
demand record defined. Demand records CX20.1 CX20.2
are processed in the Lawson Warehouse CX20.4 CX20.5
system and supply records are not. CX220 CX30.1
D = Demand CX300 CX506
S = Supply CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-ITEM Alpha 32 BL92.1 CX05.1
Item This field contains the item CX05.2 CX100
identifier. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-ITEM-DESC Alpha 30 BL92.1 CX05.1
Item Description This field contains the description for CX05.2 CX100
inventoried and nonstock items. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE81.1 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO30.1
PO31.1 PO34.1
...
WDM-LOCATION Alpha 5 BL92.1 CX05.1
Location This field contains a valid stock CX05.2 CX100
location within the company inventory. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-DESTINATION Alpha 15 BL92.1 CX05.1
Destination This field contains the destination CX05.2 CX100
name for the shipment (ship-to CX20.1 CX20.2
customer). CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-ROUTE Numeric 4 BL92.1 CX05.1
Route This field contains the route number. CX05.2 CX100
The route assigned to the ship-to CX20.1 CX20.2
customer defaults from the Order Entry CX20.4 CX20.5
Route file. CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-STOP Numeric 4 BL92.1 CX05.1
Stop This field contains the stop within the CX05.2 CX100
route. If left blank, the stop CX20.1 CX20.2
associated with the ship-to customer CX20.4 CX20.5
defaults from the Route file. CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-RTE-CREATE-FL Alpha 1 BL92.1 CX05.1
Route Create Flag This field indicates whether a route CX05.2 CX100
record exists for this document line. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-STATUS Numeric 1 BL92.1 CX05.1
Status This field contains the demand status. CX05.2 CX100
0 = Unreleased CX20.1 CX20.2
1 = Released for Processing CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-ALLOCABLE-FL Alpha 1 BL92.1 CX05.1
Allocatable Flag This field indicates whether demand CX05.2 CX100
lines are ready to be allocated or not. CX20.1 CX20.2
Y = Allocatable CX20.4 CX20.5
N = Not Ready for Allocation CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-LINE-TYPE Alpha 1 BL92.1 CX05.1
Line Type This field contains the type of item on CX05.2 CX100
this demand line. CX20.1 CX20.2
I = Inventoried CX20.4 CX20.5
N = Nonstock CX220 CX30.1
X = Special CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-QUANTITY Signed 13.4 BL92.1 CX05.1
Quantity This field contains the demand CX05.2 CX100
quantity. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-ALLOC-QTY Signed 13.4 BL92.1 CX05.1
Allocated Quantity This field contains the quantity that CX05.2 CX100
has been allocated for this demand line. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-BACKORD-QTY Signed 13.4 BL92.1 CX05.1
Backordered Quantity This field contains the backordered CX05.2 CX100
quantity that is not available in CX20.1 CX20.2
inventory for allocation. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-PRINTED-QTY Signed 13.4 BL92.1 CX05.1
Printed Quantity This field contains the quantity that CX05.2 CX100
was printed on the pick list to be CX20.1 CX20.2
picked. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-IN-PROC-QTY Signed 13.4 BL92.1 CX05.1
In-Process Quantity This field contains the in-process CX05.2 CX100
quantity for the demand. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-SHIPPED-QTY Signed 13.4 BL92.1 CX05.1
Shipped Quantity This field contains the quantity that CX05.2 CX100
was shipped. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-PRE-ASMBLD-KIT Signed 13.4 BL92.1 CX05.1
Pre-Assembled Kit This field contains the quantity of CX05.2 CX100
make-to-order kits you want to CX20.1 CX20.2
preassemble. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-DETAIL-QTY Signed 13.4 BL92.1 CX05.1
Quantity Details This field shows the quantity of demand CX05.2 CX100
lines with details. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-UNIT-COST Signed 13.5 BL92.1 CX05.1
Unit Cost This field contains the unit cost for CX05.2 CX100
the document line. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-TRAN-UOM Alpha 4 BL92.1 CX05.1
Document Unit of This field contains the unit of measure CX05.2 CX100
Measure used for the document. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-TRAN-UOM-MULT Signed 13.7 BL92.1 CX05.1
Document UOM This field contains the multiplier used CX05.2 CX100
Multiplier to convert the document unit of measure CX20.1 CX20.2
to the stock unit of measure. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-FUTURE-FL Alpha 1 BL92.1 CX05.1
Future Document Flag This field indicates if the document CX05.2 CX100
line has a future status. CX20.1 CX20.2
Y = Future Demand CX20.4 CX20.5
N = Current Demand CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-FIRM-FL Alpha 1 BL92.1 CX05.1
Firm Flag This field indicates whether allocation CX05.2 CX100
is firm or not for a document line item. CX20.1 CX20.2
If the allocation is set to Confirmed CX20.4 CX20.5
Demand, WH110 (Batch Allocation) will CX220 CX30.1
not let you deallocate this item later. CX300 CX506
Y = Confirmed Demand CX805 CXCP.1
N = Open For Confirmation DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-BACK-ORD-FL Alpha 1 BL92.1 CX05.1
Backorder Flag This field indicates whether or not the CX05.2 CX100
customer accepts backorders. CX20.1 CX20.2
Y = Backorder Allowed CX20.4 CX20.5
N = Backorder Not Allowed CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-KIT-FL Alpha 1 BL92.1 CX05.1
Kit Flag This field indicates the kind of kit CX05.2 CX100
item found on the document line. CX20.1 CX20.2
O = Make-to-Order Kit CX20.4 CX20.5
S = Make-to-Stock Kit CX220 CX30.1
N = Not a Kit CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-KIT-COMPLETE Alpha 1 BL92.1 CX05.1
Kit Complete This field indicates whether or not all CX05.2 CX100
kit options have been reviewed and CX20.1 CX20.2
selected for a kit item. CX20.4 CX20.5
Y = All kit options are reviewed CX220 CX30.1
N = All kit options not reviewed CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE81.1 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO30.1
PO31.1 PO34.1
...
WDM-PO-FLAG Alpha 1 BL92.1 CX05.1
Purchase Order Flag This field indicates whether or not the CX05.2 CX100
line is related to a purchase order. CX20.1 CX20.2
Y = Based on PO Receipt CX20.4 CX20.5
N = Not Related to PO CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-PICKING-REQ Alpha 1 BL92.1 CX05.1
Picking Required This field indicates whether the CX05.2 CX100
process type for the document requires CX20.1 CX20.2
picking feedback. CX20.4 CX20.5
Y = Picking is Required CX220 CX30.1
N = Picking is not Required CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-PACKING-REQ Alpha 1 BL92.1 CX05.1
Packing Required This field indicates whether or not the CX05.2 CX100
process type for this document requires CX20.1 CX20.2
packing feedback. CX20.4 CX20.5
Y = Packing is Required CX220 CX30.1
N = Packing is not Required CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-DETAIL-REQ Alpha 1 BL92.1 CX05.1
Detail Required This field indicates whether or not CX05.2 CX100
details are required for the document CX20.1 CX20.2
line item. CX20.4 CX20.5
Y = Details are Required CX220 CX30.1
N = Details are not Required CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-ALLOC-PRI Numeric 2 BL92.1 CX05.1
Allocation Priority This field indicates what allocation CX05.2 CX100
priority you gave to a document line. CX20.1 CX20.2
00 = Priority of Allocation CX20.4 CX20.5
99 = Priority of Allocation CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-HOLD-FL Alpha 1 BL92.1 CX05.1
Hold Flag This field indicates if the document CX05.2 CX100
line is on hold. The source for this CX20.1 CX20.2
field is the originating Lawson system. CX20.4 CX20.5
Y = Document Line is on Hold CX220 CX30.1
N = Document Line is not on Hold CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-VENDOR Alpha 9 BL92.1 CX05.1
Vendor The vendor's identification code. CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 IN20.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE81.1 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO100
...
WDM-CUST-SHIP-TO Numeric 4 BL92.1 CX05.1
Customer Ship-To This field contains the ship-to CX05.2 CX100
Number customer number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-REQ-LOCATION Alpha 5 BL92.1 CX05.1
To Location The location that is requesting items. CX05.2 CX100
This location can be an inventory or CX20.1 CX20.2
nonstock location. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE81.1 OE810
...
WDM-REQ-COMPANY Numeric 4 BL92.1 CX05.1
Requesting Company This field contains the requesting CX05.2 CX100
company. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE81.1 OE810
...
WDM-ALLOCATE-DT Numeric 8 (yyyymmdd) BL92.1 CX05.1
Allocate Date This field contains the date that you CX05.2 CX100
want the document line to be allocated. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-EST-TRAN-DT Numeric 8 (yyyymmdd) BL92.1 CX05.1
Expected Ship Date This field contains the expected ship CX05.2 CX100
date for the line. If you leave the CX20.1 CX20.2
field blank and no ship days are defined CX20.4 CX20.5
on the document's process level, the CX220 CX30.1
document date defaults. If ship dates CX300 CX506
exist on the process level, ship days CX805 CXCP.1
are added to the document date to DR100 IC141
calculate the expected ship date. IC142 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC83.1
IC850 IC963
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
...
WDM-SUGGESTED-LOT Alpha 10 BL92.1 CX05.1
Suggested Lot This field contains the suggested lot CX05.2 CX100
for lot-tracked items. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
IC963 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE81.1
OE810 OE830
OE90.1 OE90.2
OE920 OE950
PO30.1 PO31.1
...
WDM-SHIP-ACCT-UNIT Alpha 15 WH961
Ship Account Unit This field contains a temporary general
ledger shipping account unit.
WDM-SHIP-ACCOUNT Numeric 6 WH961
Ship Account This field contains a temporary general
ledger shipping account.
WDM-SHIP-SUB-ACCT Numeric 4 WH961
Ship Subaccount This field contains a temporary general
ledger shipping subaccount.
WDM-RUSH-FL Alpha 1 BL92.1 CX05.1
Rush Flag The rush flag indicates if the document CX05.2 CX100
has a 'rush' placed on it. CX20.1 CX20.2
Y = Yes CX20.4 CX20.5
N = No CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE81.1 OE810
OE830 OE90.1
OE90.2 OE920
OE950 PO30.1
PO31.1 PO34.1
...
WDM-OBJ-ID-DMND Numeric 12 WO120 WO140
Object Demand ID This field contains the demand object WO20.1
identifier.
WDM-SEQ Numeric 3
Sequence 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-ORIGIN Derived
Origin This literal helps to determine on
which Lawson system a document
originated.
WDM-DOC-ALPHA Derived
Document Alpha This field contains the alpha version
Number 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
Source Item This field contains either the item
Description 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.
WHDEMAND FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDMSET1 COMPANY Used to find all demand line records. BL92.1 CX05.1
SYSTEM-CD Subset CX05.2 CX100
DOC-NBR Where (RECORD-TYPE = "D" ) CX20.1 CX20.2
LINE-NBR CX20.4 CX20.5
COMPONENT-SEQ CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC141
IC142 IC83.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
...
WDMSET2 COMPANY Used to find all demand lines that are WH110 WH20.1
LOCATION ready to allocate. WH20.2 WH220
LINE-TYPE KeyChange, Subset WH221
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 RQ35.1 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 BL92.1 OE114
SYSTEM-CD have details assigned. WH130 WH132
DOC-NBR KeyChange, Subset WH190 WH30.1
LINE-NBR Where (RECORD-TYPE = "D" ) WH30.2 WH30.3
COMPONENT-SEQ And (LINE-TYPE = "I" ) WH31.1 WH31.2
ITEM And (DETAIL-REQ = "Y" ) WH31.3 WH32.1
LOCATION WH32.2 WH32.3
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
WDMSET5 COMPANY Primary index used for accessing and BL92.1 DR100
LOCATION updating the table. IC12.1 IC141
ITEM KeyChange IC142 IC145
EST-TRAN-DT IC22.1 IC22.2
DOC-TYPE IC23.1 IC23.2
SYSTEM-CD IC25.1 IC45.1
DOC-NBR IC500 IC83.1
LINE-NBR IC850 IC963
COMPONENT-SEQ IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
...
WDMSET6 COMPANY KeyChange, Subset WO120 WO20.1
LOCATION Where (RECORD-TYPE = "D" WO215 WO220
ITEM And ALLOCABLE-FL = "Y" WO82.1
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 WO30.1 WOSP.1
LOCATION Where RECORD-TYPE = "S"
SYSTEM-CD
DOC-NBR
LINE-NBR
COMPONENT-SEQ
WDMSET8 OBJ-ID-DMND KeyChange, Duplicates, Subset WO20.1
SEQ Where (OBJ-ID-DMND > Zeroes
And OBJ-ID-DMND < 999999999999 )
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
Reqheader REQHEADER Required
When WDM-SYSTEM-CD = "RQ"
WDM-COMPANY -> RQH-COMPANY
WDM-DOC-NBR-NUM -> RQH-REQ-NUMBER
Reqline REQLINE Required
When WDM-SYSTEM-CD = "RQ"
WDM-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
Returnline RETURNLINE Required
When WDM-SYSTEM-CD = "RT"
WDM-COMPANY -> RTL-COMPANY
WDM-DOC-NBR-NUM -> RTL-AUTH-NO
WDM-LINE-NBR -> RTL-LINE-NBR
Whdemndhdr WHDEMNDHDR Required
WDM-COMPANY -> WDH-COMPANY
WDM-SYSTEM-CD -> WDH-SYSTEM-CD
WDM-DOC-NBR -> WDH-DOC-NBR
Woschedule WOSCHEDULE Not Required
WDM-OBJ-ID-DMND -> WOS-OBJ-ID-DMND
WHDEMAND FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bins WHDEMNDDTL
Valid When WDM-LOT-TRACK-FL = "N"
And WDM-BIN-TRACK-FL = "Y"
And WDM-SER-TRACK-FL != "R"
WDM-COMPANY -> WDD-COMPANY
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
Valid When WDM-LOT-TRACK-FL = "Y"
WDM-COMPANY -> WDD-COMPANY
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
Valid When WDM-SER-TRACK-FL = "R"
WDM-COMPANY -> WDD-COMPANY
WDM-SYSTEM-CD -> WDD-SYSTEM-CD
WDM-DOC-NBR -> WDD-DOC-NBR
WDM-COMPANY -> WDD-LINE-NBR
WDM-COMPONENT-SEQ -> WDD-COMPONENT-SEQ
WDD-BIN
WDD-LOT
WDD-SUBLOT
WDD-SERIAL
WDD-UOM
Subloc ITEMLOC
WDM-COMPANY -> ITL-COMPANY
WDM-ITEM -> ITL-ITEM
ITL-LOCATION
Uoms WHDEMNDDTL
Valid When WDM-LOT-TRACK-FL = "N"
And WDM-SER-TRACK-FL != "R"
And WDM-BIN-TRACK-FL = "N"
And WDM-DETAIL-REQ = "Y"
WDM-COMPANY -> WDD-COMPANY
WDM-SYSTEM-CD -> WDD-SYSTEM-CD
WDM-DOC-NBR -> WDD-DOC-NBR
WDM-LINE-NBR -> WDD-LINE-NBR
WDM-COMPANY -> WDD-COMPONENT-SEQ
Spaces -> WDD-BIN
Spaces -> WDD-LOT
Spaces -> WDD-SUBLOT
Spaces -> WDD-SERIAL
WDD-UOM
Whdemnddtl WHDEMNDDTL
Valid When (WDM-RECORD-TYPE = "D" )
And (WDM-LINE-TYPE = "I" )
And (WDM-DETAIL-REQ = "Y" )
WDM-COMPANY -> WDD-COMPANY
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
|