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

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 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.
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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
POZ_SUPPLIERS_PII poz_suppliers VENDOR_ID

Indexes

Index Uniqueness Tablespace Columns
POZ_SUPPLIERS_PII_N1 Non Unique Default UPPER("INCOME_TAX_ID")
POZ_SUPPLIERS_PII_N2 Non Unique POZ_SUPPLIERS_PII_N2 UPPER(REPLACE((TRANSLATE("INCOME_TAX_ID",(NVL((TRANSLATE((UPPER("INCOME_TAX_ID")),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789','$')),'$')),'$')),'$',''))
POZ_SUPPLIERS_PII_PK Unique Default VENDOR_ID