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.

表 : 1. 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.
Email	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.