SALESREP

AR SalesReps

The AR Sales Representative file carries sales representative codes. Sale representative codes are added to a customer record, contained on transaction records, and are used for selection and reporting purposes.

REFERENCED BY
AR09.1 AR206 AR210 AR301 TX140


UPDATED BY
AR06.3 AR08.1 AR10.1 AR501 AR550 AR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAW-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AR06.3
SAW-SALESMAN
Element: SalesRep Number
Numeric 4
The sales representative number.
AR06.3
SAW-NAME
Element: Name
Alpha 30 (Lower Case)
The name of the sales representative.
AR06.3
SAW-TERRITORY
Element: Territory
Alpha 4
Sales Territory for the particular sales representative. Used by the Lawson Order Processing system.
AR06.3
SAW-COMM-RATE
Element: Comm Rate
Percent 7.5 (Percent)
Commission Rate for the sales representative. Used by the Lawson Order Processing system.
AR06.3
SAW-USED-FL
Element: Used Fl
Alpha 1
Indicates whether or not the sales representative has been used. Valid values are: N = No Y = Yes
AR06.3 AR08.1
AR10.1 AR501
AR550
SAW-ACTIVE-STATUS
Element: Active Status
Alpha 1
Determines the active status of the sales representative. Valid values are: A = Active I = Inactive
AR06.3


SALESREP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SAWSET1 COMPANY
SALESMAN
AR01.1 AR06.3
AR08.1 AR09.1
AR10.1 AR206
AR210 AR301
AR501 AR550
TX140


SALESREP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
SAW-COMPANY->ACO-COMPANY
Territory TERITORY Required
SAW-COMPANY->TRY-COMPANY
SAW-TERRITORY->TRY-TERRITORY


File created: Wed Jun 08 20:47:57 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.