AR_CustomerMailingLabelsWrk AR Customer Mailing Labels Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CustomerMailingLabels_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerMailingLabelsWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 4 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 5 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 6 LabelNumber . . . . . . . . . 3 SNN Label Number. . . . . . . . . . 7 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 8 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . . 9 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . . 10 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . . 11 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . . 12 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . . 13 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . . 14 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . . 15 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . . 16 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 17 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . . 18 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 19 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 20 CustomerSortField . . . . . . 10 SNN Customer Sort Field . . . . . . 21 Comment . . . . . . . . . . . 30 SNN Customer Comment. . . . . . . . 22 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 23 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . . 24 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 25 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 26 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 27 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 28 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 29 CustomerType. . . . . . . . . 4 SNN Customer Type . . . . . . . . . 30 PriceLevel. . . . . . . . . . 1 SNN Price Level . . . . . . . . . . 31 DollarsSoldMTD. . . . . . . . 16.2 NNN Dollars Sold Month To Date. . . 32 DollarsSoldYTD. . . . . . . . 16.2 NNN Dollars Sold Year To Date . . . 33 DollarsSoldPY . . . . . . . . 16.2 NNN Dollars Sold Prior Year . . . . 34 BalanceForward. . . . . . . . 14.2 NNN Balance Forward . . . . . . . . 35 CurrentBalance. . . . . . . . 14.2 NNN Current Balance . . . . . . . . 36 AgingCategory1. . . . . . . . 14.2 NNN Aging Category 1. . . . . . . . 37 AgingCategory2. . . . . . . . 14.2 NNN Aging Category 2. . . . . . . . 38 AgingCategory3. . . . . . . . 14.2 NNN Aging Category 3. . . . . . . . 39 AgingCategory4. . . . . . . . 14.2 NNN Aging Category 4. . . . . . . . 40 OpenOrderAmt. . . . . . . . . 14.2 NNN Open Order Amount . . . . . . . 41 CustomerDiscountRate. . . . . 13.3 NNN Customer Discount Rate. . . . . 42 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . .