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_PAYMENT_METHODS_B

Object Details

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

IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods include printing paper checks in-house, outsourcing checks to be printed by a payment system, and wiring money. A payment method can be very generic, such as EFT, or very specific, such as EFT in Denmark via Citibank using the EDIFACT format. Some payment methods are seeded, but implementers may define their own payment methods. This table corresponds to the Payment Methods pages.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_PAYMENT_METHODS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_METHOD_CODE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_METHOD_CODE	VARCHAR2	(30)	Yes	User entered primary key
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
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
SEEDED_FLAG	VARCHAR2	(1)		Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
BANK_CHARGE_BEARER_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the bank charge bearer attribute is mandatory, optional or non-applicable to this payment method. The default setting is disabled.
PAYMENT_REASON_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the payment reason attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
PAYMENT_REASON_COMNT_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the payment reason comment attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
REMITTANCE_MESSAGE1_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the remittance message1 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is optional.
REMITTANCE_MESSAGE2_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the remittance message2 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
REMITTANCE_MESSAGE3_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the remittance message3 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
UNIQUE_REMITTANCE_ID_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the unique remittance identifier attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
URI_CHECK_DIGIT_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the URI check digit attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
DELIVERY_CHANNEL_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the delivery channel attribute is mandatory, optional, or non-applicable to this payment method. The default setting is optional.
PAYMENT_FORMAT_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the payment format attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
SETTLEMENT_PRIORITY_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the settlement priority attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
EXCLUSIVE_PMT_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the pay alone attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
EXTERNAL_BANK_ACCT_APL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the external bank account attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
SUPPORT_BILLS_PAYABLE_FLAG	VARCHAR2	(1)	Yes	Indicates whether this payment method can be used to issue bills payable, that is future dated payments
DOCUMENT_CATEGORY_CODE	VARCHAR2	(30)		Document category code that is linked to a payment method. Document category codes are used in providing document sequence numbers for payments.
MATURITY_DATE_OFFSET_DAYS	NUMBER	(15)		With this payment method, number of days to be added to the payment date on a payment, which determines its maturity date
INACTIVE_DATE	DATE			Inactive date
ANTICIPATED_FLOAT	NUMBER	(15)		Days added to the payment date for use in cash forecasting
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
FORMAT_VALUE	VARCHAR2	(80)		Value used in the formatted payment instruction
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT PAYMENT_METHOD_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SEEDED_FLAG
,      BANK_CHARGE_BEARER_APL_FLAG
,      PAYMENT_REASON_APL_FLAG
,      PAYMENT_REASON_COMNT_APL_FLAG
,      REMITTANCE_MESSAGE1_APL_FLAG
,      REMITTANCE_MESSAGE2_APL_FLAG
,      REMITTANCE_MESSAGE3_APL_FLAG
,      UNIQUE_REMITTANCE_ID_APL_FLAG
,      URI_CHECK_DIGIT_APL_FLAG
,      DELIVERY_CHANNEL_APL_FLAG
,      PAYMENT_FORMAT_APL_FLAG
,      SETTLEMENT_PRIORITY_APL_FLAG
,      EXCLUSIVE_PMT_APL_FLAG
,      EXTERNAL_BANK_ACCT_APL_FLAG
,      SUPPORT_BILLS_PAYABLE_FLAG
,      DOCUMENT_CATEGORY_CODE
,      MATURITY_DATE_OFFSET_DAYS
,      INACTIVE_DATE
,      ANTICIPATED_FLOAT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FORMAT_VALUE
,      ZD_EDITION_NAME
FROM IBY.IBY_PAYMENT_METHODS_B;

Dependencies

[top of page]

IBY.IBY_PAYMENT_METHODS_B does not reference any database object

IBY.IBY_PAYMENT_METHODS_B is referenced by following:

IBY: IBY_PAYMENT_METHODS_B#