The Customer Maintenance template has the following fields, the table also includes any restrictions regarding the field inputs:
| Field | Restrictions |
|---|---|
| Customer Number * | Max Characters:15 |
| Hold Status | Hold status: 0=No hold; 1=Hold Default is zero on new record |
| Inactive | Inactive: 0=Active; 1=Inactive Default is zero on new record |
| Customer Name | Max Characters:64 |
| Short Name | Short name; if not passed in, default is CUSTNAME Max Characters:15 |
| Statement Name | Statement name; if not passed in, default is CUSTNAME Max Characters:64 |
| Customer Class Id | Max Characters:15 |
| Customer Priority | Customer priority; valid input values 1 (none to 100 Default is one on new record |
| Primary Address Id | Max Characters:15 |
| Contact Person | Max Characters:60 |
| Customer Address One | Max Characters:60 |
| Customer Address Two | Max Characters:60 |
| Customer Address Three | Max Characters:60 |
| City | Max Characters:35 |
| State | Max Characters:29 |
| Zip Code | Max Characters:10 |
| Country Code | Max Characters:6 |
| Country | Max Characters:60 |
| Phone One | Max Characters:21 |
| Phone Two | Max Characters:21 |
| Phone Three | Max Characters:21 |
| Fax | Max Characters:21 |
| Ups Zone | Max Characters:3 |
| Shipping Method | Max Characters:15 |
| Tax Schedule Id | Max Characters:15 |
| Ship Complete Documents | Ship complete documents: 0=False; 1=True Default is zero on new record |
| Primary Ship To Address Code | Max Characters:15 |
| Primary Bill To Address Code | Max Characters:15 |
| Statement To Address Code | Max Characters:15 |
| Salesperson Id | Max Characters:15 |
| Sales Territory | Max Characters:15 |
| User-Defined One | Max Characters:20 |
| User-Defined Two | Max Characters:20 |
| Comment One | Max Characters:30 |
| Comment Two | Max Characters:30 |
| Trade Discount | |
| Payment Terms Id | Max Characters:20 |
| Discount Grace Period | |
| Due Date Grace Period | |
| Price Level | Max Characters:10 |
| Note Text | Max Characters:8000 |
| Balance Type | Balance type: 0=Open item; 1=Balance forward Default is zero on new record |
| Finance Charge Type | Finance charge type: 0=None; 1=Percent; 2=Amount Default is zero for new record |
| Finance Charge Percent | Finance charge percent; used if FNCHATYP=1 |
| Finance Charge Dollar | Finance charge dollar; used if FNCHATYP=2 |
| Minimum Payment Type | Minimum payment type: 0=No minimum; 1=Percent; 2=Amount Default is zero for new record |
| Minimum Payment Percent | Minimum payment percent; used if MINPYTYP=1 |
| Minimum Payment Dollar Amount | Minimum payment dollar amount; used if MINPYTYP=2 |
| Credit Limit Type | Credit limit type: 0=No credit; 1=Unlimited; 2=Amount Default is zero on new record |
| Credit Limit Amount | Credit limit amount; used if CRLMTTYP=2 |
| Credit Limit Period | Credit limit period; used if CRLMTTYP=2 and the credit limit warning is used in Microsoft Dynamics GP application |
| Credit Limit Period Amount | Credit limit period amount; used if CRLMTTYP=2 and the credit limit warning is used in Microsoft Dynamics GP application |
| Maximum Write-Off Type | Maximum write-off type: 0=Not allowed; 1=Unlimited; 2=Maximum Default is zero for new record |
| Maximum Write-Off Amount | Maximum write-off amount; used if MXWOFTYP=2 |
| Revalue Customer | Revalue customer: 0=Do not revalue; 1=Revalue Default is one for new record |
| Post Results To | Post results to: 0=Receivables/Discount Account; 1=Sales offset Default is zero on new records |
| Order Fulfillment Shortage | Order fulfillment shortage: 1=None; 2=Back order remaining; 3=Cancel remaining Default is one on new record |
| Include In Demand Planning | Include in demand planning: 0=Do not include; 1=Include Default is one on new record |
| Credit Card Id | Max Characters:15 |
| Credit Card Number | Max Characters:20 |
| Credit Card Expiration Date | |
| Bank Name | Max Characters:30 |
| Bank Branch | Max Characters:20 |
| User Language | User language; default is zero on new record |
| Tax Exempt One | Max Characters:25 |
| Tax Exempt Two | Max Characters:25 |
| Tax Registration Number | Max Characters:25 |
| Currency Id | Max Characters:15 |
| Rate Type Id | Max Characters:15 |
| Statement Cycle | Statement Cycle: 1=No Statement; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Bimonthly; 7=Quarterly |
| Maintain History—Calendar Year | Maintain history—calendar year: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
| Maintain History—Fiscal Year | Maintain history—fiscal year: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
| Maintain History—Transaction | Maintain history—transaction: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
| Maintain History—Distribution | Maintain history—distribution: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
| Send E-Mail Statements | Send e-mail statements: 0=Do not sent statements; 1=Send statements Default is zero on new record |
| To Email Recipient | To email recipient; separate each recipient with a semicolon Max Characters:80 |
| Carbon Copy Email Recipient | Carbon copy email recipient; separate each recipient with a semicolon Max Characters:80 |
| Blind Carbon Copy Email Recipient | Blind carbon copy email recipient; separate each recipient with a semicolon Max Characters:80 |
| Checkbook Id | Max Characters:15 |
| Cash Account From | Cash account from: 0=Checkbook; 1=Customer Default is zero on new record |
| Cash Account | Cash account; only valid if DEFCACTY=1 Max Characters:75 |
| Accounts Receivable Account | Max Characters:75 |
| Sales Account | Max Characters:75 |
| Cost Of Sales Account | Max Characters:75 |
| Inventory Account | Max Characters:75 |
| Terms Discount Taken Account | Max Characters:75 |
| Terms Discount Available Account | Max Characters:75 |
| Finance Charges Account | Max Characters:75 |
| Write-Offs Account | Max Characters:75 |
| Sales Order Returns Account | Max Characters:75 |
| Overpayment Write-Offs Account | Max Characters:75 |
| Front Office Integration Id | Max Characters:30 |
| Integration Source | |
| Integration Id | Max Characters:30 |
| Flag To Have Class Setting Roll Down To Elements Not Passed In | Flag to have class setting roll down to elements not passed in; uses the CUSTCLAS class to roll down |
| Flag To Allow A Primary Address Code To Be Created On The Fly | Flag to allow a primary address code to be created on the fly: 0=Do not create address code; 1=Create address code |
Keep an eye on our social media for updates on changes coming to TitaniumGP. We hope to see you! Privacy Policy
