SALESREP

Accounts Receivables Sales Rep

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 ARLL.1 TX140


UPDATED BY
AR06.3 AR08.1 AR10.1 AR501 AR550 WH20.2
WH20.7 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 WH20.2
WH20.7
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
ARLL.1 TX140
WH20.2 WH20.7


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: Thu Jun 09 02:09:15 2016

Home
Contact Us



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