WHDEMNDCMT FILE
Demand Comment
The Demand Comment file contains comments from document lines.
UPDATED BY
BL92.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.2 OE11.3 OE11.4 OE11.5
OE11.6 OE11.8 OE11.9 OE110 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE510 OE810 OE920 RQ10.1
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ20.1 RQ35.1
RQ500 WH20.7 WH20.1 WH20.2 WH20.3 WH20.4
WH20.5 WH20.6 WH963 CX05.1 CX05.2 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CX805 CXCP.1 IC963 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE81.1 OE830 OE90.1 OE90.2 OE950
PO30.1 PO31.1 PO34.1 PO35.1 PO530 RQ12.1
RQ120 RQ13.1 RQ300 RQ961 WH110 WH120
WH130 WH132 WH190 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 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
WDC-COMPANY Numeric 4 BL92.1 DR100
Company This field contains the company number. IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WDC-SYSTEM-CD Alpha 2 BL92.1 DR100
System Code This field indicates on which Lawson IC141 IC142
system the document originated. IC83.1 OE10.1
OE = Customer Order OE10.2 OE10.3
RQ = Requisition OE10.4 OE10.5
CX = Case Cart OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WDC-DOC-NBR Alpha 10 (Right Justified) BL92.1 DR100
Document Number This field indicates the document IC141 IC142
number containing comments. IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WDC-LINE-NBR Numeric 6 BL92.1 DR100
Line Number This field contains the document line IC141 IC142
number. IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WDC-SEQ Numeric 3 BL92.1 DR100
Sequence This field contains the sequence number IC141 IC142
of the comment line entered on the IC83.1 OE10.1
document line. OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WDC-COMMENT Alpha 40 (Lower Case) BL92.1 DR100
Comment This field contains the text of the IC141 IC142
comment. IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WDC-PRINT-CODE Alpha 1 BL92.1 DR100
Print Code This field contains the print code, IC141 IC142
which defines where comments are IC83.1 OE10.1
displayed or printed. OE10.2 OE10.3
B = Both Display and Print OE10.4 OE10.5
D = Display Only OE10.6 OE10.7
P = Print on all Reports/Forms OE10.8 OE11.1
R = Print only on Reports OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WDC-PICK-FL Alpha 1 BL92.1 DR100
Pick Flag This field indicates whether to print IC141 IC142
comments on the pick list. IC83.1 OE10.1
Y = Yes OE10.2 OE10.3
N = No OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 RQ10.1
RQ10.3 RQ10.4
RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 WH20.7
WH963
WHDEMNDCMT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDCSET1 COMPANY Primary index used for accessing and BL92.1 CX05.1
SYSTEM-CD updating the table. CX05.2 CX100
DOC-NBR CX20.1 CX20.2
LINE-NBR CX20.4 CX20.5
SEQ 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.2 OE11.4
...
|