AR_Customer AR Customer Master Rel: 6.00 Bld: 957 11/20/2018 Physical Path: "MAS_"+%C$+"/AR"+%C$+"/AR_Customer.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: AR_Customer_bus AR_SalesJournal_upd SO_SalesJournal_upd IT_ShoppingCart_upd IT_UIDCustomerChange_upd AP_ARClearingRegister_upd JC_JobBillingRegister_upd
KPRIMARY: ARDivisionNo+CustomerNo KNAME: CustomerName+ARDivisionNo+CustomerNo KSORT: SortField+ARDivisionNo+CustomerNo KSALESPERSON: ARDivisionNo+SalespersonNo+CustomerNo KTYPE: CustomerType+ARDivisionNo+CustomerNo KZIPCODE: ZipCode+ARDivisionNo+CustomerNo KTELEPHONE: TelephoneNo+ARDivisionNo+CustomerNo KCUSTOMERNO: CustomerNo KADDRESS1: AddressLine1+ARDivisionNo+CustomerNo KADDRESS2: AddressLine2+ARDivisionNo+CustomerNo KADDRESS3: AddressLine3+ARDivisionNo+CustomerNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR1$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC Next:Custo merNo$ ChngTag:Replace1/ARDiv isionNo$ Notes: {AR1$(3,7)} 3 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME ValGroup:CRM Notes: {AR1$(10, 30)} 4 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . .ADDRESSLINE ValGroup:CRM Notes: {AR1$(40, 30)} 5 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . .ADDRESSLINE ValGroup:CRM Notes: {AR1$(70, 30)} 6 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . .ADDRESSLINE ValGroup:CRM Notes: {AR1$(341,30)} 7 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .CITY ValGroup:CRM Notes: {AR1$(100,20)} 8 State . . . . . . . . . . . . 2 SYN State . . . . . . . . . . . . .STATE ValGroup:CRM Notes: {AR1$(120,2)} 9 ZipCode . . . . . . . . . . . 10 SYN Zip Code. . . . . . . . . . . .ZIPCODE ValGroup:CRM Notes: {AR1$(122,10)} 10 CountryCode . . . . . . . . . 3 SYN Country Code. . . . . . . . . .COUNTRY FmtType:CHARNUM ValGroup:CRM Notes: {AR1$(172,3)} 11 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .TELEPHONENO ValGroup:CRM Notes: {AR1$(132,17)} 12 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . .TELEPHONEEXT ValGroup:CRM Notes: {AR1$(149,5)} 13 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO DepVal:REQUIRED ValGroup:CRM Notes: {AR1$(371,17)} 14 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS DepVal:REQUIRED ValGroup:CRM Notes: {AR1$(388,50)} 15 URLAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . .URLADDRESS ValGroup:CRM Notes: {AR1$(438,50)} 16 EBMEnabled. . . . . . . . . . 1 SYN eBusiness Manager Enabled . . .YESNO DfltVal:N Valid:Y,N ChngTag:Copy Notes: {AR1$(154,1)} 17 EBMConsumerUserID . . . . . . 15 SNN eBusiness Manager Consumer User DepVal:REQUIRED ChngTag:Copy Notes: {AR1$(175,15)} 18 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR1$(155,1)} 19 DefaultCreditCardPmtType. . . 5 SYN Default Credit Card Payment TypPAYMENTTYPE Read Only:Y Notes: e.g., VISA or MC. A match here will cause dflt Cred Crd info from AR1 to fill in S/O Credit Card fields. {AR1$(156,5)} 20 ContactCode . . . . . . . . . 10 SYN Contact Code. . . . . . . . . .ARCONTACT ValGroup:CRM Notes: {AR1$(162,10)} 21 ShipMethod. . . . . . . . . . 15 SYN Ship Method . . . . . . . . . .SHIPCODE Notes: {AR1$(192,15)} 22 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:ARSalesTax,CRM Notes: {AR1$(207,9)} 23 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . . Notes: (Only If Sales Tax Reporting = Yes) {AR1$(216, 15)} 24 TermsCode . . . . . . . . . . 2 SNY Terms Code. . . . . . . . . . .ARTERMS DfltVal:00 Mask:00 FmtType:ZE ROFILL ValGroup:CRM Notes: {AR1$(231,2)} 25 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:CRM ChngTag:Replace2 /ARDivisionNo$/CustomerNo$ 26 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM ValGroup:Sale spersonReporting,CRM Notes: {AR1$(233,4)} 27 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:SplitCommission, SalespersonRequired 28 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:SplitCommission, SalespersonRequired 29 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:SplitCommission, SalespersonRequired 30 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:SplitCommission, SalespersonRequired 31 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:SplitCommission, SalespersonRequired 32 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:SplitCommission, SalespersonRequired 33 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:SplitCommission, SalespersonRequired 34 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:SplitCommission, SalespersonRequired 35 Comment . . . . . . . . . . . 30 SNN Customer Comment. . . . . . . .COMMENT30 Notes: {AR1$(237,30)} 36 SortField . . . . . . . . . . 10 SYN Sort Field. . . . . . . . . . . Notes: {AR1$(267,10)} 37 TemporaryCustomer . . . . . . 1 SNN Obsolete 5.00 . . . . . . . . . Notes: {AR1$(277,1)} 38 CustomerStatus. . . . . . . . 1 SYY Customer Status . . . . . . . . DfltVal:A Valid:A,I,T Notes: A=Active, I=Inactive, T=Temporary 39 InactiveReasonCode. . . . . . 5 SYN Inactive Reason Code. . . . . . FmtType:CHARNUM 40 OpenItemCustomer. . . . . . . 1 SYY Open Item Customer. . . . . . .YESNO DfltVal:Y Valid:Y,N Notes: {AR1$(278,1)} 41 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO DfltVal:N Valid:Y,N 42 StatementCycle. . . . . . . . 1 SYN Statement Cycle . . . . . . . . DfltVal:M ValGroup:PrintARSta tements Notes: {AR1$(279,1)} 43 PrintDunningMessage . . . . . 1 SYN Print Dunning Message On StatemYESNO DfltVal:Y Valid:Y,N ValGroup:PrintARStatements Notes: {AR1$(280,1)} 44 UseSageCloudForInvPrinting. . 1 SYN Use Sage Cloud For Invoice PrinYESNO DfltVal:N Valid:Y,N 45 CustomerType. . . . . . . . . 4 SYN Customer Type . . . . . . . . . ValGroup:CRM Notes: {AR1$(281,4)} 46 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . ValGroup:CRM Notes: {AR1$(285,1)} 47 DateLastActivity. . . . . . . 8 SNN Date Of Last Activity . . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(286,6)} 48 DateLastPayment . . . . . . . 8 SNN Date Of Last Payment. . . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(292,6)} 49 DateLastStatement . . . . . . 8 SNN Date Of Last Statement. . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(298,6)} 50 DateLastFinanceChrg . . . . . 8 SNN Date Of Last Finance Charge . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(304,6)} 51 DateLastAging . . . . . . . . 8 SNN Date Of Last Aging. . . . . . .DATE Read Only:Y ChngTag:Max Notes: {AR1$(310,6)} 52 DefaultItemCode . . . . . . . 30 SYN Default Item Code . . . . . . .ITEMCODE FmtType:CHARNUM Notes: {AR1$(324,6)} 53 DefaultCostCode . . . . . . . 9 SNN Default Cost Code . . . . . . .COSTCODE 54 DefaultCostType . . . . . . . 1 SNN Default Cost Type . . . . . . . 55 CreditHold. . . . . . . . . . 1 SYN Customer On Credit Hold . . . .YESNO DfltVal:N Valid:Y,N ChngTag:Max Notes: {AR1$(330, 1)} 56 PrimaryShipToCode . . . . . . 4 SYN Primary Ship To Code. . . . . .SHIPTO ValGroup:CRM Notes: {AR1$(331,4)} 57 DateEstablished . . . . . . . 8 SNN Date Established. . . . . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Min Notes: {AR1$(335,6)} 58 CreditCardGUID. . . . . . . . 32 SNN Sage Exchange Vault Payment IdeCREDITCARDGUID DepVal:REQUIRED 59 DefaultPaymentType. . . . . . 5 SYN Default Payment Type. . . . . .PAYMENTTYPE DfltVal:CHECK DepVal:REQUIRED ValGroup:CRM Notes: e.g., CASH or AMEX {AR1$(546,5)} 60 EmailStatements . . . . . . . 1 SYN Obsolete 4.30 . . . . . . . . .YESNO DfltVal:N Valid:Y,N 61 NumberOfInvToUseInCalc. . . . 2.0 NNN Number Of Invoices To Use In Da Mask:00 Notes: (0-20) {AR1$(322,2)} 62 AvgDaysPaymentInvoice . . . . 3.0 NNN Avg Days For Payment From Invoi Mask:000 ValGroup:AREditCusto merStatistics ChngTag:Max Notes: {AR1$(316,3)} 63 AvgDaysOverDue. . . . . . . . 3.0 NNN Avg Days Overdue (Pay Date - Du Mask:000 ValGroup:AREditCusto merStatistics ChngTag:Max Notes: {AR1$(319,3)} 64 CustomerDiscountRate. . . . . 13.3 NNN Customer Discount Rate. . . . . Mask:##,###,###.000- Notes: {AR1[0]} 65 ServiceChargeRate . . . . . . 13.3 NNN Service Charge Rate . . . . . . Mask:##,###,###.000- Notes: {AR1[1]} 66 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Max Notes: {AR1[2]} 67 LastPaymentAmt. . . . . . . . 14.2 NNN Last Payment Amount . . . . . .BALANCEAMT Mask:#,###,###,###.00- ValGroup:AREditCustomerStatis tics ChngTag:CopyMax/DateLast Payment$ Notes: {AR1[3]} 68 HighestStmntBalance . . . . . 14.2 NNN Highest Statement Balance . . .BALANCEAMT Mask:#,###,###,###.00- ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1[4]} 69 UnpaidServiceChrg . . . . . . 14.2 NNN Unpaid Service Charge . . . . .BALANCEAMT Mask:#,###,###,###.00- ValGroup:AREditCustomerStatis tics ChngTag:Sum Notes: {AR1[5]} 70 BalanceForward. . . . . . . . 14.2 NNN Balance Forward . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[24]} 71 CurrentBalance. . . . . . . . 14.2 NNN Current Balance . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[25]} 72 AgingCategory1. . . . . . . . 14.2 NNN Aging Category 1. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[26]} 73 AgingCategory2. . . . . . . . 14.2 NNN Aging Category 2. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[27]} 74 AgingCategory3. . . . . . . . 14.2 NNN Aging Category 3. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[28]} 75 AgingCategory4. . . . . . . . 14.2 NNN Aging Category 4. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[29]} 76 OpenOrderAmt. . . . . . . . . 14.2 NNN Open Order Amount . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[30]} 77 RetentionCurrent. . . . . . . 14.2 NNN Retention Current . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 78 RetentionAging1 . . . . . . . 14.2 NNN Retention Aging 1 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 79 RetentionAging2 . . . . . . . 14.2 NNN Retention Aging 2 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 80 RetentionAging3 . . . . . . . 14.2 NNN Retention Aging 3 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 81 RetentionAging4 . . . . . . . 14.2 NNN Retention Aging 4 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 82 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired 83 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired 84 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired 85 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired 86 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y ChngTag:Min Notes: YYYYMMDD 87 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .TIME Read Only:Y ChngTag:CopyMin/D ateCreated$ 88 UserCreatedKey. . . . . . . . 10 SNY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Min/DateCreated$ 89 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max 90 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .TIME Read Only:Y ChngTag:CopyMax/D ateUpdated$ 91 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Max/DateUpdated$