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. .