Lawson Insight Technical Documentation |
|
SALESREP
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
AR09.1 AR206 AR210 AR234 AR235 AR251
AR253 AR260 AR271 AR275 AR282 AR292
AR301 AR502 AR560 ARLL.1 SA258
UPDATED BY
AR06.3 AR08.1 AR10.1 AR42.2 AR501 AR550
BL02.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL30.1 BL30.2
BL30.3 BL30.5 BL31.1 BL31.2 BL31.3 BL31.5
BL31.7 BL32.1 BL32.2 BL32.3 BL32.4 BL520
BL80.1 BL802 BL820 BL92.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE112 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.5 OE14.4 OE16.1 OE229 OE288
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE810 OE830
SA02.1 SA253 SA80.1 SA90.1 WH20.2 WH20.7
AR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAW-COMPANY Numeric 4 AR06.3
Element: Company Company number.
SAW-SALESMAN Numeric 4 AR06.3
Element: SalesRep NumbeSales representative number established
online.
SAW-NAME Alpha 30 (Lower Case) AR06.3
Element: Name The name/description of the Sales
Representative.
SAW-TERRITORY Alpha 4 AR06.3
Element: Sales TerritorSales Territory for the particular
sales representative.
SAW-COMM-RATE Percent 7.5 (Percent) AR06.3
Element: Commission RatCommission Rate for sales
representative.
SAW-USED-FL Alpha 1 AR06.3 AR08.1
Element: Used Indicates whether or not the sales AR10.1 AR42.2
representative has been used. Valid AR501 AR550
values are: BL02.1 BL120
BL122 BL130
N = No BL20.1 BL20.3
Y = Yes BL21.2 BL21.5
BL29.1 BL29.2
BL30.1 BL30.2
BL30.3 BL30.5
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.1
BL32.2 BL32.3
BL32.4 BL520
BL80.1 BL802
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE112 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE16.1
OE229 OE288
...
SAW-ACTIVE-STATUS Alpha 1 AR06.3
Element: Status Determines the active status of the
sales representative. Valid values are:
A = Active
I = Inactive
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 AR09.1
AR10.1 AR206
AR210 AR234
AR235 AR251
AR253 AR260
AR271 AR275
AR282 AR292
AR301 AR42.2
AR42.6 AR501
AR502 AR550
AR560 ARLL.1
BL02.1 BL120
BL122 BL130
BL20.1 BL20.3
...
SALESREP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
SAW-COMPANY -> ACO-COMPANY
Territory TERITORY Required
SAW-COMPANY -> TRY-COMPANY
SAW-TERRITORY -> TRY-TERRITORY
|