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_PAY_BATCHES_ALL

Object Details

Object Name:	IBY_PAY_BATCHES_ALL
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_PAY_BATCHES_ALL
Subobject Name:
Status:	VALID

IBY_PAY_BATCHES_ALL is used to store the batch level payment information submitted by payable programs such Oracle Payables. This includes the paying party, originating bank and bank account, and various batch summary information. If batch merge is enabled, the IBY_BATCH_ID will point to the parent batch in IBY_BATCHES_ALL that the payable batch is merged to. The payment requests are submitted through iPayment PL/SQL APIs. For Oracle Payables, each row in this table corresponds to a row in AP_INV_SELECTION_CRITERIA_ALL.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_PAY_BATCHES_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
IBY_PAY_BATCHES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_STATUS
IBY_PAY_BATCHES_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PMT_BATCH_NAME
IBY_PAY_BATCHES_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PMT_METHOD
IBY_PAY_BATCHES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BEPID
IBY_PAY_BATCHES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_NAME
IBY_PAY_BATCHES_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IBY_BATCH_ID
IBY_PAY_BATCHES_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_BANK_ACCT_NUMBER
IBY_PAY_BATCHES_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_BANK_BRANCH_NUM
IBY_PAY_BATCHES_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_BANK_NAME
IBY_PAY_BATCHES_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_BANK_NUMBER
IBY_PAY_BATCHES_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PMT_BATCH_REQUEST_ID	NUMBER	(15)		The parent concurrent request which initiated the payment request that submitted the batch to iPayment. For Oracle Payables, this is the Payment Process Manager request
PAYER_ID	VARCHAR2	(80)	Yes	Payer identifier. The payer you registered in iPayment
MPAYER_ID	NUMBER	(15)		Payer identifier. Primary key of IBY_PAYEE
BATCH_ID	NUMBER	(15)	Yes	System generated primary key
IBY_BATCH_ID	VARCHAR2	(80)		Merged parent batch in IBY_BATCHES_ALL
IBY_MBATCH_ID	NUMBER	(15)		Merged parent batch in IBY_BATCHES_ALL. Primary key of IBY_BATCHES_ALL
ECAPP_ID	NUMBER	(15)	Yes	EC application registration Identifier. For Oracle Applications such as Oracle Payables, this is the APPLICATION_ID in FND_APPLICATION for the corresponding app
BEPID	NUMBER	(15)		Back-end Payment System Identifier. Foreign key to IBY_BEPINFO. This is the third party bank or payment processor that will process the payment request
BEPKEY	VARCHAR2	(80)		Payment System Merchant Identifier
CUST_ID	NUMBER	(15)		Customer identifier from the external calling payable program. For Oracle Payables, this is the ORG_ID of the payment request originating operating unit
CUST_NAME	VARCHAR2	(240)		Name of the paying customer. For Oracle Payables, this is the orgnization name (HR_ALL_ORGNIZATION_UNITS.NAME) for which the payable request is originated.
CUST_ADDR1	VARCHAR2	(240)		Address line1 of the paying customer. For Oracle Payables, this is the default org location (HR_LOCATIONS_ALL) associated with the operating unit.
CUST_ADDR2	VARCHAR2	(240)		Address line2 of the paying customer. For Oracle Payables, this is the default org location (HR_LOCATIONS_ALL) associated with the operating unit.
CUST_ADDR3	VARCHAR2	(240)		Address line3 of the paying customer. For Oracle Payables, this is the default org location (HR_LOCATIONS_ALL) associated with the operating unit.
CUST_ADDR_CITY	VARCHAR2	(240)		City of the paying customer
CUST_ADDR_COUNTY	VARCHAR2	(240)		County (US, UK); Province (CA)
CUST_ADDR_STATE	VARCHAR2	(240)		State or Province of the paying customer
CUST_ADDR_ZIP	VARCHAR2	(240)		Zip code of the paying customer
CUST_ADDR_COUNTRY	VARCHAR2	(240)		Country code of the paying customer
CUST_ADDR_ADDN	VARCHAR2	(240)		Additional address segment
ORIG_BANK_NAME	VARCHAR2	(60)	Yes	Paying customer bank name. AP_BANK_BRANCHES.BANK_NAME
ORIG_BANK_NUMBER	VARCHAR2	(30)		AP_BANK_BRANCHES.BANK_NUMBER. Holds the number by some countries to identify bank.
ORIG_BANK_BRANCH_NAME	VARCHAR2	(60)	Yes	AP_BANK_BRANCHES.BANK_BRANCH_NAME.
ORIG_BANK_BRANCH_TYPE	VARCHAR2	(25)		AP_BANK_BRANCHES.BANK_BRANCH_TYPE. Indicates which list the bank routing number is on. Valid values are ABA, CHIPS, SWIFT and OTHER.
ORIG_BANK_BRANCH_NUM	VARCHAR2	(25)		AP_BANK_BRANCHES.BANK_NUM. Bank branch number.
ORIG_EFT_SWIFT_CODE	VARCHAR2	(12)		AP_BANK_BRANCHES.EFT_SWIFT_CODE
ORIG_BANK_ACCOUNT_NAME	VARCHAR2	(80)	Yes	Paying customer bank account name. AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NAME
ORIG_BANK_ACCT_NUMBER	VARCHAR2	(30)	Yes	Paying customer bank account number. AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NUM
ORIG_BANK_ACCT_CHECK_DIGITS	VARCHAR2	(30)		AP_BANK_ACCOUNTS_ALL.CHECK_DIGITS
ORIG_BANK_ACCT_TYPE	VARCHAR2	(25)		Paying customer bank account type. AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_TYPE
ORIG_BANK_ADDR_LINE1	VARCHAR2	(35)		AP_BANK_BRANCHES.ADDRESS_LINE1
ORIG_BANK_ADDR_CITY	VARCHAR2	(25)		AP_BANK_BRANCHES.CITY
ORIG_BANK_ADDR_STATE	VARCHAR2	(25)		AP_BANK_BRANCHES.STATE
ORIG_BANK_ADDR_ZIP	VARCHAR2	(20)		AP_BANK_BRANCHES.ZIP
ORIG_COUNTRY_CODE	VARCHAR2	(25)		AP_BANK_BRANCHES.COUNTRY
PMT_METHOD	VARCHAR2	(25)		AP_INV_SELECTION_CRITERIA_ALL.PAYMENT_METHOD_LOOKUP_CODE. Only CHECK, WIRE, and EFT are supported
CURRENCY_CODE	VARCHAR2	(15)	Yes	AP_INV_SELECTION_CRITERIA_ALL.CURRENCY_CODE
REF_CURRENCY_CODE	VARCHAR2	(15)		not used
DOC_ORDER_LOOKUP_CODE	VARCHAR2	(25)		AP_INV_SELECTION_CRITERIA_ALL.DOCUMENT_ORDER_LOOKUP_CODE
NUM_OF_TRXNS	NUMBER	(15)	Yes	Number of transactions in this payment batch
BATCH_TOTAL	NUMBER		Yes	total payment amount of the batch
BATCH_STATUS	NUMBER		Yes	batch status
REQUEST_DATE	DATE		Yes	date and time when the batch is submitted to iPayment
PMT_BATCH_NAME	VARCHAR2	(80)	Yes	Batch name as given in Oracle Payables.
PMT_BATCH_SET_ID	NUMBER	(15)		AP_INV_SELECTION_CRITERIA_ALL.BATCH_SET_ID
OBJECT_VERSION_NUMBER	NUMBER		Yes	Application level record locking for three tier stateless applications
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ERROR_LOCATION	NUMBER			Identifies the location of error
ORG_ID	NUMBER	(15)		AP_INV_SELECTION_CRITERIA_ALL.ORG_ID
BEP_CODE	VARCHAR2	(80)		Error code from Back End Payment System
BEP_MESSAGE	VARCHAR2	(1024)		Error message from Back End Payment System

