1. Tables and Views for Financials
  2. IBY_BATCHES_ALL

IBY_BATCHES_ALL

IBY_BATCHES_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: APPS_TS_TX_DATA

Primary Key

Name Columns

IBY_BATCHES_ALL_PK

MBATCHID

Columns

Name Datatype Length Precision Not-null Comments
MBATCHID NUMBER 18 Yes System generated batch Identifier
CURRENCY_CODE VARCHAR2 15 Currency code of the settlement.
BATCHID VARCHAR2 80 Yes Batch Identifier provided by electronic commerce application
PAYEEID VARCHAR2 80 Identifier of the payee passed by electronic commerce application
BEPID NUMBER Payment system Identifier
MPAYEEID NUMBER Payee Identifier
ECAPPID NUMBER Electronic commerce application Identifier
PAYMENTMETHODNAME VARCHAR2 80 Name of the payment method
BATCHSTATUS NUMBER Status of the batch
BATCHCLOSEDATE DATE Close date of this batch
NUMTRXNS NUMBER Number of transactions in this batch
BATCHSTATEID NUMBER 18 State of the batch. Batch states are 0 for batch accepted, 1 for batch sent, 2 for batch queued, 3 for batch rejected, 4 for batch processed, 5 for batch error, 6 for batch not found, and 7 for batch unknown.
BATCHTOTAL NUMBER Total net amount for this batch
BATCHSALES NUMBER Total inflow
BATCHCREDIT NUMBER Total outflow including return and credit transaction amounts
CURRENCYNAMECODE VARCHAR2 15 ISO currency code for this batch
VPSBATCHID VARCHAR2 80 Batch Identifier from payment system
GWBATCHID VARCHAR2 80 Batch Identifier from Gateway
ERRORLOCATION NUMBER Indicates the location of error
BEPCODE VARCHAR2 80 Error code from payment system
BEPMESSAGE VARCHAR2 1024 Error messages from payment system
BATCHOPENDATE DATE Date batch was opened
REQTYPE VARCHAR2 20 Type of request such as closebatch, purgebatch, or openbatch
REQDATE DATE Date when the batch operation request is received
DESTURL VARCHAR2 1024 Payment system URL constructed during schedule of payments
TERMINALID VARCHAR2 80 Terminal Identifier used for credit card processing. A merchant can get multiple terminal identifiers with a batch open for each one. The merchant can perform operations on those batches independently.
ACQUIRER VARCHAR2 80 Merchant bank which may be optionally returned
NLSLANG VARCHAR2 80 NLS Language
NEEDSUPDT VARCHAR2 3 Y or N flag indicating that the rows that have changed status
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of 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_UPDATED_BY VARCHAR2 64 Yes Who column: indicates 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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row.
SECURITY_GROUP_ID NUMBER Used in hosted environments
BEPKEY VARCHAR2 80 Merchant account Identifier used with this transaction
SENTCOUNTER NUMBER Count of the number of times the batch has been sent to the payment system
SENTCOUNTERDAILY NUMBER Count of the number of times that the batch has been sent to the payment system on the current day
LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier
PROCESS_PROFILE_CODE VARCHAR2 30 Funds capture process profile for the batch
PAYEEINSTRID NUMBER 18 Internal bank account for all transactions in the batch
SETTLEDATE DATE Settlement date for all transactions in the batch
ORG_TYPE VARCHAR2 30 Organization type from lookup type IBY_ORGANIZATION_TYPES
INSTRUMENT_TYPE VARCHAR2 30 Instrument type for the batch from lookup type IBY_PAYMENT_INSTR_TYPES
BR_DISPUTED_FLAG VARCHAR2 1 Bills receivable disputed flag
PAYER_NOTIFICATION_REQUIRED VARCHAR2 1 Y or N flag indicating whether payer notification is created for settlements in this batch
PAYER_NOTIFICATION_CREATED VARCHAR2 1 Y or N flag indicating whether payer notification has been created for settlements in this batch
TRANSMISSION_DATE DATE Date time when the batch is successfully transmitted to the payment system
ENTERPRISE_ID NUMBER 18 Enterprise Id to support multi-tenancy
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
INBOUND_FILE_ID NUMBER 18 The identifier of the inbound acknowledgment file.
ACKNOWLEDGMENT_DATE DATE The date when the acknowledgment is processed.
BEP_STATUS VARCHAR2 30 Status of the transaction returned by the bank or payment system.
ACKNOWLEDGMENT_FORMAT_CODE VARCHAR2 30 Code of the acknowledgment format used for the direct debit.
NOTIFICATION_MESSAGE_ID NUMBER 18 The identifier of the notification message.
CES_TRANSMISSION_FLAG VARCHAR2 1 Indicates if the settlement batch file is transmitted using Oracle Connected Partners.
SENT_FILE_NAME VARCHAR2 360 Name of the payment file transmitted to the bank.

Foreign Keys

Table Foreign Table Foreign Key Column
IBY_BATCHES_ALL iby_bepinfo BEPID
IBY_BATCHES_ALL iby_payee MPAYEEID
iby_trxn_summaries_all iby_batches_all MBATCHID

Indexes

Index Uniqueness Tablespace Columns
IBY_BATCHES_ALL_N3 Non Unique Default REQDATE
IBY_BATCHES_ALL_N4 Non Unique Default REQUEST_ID
IBY_BATCHES_BATCHID_PAYEEID_U1 Unique Default BATCHID, PAYEEID
IBY_BATCHES_BATCHSTATUS_N1 Non Unique Default BATCHSTATUS
IBY_BATCHES_LASTUPDATEDATE_N2 Non Unique Default LAST_UPDATE_DATE
IBY_BATCHES_MBATCHID_U2 Unique Default MBATCHID