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