AR_CustomerListingBalWrk AR Customer Listing Balance Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CustomerListingBal_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerListingBalWrk"+%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 CustomerName. . . . . . . . . 30 SNN Customer 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 ZipCode . . . . . . . . . . . . 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 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 17 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . . 18 URLAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . . 19 BatchFax. . . . . . . . . . . 1 SNN Batch Fax . . . . . . . . . . . 20 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . . 21 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 22 ShipMethod. . . . . . . . . . 15 SNN Ship Method . . . . . . . . . . 23 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 24 TaxScheduleDesc . . . . . . . 30 SNN Tax Schedule Description. . . . 25 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . . 26 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 27 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 28 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 29 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 30 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 31 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 32 CustomerSortField . . . . . . 10 SNN Customer Sort Field . . . . . . 33 TemporaryCustomer . . . . . . 1 SNN Temporary Customer. . . . . . . 34 OpenItemCustomer. . . . . . . 1 SNN Open Item Customer. . . . . . . 35 ResidentialAddress. . . . . . 1 SNN Residential Address . . . . . . 36 StatementCycle. . . . . . . . 1 SNN Statement Cycle . . . . . . . . 37 PrintDunningMessage . . . . . 1 SNN Print Dunning Message . . . . . 38 CustomerType. . . . . . . . . 4 SNN CustomerType. . . . . . . . . . 39 EmailStatements . . . . . . . 1 SNN Obsolete 4.30 . . . . . . . . . 40 PriceLevel. . . . . . . . . . 1 SNN Price Level . . . . . . . . . . 41 DefaultItemCode . . . . . . . 30 SNN Default Item Code . . . . . . . 42 DefaultItemCodeDesc . . . . . 30 SNN Default Item Code Description . 43 CreditHold. . . . . . . . . . 1 SNN Credit Hold . . . . . . . . . . 44 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 45 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 46 DefaultPaymentType. . . . . . 11 SNN Default Payment Type. . . . . . 47 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 48 CRMName . . . . . . . . . . . 120 SNN CRM Name. . . . . . . . . . . . 49 DateLastActivity. . . . . . . 8 SNN Date Last Activity. . . . . . .DATE 50 DateLastPayment . . . . . . . 8 SNN Date Last Payment . . . . . . .DATE 51 DateLastStatement . . . . . . 8 SNN Date Last Statement . . . . . .DATE 52 DateLastFinanceChrg . . . . . 8 SNN Date Last Finance Charge. . . .DATE 53 DateLastAging . . . . . . . . 8 SNN Date Last Aging . . . . . . . .DATE 54 DateEstablished . . . . . . . 8 SNN Date Established. . . . . . . .DATE 55 CurrentPeriod . . . . . . . . 2 SNN Current Period. . . . . . . . . 56 CurrentFiscalYear . . . . . . 4 SNN Current Fiscal Year . . . . . . 57 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . . 58 AvgDaysPaymentInvoice . . . . 3.0 NNN Average Days Payment Invoice. . 59 AvgDaysOverDue. . . . . . . . 3.0 NNN Average Days Over Due . . . . . 60 CustomerDiscountRate. . . . . 13.3 NNN Customer Discount Rate. . . . . 61 ServiceChargeRate . . . . . . 13.3 NNN Service Charge Rate / Finance C 62 LastPaymentAmt. . . . . . . . 14.2 NNN Last Payment Amount . . . . . . 63 HighestStmntBalance . . . . . 14.2 NNN Highest Statement Balance . . . 64 UnpaidServiceChrg . . . . . . 14.2 NNN Unpaid Service Charge . . . . . 65 CurrentBalance. . . . . . . . 14.2 NNN Current Balance . . . . . . . . 66 AgingCategory1. . . . . . . . 14.2 NNN Aging Category 1. . . . . . . . 67 AgingCategory2. . . . . . . . 14.2 NNN Aging Category 2. . . . . . . . 68 AgingCategory3. . . . . . . . 14.2 NNN Aging Category 3. . . . . . . . 69 AgingCategory4. . . . . . . . 14.2 NNN Aging Category 4. . . . . . . . 70 OpenOrderAmt. . . . . . . . . 14.2 NNN Open Order Amount . . . . . . . 71 ARBalance . . . . . . . . . . 14.2 NNN AR Balance. . . . . . . . . . . 72 DollarsSoldPTD. . . . . . . . 15.2 NNN Dollars Sold Period to Date . . 73 DollarsSoldYTD. . . . . . . . 16.2 NNN Dollars Sold Year to Date . . . 74 DollarsSoldPY . . . . . . . . 16.2 NNN Dollars Sold Prior Year . . . . 75 CostOfGoodsSoldPTD. . . . . . 15.2 NNN Cost of Goods Sold Period to Da 76 CostOfGoodsSoldYTD. . . . . . 16.2 NNN Cost of Goods Sold Year to Date 77 CostOfGoodsSoldPY . . . . . . 16.2 NNN Cost of Goods Sold Prior Year . 78 ProfitPercentPTD. . . . . . . 8.3 NNN Profit Percent Period to Date . 79 ProfitPercentYTD. . . . . . . 8.3 NNN Profit Percent Year to Date . . 80 ProfitPercentPY . . . . . . . 8.3 NNN Profit Percent Prior Year . . . 81 CashReceivedPTD . . . . . . . 15.2 NNN Cash Received Period to Date. . 82 CashReceivedYTD . . . . . . . 16.2 NNN Cash Received Year to Date. . . 83 CashReceivedPY. . . . . . . . 16.2 NNN Cash Received Prior Year. . . . 84 FinanceChargesPTD . . . . . . 15.2 NNN Finance Charges Period to Date. 85 FinanceChargesYTD . . . . . . 16.2 NNN Finance Charges Year to Date. . 86 FinanceChargesPY. . . . . . . 16.2 NNN Finance Charges Prior Year. . . 87 NumberOfInvoicesPTD . . . . . 7.0 NNN Number of Invoices Period to Da 88 NumberOfInvoicesYTD . . . . . 8.0 NNN Number of Invoices Year to Date 89 NumberOfInvoicesPY. . . . . . 8.0 NNN Number of Invoices Prior Year . 90 NumberOfFinanceChrgsPTD . . . 7.0 NNN Number of Finance Charges Perio 91 NumberOfFinanceChrgsYTD . . . 8.0 NNN Number of Finance Charges Year 92 NumberOfFinanceChrgsPY. . . . 8.0 NNN Number of Finance Charges Prior