AR_CustomerListingWrk AR Customer Listing Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CustomerListing_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerListingWrk"+%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 ReportSection . . . . . . . . 1 SNN Report Section. . . . . . . . . 6 SequenceNo. . . . . . . . . . 14 SNN Sequence 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 ZipCode . . . . . . . . . . . . 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 TelephoneNo2. . . . . . . . . 17 SNN Telephone Number 2. . . . . . . 19 TelephoneExt2 . . . . . . . . 5 SNN Telephone Extension 2 . . . . . 20 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 21 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . . 22 URLAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . . 23 BatchFax. . . . . . . . . . . 1 SNN Batch Fax . . . . . . . . . . . 24 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . . 25 ShipMethod. . . . . . . . . . 15 SNN Ship Method . . . . . . . . . . 26 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 27 TaxScheduleDesc . . . . . . . 30 SNN Tax Schedule Description. . . . 28 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 29 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 30 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 31 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 32 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 33 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 34 CustomerSortField . . . . . . 10 SNN Customer Sort Field . . . . . . 35 TemporaryCustomer . . . . . . 1 SNN Temporary Customer. . . . . . . 36 OpenItemCustomer. . . . . . . 1 SNN Open Item Customer. . . . . . . 37 ResidentialAddress. . . . . . 1 SNN Residential Address . . . . . . 38 StatementCycle. . . . . . . . 1 SNN Statement Cycle . . . . . . . . 39 PrintDunningMessage . . . . . 1 SNN Print Dunning Message . . . . . 40 CustomerType. . . . . . . . . 4 SNN CustomerType. . . . . . . . . . 41 PriceLevel. . . . . . . . . . 1 SNN Price Level . . . . . . . . . . 42 DefaultItemCode . . . . . . . 30 SNN Default Item Code . . . . . . . 43 DefaultItemCodeDesc . . . . . 30 SNN Default Item Code Description . 44 CreditHold. . . . . . . . . . 1 SNN Credit Hold . . . . . . . . . . 45 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 46 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 47 CRMAddressID. . . . . . . . . 11 SNN CRM Address ID. . . . . . . . . 48 CRMAddress1 . . . . . . . . . 80 SNN CRM Address 1 . . . . . . . . . 49 DefaultPaymentType. . . . . . 11 SNN Default Payment Type. . . . . . 50 PaymentDesc . . . . . . . . . 30 SNN Payment Description . . . . . . 51 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 52 CRMName . . . . . . . . . . . 120 SNN CRM Name. . . . . . . . . . . . 53 TaxCode . . . . . . . . . . . 15 SNN Tax Code. . . . . . . . . . . . 54 TaxExemptionNo. . . . . . . . 20 SNN Tax Exempt Number . . . . . . . 55 MemoCode. . . . . . . . . . . 10 SNN Memo Code . . . . . . . . . . . 56 MemoDate. . . . . . . . . . . 8 SNN Memo Date . . . . . . . . . . .DATE 57 MemoDesc. . . . . . . . . . . 30 SNN Memo Description. . . . . . . . 58 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 59 ReminderStartDate . . . . . . 8 SNN Reminder Start Date . . . . . .DATE 60 ReminderEndDate . . . . . . . 8 SNN Reminder End Date . . . . . . .DATE 61 AutoDisplaySetting. . . . . . 1 SNN Auto Display Setting. . . . . . 62 MemoText. . . . . . . . . . . 7168 SNN Memo Text . . . . . . . . . . . 63 Attachment. . . . . . . . . . 128 SNN Attachment. . . . . . . . . . . 64 PrimaryLocation . . . . . . . 1 SNN Primary Location. . . . . . . . 65 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 66 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 67 PrimaryContact. . . . . . . . 1 SNN Primary Contact . . . . . . . . 68 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 69 Salutation. . . . . . . . . . 10 SNN Salutation. . . . . . . . . . . 70 ContactTitle. . . . . . . . . 15 SNN Contact Title . . . . . . . . . 71 ContactNotes. . . . . . . . . 256 SNN Contact Notes . . . . . . . . . 72 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 73 CRMFirstName. . . . . . . . . 60 SNN CRM First Name. . . . . . . . . 74 CRMLastName . . . . . . . . . 80 SNN CRM Last Name . . . . . . . . . 75 EBMEnabled. . . . . . . . . . 1 SNN e-Business Manager Enabled. . . 76 RequireAcceptOfCustChange . . 1 SNN Require Acceptance of Customer 77 RequireAcceptOfUIDChange. . . 1 SNN Require Acceptance of UID Chang 78 RequireAcceptOfSOSubmits. . . 1 SNN Require Acceptance of SO Submit 79 PrimaryCardNo . . . . . . . . 1 SNN Primary Card Number . . . . . . 80 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card 81 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . . 82 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . . 83 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas 84 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . . 85 EBMUserID . . . . . . . . . . 15 SNN E-Business Manager User ID. . . 86 UserName. . . . . . . . . . . 30 SNN User Name . . . . . . . . . . . 87 EmailStatements . . . . . . . 1 SNN Obsolete 4.30 . . . . . . . . . 88 FullCreditCardNo. . . . . . . 24 SNN Full Credit Card Number . . . . 89 Document. . . . . . . . . . . 30 SNN Document Name . . . . . . . . . 90 PrintDocument . . . . . . . . 1 SNN Print Document. . . . . . . . . 91 EmailDocument . . . . . . . . 1 SNN Email Document. . . . . . . . . 92 FaxDocument . . . . . . . . . 1 SNN Fax Document. . . . . . . . . . 93 UseEmailAddressInDataEntry. . 1 SNN Use Email Address In Data Entry 94 UseFaxNoInDataEntry . . . . . 1 SNN Use Fax Number In Data Entry. . 95 UseCustomerEmailAddress . . . 1 SNN Use Customer Email Address. . . 96 UseCustomerFaxNo. . . . . . . 1 SNN Use Customer Fax Number . . . . 97 RecordType. . . . . . . . . . 1 SNN Record Type . . . . . . . . . . 98 ToContactCode . . . . . . . . 10 SNN To Contact Code . . . . . . . . 99 ContactEmailAddress . . . . . 50 SNN Contact Email Address . . . . . 100 ContactFaxNo. . . . . . . . . 17 SNN Contact Fax Number. . . . . . . 101 ToAdditionalEmailAddress. . . 50 SNN To Additional Email Address . . 102 ToAdditionalFaxNo . . . . . . 17 SNN To Additional Fax Number. . . . 103 ToAdditionalFaxRecipientName. 30 SNN To Additional Fax Recipient Nam 104 CustomerDiscountRate. . . . . 13.3 NNN Customer Discount Rate. . . . . 105 ServiceChargeRate . . . . . . 13.3 NNN Service Charge Rate / Finance C 106 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . .