POZ_DF_FIRMOGRAPHIC_MAPPING
This table stores the mapping between Oracle Fusion Procurement Suppliers attributes and Oracle DataFox attributes as defined within the DataFox application by end users. The user defined mapping is copied to this table and kept in sync thereafter if changed. This table determines if a mapped Fusion Procurement Suppliers attribute should be updated only if it is currently Null if the attribute update is being driven by DataFox
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
POZ_DF_FIRMOGRAPHIC_MAPPI_PK |
MAPPING_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
MAPPING_ID | NUMBER | 18 | Yes | DF Mapping Unique Identifier for this table. | |
POZ_ATTRIBUTE_NAME | VARCHAR2 | 400 | Yes | Supplier attribute name which will be overriden from datafox | |
DATAFOX_ATTRIBUTE_NAME | VARCHAR2 | 400 | Yes | DataFox attribute name which will be mapped to the supplier attribute | |
OVERRIDE_POZ_ATTRIBUTE_FLAG | VARCHAR2 | 1 | Yes | Stores whether the supplier attribute will be overridden by the Datafox attribute value or not. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates 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_DF_FIRMOGRAPHIC_MPNG_PK1 | Unique | Default | MAPPING_ID |