Supplier contact outbound staging table
The Supplier contact outbound [sn_spend_intg_supplier_contact_outbound] staging table temporarily stores important data about a supplier contact so that an ERP integrator can export this data to a third-party ERP system.
Supplier contact outbound staging table
The following table lists the mandatory fields for the Supplier contact outbound [sn_spend_intg_supplier_contact_outbound] staging table.
| Field | Data type | Description |
|---|---|---|
| Active | String | Indicates if the supplier contact is active or not. |
| Avatar | String | Display avatar of the supplier contact. |
| Building | String | Name of the building of the supplier contact. |
| Business phone | String | Business phone number of the supplier contact. |
| City | String | Name of the city of the supplier contact. |
| Company | String | Name of the company that the supplier contact is linked to. |
| Cost center | String | Cost center that incurs the cost of the supplier contact. |
| Country | String | Name of the country of the supplier contact. |
| Country code | String | Country code of the supplier contact. |
| Date format | String | Date format of the supplier contact, which is YYYY-MM-DD. |
| Department | String | Department of the supplier contact. |
| Division | String | Division of the supplier contact. |
| String | Email address of the supplier contact. | |
| Employee number | String | Employee number of the supplier contact. |
| Fax | String | Fax number of the supplier contact. |
| First name | String | First name of the supplier contact. |
| Gender | String | Gender of the supplier contact. |
| Home phone | String | Home phone number of the supplier contact |
| Integration status | String | Current status of the supplier contact integration. |
| Job code | String | Job code of the supplier contact. |
| Last name | String | Last name of the supplier contact. |
| Location | String | Location of the supplier contact. |
| Manager | String | Name of the Manager of the supplier contact. |
| Middle name | String | Middle name of the supplier contact. |
| Mobile phone | String | Mobile phone number of the supplier contact. |
| Name | String | Name of the supplier contact. |
| Notes | String | Notes about the supplier contact. |
| Organization | String | Name of the organization of the supplier contact. |
| Other phone | String | Other phone number of the supplier contact. |
| Photo | String | Photo of the supplier contact. |
| Prefix | String | Prefix of the supplier contact. |
| Primary contact | String | Primary contact person of the supplier contact. |
| Registration status | String | Current registration status of the supplier contact. |
| Time format | String | Time format of the supplier contact, which is HH: MM: SS. |
| Time zone | String | Time zone of the supplier contact. |
| Title | String | Designated title of the supplier contact. |
| User ID | String | User ID to identify the supplier contact. |
| Zip/Postal Code | String | ZIP code of the supplier contact. |