OESOURCE FILE
Order Entry Order Source
The Order Entry Order Source file contains order source records set up in
OE52.1 (Order Source). An order source indicates how a customer heard about
your company (advertisements, newspapers, and so on).
REFERENCED BY
OE252 OE53.1
UPDATED BY
BL92.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE510 OE52.1 OE810 OE920 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSR-COMPANY Numeric 4 OE52.1
Company This field contains the company number.
OSR-ORDER-SOURCE Alpha 2 OE52.1
Order Source This field contains the order source
code, which indicates how the customer
heard about your company.
OSR-SRC-DESC Alpha 30 (Lower Case) OE52.1 OE53.1
Source Description This field contains the description of
the order source code.
OSR-SRC-USED-FL Alpha 1 BL92.1 OE10.1
Source Used Flag This field indicates if the order OE10.2 OE10.3
source code has been used. OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
N = No OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE52.1
OE810 OE920
WH20.7
OSR-SRC-ACT-FL Alpha 1 OE52.1
Source Active Flag This field indicates if the order
source code is active.
A = Active
I = Inactive
OESOURCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSRSET1 COMPANY BL92.1 OE10.1
ORDER-SOURCE OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE252 OE510
OE52.1 OE53.1
OE810 OE920
...
OESOURCE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OSR-COMPANY -> OEC-COMPANY
|