POZ_SUP_REG_PII
This is a secure table with VPD policies used to store tax identifier information about supplier registrations. 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: Default
Primary Key
Name | Columns |
---|---|
POZ_SUP_REG_PII_PK |
SUPPLIER_REG_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SUPPLIER_REG_ID | NUMBER | 18 | Yes | Primary Key | |
INCOME_TAX_ID | VARCHAR2 | 30 | Income Tax ID (aka Taxpayer ID) | ||
TAX_REGISTRATION_NUMBER | VARCHAR2 | 50 | Tax Registration Number | ||
ORGANIZATION_TYPE | VARCHAR2 | 30 | Tax Organization Type | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
POZ_SUP_REG_PII | poz_supplier_registrations | SUPPLIER_REG_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POZ_SUP_REG_PII_N1 | Non Unique | Default | UPPER("INCOME_TAX_ID") |
POZ_SUP_REG_PII_N2 | Non Unique | Default | TAX_REGISTRATION_NUMBER |
POZ_SUP_REG_PII_N3 | Non Unique | POZ_SUP_REG_PII_N3 | UPPER(REPLACE((TRANSLATE("INCOME_TAX_ID",(NVL((TRANSLATE((UPPER("INCOME_TAX_ID")),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789','$')),'$')),'$')),'$','')) |
POZ_SUP_REG_PII_PK | Unique | Default | SUPPLIER_REG_ID |