address
The Address table stores address details for entities such as customers, vendors, employees, and subsidiaries, supporting mailing and billing operations.
Columns
| Name | Type | References | Description |
| addr1 | String | The first line of the street address, which typically contains primary address details such as a street number, street name, or building name. This field is critical for identifying the main physical location of an entity for billing, shipping, or legal purposes. | |
| addr2 | String | The second line of the street address, often used for additional details such as apartment, suite, unit, or floor numbers. This field ensures that deliveries, invoices, and correspondence are directed to the correct subdivision of a building or complex. | |
| addr3 | String | The third line of the street address, if applicable. This field is used for extended address information. It provides flexibility for regions with complex address structures, such as rural areas or countries requiring additional address details. | |
| addressee | String | The name of the person, company, or entity associated with the address. This field ensures that documents, shipments, or communications are directed to the intended recipient, reducing errors in delivery or processing. | |
| addressformat | String | The standardized format applied to the address based on country-specific requirements. This field determines how the address is displayed in invoices, shipping labels, tax forms, and other documents to ensure compliance with local and international formatting standards. | |
| addrphone | String | The phone number associated with the address, typically used for contacting the recipient regarding shipments, invoices, or verification purposes. This phone number is essential for logistics, customer service, and emergency contact scenarios. | |
| addrtext | String | The full formatted address stored as a single text string, combining all address components into a readable format. This field is useful for display purposes in reports, customer records, and automated communications. | |
| attention | String | The name of a specific individual or department at the address who should receive attention. This field is commonly used for business addresses where a particular person, role, or team needs to be notified or contacted for deliveries, invoices, or legal notices. | |
| city | String | The city associated with the address, providing essential geographical information for shipping, billing, and tax calculations. This field is required for most mailing and regulatory purposes to ensure location accuracy. | |
| country | String | The country associated with the address, determining international shipping rules, tax jurisdictions, and regional compliance. This field ensures that address formatting follows the correct country-specific postal standards. | |
| customform | String | The custom form associated with this address record, allowing businesses to use a tailored form layout for address entry and management. This field supports company-specific workflows for data capture, validation, and integration with external systems. | |
| externalid | String | The unique identifier (Id) assigned to the address record by an external system. This Id enables seamless data synchronization between NetSuite and third-party applications, ensuring consistency across integrated platforms such as customer relationship management (CRM), enterprise resource planning (ERP), or e-commerce systems. | |
| override | Boolean | Indicates whether default address formatting should be overridden to allow manual adjustments. This setting ensures that exceptions, such as nonstandard addresses, can be correctly formatted while maintaining system compatibility. | |
| state | String | The state, province, or region associated with the address, used for regional categorization in shipping, taxation, and compliance. This field ensures that addresses are properly validated for jurisdictional rules, tax calculations, and regulatory reporting. | |
| zip | String | The postal or ZIP code for the address, providing location-based categorization for mail delivery, tax determination, and service eligibility. This field ensures that addresses are accurately classified for domestic and international transactions. |