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_DOCUMENTS

Object Details

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

This table stores payment document information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CE_PAYMENT_DOCUMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_DOCUMENT_NAME
CE_PAYMENT_DOCUMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_DOCUMENT_ID
CE_PAYMENT_DOCUMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID
CE_PAYMENT_DOCUMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERNAL_BANK_ACCOUNT_ID
CE_PAYMENT_DOCUMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORMAT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_DOCUMENT_ID	NUMBER	(15)	Yes	Uniquely identifies the payment document
PAYMENT_DOC_CATEGORY	VARCHAR2	(30)		Payment document category
PAYMENT_DOCUMENT_NAME	VARCHAR2	(100)	Yes	Payment Document Name
PAYMENT_INSTRUCTION_ID	NUMBER	(15)		Payment Instruction Identifier
INTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank Account Indentifier
PAPER_STOCK_TYPE	VARCHAR2	(30)	Yes	Paper Stock Type
ATTACHED_REMITTANCE_STUB_FLAG	VARCHAR2	(1)	Yes	Attached Remittance Stub flag
NUMBER_OF_LINES_PER_REMIT_STUB	NUMBER			Number of Lines per Remittance Stub
NUMBER_OF_SETUP_DOCUMENTS	NUMBER			Number of documents printed at the beginning of each automatic payment batch
FORMAT_CODE	VARCHAR2	(30)	Yes	Payment Format Code
FIRST_AVAILABLE_DOCUMENT_NUM	NUMBER			First payment number available on a payment document
LAST_AVAILABLE_DOCUMENT_NUMBER	NUMBER			Last payment number available on a payment document
LAST_ISSUED_DOCUMENT_NUMBER	NUMBER		Yes	Last payment number used on a payment document to pay invoices
MANUAL_PAYMENTS_ONLY_FLAG	VARCHAR2	(1)	Yes	Manual Payments only flag
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
INACTIVE_DATE	DATE			Inactive Date
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 PAYMENT_DOCUMENT_ID
,      PAYMENT_DOC_CATEGORY
,      PAYMENT_DOCUMENT_NAME
,      PAYMENT_INSTRUCTION_ID
,      INTERNAL_BANK_ACCOUNT_ID
,      PAPER_STOCK_TYPE
,      ATTACHED_REMITTANCE_STUB_FLAG
,      NUMBER_OF_LINES_PER_REMIT_STUB
,      NUMBER_OF_SETUP_DOCUMENTS
,      FORMAT_CODE
,      FIRST_AVAILABLE_DOCUMENT_NUM
,      LAST_AVAILABLE_DOCUMENT_NUMBER
,      LAST_ISSUED_DOCUMENT_NUMBER
,      MANUAL_PAYMENTS_ONLY_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INACTIVE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM CE.CE_PAYMENT_DOCUMENTS;

Dependencies

[top of page]

CE.CE_PAYMENT_DOCUMENTS does not reference any database object

CE.CE_PAYMENT_DOCUMENTS is referenced by following:

CE: CE_PAYMENT_DOCUMENTS#