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: CE.CE_PAYMENT_TEMPLATES

Object Details

Object Name:	CE_PAYMENT_TEMPLATES
Object Type:	TABLE
Owner:	CE
FND Design Data:	CE.CE_PAYMENT_TEMPLATES
Subobject Name:
Status:	VALID

Table for storing payment templates

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PAYTEMPLATE_REFERENCE_NUMBER	NUMBER	(15)		Uniquely identifies the payment template
PAYMENT_TEMPLATE_CODE	VARCHAR2	(150)	Yes	unique template reference code, created by the user
SETTLE_BY_SYSTEM_FLAG	VARCHAR2	(1)		Y/N flag used to indicate whether the transaction will be settled by the system or not
AUTHORIZE_FLAG	VARCHAR2	(1)		Y/N flag used to indicate whether the transaction will require authorization
TRANSACTION_TYPE	VARCHAR2	(30)		transaction type
PAYTEMPLATE_SUBTYPE_CODE_ID	NUMBER	(15)		Transaction sub type.
ANTICIPATED_VALUE_DAYS	NUMBER			anticipated value days
TRANSACTION_DESCRIPTION	VARCHAR2	(255)		free text description
TRANSACTION_COMMENTS	VARCHAR2	(255)		transaction comments
PAYMENT_CURRENCY_CODE	VARCHAR2	(10)		payment currency code, specifies the currency in which the payee expects to receive the payment
PAYMENT_AMOUNT	NUMBER			amount to be paid in payment currency, needs to be positive
SOURCE_BANK_ACCOUNT_ID	NUMBER	(15)		Identifier of the source party bank account that will be used to process this transaction
SOURCE_LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity identifier of source party
SOURCE_BANK_BRANCH_ID	NUMBER	(15)		Identifier of the source party's bank branch that will be used to process this transaction.
SOURCE_BANK_ID	NUMBER	(15)		Identifier of the source party's bank that will be used to process this transaction
DESTINATION_LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity identifier of desination party. Polulated only if the destination party is an internal legal entity
DESTINATION_BANK_ACCOUNT_ID	NUMBER	(15)		Identifier of the destination party bank account that will be used to process this transaction
DESTINATION_BANK_BRANCH_ID	NUMBER	(15)		Identifier of the destination party's bank branch that will be used to process this transaction.
DESTINATION_BANK_ID	NUMBER	(15)		Identifier of the destination party's bank that will be used to process this transaction.
DESTINATION_PARTY_SITE_USE_ID	VARCHAR2	(15)		TCA HZ identifier of destination party site use. The identifier will be used to derive address information if required by the payment method
PAYMENT_METHOD_CODE	VARCHAR2	(30)		The payment method used in the transaction. Links to Payments' payment method table
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost
PAYMENT_REASON_CODE	VARCHAR2	(30)		Payment reason code
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)		free text field available for entering a reason for the payment
REPETITIVE_CODE	VARCHAR2	(1)		Indicates whether the template is used as a repetitive code Y/N
TEMPLATE_STATUS	VARCHAR2	(1)	Yes	Template's status Active/Inactive
END_DATE	DATE			End date
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column
ATTRIBUTE1	VARCHAR2	(150)		Attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Attribute 15
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	(15)	Yes	Object Version Number

Query Text

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


SELECT PAYTEMPLATE_REFERENCE_NUMBER
,      PAYMENT_TEMPLATE_CODE
,      SETTLE_BY_SYSTEM_FLAG
,      AUTHORIZE_FLAG
,      TRANSACTION_TYPE
,      PAYTEMPLATE_SUBTYPE_CODE_ID
,      ANTICIPATED_VALUE_DAYS
,      TRANSACTION_DESCRIPTION
,      TRANSACTION_COMMENTS
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_AMOUNT
,      SOURCE_BANK_ACCOUNT_ID
,      SOURCE_LEGAL_ENTITY_ID
,      SOURCE_BANK_BRANCH_ID
,      SOURCE_BANK_ID
,      DESTINATION_LEGAL_ENTITY_ID
,      DESTINATION_BANK_ACCOUNT_ID
,      DESTINATION_BANK_BRANCH_ID
,      DESTINATION_BANK_ID
,      DESTINATION_PARTY_SITE_USE_ID
,      PAYMENT_METHOD_CODE
,      BANK_CHARGE_BEARER
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      REPETITIVE_CODE
,      TEMPLATE_STATUS
,      END_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM CE.CE_PAYMENT_TEMPLATES;

Dependencies

[top of page]

CE.CE_PAYMENT_TEMPLATES does not reference any database object

CE.CE_PAYMENT_TEMPLATES is referenced by following:

APPS: CE_PAYMENT_TEMPLATES