1. Tables and Views for Procurement
  2. POZ_SUP_THIRDPARTY_INT

POZ_SUP_THIRDPARTY_INT

Interface table to import Third Party Payment relationships data. Imported data goesto POZ_SUP_THIRDPARTY_PAYMENT_REL.

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

POZ_SUP_THIRDPARTY_INT_PK

THIRDPARTY_REL_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments
THIRDPARTY_REL_INTERFACE_ID NUMBER 18 Yes Third party relationship identifier and primary key of the table
TPP_RELATIONSHIP_ID NUMBER 18 Third party realtionship unique identifier.It is the primary key for production table (POZ_SUP_THIRDPARTY_PAYMENT_REL)
VENDOR_INTERFACE_ID NUMBER 18 Supplier interface unique record Identifier
BATCH_ID VARCHAR2 200 An optional identifier, if provided while scheduling an import process is used to identify which set of interface table records will be picked up for processing
IMPORT_STATUS VARCHAR2 30 Status of the record during or after the import. Valid values are 'NEW', 'PROCESSED' and 'REJECTED'.
IMPORT_ACTION VARCHAR2 10 Yes Indicates whether the record is to be created or deleted via import. Valid values are CREATE and DELETE
DEFAULT_RELATIONSHIP_FLAG VARCHAR2 1 Identicates the row is the default third party payment relationship for this supplier site.Values can 'Y' or 'N'. Only one record can be marked as deafult. Null value from this column is also treateed as N from Import.
VENDOR_ID NUMBER 18 Supplier unique identifier
VENDOR_NAME VARCHAR2 360 Supplier Name
PRC_BU_ID NUMBER 18 Procurement business unit identifier
PROCUREMENT_BUSINESS_UNIT_NAME VARCHAR2 240 Procurement business unit name
VENDOR_SITE_ID NUMBER 18 Suppleir site unique identifier
VENDOR_SITE_CODE VARCHAR2 240 Site Name
REMIT_TO_SUPPLIER_ID NUMBER 18 party ID of Supplier
REMIT_TO_SUPPLIER VARCHAR2 360 Remit to Supplier unique name
REMIT_ADDRESS_ID NUMBER 18 Party Site ID corresponding to the address
REMIT_TO_ADDRESS VARCHAR2 240 Address name.
FROM_DATE DATE The start date of relationship fro third party payments.
TO_DATE DATE The end date of relationship foo third party payments
DESCRIPTION VARCHAR2 1000 Provision to capture information that gets included in the payment file.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
LOAD_REQUEST_ID NUMBER 18 Standard WHO column. Indicates the identifier of the job that loaded the records into the interface table.
REQUEST_SOURCE VARCHAR2 15 Signifies whether the request is from import or through web service. Valid vlaues are IMPORT and WEB_SERVICE. Null values for this column is also treated as request from import.
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.
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.
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who 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_APP_NAME VARCHAR2 50 Program application name.

Indexes

Index Uniqueness Tablespace Columns
POZ_SUP_THIRDPARTY_INT_N1 Non Unique Default REQUEST_ID
POZ_SUP_THIRDPARTY_INT_N2 Non Unique Default VENDOR_INTERFACE_ID
POZ_SUP_THIRDPARTY_INT_U1 Unique Default UPPER("BATCH_ID"), THIRDPARTY_REL_INTERFACE_ID
POZ_SUP_THIRDPARTY_INT_U2 Unique Default THIRDPARTY_REL_INTERFACE_ID