POZ_EXT_DATA_MAPPING

This table serves as a mapping layer between the field names provided by external data provider APIs and supplier attributes.

Details

• Schema: FUSION

• Object owner: POZ

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
POZ_EXT_DATA_MAPPING_PK	MAPPING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MAPPING_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.
API_URL	VARCHAR2	4000			REST API endpoint URL of the external data provider for supplier information.
PAYLOAD_TYPE	VARCHAR2	30			Type of payload. Valid values: Request (for request payload) and Response (for response payload). Required for validation integrations.
INTERNAL_VALIDATION_ATTR	VARCHAR2	255			Name of the Cloud application attribute that is mapped to the external data provider’s validation response attribute. Required for validation integrations.
API_FIELD_NAME	VARCHAR2	4000		Yes	Specifies the path to the desired attribute in the external data provider’s response payload. Use dot notation for nested fields.
INTERNAL_REG_ATTRIBUTE	VARCHAR2	255			Name of the supplier registration attribute in the Cloud application mapped to an external data provider attribute. For validation integrations, this value is included in the request payload; for enrichment integrations, it is updated with enriched data.
SUPP_PROFILE_ATTRIBUTE	VARCHAR2	255			Name of the supplier profile attribute in the Cloud application mapped to an external data provider attribute. For validation integrations, this value is included in the request payload; for enrichment integrations, it is updated with enriched data.
DATA_TYPE	VARCHAR2	255			The data type of the field.
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_MAPPING_U1	Unique	FUSION_TS_TX_DATA	MAPPING_ID