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