eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	IBY.IBY_BATCHES_ALL
Subobject Name:
Status:	VALID

"This table contains records of the settlement batch information which is updated by system while processing 'Create settlement Batches' program.
IBY_BATCHES_ALL stores information about batch operations for credit cards and bank account transfer transactions. A terminal-based merchant needs to have batch operations.
This table stores the funds capture settlement information at batch level.� This is applicable for processor model payment systems.� This table contains the information like Payment System code, process profile code, status of batch, number of transactions in the batch, settlement date, payer notification creation etc. "

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_BATCHES_BATCHID_PAYEEID_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCHID PAYEEID
IBY_BATCHES_MBATCHID_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	MBATCHID
IBY_BATCHES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQDATE
IBY_BATCHES_BATCHSTATUS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCHSTATUS
IBY_BATCHES_LASTUPDATEDATE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
MBATCHID	NUMBER	(15)	Yes	Unique internal Identifier for this record. Generated using a database sequence.
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			Back End Payment system Identifier.
MPAYEEID	NUMBER			Payee Identifier
ECAPPID	NUMBER			Electronic commerce application Identifier
PAYMENTMETHODNAME	VARCHAR2	(80)		Name of the payment method
BATCHSTATUS	NUMBER			"Batch status like scuccess-0, failed-7, pending-11, submitted-18, Batch Partially Succeded-6from Lookup type : IBY_TRANSACTION_STATUS"
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)		"Request type like oraPmtCloseBatch,oraPmtQueryBatch from lookup type IBY_TRXN_REQTYPES"
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 - date when a user last updated this row.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. This number is incremented for every update to the row through the application.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
ORG_ID	NUMBER	(15)		Unique internal identifier of the Operating Unit. Validated against HR_OPERATING_UNITS.ORGANIZATION_ID.
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)		The funds capture process profiles code used in 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 needs to be 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:

APPS: IBY_BATCHES_ALL