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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#SAW-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR06.3
#SAW-SALESMAN PK
SALESMAN		Numeric 4The sales representative number.AR06.3
#SAW-NAME
NAME		Alpha 30 (Lower Case)The name of the sales representative.AR06.3
#SAW-TERRITORY
TERRITORY		Alpha 4Sales 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 1Indicates 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 1Determines the active status of the sales representative. Valid values are:
  • A Active
  • I Inactive
AR06.3

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SAWSET1
  1. COMPANY
  2. SALESMAN
PrimaryAR01.1, AR06.3, AR08.1, AR09.1, AR10.1, AR206, AR210, AR301 +6 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPTERITORYSALESREP

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
SAW-COMPANY→ACO-COMPANY
TerritoryTERITORYRequired
SAW-COMPANY→TRY-COMPANY
SAW-TERRITORY→TRY-TERRITORY

Programs

Updated by (8)

Referenced by (6)