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
BLI2.1 PO23.1 POCP.1 WH126 WH130 WH20.7
WH224 ZW130

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 ZW130


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 11:21:46 2016

Home
Contact Us



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