1. Tables and Views for Procurement
  2. POZ_EXT_DATA_SUP_PROV_IDS

POZ_EXT_DATA_SUP_PROV_IDS

This table stores the mapping between the internal FA (Financial Application) identifiers and the corresponding entity identifiers provided by external data providers. It is primarily used during periodic data refreshes to track which FA entity (such as supplier, contact, or address) is associated with the corresponding company, address, or contact on the provider's side.

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

POZ_EXT_DATA_SUP_PROV_IDS_PK

SUPP_PROVIDER_ID

Columns

Name Datatype Length Precision Not-null Comments
SUPP_PROVIDER_ID NUMBER 18 Yes Unique identifier for each record in the table.
EXT_DATA_PROVIDER_CODE VARCHAR2 255 Yes Unique code that identifies the data provider. References the data provider in poz_ext_data_providers table.
PROVIDER_ENTITY_NAME VARCHAR2 255 Yes The name of the entity on the provider side
PROVIDER_ENTITY_ID_VALUE VARCHAR2 4000 Yes The value of the unique identifier of the entity on the provide side.
SUPPLIER_ENTITY_NAME VARCHAR2 255 Yes Entity on the supplier side.
SUPPLIER_ENTITY_ID_VALUE VARCHAR2 255 Yes The value of the wnique identifier of the supplier entity.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
POZ_EXT_DATA_SUP_PROV_IDS_U1 Unique APPS_TS_TX_DATA SUPP_PROVIDER_ID