SALESREP – Accounts Receivables Sales Rep

System: Accounts Receivable (AR)
Prefix: SAW
Primary key: COMPANY, SALESMAN
Fields: 7
Updated by: 8 programs
Referenced by: 6 programs

SALESREP is the Accounts Receivables Sales Rep table in Lawson Accounts Receivable (prefix SAW). It is indexed by COMPANY, SALESMAN (SAWSET1). It is related 1:1 to ARCOMP and TERITORY. It is updated by AR01.1, AR06.3, AR08.1, AR10.1, AR501, AR550, WH20.2 and WH20.7 and referenced by AR09.1, AR206, AR210, AR301, ARLL.1 and TX140. The table has 7 fields, 1 index and 2 documented relations.

About SALESREP

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.

Fields (7)

Column = COBOL field name without the SAW- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`SAW-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	AR06.3
`SAW-SALESMAN` PK SALESMAN	Numeric 4	The sales representative number.	AR06.3
`SAW-NAME` NAME	Alpha 30 (Lower Case)	The name of the sales representative.	AR06.3
`SAW-TERRITORY` TERRITORY	Alpha 4	Sales Territory for the particular sales representative. Used by the Lawson Order Processing system.	AR06.3
`SAW-COMM-RATE` COMM_RATE	Percent 7.5 (Percent)	Commission Rate for the sales representative. Used by the Lawson Order Processing system.	AR06.3
`SAW-USED-FL` 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` ACTIVE_STATUS	Alpha 1	Determines the active status of the sales representative. Valid values are: `A` Active `I` Inactive	AR06.3

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`SAWSET1`	`COMPANY`, `SALESMAN`	Primary		AR01.1, AR06.3, AR08.1, AR09.1, AR10.1, AR206, AR210, AR301 +6 more

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcomp	ARCOMP	Required		`SAW-COMPANY` → `ACO-COMPANY`
Territory	TERITORY	Required		`SAW-COMPANY` → `TRY-COMPANY`, `SAW-TERRITORY` → `TRY-TERRITORY`

Programs

Updated by (8)

AR01.1 Company
AR06.3 Sales Representative
AR08.1 Customer Defaults
AR10.1 Customer
AR501 Customer Conversion
AR550 Customer Interface
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location

Referenced by (6)

AR09.1 Customer Group Address
AR206 Operational Setup 1 Listing
AR210 Customer Listing
AR301 Customer Purge
ARLL.1 AR Transaction Interface
TX140 Vertex Geocode Update