|
|
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
OE112 OE229 OE280 OE281 PO23.1 WH126
WH130 WH224
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
BLI2.1 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 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE310 OE510
OE530 OE810 OE830 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOC-COMPANY Numeric 4 BLI2.1 OE11.2
Element: Company This field contains the company number. OE11.5 OE510
OE810
OOC-CUSTOMER Alpha 9 (Right Justified) BLI2.1 OE11.2
Element: Customer NumbeThis field contains the number that OE11.5 OE510
represents the customer who placed the OE810
order.
OOC-STD-ORDER-NBR Alpha 22 BLI2.1 OE11.2
Standard Order This field contains the number of the OE11.5 OE510
Number standard order used to create the order OE810
to which this comment line is attached.
Standard Orders are setup on OE54.1
(Standard Order).
OOC-ORDER-NBR Numeric 8 BLI2.1 OE11.2
Element: Order Number This field contains the order number to OE11.5 OE14.4
which the comment line is attached. OE510 OE810
OOC-LINE-NBR Numeric 6 BLI2.1 OE11.2
Element: Line Number This field contains the number of the OE11.5 OE510
line on the order to which the comment OE810
can be attached. If this field is
blank, the comment is attached at the
order level.
OOC-SEQ Numeric 3 BLI2.1 OE11.2
Element: Sequence NumbeThis field contains the comment OE11.5 OE510
sequence number. OE810
OOC-PRINT-CODE Alpha 1 BLI2.1 OE11.2
Element: Print Code This field contains the print code, OE11.5 OE510
which defines where comments are OE810
displayed or printed.
B = Both display and print
D = Display only
P = Print on all reports/forms
R = Print on reports, not forms
OOC-PICK-FL Alpha 1 BLI2.1 OE11.2
Element: Picking OptionThis field determines whether to print OE11.5 OE510
the comment on the pick list. OE810
N = No
Y = Yes
OOC-INVC-FL Alpha 1 BLI2.1 OE11.2
Element: All Flag This field indicates if the comment OE11.5 OE510
prints on the invoice. OE810
N = No
Y = Yes
OOC-COMM-TYPE Derived
Element: 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 BL122
CUSTOMER BL130 BL20.1
STD-ORDER-NBR BL20.3 BL21.2
ORDER-NBR BL21.5 BL29.1
LINE-NBR BL29.2 BL520
SEQ BL820 BL92.1
BLI2.1 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
OE111 OE112
...
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
|
