1. Tables and Views for Financials
  2. IBY_FC_SELECTED_TRXNS_ALL

IBY_FC_SELECTED_TRXNS_ALL

IBY_FC_SELECTED_TRXNS_ALL stores information about batch operations for credit card transactions. A terminal-based merchant needs to have batch operations. The status of the payee's batch is contained in this table.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
TRXNMID NUMBER 18 This is system-generated identifier.
INITIATOR_EXTENSION_ID NUMBER 18 Yes Initiating transaction extension identifier.
LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier of the transaction.
MBATCHID NUMBER 18 Yes System-generated settlement batch identifier.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
PAYER_PARTY_ID NUMBER 18 System-generated payer TCA party identifier.
PAYERINSTRID NUMBER 18 Instrument identifier for the payer.
PAYEEINSTRID NUMBER 18 Instrument identifier for the payee.
BILL_TO_ADDRESS_ID NUMBER 18 Identifier of the bill-to address.
CUST_ACCOUNT_ID NUMBER 18 Customer account for which the payment transaction is being processed. Foreign key to HZ_CUST_ACCOUNTS.
ACCT_SITE_USE_ID NUMBER 18 System-generated account site use identifier.
DEBIT_AUTHORIZATION_ID NUMBER 18 Debit authorization identifier.
INSTRTYPE VARCHAR2 30 Instrument type of the transaction.
TRXNTYPEID NUMBER 18 From lookup type IBY_TRXNTYPES.
ECAPPID NUMBER 18 Electronic commerce application Identifier.
APPLICATION_SHORT_NAME VARCHAR2 1000 Short name of the application that initiated the transaction.
PROCESS_PROFILE_CODE VARCHAR2 30 Funds capture process profile code.
TANGIBLEID VARCHAR2 80 System-generated bill or order identifier.
LOGICAL_GROUP_REFERENCE VARCHAR2 30 System generated logical group reference.
MEMO VARCHAR2 80 Memo for the settlement transaction.
REFINFO VARCHAR2 80 Any reference information passed by the Electronic Commerce Application.
ORDER_MEDIUM VARCHAR2 30 Order medium/channel from lookup type IBY_ORDER_MEDIUM_TYPE.
AMOUNT NUMBER Transaction amount entered by user.
CURRENCYNAMECODE VARCHAR2 15 Currency code of the transaction.
REQTYPE VARCHAR2 20 Type of request such as close batch, purge batch, or open batch.
UPDATEDATE DATE Date that scheduled payment is updated.
SETTLEMENT_DUE_DATE DATE Scheduled date for the bill or order used for payments.
EFT_AUTH_METHOD VARCHAR2 30 Method used in obtaining authorization for performing EFT debits against the payer's bank account.
DEBIT_ADVICE_DELIVERY_METHOD VARCHAR2 30 Debit notification delivery method set at the payer.
INSTRSUBTYPE VARCHAR2 40 Instrument subtype for the payment transaction.
SETTLEMENT_CUSTOMER_REFERENCE VARCHAR2 255 Reference of the customer for settlement batch.
FACTORED_FLAG VARCHAR2 1 Y or N that indicates if this payment comes from a third party on behalf of the ultimate payer.
BR_MATURITY_DATE DATE Bills receivable maturity date.
BR_DRAWEE_ISSUED_FLAG VARCHAR2 1 Yes or No that indicates if the drawee issued the bill receivable.
BR_SIGNED_FLAG VARCHAR2 1 Yes or No that indicates if the drawee needs to accept the bill receivable.
BANK_CHARGE_BEARER_CODE VARCHAR2 30 Indicates who will bear the bank charges.
DEBIT_AUTH_REFERENCE VARCHAR2 100 Debit authorization reference provided by user.
DEBIT_AUTH_METHOD VARCHAR2 30 Mode of debit authorization creation.
DEBIT_AUTH_FLAG VARCHAR2 1 Indicates if the debit authorization is recurring or one off.
DEBIT_ADVICE_EMAIL VARCHAR2 255 Debit notification email address.
DEBIT_ADVICE_FAX VARCHAR2 100 Debit notification delivery fax number.
DIRDEB_INSTRUCTION_CODE VARCHAR2 30 Direct debit transaction instruction code.
SERVICE_LEVEL VARCHAR2 35 Direct debit transaction service level.
PURPOSE_CODE VARCHAR2 30 Payment purpose codes as defined in the ISO20022 external code list.
LOCALINSTR VARCHAR2 35 Direct debit transaction local instrument.
SEQ_TYPE VARCHAR2 30 Direct debit payment sequence type.
PAYMENT_CHANNEL_CODE VARCHAR2 30 Settlement transaction payment method.
PAYMENT_CHANNEL_NAME VARCHAR2 100 Settlement transaction payment method name.
FORMAT_VALUE VARCHAR2 80 Value used in the formatted settlement batch.
PAYMENT_CHANNEL_DFF VARCHAR2 150 Structure definition of the user DFF.
STRUCTURED_PAYMENT_REFERENCE VARCHAR2 256 Structured payment reference for ISO direct debit.
SETTLEDATE DATE Scheduled date for the bill or order used for offline payments only.
AUTH_SIGN_DATE DATE Date the debtor signed the debit authorization.
AUTH_REF_NUMBER VARCHAR2 100 Authorization reference identifier. Unique per creditor.
CREDITOR_PARTY_NAME VARCHAR2 360 Name of the creditor party present on the debit authorization.
CREDITOR_IDENTIFIER VARCHAR2 150 Creditor identifier, as provided on the debit authorization document.
CREDITOR_REGISTRATION_NUMBER VARCHAR2 30 Registration number of the creditor party present on the debit authorization.
DIRECT_DEBIT_MAX_COUNT NUMBER 18 Maximum number of direct debits allowed for this authorization.
DIRECT_DEBIT_COUNT NUMBER 18 Number of direct debit transactions created for this authorization.
DEBIT_AUTH_AMEND_CODE VARCHAR2 10 Indicates changes done to the debit authorization.
DEBIT_AUTH_AMEND_USES NUMBER 18 Indicates the number of times a debit authorization is updated.
FIRST_SUCCESS_SETTLE_DATE DATE Indicates the date of debit authorization successfully used first.
DEBIT_AUTH_FNL_COLLTN_DATE DATE Date of the final collection of a direct debit as per the debit authorization.
DEBIT_AUTH_FREQUENCY VARCHAR2 20 Regularity with which direct debit instructions are to be created and processed.
AUTHORIZATION_REVISION_NUMBER NUMBER 18 Version number of debit authorization: set at 1 and increases with each new amendment.
CREDITOR_LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier prior to amendment of debit authorization.
DEBIT_AUTH_BANK_ACCOUNT_ID NUMBER 18 Customer bank account identifier prior to amendment of debit authorization.
CREDITOR_LOCATION_ID NUMBER 18 Identifier of the address of the creditor.
ORIG_AUTH_REF_NUMBER VARCHAR2 100 Debit authorization reference number prior to amendment of debit authorization.
ORIG_PARTY_NAME VARCHAR2 360 First party name prior to amendment of debit authorization.
ORIG_CREDITOR_IDENTIFIER VARCHAR2 150 Creditor identifier prior to amendment of debit authorization.
ORIG_LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier prior to amendment of debit authorization.
ORIG_REGISTRATION_NUMBER VARCHAR2 30 First party registration number prior to amendment of debit authorization.
ORIG_BANK_ACCOUNT_ID NUMBER 18 Bank account identifier prior to amendment of debit authorization.
ORIG_BANK_ACCOUNT_NUM VARCHAR2 100 Bank account number prior to amendment of debit authorization.
ORIG_IBAN VARCHAR2 50 IBAN prior to amendment of debit authorization.
PAYER_PARTY_NUMBER VARCHAR2 30 Settlement transaction payer party number.
PAYER_PARTY_NAME VARCHAR2 360 Settlement transaction payer party name.
PAYER_PARTY_TYPE VARCHAR2 30 Settlement transaction payer party type.
PAYER_PARTY_TYPE_MEANING VARCHAR2 80 Settlement transaction payer party type meaning.
PAYER_TAX_REGN_NUMBER VARCHAR2 50 Settlement transaction payer tax registration number.
PAYER_JGZZ_FISCAL_CODE VARCHAR2 20 Settlement transaction payer fiscal identifier.
PAYER_ATTRIBUTE_CATEGORY VARCHAR2 30 Settlement transaction payer attribute category for DFF.
PAYER_ALT_PARTY_NAME VARCHAR2 360 Settlement transaction payer alternate party name.
PAYER_ACCOUNT_NUMBER VARCHAR2 30 Settlement transaction payer account number.
PAYER_ADDRESS1 VARCHAR2 240 Settlement transaction payer address line 1.
PAYER_ADDRESS2 VARCHAR2 240 Settlement transaction payer address line 2.
PAYER_ADDRESS3 VARCHAR2 240 Settlement transaction payer address line 3.
PAYER_CITY VARCHAR2 60 Settlement transaction payer address city.
PAYER_COUNTY VARCHAR2 60 Settlement transaction payer address county.
PAYER_STATE VARCHAR2 60 Settlement transaction payer address state.
PAYER_COUNTRY VARCHAR2 2 Settlement transaction payer address country.
PAYER_TERRITORY_SHORT_NAME VARCHAR2 80 Settlement transaction payer address territory short name.
PAYER_ISO_TERRITORY_CODE VARCHAR2 3 Settlement transaction payer address territory code.
PAYER_POSTAL_CODE VARCHAR2 60 Settlement transaction payer address postal code.
PAYER_BANK_NAME VARCHAR2 360 Settlement transaction payer bank accounts bank name.
PAYER_BANK_NUMBER VARCHAR2 30 Settlement transaction payer bank accounts bank number.
PAYER_BRANCH_ID NUMBER 18 Settlement transaction payer bank accounts branch identifier.
PAYER_BRANCH_NAME VARCHAR2 360 Settlement transaction payer bank accounts branch name.
PAYER_BRANCH_NUMBER VARCHAR2 30 Settlement transaction payer bank accounts branch number.
PAYER_BRANCH_TYPE VARCHAR2 30 Settlement transaction payer bank accounts branch type.
PAYER_BRANCH_TYPE_MEANING VARCHAR2 80 Settlement transaction payer bank accounts branch type meaning.
PAYER_BANK_ACCOUNT_NAME VARCHAR2 80 Settlement transaction payer bank accounts name.
PAYER_BANK_ACCOUNT_NAME_ALT VARCHAR2 320 Settlement transaction payer bank accounts alternate name.
PAYER_BANK_ACCT_NUM VARCHAR2 100 Settlement transaction payer bank account number.
PAYER_USER_BANK_ACCT_NUM VARCHAR2 100 Settlement transaction payer user entered bank account number.
PAYER_MASKED_BANK_ACCOUNT_NUM VARCHAR2 100 Settlement transaction payer masked bank account number.
PAYER_BRANCH_SWIFT_CODE VARCHAR2 30 Settlement transaction payer bank accounts branch SWIFT code.
PAYER_IBAN VARCHAR2 50 Settlement transaction payer bank accounts IBAN.
PAYER_MASKED_IBAN VARCHAR2 50 Settlement transaction payer bank accounts masked IBAN.
PAYER_ACCT_CHECK_DIGITS VARCHAR2 30 Settlement transaction payer bank accounts check digits.
PAYER_BANK_ACCOUNT_TYPE VARCHAR2 25 Settlement transaction payer bank account type.
PAYER_BANK_ACCT_TYPE_MEANING VARCHAR2 80 Settlement transaction payer bank account type meaning.
PAYER_BANK_ACCOUNT_SUFFIX VARCHAR2 30 Settlement transaction payer bank account suffix.
PAYER_BANK_ACCT_CURRENCY_CODE VARCHAR2 15 Settlement transaction payer bank accounts currency code.
PAYER_BANK_ACCOUNT_HOLDER_NAME VARCHAR2 360 Settlement transaction payer bank accounts holder name.
PAYER_BANK_ACCT_DFF VARCHAR2 150 Settlement transaction payer bank accounts attribute category for DFF.
PAYER_BANK_ACCT_LOCATION_ID NUMBER 18 Settlement transaction payer bank accounts location identifier.
PAYER_BANK_ACCT_ADDR_NAME VARCHAR2 240 Settlement transaction payer bank accounts address name.
PAYER_BANK_ACCT_ADDRESS1 VARCHAR2 240 Settlement transaction payer bank accounts address 1.
PAYER_BANK_ACCT_ADDRESS2 VARCHAR2 240 Settlement transaction payer bank accounts address 2.
PAYER_BANK_ACCT_ADDRESS3 VARCHAR2 240 Settlement transaction payer bank accounts address 3.
PAYER_BANK_ACCT_CITY VARCHAR2 60 Settlement transaction payer bank accounts city.
PAYER_BANK_ACCT_COUNTY VARCHAR2 60 Settlement transaction payer bank accounts county.
PAYER_BANK_ACCT_STATE VARCHAR2 60 Settlement transaction payer bank accounts state.
PAYER_BANK_ACCT_COUNTRY VARCHAR2 2 Settlement transaction payer bank accounts country.
PAYER_BANK_ACCT_TERR_NAME VARCHAR2 80 Settlement transaction payer bank accounts territory name.
PAYER_BANK_ACCT_ISO_TERR_CODE VARCHAR2 3 Settlement transaction payer bank accounts territory code.
PAYER_BANK_ACCT_POSTAL_CODE VARCHAR2 60 Settlement transaction payer bank accounts postal code.
PAYER_BANK_ACCT_CONCAT_ADDR VARCHAR2 4000 Settlement transaction payer bank accounts contact address.
PAYER_BANK_ACCT_MAIL_ADDR VARCHAR2 4000 Settlement transaction payer bank accounts mail address.
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.
RESERVED_ATTRIBUTE1 VARCHAR2 2000 Additional column included for future use.
RESERVED_ATTRIBUTE2 VARCHAR2 360 Additional column included for future use.
RESERVED_ATTRIBUTE3 VARCHAR2 360 Additional column included for future use.
RESERVED_ATTRIBUTE4 VARCHAR2 360 Additional column included for future use.
RESERVED_ATTRIBUTE5 VARCHAR2 360 Additional column included for future use.
RESERVED_ATTRIBUTE6 NUMBER Additional column included for future use.
RESERVED_ATTRIBUTE7 NUMBER Additional column included for future use.
RESERVED_ATTRIBUTE8 NUMBER Additional column included for future use.
RESERVED_ATTRIBUTE9 DATE Additional column included for future use.
RESERVED_ATTRIBUTE10 DATE Additional column included for future use.

Indexes

Index Uniqueness Tablespace Columns
IBY_FC_SELECTED_TRXNS_ALL_N1 Non Unique Default MBATCHID, INITIATOR_EXTENSION_ID