|
|
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 BL22.1 BL520
BL80.1 OE10.6 OE11.3 OE11.6 OE112 OE114
OE14.4 OE15.4 OE15.7 OE254 OE54.1
UPDATED BY
BL03.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSC-COMPANY Numeric 4 BL03.1
Company The company number represents an
established company and is entered on
all function codes.
OSC-STD-COMM Alpha 4 BL03.1
Standard Comment 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
Sequence Number The record sequence number. Line or
sequence number of the line of comment
text this record represents.
OSC-COMMENT Alpha 40 (Lower Case) BL03.1
Comment Line This field contains the comment
narrative.
OSC-PRINT-CODE Alpha 1 BL03.1
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
Picking Option Flag Determines whether to print the comment
on the pick list.
N = No
Y = Yes
OSC-INVC-FL Alpha 1 BL03.1
Invoices Running This indicates if the comment prints on
Flag the invoice.
N = No
Y = Yes
OSC-ACTIVE-STATUS Alpha 1 BL03.1
Status Indicates whether the status of the
comment is active.
A = Active.
I = Inactive.
OSC-LANGUAGE-CODE Alpha 10 BL03.1
Language Code The code representing the language in
which the comment is written. Spaces
indicate the base language used at the
client site.
OESTDCOMM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSCSET1 COMPANY BL03.1 BL122
STD-COMM BL130 BL203
LANGUAGE-CODE BL21.6 BL22.1
SEQ BL520 BL80.1
OE10.6 OE11.3
OE11.6 OE112
OE114 OE14.4
OE15.4 OE15.7
OE254 OE54.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
|