DBA Data[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_BATCHES_ALL

Object Details
Object Name: IBY_BATCHES_ALL
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_BATCHES_ALL
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_BATCHES_BATCHID_PAYEEID_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCHID
ColumnPAYEEID
IBY_BATCHES_MBATCHID_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMBATCHID
IBY_BATCHES_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQDATE
IBY_BATCHES_BATCHSTATUS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCHSTATUS
IBY_BATCHES_LASTUPDATEDATE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
MBATCHID NUMBER (15) Yes System generated batch Identifier
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 (15)
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 DATE
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Yes Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ORG_ID NUMBER (15)
First party organization identifier for all transactions in the batch
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 (15)
Legal entity identifier
PROCESS_PROFILE_CODE VARCHAR2 (30)
Funds capture process profile for the batch
PAYEEINSTRID NUMBER (15)
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MBATCHID
,      BATCHID
,      PAYEEID
,      BEPID
,      MPAYEEID
,      ECAPPID
,      PAYMENTMETHODNAME
,      BATCHSTATUS
,      BATCHCLOSEDATE
,      NUMTRXNS
,      BATCHSTATEID
,      BATCHTOTAL
,      BATCHSALES
,      BATCHCREDIT
,      CURRENCYNAMECODE
,      VPSBATCHID
,      GWBATCHID
,      ERRORLOCATION
,      BEPCODE
,      BEPMESSAGE
,      BATCHOPENDATE
,      REQTYPE
,      REQDATE
,      DESTURL
,      TERMINALID
,      ACQUIRER
,      NLSLANG
,      NEEDSUPDT
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      SECURITY_GROUP_ID
,      BEPKEY
,      SENTCOUNTER
,      SENTCOUNTERDAILY
,      LEGAL_ENTITY_ID
,      PROCESS_PROFILE_CODE
,      PAYEEINSTRID
,      SETTLEDATE
,      ORG_TYPE
,      INSTRUMENT_TYPE
,      BR_DISPUTED_FLAG
,      PAYER_NOTIFICATION_REQUIRED
,      PAYER_NOTIFICATION_CREATED
FROM IBY.IBY_BATCHES_ALL;

Dependencies

[top of page]

IBY.IBY_BATCHES_ALL does not reference any database object

IBY.IBY_BATCHES_ALL is referenced by following:

SchemaIBY
ViewIBY_BATCHES_ALL#