| Internal ID | Type | nlapiSubmitField | Label | Required | Help |
|---|---|---|---|---|---|
| accountnumber | text | true | Account ID | false | |
| altemail | true | Alt. Email | false | ||
| autoname | checkbox | false | Auto | false | |
| balance | currency | false | Balance | false | |
| bcn | text | false | Business Number | false | |
| billaddr1 | text | false | false | ||
| billaddr2 | text | false | false | ||
| billaddr3 | text | false | false | ||
| billcity | text | false | false | ||
| billcountry | text | false | false | ||
| billstate | text | false | false | ||
| billzip | text | false | false | ||
| category | select | true | Category | false | |
| comments | textarea | true | Comments | false | |
| companyname | text | true | Company Name | false | |
| contact | select | false | Primary Contact | false | |
| creditlimit | currency | false | Credit Limit | false | |
| currency | select | true | Currency | true | |
| datecreated | datetime | false | Date Created | false | |
| defaultaddress | address | false | Address | false | |
| false | Other Name Email | false | |||
| emailpreference | select | false | Email Preference | false | |
| entityid | text | true | Other Name | true | |
| entitystatus | integer | false | Status | false | |
| externalid | text | false | ExternalId | false | |
| fax | phone | true | Fax | false | |
| firstname | text | false | First Name | false | |
| globalsubscriptionstatus | select | false | Global Subscription Status | false | |
| homephone | phone | false | Home Phone | false | |
| image | select | false | Image | false | |
| isinactive | checkbox | true | Other Name Is Inactive | false | |
| isperson | radio | false | Company | false | |
| lastmodifieddate | datetime | false | Last Modified Date | false | |
| lastname | text | false | false | ||
| middlename | text | false | false | ||
| mobilephone | phone | false | Mobile Phone | false | |
| openingbalance | currency | false | Opening Balance | false | |
| openingbalanceaccount | select | false | Opening Balance Account | false | |
| openingbalancedate | date | false | Opening Balance Date | false | |
| otherrelationships | select | false | Other Relationships | false | |
| parent | integer | false | Parent | false | |
| phone | phone | true | Phone | false | |
| phoneticname | text | false | Furigana | false | |
| printoncheckas | text | false | Print on Check As | false | |
| salesrep | integer | true | Sales Rep | false | |
| salutation | text | false | Mr./Ms... | false | |
| subsidiary | select | false | Subsidiary | true | |
| taxfractionunit | select | false | Consumption Tax Fraction Unit | false | |
| taxidnum | text | false | Tax ID | false | |
| taxrounding | select | false | Tax Rounding | false | |
| terms | select | false | Terms | false | |
| title | text | false | Job Title | false | |
| unsubscribe | select | false | Unsubscribe from Campaigns | false | |
| url | url | false | URL | false | |
| vatregnumber | text | false | VAT Registration No. | false |
| Internal ID | Type | Label | Required |
|---|---|---|---|
| addr1 | text | Address 1 | false |
| addr2 | text | Address 2 | false |
| addr3 | text | false | |
| addressee | text | Addressee | false |
| addressid | text | false | |
| addrtext | address | Address | false |
| attention | text | Attention | false |
| city | text | City | false |
| country | select | Country | false |
| defaultbilling | checkbox | Default Billing | false |
| defaultshipping | checkbox | Default Shipping | false |
| displaystate | text | State/Province | false |
| id | integer | ID | false |
| internalid | integer | false | |
| label | text | Label | false |
| override | checkbox | Override | false |
| phone | phone | Phone | false |
| state | text | State/Province | false |
| zip | text | Zip | false |
| Name | Label |
|---|---|
| access | System Access |
| address | Address |
| custom | Custom |
| financial | Financial |
| general | General |
| info | Info |
| marketing | Marketing |
| s_comm | Communications |
| s_relation | Relationships |
| s_sysinfo | System Information |
| sales | Sales |
| support | Support |
| Join ID | Join Description | Actual Join Name |
|---|---|---|
| campaignresponse | Campaign Response | Campaign |
| contact | Contact | Contact |
| messages | Messages | Message |
| messagesfrom | Messages From | Message |
| messagesto | Messages To | Message |
| Internal ID | Type | Label |
|---|---|---|
| accountnumber | text | Account |
| address | textarea | Address |
| addressee | text | Addressee |
| addresslabel | text | Address Label |
| addressphone | phone | Address Phone |
| attention | text | Attention |
| category | select | Category |
| city | text | City |
| comments | textarea | Comments |
| country | select | Country |
| county | text | County/State |
| currency | select | Currency |
| datecreated | datetime | Date Created |
| text | ||
| entityid | text | Name/ID |
| externalid | select | External ID |
| externalidstring | text | External ID (Text) |
| fax | phone | Fax |
| formuladate | date | Formula (Date) |
| formulanumeric | float | Formula (Numeric) |
| formulatext | text | Formula (Text) |
| giveaccess | checkbox | Login Access |
| globalsubscriptionstatus | select | Global Subscription Status |
| image | image | Image |
| internalid | select | Internal ID |
| internalidnumber | integer | Internal ID (Number) |
| isdefaultbilling | checkbox | Default Billing Address |
| isdefaultshipping | checkbox | Default Shipping Address |
| isinactive | checkbox | Inactive |
| language | select | Language |
| lastmodifieddate | datetime | Last Modified |
| level | select | Level |
| permission | select | Permission |
| phone | phone | Phone |
| phoneticname | text | Phonetic Name |
| representingsubsidiary | select | Represents Subsidiary |
| salesrep | select | Sales Rep |
| state | select | State/Province |
| subsidiary | select | Subsidiary |
| type | select | Type |
| url | url | Web Address |
| zipcode | text | Zip |
| Internal ID | Type | Label |
|---|---|---|
| accountnumber | text | Account |
| address | text | Address |
| address1 | text | Address 1 |
| address2 | text | Address 2 |
| address3 | text | Address 3 |
| addressee | text | Addressee |
| addressinternalid | text | Address Internal ID |
| addresslabel | text | Address Label |
| addressphone | text | Address Phone |
| altemail | Alt. Email | |
| altname | text | Name |
| altphone | phone | Office Phone |
| attention | text | Attention |
| billaddress1 | text | Billing Address 1 |
| billaddress2 | text | Billing Address 2 |
| billaddress3 | text | Billing Address 3 |
| billaddressee | text | Billing Addressee |
| billattention | text | Billing Attention |
| billcity | text | Billing City |
| billcountry | select | Billing Country |
| billcountrycode | text | Billing Country Code |
| billphone | text | Billing Phone |
| billstate | select | Billing State/Province |
| billzipcode | text | Billing Zip |
| category | text | Category |
| city | text | City |
| comments | text | Comments |
| companyname | text | Company Name |
| country | select | Country |
| countrycode | text | Country Code |
| currency | text | Currency |
| datecreated | datetime | Date Created |
| entityid | text | Name |
| entitynumber | integer | Number |
| entitystatus | text | Status |
| externalid | select | External ID |
| fax | text | Fax |
| formulacurrency | currency | Formula (Currency) |
| formuladate | date | Formula (Date) |
| formuladatetime | datetime | Formula (Date/Time) |
| formulanumeric | float | Formula (Numeric) |
| formulapercent | percent | Formula (Percent) |
| formulatext | text | Formula (Text) |
| globalsubscriptionstatus | select | Global Subscription Status |
| image | select | Image |
| internalid | select | Internal ID |
| isdefaultbilling | checkbox | Default Billing Address |
| isdefaultshipping | checkbox | Default Shipping Address |
| isinactive | checkbox | Inactive |
| language | select | Language |
| lastmodifieddate | datetime | Last Modified |
| lastviewed | datetime | Last Viewed |
| level | select | Level |
| notsfastatus | text | Status |
| permission | select | Permission |
| phone | phone | Phone |
| phoneticname | text | Phonetic Name |
| representingsubsidiary | select | Represents Subsidiary |
| salesrep | select | Sales Rep |
| shipaddress1 | text | Shipping Address 1 |
| shipaddress2 | text | Shipping Address 2 |
| shipaddress3 | text | Shipping Address 3 |
| shipaddressee | text | Shipping Addressee |
| shipattention | text | Shipping Attention |
| shipcity | text | Shipping City |
| shipcountry | select | Shipping Country |
| shipcountrycode | text | Shipping Country Code |
| shipphone | text | Shipping Phone |
| shipstate | text | Shipping State/Province |
| shipzip | text | Shipping Zip |
| state | select | State/Province |
| statedisplayname | select | State/Province Display Name |
| subscription | select | Subscription |
| subscriptiondate | datetime | Subscription Date |
| subscriptionstatus | checkbox | Subscription Status |
| subsidiary | select | Subsidiary |
| subsidiarynohierarchy | select | Subsidiary (no hierarchy) |
| type | text | Type |
| url | text | Web Address |
| zipcode | text | Zip Code |