ARD    A/R Salesperson Master File (ARD_SalespersonMasterfile)                  Level: 4.40
        Record Type: 1    A/R Salesperson Master File                            08/28/2009
 
 File Type: Direct   Key Size: 6    Rec Len: 459     Min Len: 266    Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Division Number . . . . . . . . . . . . Division. . . . . . . . . . . Zero-Filled *(1,2)
 Salesperson Number. . . . . . . . . . . SalespersonNumber . . . . . . Uppercase   *(3,4)
 Name. . . . . . . . . . . . . . . . . . Name. . . . . . . . . . . . . String      (7,30)
 Address Line 1. . . . . . . . . . . . . AddressLine1. . . . . . . . . String      (37,30)
 Address Line 2. . . . . . . . . . . . . AddressLine2. . . . . . . . . String      (67,30)
 City. . . . . . . . . . . . . . . . . . City. . . . . . . . . . . . . String      (97,20)
 State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . String      (117,2)
 Zip Code. . . . . . . . . . . . . . . . ZipCode . . . . . . . . . . . String      (119,10)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (129,10)
 Extension . . . . . . . . . . . . . . . Extension . . . . . . . . . . String      (139,5)
 Sales Manager Division. . . . . . . . . SalesManagerDivision. . . . . Zero-Filled (144,2)
 Sales Manager Number. . . . . . . . . . SalesManager. . . . . . . . . Uppercase   (146,4)
 Telephone Number. . . . . . . . . . . . TelephoneNo . . . . . . . . . String      (150,17)
 Address Line 3. . . . . . . . . . . . . AddressLine3. . . . . . . . . String      (167,30)
 Country Code. . . . . . . . . . . . . . CountryCode . . . . . . . . . String      (197,3)
 E-Mail Address. . . . . . . . . . . . . EmailAddress. . . . . . . . . String      (200,50)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (250,17)
 Commission Rate . . . . . . . . . . . . CommRate. . . . . . . . . . . Number      [0]       3.3
 Sales P-T-D . . . . . . . . . . . . . . SalesPTD. . . . . . . . . . . Number      [1]       9.2
 Sales Y-T-D . . . . . . . . . . . . . . SalesYTD. . . . . . . . . . . Number      [2]       9.2
 Sales L-Y . . . . . . . . . . . . . . . SalesPYR. . . . . . . . . . . Number      [3]       9.2
 Gross Profit P-T-D. . . . . . . . . . . ProfitPTD . . . . . . . . . . Number      [4]       9.2
 Gross Profit Y-T-D. . . . . . . . . . . ProfitYTD . . . . . . . . . . Number      [5]       9.2
 Gross Profit L-Y. . . . . . . . . . . . ProfitPYR . . . . . . . . . . Number      [6]       9.2
 Commission P-T-D. . . . . . . . . . . . CommPTD . . . . . . . . . . . Number      [7]       9.2
 Commission Y-T-D. . . . . . . . . . . . CommYTD . . . . . . . . . . . Number      [8]       9.2
 Commission L-Y. . . . . . . . . . . . . CommPYR . . . . . . . . . . . Number      [9]       9.2
 Sales Manager Rate. . . . . . . . . . . SalesManagerRate. . . . . . . Number      [10]      3.3
 Sales - Next Period . . . . . . . . . . SalesNextPeriod . . . . . . . Number      [11]      9.2
 Gross Profit - Next Period. . . . . . . ProfitNextPeriod. . . . . . . Number      [12]      9.2
 Commission - Next Period. . . . . . . . CommNextPeriod. . . . . . . . Number      [13]      9.2
                                                                                   ________
                                                                      Total Bytes  454