1. Tables and Views for Procurement
  2. POZ_SUPPLIERS_PII_

POZ_SUPPLIERS_PII_

This is a secure table with VPD policies used to store tax identifier information about suppliers. Only users with "Maintain Supplier Corporate Tax Identifiers Data" and "Maintain Supplier Tax Identifiers PII Data" are granted access to this table. The Organization Type identifies whether these tax identifiers are PII attributes. Only users with "Maintain Supplier Tax Identifiers PII Data" will be able to access all rows in this table, those with "Maintain Supplier Corporate Tax Identifiers Data" privilege can only access rows whose Organization Type does not equal Individual or Foreign Individual.

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

POZ_SUPPLIERS_PII_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, VENDOR_ID

Columns

Name Datatype Length Precision Not-null Comments
VENDOR_ID NUMBER 18 Yes Supplier unique identifier
NI_NUMBER VARCHAR2 30 National Insurance Number
ORGANIZATION_TYPE VARCHAR2 30 Tax Organization Type
INCOME_TAX_ID VARCHAR2 30 Income Tax ID (aka Taxpayer ID)
VAT_REGISTRATION_NUM VARCHAR2 20 VAT registration number
OBJECT_VERSION_NUMBER NUMBER 9 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.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP 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.
DF_INCOME_TAX_ID VARCHAR2 30 Taxpayer Id of company sourced from Oracle DataFox. Applicable only when Power Supplier Intelligence with Oracle DataFox Smart Data feature is enabled and should not be updated or utilized elsewhere.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
POZ_SUPPLIERS_PIIN1_ Non Unique Default VENDOR_ID
POZ_SUPPLIERS_PII_PK_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, VENDOR_ID