AR_SalespersonLink AR Salesperson Link Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_SalespersonLink_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_SalespersonLink.M4T"
KPRIMARY: SalespersonDivisionNo+SalespersonNo
Fld Column Name M/L TUR Description/Notes Class
1 SalespersonDivisionNo . . . . 2 SNY Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AR_06$(1,2)}
2 SalespersonNo . . . . . . . . 4 SYY Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{AR_06$(3,4)}
3 LinkToCode. . . . . . . . . . 1 SYN Link To Code. . . . . . . . . .
Valid:V,G,E,N Notes:
V=Vendor, G=GL, E=Employee,
N=None {AR_06$(7,1)}
4 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 DepVal:REQUIRED
Notes: {AR_06$(8,2)}
5 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM DepVal:REQU
IRED ChngTag:Replace1/APDivis
ionNo$ Notes: {AR_06$(10,7)}
6 PRDepartmentNo. . . . . . . . 2 SNN PR Department Number. . . . . .DEPARTMENT
Mask:00 DepVal:REQUIRED
Notes: {AR_06$(8,2)}
7 EmployeeNo. . . . . . . . . . 7 SYN Employee Number . . . . . . . .EMPLOYEENO
FmtType:MASTERNUM DepVal:REQU
IRED Notes: {AR_06$(10,2)}
8 AccrualAcctKey. . . . . . . . 9 SYN Accrual Account Key . . . . . .ACCOUNT
DepVal:REQUIRED Notes: It
LinkToCode= G {AR_06$(8,9)}
9 VendorDefaultAcctKey. . . . . 9 SYN Vendor Default Account Key. . .ACCOUNT
DepVal:REQUIRED Notes: If
LinkToCode = G - Comm
Expense Acct. If LinkToCode
= V - Default G/L Acct.
{AR_06$(20,9)}
10 ExpenseAcctKey. . . . . . . . 9 SYN Expense Account Key . . . . . .ACCOUNT
DepVal:REQUIRED
11 EarningsCode. . . . . . . . . 2 SYN Earnings Code . . . . . . . . .
FmtType:CHARNUM Notes: Only
if LinkToCode = E {AR_06$(17,
2)}
12 UpdateAPInvBySlsprsonCust . . 1 SYN Update A/P Invoice By Slspsn/Cu
Notes: Only If LinkToCode =
V {AR_06$(19,1)}
13 TermsCode . . . . . . . . . . 2 SYN Terms Code. . . . . . . . . . .APTERMS
FmtType:ZEROFILL Notes: Only
if LinkToCode = V {AR_06$(29,
2)}
14 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
15 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
16 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
17 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
18 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
19 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL