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.
UPDATED BY
POCP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOC-COMPANY
Element: Company
Numeric 4
This field contains the company number.
OOC-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents the customer who placed the order.
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).
OOC-ORDER-NBR
Element: Order Nbr
Numeric 8
This field contains the order number to which the comment line is attached.
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.
OOC-SEQ
Element: Seq
Numeric 3
This field contains the comment sequence number.
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
OOC-PICK-FL
Element: Pick Fl
Alpha 1
This field determines whether to print the comment on the pick list.
N = No
Y = Yes
OOC-INVC-FL
Element: All Flag
Alpha 1
This field indicates if the comment prints on the invoice.
N = No
Y = Yes
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
POCP.1


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: Wed Jun 08 20:50:17 2016

Home
Contact Us



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