|
|
OESTDCOMM FILE
Order Entry Standard Comments
This file stores standard comments for existing standard comment codes.
These comments can be copied and attached to orders, order lines, invoices,
and invoice lines.
REFERENCED BY
BL122 BL130 BL203 BL21.6 BL520 BLI2.1
UPDATED BY
BL03.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSC-COMPANY Numeric 4 BL03.1
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OSC-STD-COMM Alpha 4 BL03.1
Element: Std Comm User-defined code tied to comment text.
The standard comment code can be added
to an order or an order line and the
text tied to the code will default onto
the order. There are options users can
select when setting up the codes
indicating where the text should print.
OSC-SEQ Numeric 3 BL03.1
Element: Seq The record sequence number. Line or
sequence number of the line of comment
text this record represents.
OSC-PRINT-CODE Alpha 1 BL03.1
Element: Print Code The print code defines if the comment
should display and/or print on reports.
B = Both print and display.
D = Display only.
P = Print on forms and reports.
R = Print on reports only.
OSC-PICK-FL Alpha 1 BL03.1
Element: Pick Fl Determines whether to print the comment
on the pick list.
N = No
Y = Yes
OSC-INVC-FL Alpha 1 BL03.1
Element: All Flag N = No
Y = Yes
OSC-ACTIVE-STATUS Alpha 1 BL03.1
Element: Active Status Indicates whether the status of the
comment is active.
A = Active.
I = Inactive.
OSC-LANGUAGE-CODE Alpha 10 BL03.1
Element: Language Code Language Code (LOCALE).
OESTDCOMM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSCSET1 COMPANY BL03.1 BL122
STD-COMM BL130 BL203
LANGUAGE-CODE BL21.6 BL520
SEQ BLI2.1
OESTDCOMM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecommhdr OECOMMHDR Required
OSC-COMPANY -> OCH-COMPANY
OSC-STD-COMM -> OCH-STD-COMM
Oecompany OECOMPANY Required
OSC-COMPANY -> OEC-COMPANY
|
