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