1. Tables and Views for Financials
  2. IBY_TEMP_EXT_PAYEES

IBY_TEMP_EXT_PAYEES

IBY_TEMP_EXT_PAYEES stores payment processing attributes for external payees.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

IBY_TEMP_EXT_PAYEES_PK

TEMP_EXT_PAYEE_ID, FEEDER_IMPORT_BATCH_ID

Columns

Name Datatype Length Precision Not-null Comments
TEMP_EXT_PAYEE_ID NUMBER 18 Yes Primary identifier. Populated by Oracle.
STATUS VARCHAR2 30 Yes Interface record status. Valid values: NEW, PROCESSED, REJECTED.
PAYMENT_FUNCTION VARCHAR2 30 Yes Interface record type. Use: PA.
PARTY_ID NUMBER 18 Party identifier. Use the Manage Suppliers task to identify valid values. Use either PARTY_ID or VENDOR_CODE, but not both. Foreign key to party at HZ_PARTIES_ALL.PARTY_ID.
ORG_TYPE VARCHAR2 30 Oracle internal use only. Valid values: Business Group, Legal Entity, Business Unit.
ORG_ID NUMBER 18 Identifies the business unit. Use the Manage Business Units task to identify valid values.
BANK_CHARGE_BEARER VARCHAR2 30 Party that is responsible for paying regular or express bank charges, such as payee or payer. Valid values: BEN, OUR, SHA, PAYEE_PAYS_EXPRESS. BEN means payee. OUR means payer. SHA means shared. PAYEE_PAYS_EXPRESS means express charges.
PARTY_SITE_ID NUMBER 18 Party site use identifier. Use the Manage Suppliers task to identify valid values.
SUPPLIER_SITE_ID NUMBER 18 Supplier site identifier. Use the Manage Suppliers task to identify valid values.
DEFAULT_PAYMENT_METHOD_CODE VARCHAR2 30 Default payment method. Use the Management Payment Methods task, Payment Method Codes option, to identify valid values.
ECE_TP_LOCATION_CODE VARCHAR2 60 Trading partner location code for the e-Commerce Gateway. Free text field. Not validated.
BANK_INSTRUCTION1_CODE VARCHAR2 30 Bank instruction code. Use the Manage Payment Codes task, Bank Instruction option to identify valid values.
BANK_INSTRUCTION2_CODE VARCHAR2 30 Bank instruction code. Use the Manage Payment Codes task, Bank Instruction option to identify valid values.
BANK_INSTRUCTION_DETAILS VARCHAR2 255 Additional bank instruction details. Free text field. Not validated.
PAYMENT_REASON_CODE VARCHAR2 30 Payment reason code provided by government or central bank. Use the Manage Payment Codes task, Payment Reason option, to identify valid values.
PAYMENT_REASON_COMMENTS VARCHAR2 240 Reason for payment. Free text field. Not validated.
PAYMENT_TEXT_MESSAGE1 VARCHAR2 256 Payment message. Free text field. Not validated.
PAYMENT_TEXT_MESSAGE2 VARCHAR2 256 Payment message. Free text field. Not validated.
PAYMENT_TEXT_MESSAGE3 VARCHAR2 256 Payment message. Free text field. Not validated.
DELIVERY_CHANNEL_CODE VARCHAR2 30 Indicates how to execute payment. Use the Manage Payment Codes task, Delivery Channel option, to identify valid values.
PAYMENT_FORMAT_CODE VARCHAR2 30 Payment format code. Use the Manage Formats task, Disbursement Payment File Formats option, to identify valid values.
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 1 Yes Indicates whether similar documents payable are prevented from being grouped for payment. Valid values: Y, N.
SETTLEMENT_PRIORITY VARCHAR2 30 Priority for executing payment. Valid values: NORMAL, EXPRESS. Valid values defined by lookup IBY_SETTLEMENT_PRIORITY.
START_DATE DATE Yes Date payee record becomes active. Date format: YYYY/MM/DD. Must be earlier than END_DATE.
END_DATE DATE Yes Date payee record becomes inactive. Date format: YYYY/MM/DD. Must be later than START_DATE.
FEEDER_IMPORT_BATCH_ID NUMBER 18 Yes Unique number to identify the batch. Free text field. Not validated.
ORIG_SYSTEM VARCHAR2 80 Original system for the external payee. Not used for Oracle Cloud implementations. Free text field. Not validated.
ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the external payee. Not used for Oracle Cloud implementations. Free text field. Not validated.
LOCAL_INSTRUMENT_CODE VARCHAR2 30 Payment method for a specific locale. Use the Management Payment Codes task, Local Instrument option, to identify valid values.
REMIT_ADVICE_DELIVERY_METHOD VARCHAR2 30 Communication method for delivering remittance advice. Valid values: EMAIL, FAX, PRINTED.
REMIT_ADVICE_EMAIL VARCHAR2 255 E-mail address of the payee for receiving remittance advice. Should be in standard email format with @. Not validated.
REMIT_ADVICE_FAX VARCHAR2 100 Fax number of the payee for receiving remittance advice. Free text field. Not validated.
CREATED_BY VARCHAR2 64 Yes Who column: user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
VENDOR_CODE VARCHAR2 30 Vendor code. Use the Manage Suppliers task to identify valid values. Use either PARTY_ID or VENDOR_CODE, but not both.
VENDOR_SITE_CODE VARCHAR2 240 Vendor Site Code. Use the Manage Suppliers task to identify valid values.
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: request ID of the loader job that created or last updated the row.
BUSINESS_UNIT VARCHAR2 240 Indicates the business unit of the Payee

Foreign Keys

Table Foreign Table Foreign Key Column
IBY_TEMP_EXT_PAYEES iby_payment_methods_b DEFAULT_PAYMENT_METHOD_CODE
IBY_TEMP_EXT_PAYEES iby_formats_b PAYMENT_FORMAT_CODE
iby_temp_pmt_instr_uses iby_temp_ext_payees TEMP_EXT_PARTY_ID, FEEDER_IMPORT_BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
IBY_TEMP_EXT_PAYEES_U1 Unique Default TEMP_EXT_PAYEE_ID, FEEDER_IMPORT_BATCH_ID