SALESREP FILE
AR SalesReps
AR SalesReps
REFERENCED BY
AR206 AR210 AR234 AR235 AR251 AR253
AR260 AR271 AR275 AR282 AR292 AR502
AR560 AR973 OE13.1 SA258 SAA2.1
UPDATED BY
AR01.1 AR06.3 AR08.1 AR10.1 AR42.2 AR501
AR550 BL02.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL30.1
BL30.2 BL30.3 BL30.5 BL31.1 BL31.2 BL31.3
BL31.5 BL31.7 BL32.1 BL32.2 BL32.3 BL32.4
BL520 BL80.1 BL802 BL820 BL902 BL92.1
BL940 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 OE112 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE288 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE920 OE950 SA02.1 SA253 SA80.1
SA90.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAW-COMPANY Numeric 4 AR06.3
Company Company number.
SAW-SALESMAN Numeric 4 AR06.3
Sales Rep Number Sales representative number established
online.
SAW-NAME Alpha 30 (Lower Case) AR06.3
Name The name/description of the Sales
Representative.
SAW-TERRITORY Alpha 4 AR06.3
Sales Territory Sales Territory for the particular
sales representative.
SAW-COMM-RATE Percent 7.5 (Percent) AR06.3
Commission Rate Commission Rate for sales
representative.
SAW-USED-FL Alpha 1 AR06.3 AR08.1
Used Indicates whether or not the sales AR10.1 AR42.2
representative has been used. Valid AR501 AR550
values are: BL02.1 BL120
BL122 BL130
N = No BL20.1 BL20.3
Y = Yes BL21.2 BL21.5
BL29.1 BL29.2
BL30.1 BL30.2
BL30.3 BL30.5
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.1
BL32.2 BL32.3
BL32.4 BL520
BL80.1 BL802
BL820 BL902
BL92.1 BL940
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 OE112
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
...
SAW-ACTIVE-STATUS Alpha 1 AR06.3
Status Determines the active status of the
sales representative. Valid values are:
A = Active
I = Inactive
SALESREP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SAWSET1 COMPANY This is the primary path used to access AR01.1 AR06.3
SALESMAN records. AR08.1 AR10.1
AR206 AR210
AR234 AR235
AR251 AR253
AR260 AR271
AR275 AR282
AR292 AR42.2
AR42.6 AR501
AR502 AR550
AR560 AR973
BL02.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
SALESREP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
SAW-COMPANY -> ACO-COMPANY
Territory TERITORY Required
SAW-COMPANY -> TRY-COMPANY
SAW-TERRITORY -> TRY-TERRITORY
|