OEORDCMNT FILE
Customer Order Comments
The Customer Order Comments file contains comments that have been placed on
an order that was created from a standard order template. This file contains
both standard comments that are assigned to the order header or order line.
Each line of comments creates a separate record in this file.
REFERENCED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL940 OE112
OE280 OE281 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950
WH126 WH224
UPDATED BY
BL92.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 OE310 OE510
OE810 OE920 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOC-COMPANY Numeric 4 BL92.1 OE10.1
Company This field contains the company number. 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 WH20.7
OOC-CUSTOMER Alpha 9 (Right Justified) BL92.1 OE10.1
Customer This field contains the number that OE10.2 OE10.3
represents the customer who placed the OE10.4 OE10.5
order. OE10.6 OE10.7
OE10.8 OE11.1
OE11.2 OE11.3
OE11.4 OE11.5
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
WH20.7
OOC-STD-ORDER-NBR Alpha 10 BL92.1 OE10.1
Standard Order This field contains the number of the OE10.2 OE10.3
Number standard order used to create the order OE10.4 OE10.5
to which this comment line is attached. OE10.6 OE10.7
Standard Orders are setup on OE54.1 OE10.8 OE11.1
(Standard Order). OE11.2 OE11.3
OE11.4 OE11.5
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
WH20.7
OOC-ORDER-NBR Numeric 8 BL92.1 OE10.1
Order Number This field contains the order number to OE10.2 OE10.3
which the comment line is attached. 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 WH20.7
OOC-LINE-NBR Numeric 6 BL92.1 OE10.1
Line Number This field contains the number of the OE10.2 OE10.3
line on the order to which the comment OE10.4 OE10.5
can be attached. If this field is OE10.6 OE10.7
blank, the comment is attached at the OE10.8 OE11.1
order level. 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 WH20.7
OOC-SEQ Numeric 3 BL92.1 OE10.1
Sequence This field contains the comment OE10.2 OE10.3
sequence number. 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 WH20.7
OOC-COMMENT Alpha 40 (Lower Case) BL92.1 OE10.1
Comment This field contains the comment OE10.2 OE10.3
narrative. 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 WH20.7
OOC-PRINT-CODE Alpha 1 BL92.1 OE10.1
Print Code This field contains the print code, OE10.2 OE10.3
which defines where comments are OE10.4 OE10.5
displayed or printed. OE10.6 OE10.7
B = Both display and print OE10.8 OE11.1
D = Display only OE11.2 OE11.3
P = Print on all reports/forms OE11.4 OE11.5
R = Print on reports, not forms 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 WH20.7
OOC-PICK-FL Alpha 1 BL92.1 OE10.1
Pick Flag This field determines whether to print OE10.2 OE10.3
the comment on the pick list. OE10.4 OE10.5
N = No OE10.6 OE10.7
Y = Yes 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 WH20.7
OOC-INVC-FL Alpha 1 BL92.1 OE10.1
Invoice Flag This field indicates if the comment OE10.2 OE10.3
prints on the invoice. OE10.4 OE10.5
N = No OE10.6 OE10.7
Y = Yes 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 WH20.7
OOC-COMM-TYPE Derived
Comment Type This field defines the type of comment
added to the file.
OEORDCMNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OOCSET1 COMPANY BL120 BL130
CUSTOMER BL20.1 BL20.3
STD-ORDER-NBR BL21.2 BL21.5
ORDER-NBR BL29.1 BL29.2
LINE-NBR BL520 BL820
SEQ BL92.1 BL940
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.2
OE11.4 OE11.5
OE11.8 OE11.9
OE110 OE112
OE113 OE114
...
OEORDCMNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Required
When OOC-LINE-NBR != Zeroes
And OOC-LINE-NBR != 999999
OOC-COMPANY -> COL-COMPANY
OOC-ORDER-NBR -> COL-ORDER-NBR
OOC-LINE-NBR -> COL-LINE-NBR
Custorder CUSTORDER Required
OOC-COMPANY -> COR-COMPANY
OOC-ORDER-NBR -> COR-ORDER-NBR
|