SALESREP FILE
AR SalesReps
The AR SalesReps file carries sales representative codes. Sale representative
codes are added to a customer record, contained on transaction records and are
used for reporting purposes.
REFERENCED BY
AR11.1 AR206 AR210 AR234 AR235 AR251
AR253 AR260 AR271 AR275 AR282 AR292
AR502 AR560
UPDATED BY
AR06.3 AR08.1 AR10.1 AR42.2 AR501 AR550
WH20.2 WH20.7 AR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAW-COMPANY Numeric 4 AR06.3
Company Company number.
SAW-SALESMAN Numeric 4 AR06.3
SalesRep 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: WH20.2 WH20.7
N = No
Y = Yes
SAW-ACTIVE-STATUS Alpha 1 AR06.3
Status Determines the active status of the
sales representative. Valid values are:
A = Active
I = Inactive
SAW-EMP-COMPANY Numeric 4
Emp Company
SAW-EMPLOYEE Numeric 9
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
SAW-LAST-NAME Alpha 30 (Lower Case)
Last Name Contains the last name of the manager
in charge.
SAW-FIRST-NAME Alpha 15 (Lower Case)
First Name Contains the first name of the manager
in charge.
SAW-MIDDLE-INIT Alpha 1
Middle Initial Contains the middle initial of the
manager in charge.
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
AR11.1 AR206
AR210 AR234
AR235 AR251
AR253 AR260
AR271 AR275
AR282 AR292
AR42.2 AR42.6
AR501 AR502
AR550 AR560
WH20.2 WH20.7
SAWSET2 EMP-COMPANY KeyChange
EMPLOYEE
COMPANY
SALESMAN
SALESREP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
SAW-COMPANY -> ACO-COMPANY (ACOSET1)
Territory TERITORY Required
SAW-COMPANY -> TRY-COMPANY
SAW-TERRITORY -> TRY-TERRITORY
|
