AR_SalespersonListingWrk AR Salesperson Listing Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_SalespersonListing_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_SalespersonListingWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 SalespersonDivisionNo . . . . 2 SNN AR Division Number. . . . . . . 3 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 4 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 5 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 6 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . . 7 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . . 8 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . . 9 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . . 10 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . . 11 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . . 12 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . . 13 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . . 14 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 15 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . . 16 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . . 17 SalesManagerDivisionNo. . . . 2 SNN Sales Manager Division Number . 18 SalesManagerNo. . . . . . . . 4 SNN Sales Manager Number. . . . . . 19 SalesManagerName. . . . . . . 30 SNN Sales Manager Name. . . . . . . 20 FiscalPeriod. . . . . . . . . 2 SNN FiscalPeriod. . . . . . . . . . 21 PeriodEndingDate. . . . . . . 8 SNN Period Ending Date. . . . . . .DATE 22 LinkToCode. . . . . . . . . . 1 SNN Link To Code. . . . . . . . . . 23 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 24 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 25 PRDepartmentNo. . . . . . . . 2 SNN PR Department Number. . . . . . 26 EmployeeNo. . . . . . . . . . 7 SNN Employee Number . . . . . . . . 27 AccrualAcctKey. . . . . . . . 9 SNN Accrual Account Key . . . . . . 28 AccrualAccount. . . . . . . . 41 SNN Fully Formatted Accrual Account 29 VendorDefaultAcctKey. . . . . 9 SNN Vendor GL Default Account Key . 30 VendorDefaultAccount. . . . . 41 SNN Fully Formatted Vendor Default 31 ExpenseAcctKey. . . . . . . . 9 SNN Expense Account Key . . . . . . 32 ExpenseAccount. . . . . . . . 41 SNN Fully Formatted Expense Account 33 EarningsCode. . . . . . . . . 2 SNN Earnings Code . . . . . . . . . 34 UpdateAPInvBySlsprsonCust . . 1 SNN Update A/P Invoice By Salespers 35 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 36 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 37 CRMUserLogon. . . . . . . . . 25 SNN CRM User Logon. . . . . . . . . 38 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . . 39 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . . 40 UserKey . . . . . . . . . . . 10 SNN User Key. . . . . . . . . . . . 41 UserCode. . . . . . . . . . . 3 SNN User Code . . . . . . . . . . . 42 UserLogon . . . . . . . . . . 60 SNN User Logon. . . . . . . . . . . 43 UserFirstName . . . . . . . . 20 SNN User First Name . . . . . . . . 44 UserLastName. . . . . . . . . 30 SNN User Last Name. . . . . . . . . 45 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . . 46 SalesManagerCommRate. . . . . 9.3 NNN Sales Manager Commission Rate . 47 CommissionDollarsSold . . . . 15.2 NNN Commission Dollars Sold . . . . 48 CommissionDollarsSoldPY . . . 15.2 NNN Commission Dollars Sold Prior Y 49 GrossProfitAmt. . . . . . . . 15.2 NNN Gross Profit Amount . . . . . . 50 GrossProfitAmtPY. . . . . . . 15.2 NNN Gross Profit Amount Prior Year. 51 CommissionAmt . . . . . . . . 15.2 NNN Commission Amount . . . . . . . 52 CommissionAmtPY . . . . . . . 15.2 NNN Commission Amount Prior Year. .