|
|
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
PO23.1 POCP.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 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOC-COMPANY Numeric 4 BLI2.1
Element: Company This field contains the company number.
OOC-CUSTOMER Alpha 9 (Right Justified) BLI2.1
Element: Customer This field contains the number that
represents the customer who placed the
order.
OOC-STD-ORDER-NBR Alpha 22 BLI2.1
Element: Std Order Nbr This field contains the number of the
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
Element: Order Nbr This field contains the order number to
which the comment line is attached.
OOC-LINE-NBR Numeric 6 BLI2.1
Element: Line Nbr 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
Element: Seq This field contains the comment
sequence number.
OOC-PRINT-CODE Alpha 1 BLI2.1
Element: 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
Element: Pick Fl This field determines whether to print
the comment on the pick list.
N = No
Y = Yes
OOC-INVC-FL Alpha 1 BLI2.1
Element: All Flag This field indicates if the comment
prints on the invoice.
N = No
Y = Yes
OOC-COMM-TYPE Derived
Element: Comm 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 PO23.1
POCP.1 WH126
WH130 WH20.7
WH224
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
|
