Business Entity Import
The Business Entity integration loader uses only a single set of header columns.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Business Entity | Business Entity | No | No | ||
| ID | Coupa Unique Header ID for your Business Entity | No | No | integer | |
| Name | Name of Business Entity External Reference | Yes | Yes | string(100) | |
| Display Name | Business entity display name | No | No | string(100) | |
| Type | Type of Business Entity External Reference | No | No | string(255) | LegalBusinessEntity, OrganizationalBusinessEntity |
| Status | Possible values are active and inactive | No | No | string(255) | |
| Country of Origin Code | Your business entity's origin Country Code | No | No | ||
| State of Origin | Your business entity's origin State | No | No | ||
| Formation Type | Can be either Organization or Person | No | No | string(255) | Organization, Person |
| Business Entity Alternate Names | Alternate names for your business entity | No | No |
Business Entity Contact columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Contact | Contact | No | No | ||
| ID | Coupa Unique Contact ID for your Business Entity | No | No | integer | |
| Primary | Can be either true or false | No | No | ||
| Your business entity contact's Email | No | No | |||
| Name Given | Your business entity contact's Name Given | No | No | ||
| Name Family | Your business entity contact's Name Family | No | No | ||
| Phone Work | Your business entity contact's work phone number in the format xxx-yyy-zzzz. Intl numbers must be prefaced by a + sign and the country code. +aa xxx-yyy-zzzz | No | No | ||
| Phone Mobile | Your business entity contact's Phone Mobile | No | No | ||
| Phone Fax | Your business entity contact's Phone Fax | No | No |
Business Entity Address columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Address | Address | No | No | ||
| ID | Coupa Unique Address ID for your Business Entity | No | No | integer | |
| Line 1 | Your business entity's Address Street Line 1 | No | No | ||
| Line 2 | Your business entity's Address Street Line 2 | No | No | ||
| Line 3 | Your business entity's Address Street Line 3 | No | No | ||
| Line 4 | Your business entity's Address Street Line 4 | No | No | ||
| City | Your business entity's Address City | No | No | ||
| State | Your business entity's Address State | No | No | ||
| Postal Code | Your business entity's Address Postal Code | No | No | ||
| Country Code | Your business entity's Address Country Code | No | No |
Business Entity External Reference columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Business Entity External Reference | Business Entity External Reference | No | No | ||
| ID | Coupa Unique External Reference ID for your Business Entity | No | No | integer | |
| Value | Value of Business Entity External Reference | No | No |
Business Entity Supplier Sharing Setting columns
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Supplier Sharing Setting | Supplier Sharing Setting | No | No | ||
| ID | Coupa Unique Supplier Sharing Setting ID for your Business Entity | No | No | integer | |
| Sharable ID | Coupa Unique Sharable ID for Supplier Sharing Setting of your Business Entity | No | No | ||
| Sharable Type | Possible values can be BusinessEntity | No | No | ||
| Shared Category | Possible values can be risk | No | No | ||
| Share with Children | default | No | No |