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 |