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_PAYMENTS_ALL

Object Details

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

IBY_PAY_PAYMENTS_ALL is used to store the transaction level payment information submitted by payable programs such Oracle Payables. This includes the beneficiary, receiving bank and bank account, and various payment processing information. Each payment row in this table must belong to a payment batch in IBY_PAY_BATCHES_ALL; each batch row in IBY_PAY_BATCHES_ALL can have one to n payment rows. For Oracle Payables, each row in this table corresponds to a row in AP_SELECTED_INVOICE_CHECKS_ALL.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_PAY_PAYMENTS_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PMT_TRXN_ID
IBY_PAY_PAYMENTS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
IBY_PAY_PAYMENTS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BNF_BANK_ACCT_NUMBER
IBY_PAY_PAYMENTS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BNF_BANK_BRANCH_NUM
IBY_PAY_PAYMENTS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BNF_BANK_NUM
IBY_PAY_PAYMENTS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BNF_NAME
IBY_PAY_PAYMENTS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_REF
IBY_PAY_PAYMENTS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYER_ID
IBY_PAY_PAYMENTS_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PMT_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
ECAPP_ID	NUMBER	(15)		Electronic Commerce Application Identifier
PAYER_ID	VARCHAR2	(80)	Yes	Payer Identifier
BATCH_ID	NUMBER	(15)	Yes	Batch Identifier. Foreign key to IBY_PAY_BATCHES_ALL
PMT_TRXN_ID	NUMBER	(15)	Yes	System generated primary key
PMT_PRIORITY	VARCHAR2	(10)		PO_VENDOR_SITES.PAYMENT_PRIORITY
DEBIT_ACCT_NUMBER	VARCHAR2	(30)		AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NUM. Same as IBY_PAY_BATCHES_ALL.ORIG_BANK_ACCT_NUMBER
FAX_MAIL_TO_NAME	VARCHAR2	(240)		AP_SELECTED_INVOICE_CHECKS_ALL.VENDOR_NAME. Same as BNF_NAME
MAIL_ADDRESS1	VARCHAR2	(240)		Beneficiary address line1. AP_SELECTED_INVOICE_CHECKS_ALL.ADDRESS_LINE1
MAIL_ADDRESS2	VARCHAR2	(240)		AP_SELECTED_INVOICE_CHECKS_ALL.ADDRESS_LINE2
MAIL_ADDRESS3	VARCHAR2	(240)		AP_SELECTED_INVOICE_CHECKS_ALL.ADDRESS_LINE3
MAIL_ADDR_CITY	VARCHAR2	(25)		AP_SELECTED_INVOICE_CHECKS_ALL.CITY
MAIL_ADDR_STATE	VARCHAR2	(150)		AP_SELECTED_INVOICE_CHECKS_ALL.STATE
MAIL_ADDR_ZIP	VARCHAR2	(20)		AP_SELECTED_INVOICE_CHECKS_ALL.ZIP
PMT_LOC_COUNTRY_CODE	VARCHAR2	(25)		Country code of the beneficiary address. AP_SELECTED_INVOICE_CHECKS_ALL.COUNTRY
VALUE_AMOUNT	NUMBER		Yes	AP_SELECTED_INVOICE_CHECKS_ALL.CHECK_AMOUNT
REF_AMOUNT	NUMBER			Amount in the reference currency
VALUE_DATE	DATE		Yes	AP_SELECTED_INVOICE_CHECKS_ALL.PAYMENT_DATE
CHARGE_DETAILS	VARCHAR2	(6)		PO_VENDOR_SITES_ALL.BANK_CHARGE_BEARER
VAT_AMOUNT	NUMBER			Oracle Internal use only - reserved for future use
WHT_AMOUNT	NUMBER			Oracle Internal use only - reserved for future use
PMT_DETAILS_1	VARCHAR2	(20)		Oracle Internal use only - reserved for future use
PMT_DETAILS_2	VARCHAR2	(20)		Oracle Internal use only - reserved for future use
PMT_DETAILS_3	VARCHAR2	(20)		Oracle Internal use only - reserved for future use
PMT_DETAILS_4	VARCHAR2	(20)		Oracle Internal use only - reserved for future use
TRXN_CODE_CLRID	VARCHAR2	(30)		Transaction code from PO_VENDOR_SITES_ALL flexfield
BNF_NAME	VARCHAR2	(240)	Yes	AP_SELECTED_INVOICE_CHECKS_ALL.VENDOR_NAME
BNF_ID	VARCHAR2	(30)		PO_VENDORS.SEGMENT1. Supplier number
BNF_ADDRESS_LINE1	VARCHAR2	(240)		PO_VENDOR_SITES_ALL.ADDRESS_LINE1
BNF_ADDRESS_LINE2	VARCHAR2	(240)		PO_VENDOR_SITES_ALL.ADDRESS_LINE2
BNF_ADDRESS_LINE3	VARCHAR2	(240)		PO_VENDOR_SITES_ALL.ADDRESS_LINE3
BNF_ADDR_CITY	VARCHAR2	(25)		PO_VENDOR_SITES_ALL.CITY
BNF_ADDR_STATE	VARCHAR2	(150)		PO_VENDOR_SITES_ALL.STATE
BNF_ADDR_ZIP	VARCHAR2	(20)		PO_VENDOR_SITES_ALL.ZIP
BNF_ADDR_COUNTRY	VARCHAR2	(25)		Oracle Internal use only - reserved for future use
BNF_ADDR_PHONE	VARCHAR2	(15)		PO_VENDOR_SITES_ALL.PHONE
BNF_REMARKS	VARCHAR2	(80)		Oracle Internal use only - reserved for future use
BNF_CHARGE_AMT	NUMBER			Oracle Internal use only - reserved for future use
BNF_ADJUSTMENT_AMT	VARCHAR2	(30)		Oracle Internal use only - reserved for future use
BNF_BANK_NAME	VARCHAR2	(60)		AP_BANK_BRANCHES.BANK_NAME
BNF_BANK_NUM	VARCHAR2	(30)		AP_BANK_BRANCHES.BANK_NUMBER
BNF_BANK_ADDRESS	VARCHAR2	(35)		AP_BANK_BRANCHES.ADDRESS_LINE1
BNF_BANK_ADDR_CITY	VARCHAR2	(25)		AP_BANK_BRANCHES.CITY
BNF_BANK_ADDR_STATE	VARCHAR2	(25)		AP_BANK_BRANCHES.STATE
BNF_BANK_ADDR_ZIP	VARCHAR2	(20)		AP_BANK_BRANCHES.ZIP
BNF_BANK_ADDR_COUNTRY	VARCHAR2	(25)		AP_BANK_BRANCHES.COUNTRY
BNF_BANK_BRANCH_NAME	VARCHAR2	(60)		AP_BANK_BRANCHES.BANK_BRANCH_NAME
BNF_BANK_BRANCH_NUM	VARCHAR2	(25)		AP_BANK_BRANCHES.BANK_NUM
BNF_BANK_BRANCH_TYPE	VARCHAR2	(25)		AP_BANK_BRANCHES.BANK_BRANCH_TYPE
BNF_BANK_SWIFT_CODE	VARCHAR2	(12)		AP_BANK_BRANCHES.EFT_SWIFT_CODE
BNF_BANK_ACCOUNT_NAME	VARCHAR2	(80)		AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NAME
BNF_BANK_ACCT_NUMBER	VARCHAR2	(30)		AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NUM
BNF_BANK_ACCT_CHECK_DIGITS	VARCHAR2	(30)		AP_BANK_ACCOUNTS_ALL.CHECK_DIGITS
BNF_BANK_ACCT_IBAN_NUMBER	VARCHAR2	(40)		International Bank Account Number. Corresponds to IBAN_NUMBER in AP_BANK_ACCOUNTS_ALL
BNF_BANK_ACCT_TYPE	VARCHAR2	(25)		AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_TYPE
BNF_FAXNO_CABLEADDR	VARCHAR2	(35)		Store the concatenated fax number from PO_VENDER_SITES_ALL
BNF_SITE_CODE	VARCHAR2	(15)		PO_VENDER_SITES_ALL.VENDER_SITE_CODE
BNF_BANK_CLEARING_MTD	VARCHAR2	(60)		Oracle Internal use only - reserved for future use
BNF_TAXPAYER_ID	VARCHAR2	(30)		PO_VENDORS_ALL.NUM_1099
FUTURE_PAY_DUE_DATE	DATE			AP_SELECTED_INVOICE_CHECKS_ALL.FUTURE_PAY_DUE_DATE
CUST_REF	NUMBER			AP_SELECTED_INVOICE_CHECKS_ALL.CHECK_NUMBER
INTRM_BANK_CODE	VARCHAR2	(30)		Oracle Internal use only - reserved for future use
INTRM_SWIFT_CODE	VARCHAR2	(30)		Oracle Internal use only - reserved for future use
INTRM_BANK_NAME	VARCHAR2	(60)		Oracle Internal use only - reserved for future use
INTRM_BANK_FAXNO_CBL	VARCHAR2	(35)		Oracle Internal use only - reserved for future use
PMT_STATUS	NUMBER			status of this transaction
PMT_APPROVAL_STATUS	NUMBER			Oracle Internal use only - reserved for future use
UPDATE_DATE	DATE			Oracle Internal use only - reserved for future use
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
ORG_ID	NUMBER	(15)		AP_INV_SELECTION_CRITERIA_ALL.ORG_ID
ERROR_LOCATION	NUMBER			Identifies the location of error
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 ECAPP_ID
,      PAYER_ID
,      BATCH_ID
,      PMT_TRXN_ID
,      PMT_PRIORITY
,      DEBIT_ACCT_NUMBER
,      FAX_MAIL_TO_NAME
,      MAIL_ADDRESS1
,      MAIL_ADDRESS2
,      MAIL_ADDRESS3
,      MAIL_ADDR_CITY
,      MAIL_ADDR_STATE
,      MAIL_ADDR_ZIP
,      PMT_LOC_COUNTRY_CODE
,      VALUE_AMOUNT
,      REF_AMOUNT
,      VALUE_DATE
,      CHARGE_DETAILS
,      VAT_AMOUNT
,      WHT_AMOUNT
,      PMT_DETAILS_1
,      PMT_DETAILS_2
,      PMT_DETAILS_3
,      PMT_DETAILS_4
,      TRXN_CODE_CLRID
,      BNF_NAME
,      BNF_ID
,      BNF_ADDRESS_LINE1
,      BNF_ADDRESS_LINE2
,      BNF_ADDRESS_LINE3
,      BNF_ADDR_CITY
,      BNF_ADDR_STATE
,      BNF_ADDR_ZIP
,      BNF_ADDR_COUNTRY
,      BNF_ADDR_PHONE
,      BNF_REMARKS
,      BNF_CHARGE_AMT
,      BNF_ADJUSTMENT_AMT
,      BNF_BANK_NAME
,      BNF_BANK_NUM
,      BNF_BANK_ADDRESS
,      BNF_BANK_ADDR_CITY
,      BNF_BANK_ADDR_STATE
,      BNF_BANK_ADDR_ZIP
,      BNF_BANK_ADDR_COUNTRY
,      BNF_BANK_BRANCH_NAME
,      BNF_BANK_BRANCH_NUM
,      BNF_BANK_BRANCH_TYPE
,      BNF_BANK_SWIFT_CODE
,      BNF_BANK_ACCOUNT_NAME
,      BNF_BANK_ACCT_NUMBER
,      BNF_BANK_ACCT_CHECK_DIGITS
,      BNF_BANK_ACCT_IBAN_NUMBER
,      BNF_BANK_ACCT_TYPE
,      BNF_FAXNO_CABLEADDR
,      BNF_SITE_CODE
,      BNF_BANK_CLEARING_MTD
,      BNF_TAXPAYER_ID
,      FUTURE_PAY_DUE_DATE
,      CUST_REF
,      INTRM_BANK_CODE
,      INTRM_SWIFT_CODE
,      INTRM_BANK_NAME
,      INTRM_BANK_FAXNO_CBL
,      PMT_STATUS
,      PMT_APPROVAL_STATUS
,      UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      ERROR_LOCATION
,      BEP_CODE
,      BEP_MESSAGE
FROM IBY.IBY_PAY_PAYMENTS_ALL;

Dependencies

[top of page]

IBY.IBY_PAY_PAYMENTS_ALL does not reference any database object

IBY.IBY_PAY_PAYMENTS_ALL is referenced by following:

APPS: IBY_PAY_PAYMENTS_ALL