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
WH126 WH130 WH224
UPDATED BY
BLI2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOC-COMPANY Numeric 4 BLI2.1
Company This field contains the company number.
OOC-CUSTOMER Alpha 9 (Right Justified) BLI2.1
Customer Number This field contains the number that
represents the customer who placed the
order.
OOC-STD-ORDER-NBR Alpha 22 BLI2.1
Standard Order This field contains the number of the
Number standard order used to create the order
to which this comment line is attached.
Standard Orders are setup on OE54.1
(Standard Order).
OOC-ORDER-NBR Numeric 8 BLI2.1
Order Number This field contains the order number to
which the comment line is attached.
OOC-LINE-NBR Numeric 6 BLI2.1
Line Number This field contains the number of the
line on the order to which the comment
can be attached. If this field is
blank, the comment is attached at the
order level.
OOC-SEQ Numeric 3 BLI2.1
Sequence Number This field contains the comment
sequence number.
OOC-PRINT-CODE Alpha 1 BLI2.1
Print Code This field contains the print code,
which defines where comments are
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
Picking Option Flag This field determines whether to print
the comment on the pick list.
N = No
Y = Yes
OOC-INVC-FL Alpha 1 BLI2.1
Invoices Running This field indicates if the comment
Flag prints on the invoice.
N = No
Y = Yes
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 BLI2.1 WH126
CUSTOMER WH130 WH224
STD-ORDER-NBR
ORDER-NBR
LINE-NBR
SEQ
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
|