Query Text

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


SELECT PMT_BATCH_REQUEST_ID
,      PAYER_ID
,      MPAYER_ID
,      BATCH_ID
,      IBY_BATCH_ID
,      IBY_MBATCH_ID
,      ECAPP_ID
,      BEPID
,      BEPKEY
,      CUST_ID
,      CUST_NAME
,      CUST_ADDR1
,      CUST_ADDR2
,      CUST_ADDR3
,      CUST_ADDR_CITY
,      CUST_ADDR_COUNTY
,      CUST_ADDR_STATE
,      CUST_ADDR_ZIP
,      CUST_ADDR_COUNTRY
,      CUST_ADDR_ADDN
,      ORIG_BANK_NAME
,      ORIG_BANK_NUMBER
,      ORIG_BANK_BRANCH_NAME
,      ORIG_BANK_BRANCH_TYPE
,      ORIG_BANK_BRANCH_NUM
,      ORIG_EFT_SWIFT_CODE
,      ORIG_BANK_ACCOUNT_NAME
,      ORIG_BANK_ACCT_NUMBER
,      ORIG_BANK_ACCT_CHECK_DIGITS
,      ORIG_BANK_ACCT_TYPE
,      ORIG_BANK_ADDR_LINE1
,      ORIG_BANK_ADDR_CITY
,      ORIG_BANK_ADDR_STATE
,      ORIG_BANK_ADDR_ZIP
,      ORIG_COUNTRY_CODE
,      PMT_METHOD
,      CURRENCY_CODE
,      REF_CURRENCY_CODE
,      DOC_ORDER_LOOKUP_CODE
,      NUM_OF_TRXNS
,      BATCH_TOTAL
,      BATCH_STATUS
,      REQUEST_DATE
,      PMT_BATCH_NAME
,      PMT_BATCH_SET_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ERROR_LOCATION
,      ORG_ID
,      BEP_CODE
,      BEP_MESSAGE
FROM IBY.IBY_PAY_BATCHES_ALL;

Dependencies

[top of page]

IBY.IBY_PAY_BATCHES_ALL does not reference any database object

IBY.IBY_PAY_BATCHES_ALL is referenced by following:

APPS: IBY_PAY_BATCHES_ALL