OEORDCMNT

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
BLI2.1 WH20.7

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


OEORDCMNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OOCSET1 COMPANY
CUSTOMER
STD-ORDER-NBR
ORDER-NBR
LINE-NBR
SEQ
BLI2.1 PO23.1
POCP.1 WH126
WH130 WH20.7
WH224


OEORDCMNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Required
When OOC-LINE-NBR !=Zeroes
AndOOC-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

File created: Thu Jun 09 02:24:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.