POZ_SUPPLIERS
This table stores information about your supplier level attributes. Each row includes the purchasing, receiving, invoice, tax, classification, and general information. Oracle Purchasing uses this information to determine active suppliers.
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
POZ_SUPPLIERS_PK |
VENDOR_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
VENDOR_ID | NUMBER | 18 | Yes | Supplier unique identifier | ||
REVIEW_TYPE | VARCHAR2 | 30 | Obsolete. This attribute store data to denote whether this request coming from Registration flow requires more review after approval or not. | |||
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. | ||
SEGMENT1 | VARCHAR2 | 30 | Yes | Key Flexfield: segment of the key flexfield. | ||
PARTY_ID | NUMBER | 18 | Yes | Party Identifier | ||
CREATION_SOURCE | VARCHAR2 | 25 | Displays the lookup code of the source from which the supplier was created. The possible values are: MANUAL, IMPORT, REGISTRATION, and INTERNAL_REGISTRATION. Lookup type 'POZ_CREATION_SOURCE' is used. | |||
ENABLED_FLAG | VARCHAR2 | 1 | OBSOLETE Key flexfield summary flag - defaulting to Y | |||
SUMMARY_FLAG | VARCHAR2 | 1 | OBSOLETE Key flexfield summary flag | |||
VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | 30 | Supplier type | |||
CUSTOMER_NUM | VARCHAR2 | 25 | Customer number with the supplier | |||
ONE_TIME_FLAG | VARCHAR2 | 1 | Indicates whether the supplier is a one-time supplier | |||
EMPLOYEE_ID | NUMBER | 18 | OBSOLETE Employee unique identifier if the supplier is an employee | |||
PARENT_PARTY_ID | NUMBER | 18 | Parent Party Identifier | |||
PARENT_VENDOR_ID | NUMBER | 18 | Unique identifier of the parent supplier | |||
MIN_ORDER_AMOUNT | NUMBER | OBSOLETE Minimum purchase order amount | ||||
SET_OF_BOOKS_ID | NUMBER | 18 | OBSOLETE Set of Books unique identifier | |||
TYPE_1099 | VARCHAR2 | 10 | Federal Income Tax Type | |||
WITHHOLDING_STATUS_LOOKUP_CODE | VARCHAR2 | 25 | Withholding status type | |||
WITHHOLDING_START_DATE | DATE | Withholding start date | ||||
INCOME_TAX_ID_FLAG | VARCHAR2 | 1 | Income tax (aka Taxpayer ID) flag identifier | |||
NI_NUMBER_FLAG | VARCHAR2 | 1 | National Insurance Number flag identifier. Indicating if there is a NI_NUMBER value in the PII table. | |||
ORGANIZATION_TYPE_LOOKUP_CODE | VARCHAR2 | 30 | IRS organization type | |||
TAXPAYER_COUNTRY | VARCHAR2 | 2 | Country code used to validate the Taxpayer ID for this supplier | |||
START_DATE_ACTIVE | DATE | Date on which the supplier became active | ||||
END_DATE_ACTIVE | DATE | Date on which the supplier became inactive | ||||
MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | 25 | OBSOLETE Type of minority owned business | |||
WOMEN_OWNED_FLAG | VARCHAR2 | 1 | OBSOLETE Indicates whether the supplier is a woman-owned business | |||
SMALL_BUSINESS_FLAG | VARCHAR2 | 1 | OBSOLETE Indicates that the supplier is a small business | |||
STANDARD_INDUSTRY_CLASS | VARCHAR2 | 25 | Standard industry classification number | |||
TAX_VERIFICATION_DATE | DATE | Tax verification date | ||||
NAME_CONTROL | VARCHAR2 | 4 | Indicates the first four characters of the last name of a 1099 reportable supplier. | |||
STATE_REPORTABLE_FLAG | VARCHAR2 | 1 | State reportable flag. | |||
FEDERAL_REPORTABLE_FLAG | VARCHAR2 | 1 | Federal reportable flag | |||
TAX_REPORTING_NAME | VARCHAR2 | 80 | Tax reporting method name | |||
ALLOW_AWT_FLAG | VARCHAR2 | 1 | Indicator of whether Allow Withholding Tax is enabled | |||
AWT_GROUP_ID | NUMBER | 18 | Unique Identifier for the withholding tax group | |||
BANK_CHARGE_BEARER | VARCHAR2 | 1 | Indicator of whether this supplier bears bank charges | |||
NI_NUMBER | VARCHAR2 | 30 | OBSOLETE National Insurance Number | |||
BC_NOT_APPLICABLE_FLAG | VARCHAR2 | 1 | Business Classifications not applicable flag | |||
EXTERNAL_SYSTEM_ID | NUMBER | 18 | A unique identifier of the supplier record from an external system. This is used to carry a reference from the source system for the supplier. | |||
EXTERNAL_SYSTEM | VARCHAR2 | 90 | Original system reference details of the supplier record as stored in an external system. This is used to carry reference information from the source system for the supplier. | |||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
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. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
PROGRAM_APPLICATION_ID | NUMBER | 18 | Program application identifier | |||
PROGRAM_ID | NUMBER | 18 | Program Identifier | |||
PROGRAM_UPDATE_DATE | DATE | Program update date | ||||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | ||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Supplier Profile (POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE6 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE7 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE8 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE9 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_DATE10 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER6 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER7 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER8 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER9 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_NUMBER10 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | Supplier Region Information (JE_POZ_SUPPLIERS) | ||
AP_TAX_ROUNDING_RULE | VARCHAR2 | 1 | AP Tax rounding rule | |||
AUTO_TAX_CALC_FLAG | VARCHAR2 | 1 | Supplier level where the tax calculation is done | |||
AUTO_TAX_CALC_OVERRIDE | VARCHAR2 | 1 | Allows override of tax calculation at supplier site level | |||
AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | 1 | Do amounts include tax from this supplier? | |||
OFFSET_TAX_FLAG | VARCHAR2 | 1 | Indicator of whether the supplier uses offset taxes | |||
OFFSET_VAT_CODE | VARCHAR2 | 20 | Offset vat code | |||
VAT_CODE | VARCHAR2 | 30 | VAT code | |||
VAT_REGISTRATION_NUM | VARCHAR2 | 20 | VAT registration number | |||
CORPORATE_WEBSITE | VARCHAR2 | 150 | Corporate website for the supplier | |||
BUSINESS_RELATIONSHIP | VARCHAR2 | 30 | Business relationship of the enterprise with the supplier. | |||
SPEND_AUTH_JUSTIFICATION | VARCHAR2 | 2000 | User may provide additional details to justify supplier promotion request. | |||
SPEND_AUTH_REVIEW_STATUS | VARCHAR2 | 30 | Spend authorization review status for the supplier | |||
SUPPLIER_LOCKED_FLAG | VARCHAR2 | 1 | Indicates if the supplier profile is locked by a change request. | |||
CHANGE_REQ_NUMBER | NUMBER | 18 | The change request number which locked the supplier. | |||
REBUILD_INDEX | VARCHAR2 | 1 | This is a search index column used for keyword search | |||
CREATED_BY_REST_FLAG | VARCHAR2 | 1 | Internal indicator of whether this supplier is created from REST web service. | |||
DATAFOX_COMPANY_ID | VARCHAR2 | 30 | Datafox Company Identifier | |||
DF_SCORE | NUMBER | 18 | DataFox score of this supplier. | |||
DF_INDUSTRY_CATEGORY_CODE | VARCHAR2 | 30 | Supplier's industry category code from DataFox. Uses the values from Lookup Type ORA_HZ_DATAFOX_INDUSTRY. | |||
DF_INDUSTRY_SUB_CATEGORY_CODE | VARCHAR2 | 30 | Supplier's industry sub category code from DataFox. Uses the values from the lookup Type ORA_HZ_DATAFOX_INDUSTRY. | |||
DF_LAST_SYNC_DATE | TIMESTAMP | Indicates the date and time of the last sync of the supplier record from DataFox. This attribute is used to identify if the data is coming from DataFox. Should be used only in DataFox flow. | ||||
DF_LINKED_ADDRESS_ID | NUMBER | 18 | Party site identifier of Supplier address created via Datafox linking | |||
DF_COMPANY_NAME | VARCHAR2 | 360 | Name of the 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. | |||
DF_LEGAL_NAME | VARCHAR2 | 360 | Legal Name 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. | |||
DF_CORPORATE_WEBSITE | VARCHAR2 | 150 | Web Site of the 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. | |||
DF_NAICS_CODE | VARCHAR2 | 25 | NAICS Code associated to the 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. | |||
DF_TAXPAYER_COUNTRY | VARCHAR2 | 2 | Country of Operation of company sourced from Oracle DataFox operates. Applicable only when Power Supplier Intelligence with Oracle DataFox Smart Data feature is enabled and should not be updated or utilized elsewhere. | |||
OBN_MATCHED_STATUS | VARCHAR2 | 30 | Denotes if the supplier is ready for OBN messaging. Possible values are Null - no check performed ERROR - Unknown/Unexpected exception TIMED_OUT - Time out INVALID_LOGIN - wrong username password INCOMPLETE_SETUP - OBN not configured. NO_ACCOUNT - No OBN account found ONE_ACCOUNT - One OBN account found MULTIPLE_ACCOUNTS - More than one OBN Account found (Multiple Active accounts) | |||
DENIED_PARTY_FLAG | VARCHAR2 | 1 | Indicates if a supplier is on a restricted or debarred list. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
POZ_SUPPLIERS | hz_parties | PARTY_ID |
POZ_SUPPLIERS | hz_parties | PARENT_PARTY_ID |
POZ_SUPPLIERS | poz_suppliers | PARENT_VENDOR_ID |
POZ_SUPPLIERS | gl_ledgers | SET_OF_BOOKS_ID |
POZ_SUPPLIERS | ap_income_tax_types | TYPE_1099 |
fa_adj_src_lines_t | poz_suppliers | PO_VENDOR_ID |
fa_asset_invoices | poz_suppliers | PO_VENDOR_ID |
po_headers_all | poz_suppliers | VENDOR_ID |
ap_checks_all | poz_suppliers | REMIT_TO_SUPPLIER_ID |
ap_checks_all | poz_suppliers | VENDOR_ID |
ap_checks_all | poz_suppliers | ESCHEATMENT_VENDOR_ID |
fun_ic_cust_supp_map | poz_suppliers | VENDOR_ID |
ap_invoice_payments_all | poz_suppliers | REMIT_TO_SUPPLIER_ID |
poz_spend_auth_requests | poz_suppliers | VENDOR_ID |
pon_auction_summary | poz_suppliers | VENDOR_ID |
ap_tax_codes_all | poz_suppliers | AWT_VENDOR_ID |
inv_serial_numbers | poz_suppliers | ORIGINAL_UNIT_VENDOR_ID |
po_approved_supplier_list | poz_suppliers | VENDOR_ID |
fa_warranties | poz_suppliers | PO_VENDOR_ID |
fa_leases | poz_suppliers | LESSOR_ID |
ap_payment_templates | poz_suppliers | VENDOR_ID |
poq_initiative_suppliers | poz_suppliers | SUPPLIER_ID |
poz_approval_history | poz_suppliers | VENDOR_ID |
ap_selected_invoices_all | poz_suppliers | REMIT_TO_SUPPLIER_ID |
ap_selected_invoices_all | poz_suppliers | VENDOR_ID |
poz_suppliers_pii | poz_suppliers | VENDOR_ID |
poz_supplier_sites_all_m | poz_suppliers | VENDOR_ID |
inv_consumption_rules | poz_suppliers | OWNING_ENTITY_ID |
poq_qualifications | poz_suppliers | SUPPLIER_ID |
poz_supplier_registrations | poz_suppliers | VENDOR_ID |
fa_mc_asset_invoices | poz_suppliers | PO_VENDOR_ID |
po_headers_draft_all | poz_suppliers | VENDOR_ID |
ap_1099_tape_data_all | poz_suppliers | VENDOR_ID |
poz_supp_site_requests | poz_suppliers | VENDOR_ID |
poz_suppliers | poz_suppliers | PARENT_VENDOR_ID |
poz_supplier_merge_requests | poz_suppliers | FROM_VENDOR_ID |
poz_supplier_merge_requests | poz_suppliers | TO_VENDOR_ID |
poq_assessments | poz_suppliers | SUPPLIER_ID |
poz_sup_products_services | poz_suppliers | VENDOR_ID |
ap_invoices_all | poz_suppliers | VENDOR_ID |
ap_invoices_all | poz_suppliers | REMIT_TO_SUPPLIER_ID |
fa_mass_additions | poz_suppliers | PO_VENDOR_ID |
po_headers_archive_all | poz_suppliers | VENDOR_ID |
poz_bus_classifications | poz_suppliers | VENDOR_ID |
ap_payment_schedules_all | poz_suppliers | REMIT_TO_SUPPLIER_ID |
pon_bid_headers | poz_suppliers | VENDOR_ID |
ap_invoices_interface | poz_suppliers | VENDOR_ID |
ap_awt_tax_rates_all | poz_suppliers | VENDOR_ID |
poz_supplier_mappings | poz_suppliers | VENDOR_ID |
ap_history_invoices_all | poz_suppliers | VENDOR_ID |
por_punchout_catalogs | poz_suppliers | VENDOR_ID |
jv_invoicing_partners_b | poz_suppliers | SUPPLIER_NUMBER |
por_smart_forms_all_b | poz_suppliers | SUPPLIER_ID |
poz_supp_requests | poz_suppliers | VENDOR_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
POZ_SEARCH_INDEX | Non Unique | Default | REBUILD_INDEX | |
POZ_SUPPLIERS_N1 | Non Unique | Default | REVIEW_TYPE | Obsolete |
POZ_SUPPLIERS_N2 | Non Unique | Default | PARENT_VENDOR_ID | |
POZ_SUPPLIERS_N3 | Non Unique | Default | PARENT_PARTY_ID | |
POZ_SUPPLIERS_N4 | Non Unique | Default | PARTY_ID | |
POZ_SUPPLIERS_N5 | Non Unique | Default | UPPER("SEGMENT1") | |
POZ_SUPPLIERS_N6 | Non Unique | Default | LAST_UPDATE_DATE | |
POZ_SUPPLIERS_N7 | Non Unique | Default | TAXPAYER_COUNTRY | |
POZ_SUPPLIERS_N8 | Non Unique | Default | CREATION_DATE | |
POZ_SUPPLIERS_N9 | Non Unique | Default | DATAFOX_COMPANY_ID | |
POZ_SUPPLIERS_U1 | Unique | Default | VENDOR_ID | |
POZ_SUPPLIERS_U2 | Unique | Default | SEGMENT1 |