1. Tables and Views for Procurement
  2. POZ_SUPPLIERS_INT

POZ_SUPPLIERS_INT

This table holds supplier interface data

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

POZ_SUPPLIERS_INT_PK

VENDOR_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
VENDOR_INTERFACE_ID NUMBER 18 Yes Supplier Interface Identifier Active
DATAFOX_COMPANY_ID_VALID VARCHAR2 1 Denotes if Datafox company identifier provided in column DATAFOX_COMPANY_ID is valid or not. Possible values are Y,N,T(Timed-out)
PARTY_NUMBER VARCHAR2 30 An optional Attribute, when provided will be used to check whether a party already exists with this number and the usage will be created based on that.
BATCH_ID VARCHAR2 200 An optional identifier, if provided while scheduling an import process is used to identify which interface table records will be picked up for processing.
BC_NOT_APPLICABLE_FLAG VARCHAR2 1 Business Classifications not applicable flag
VENDOR_ID NUMBER 18 Supplier unique identifier.
VENDOR_NAME VARCHAR2 360 Supplier name Active
VENDOR_NAME_NEW VARCHAR2 360 New value provided for supplier name. Valid only for UPDATE action.
STATUS VARCHAR2 20 Status Active
IMPORT_ACTION VARCHAR2 10 Indicates whether the record is to be created or updated via import. Valid Import Actions: CREATE/UPDATE.
BUSINESS_RELATIONSHIP VARCHAR2 30 Business relationship of the enterprise with the supplier. Valid only for CREATE action.
SEGMENT1 VARCHAR2 30 Key Flexfield: segment of the key flexfield. Active
VENDOR_NAME_ALT VARCHAR2 360 Alternate supplier name Active
ONE_TIME_FLAG VARCHAR2 1 Indicates whether the supplier is a one time supplier Active
VENDOR_TYPE_LOOKUP_CODE VARCHAR2 30 Supplier type Active
ORGANIZATION_TYPE_LOOKUP_CODE VARCHAR2 30 Organization type Active
END_DATE_ACTIVE DATE End date Active
CUSTOMER_NUM VARCHAR2 25 Customer number with the supplier Active
NUM_1099 VARCHAR2 30 Tax identification number(1099) Active
TYPE_1099 VARCHAR2 10 Tax Organization Type 1099 Active
STANDARD_INDUSTRY_CLASS VARCHAR2 25 Standard industry classification number Active
TAX_VERIFICATION_DATE DATE Tax verification date Active
NAME_CONTROL VARCHAR2 4 Name control Active
STATE_REPORTABLE_FLAG VARCHAR2 1 State reportable flag Active
FEDERAL_REPORTABLE_FLAG VARCHAR2 1 Federal reportable flag Active
TAX_REPORTING_NAME VARCHAR2 80 Tax reporting name for 1099 Active
ALLOW_AWT_FLAG VARCHAR2 1 Indicates whether Allow Withholding Tax is enabled Active
AWT_GROUP_ID NUMBER 18 Unique identifier for withholding tax group Active
AWT_GROUP_NAME VARCHAR2 30 Withholding tax group name Active
SERVICE_LEVEL_CODE VARCHAR2 30 Default Service Level Code
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 1 Yes or No flag indicating whether documents payable for this payee should be prevented from being grouped with other like documents payable for payment.
IBY_BANK_CHARGE_BEARER VARCHAR2 30 Bearer of bank charge cost Active
REMIT_ADVICE_DELIVERY_METHOD VARCHAR2 30 Default delivery method set on the payee level. If the Override with Payee Delivery Method Preference flag on the Payment Process Profile is turned off, the setting here is ignored. Values from the lookup IBY_DELIVERY_METHODS include EMAIL, FAX, and PRINTED.
REMIT_ADVICE_EMAIL VARCHAR2 255 E-mail address at which the payee wishes to receive remittance advice
REMIT_ADVICE_FAX VARCHAR2 100 Fax number at which the payee wishes to receive remittance advice
BANK_INSTRUCTION1_CODE VARCHAR2 30 Code of first bank instruction Active
BANK_INSTRUCTION2_CODE VARCHAR2 30 Code of second bank instruction Active
BANK_INSTRUCTION_DETAILS VARCHAR2 255 Additional bank instruction details Active
PAYMENT_REASON_CODE VARCHAR2 30 Payment reason code Active
PAYMENT_REASON_COMMENTS VARCHAR2 240 Free text field available for entering a reason Active
PAYMENT_TEXT_MESSAGE1 VARCHAR2 256 Text message for use in payment processing Active
PAYMENT_TEXT_MESSAGE2 VARCHAR2 256 Text message for use in payment processing Active
PAYMENT_TEXT_MESSAGE3 VARCHAR2 256 Text message for use in payment processing Active
DELIVERY_CHANNEL_CODE VARCHAR2 30 Default delivery channel code Active
PAYMENT_FORMAT_CODE VARCHAR2 30 Default payment format code Active
SETTLEMENT_PRIORITY VARCHAR2 30 Priority for payment settlement Active
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 30 Payment method identifier Active
TAX_COUNTRY_CODE VARCHAR2 2 Tax country code Active
PARENT_SUPPLIER_ID NUMBER 18 Parent supplier identifier Active
PARENT_SUPPLIER_NAME VARCHAR2 360 Parent supplier name Active
ALIAS VARCHAR2 360 Name as captured by the users to internally identify the organization.
DUNS_NUMBER VARCHAR2 30 DUNS_NUMBER
CORPORATE_WEBSITE VARCHAR2 150 Corporate website for the supplier
CHIEF_EXECUTIVE_NAME VARCHAR2 240 Name of the chief executive officer
CHIEF_EXECUTIVE_TITLE VARCHAR2 240 Formal title of the chief executive officer
AUTO_TAX_CALC_OVERRIDE VARCHAR2 1 Allows override of tax calculation at supplier site level
VAT_CODE VARCHAR2 30 VAT code
VAT_REGISTRATION_NUM VARCHAR2 20 VAT registration number
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
NI_NUMBER VARCHAR2 30 National Insurance Number
YEAR_ESTABLISHED NUMBER 4 Indicates the year the supplier was established
INCORP_YEAR NUMBER 4 Indicates the year the supplier was incorporated
PRINCIPAL_TITLE VARCHAR2 240 Indicates the title of the principal officer of the supplier organization
PRINCIPAL_NAME VARCHAR2 240 Indicates the name of the principal officer of the supplier organization
FISCAL_YEAREND_MONTH VARCHAR2 240 Indicates the month in which the fiscal year ends in the supplier organization.
CURR_FY_POTENTIAL_REVENUE NUMBER 24 Indicates the supplier organization's potential revenue for the current fiscal year
PREF_FUNCTIONAL_CURRENCY VARCHAR2 15 Organization's default currency code.
REQUEST_SOURCE VARCHAR2 15 Signifies whether the request is from import or through a web service. Valid values are IMPORT or WEB_SERVICE. Null value for this column is also treated as a request from import
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.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE6 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE7 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE8 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE9 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE10 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
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.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER6 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER7 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER8 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER9 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER10 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
PROGRAM_APP_NAME VARCHAR2 50 Program application name Active
IMPORT_REQUEST_ID NUMBER 18 Import request identifier Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
LOAD_REQUEST_ID NUMBER 18 Indicates the id of the job that loaded the rows into the interface table.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
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. Active
DATAFOX_COMPANY_ID VARCHAR2 30 Datafox Company Identifier

Indexes

Index Uniqueness Tablespace Columns
POZ_SUPPLIERS_INT_N1 Non Unique Default REQUEST_ID
POZ_SUPPLIERS_INT_N2 Non Unique Default UPPER("BATCH_ID"), VENDOR_INTERFACE_ID
POZ_SUPPLIERS_INT_PK Unique FUSION_TS_INTERFACE VENDOR_INTERFACE_ID