Supplier Location inbound staging table
The Supplier location inbound [sn_fcms_intg_supplier_location_inbound] staging table temporarily stores important data about the geographical location of a supplier before this data is sent to the Supplier Location [sn_slm_m2m_location] and Location [cmn_location] primary tables.
The following table lists the fields for the Supplier Location inbound [sn_fcms_intg_supplier_location_inbound] staging table.
| Field | Data type | Description |
|---|---|---|
| Category | String | The category that the supplier location belongs to. The choices are:- Contracting address - Delivery address - Facility \(default\) - Headquarters - Invoice address - Service center |
| City | String | City of the supplier location. |
| Company | String | Name of the company that the supplier location is linked to. |
| Contact | String | Contact details of the supplier location. |
| Coordinates retrieved on | String | Coordinates of the supplier location that was retrieved on a specific date. |
| Country | String | Country of the supplier location. |
| Duplicate | String | Indicates whether the supplier location is a duplicate or not. |
| ERP source | String | ERP source from which data is imported. |
| Fax phone | String | Fax phone details of the supplier location. |
| Full name | String | Full name of the supplier location. |
| Integration status | String | Latitude coordinates of the supplier location. |
| Latitude | String | Latitude coordinates of the supplier location. |
| Location source | String | Source of the supplier location. |
| Location type | String | Type of the supplier location. |
| Longitude | String | Longitude coordinates of the supplier location. |
| Managed by group | String | Name of the group that manages the supplier location. |
| Name | String | Name of the supplier. |
| Primary | String | Indicates whether the supplier is primary or not. |
| Primary location | String | Primary location of the supplier. |
| Phone | String | Phone number of the supplier. |
| Phone territory | String | Phone territory of the supplier. |
| Processing message | String | A message that describes the current processing status. |
| State / Province | String | State of the supplier location. |
| Stock room | String | Stock room details of the supplier location. |
| Street address | String | Street address of the supplier location. |
| Time zone | String | Timezone of the supplier location. |
| Zip/Postal code | String | Zip code of the supplier location. |