DBA Data[Home] [Help] [Dependency Information]

TABLE: CE.CE_STATEMENT_LINES

Object Details
Object Name: CE_STATEMENT_LINES
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_STATEMENT_LINES
Subobject Name:
Status: VALID


The CE_STATEMENT_LINES table stores information about bank statement lines. Each row in this table stores the statement header identifier, statement line number, associated transaction type, and transaction amount associated with the statement line.
This table corresponds to the Bank Statement Lines window of the Bank Statements form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_STATEMENT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATEMENT_LINE_ID
CE_STATEMENT_LINES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATEMENT_HEADER_ID
ColumnLINE_NUMBER
CE_STATEMENT_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATEMENT_HEADER_ID
ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
STATEMENT_LINE_ID NUMBER (15) Yes System-assigned statement line identifier
STATEMENT_HEADER_ID NUMBER (15) Yes Statement header identifier
LINE_NUMBER NUMBER (15) Yes Statement line number
TRX_DATE DATE
Yes Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
TRX_TYPE VARCHAR2 (30) Yes Transaction type, lookup type BANK_TRX_TYPE
AMOUNT NUMBER
Yes Statement line amount
STATUS VARCHAR2 (30) Yes Statement line status, lookup type STATEMENT_LINE_STATUS
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
TRX_CODE_ID NUMBER (15)
Bank transaction code identifier
EFFECTIVE_DATE DATE

Statement line effective date, used to update AR receipt's clearing date
BANK_TRX_NUMBER VARCHAR2 (240)
Transaction number that identifies the transaction to be matched against the statement line
TRX_TEXT VARCHAR2 (255)
Statement line description
CUSTOMER_TEXT VARCHAR2 (80)
Customer number for finding available transactions by customer numbers
INVOICE_TEXT VARCHAR2 (70)
Invoice number for finding available transactions by invoice number
CURRENCY_CODE VARCHAR2 (15)
Statement line currency code
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency conversion rate type
EXCHANGE_RATE NUMBER

Currency conversion rate
EXCHANGE_RATE_DATE DATE

Date used in determining the currency exchange rate
ORIGINAL_AMOUNT NUMBER

Statement line amount in currency code
CHARGES_AMOUNT NUMBER

Bank charges amount
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
RECONCILE_TO_STATEMENT_FLAG VARCHAR2 (1)
Flag to indicate whether this statement line is reconciled to another statement line, Y or Null
ATTRIBUTE_CATEGORY VARCHAR2 (30)
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
CE_STATEMENT_LINES VARCHAR2 (240)
No Longer Used
JE_STATUS_FLAG VARCHAR2 (1)
Flag to indicate the status of the journal entry forthis statement line. (C-JE Created S-Success E-Error)
ACCOUNTING_DATE DATE

The accounting date as entered in the JE that is created by the statement line
GL_ACCOUNT_CCID NUMBER (15)
The CCID of the GL account for which this statement line has created a journal entry
REFERENCE_TXT VARCHAR2 (30)
The reference string as populated for the JE.
TRX_CODE VARCHAR2 (30)
Transaction Code
CASHFLOW_ID NUMBER (15)
Cashflow Identifier
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
BANK_ACCOUNT_TEXT#1 VARCHAR2 (60)
Supplier/customer bank account number for finding available transactions by supplier/customer numbers
Query Text

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


SELECT STATEMENT_LINE_ID
,      STATEMENT_HEADER_ID
,      LINE_NUMBER
,      TRX_DATE
,      TRX_TYPE
,      AMOUNT
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      TRX_CODE_ID
,      EFFECTIVE_DATE
,      BANK_TRX_NUMBER
,      TRX_TEXT
,      CUSTOMER_TEXT
,      INVOICE_TEXT
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_DATE
,      ORIGINAL_AMOUNT
,      CHARGES_AMOUNT
,      LAST_UPDATE_LOGIN
,      RECONCILE_TO_STATEMENT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CE_STATEMENT_LINES
,      JE_STATUS_FLAG
,      ACCOUNTING_DATE
,      GL_ACCOUNT_CCID
,      REFERENCE_TXT
,      TRX_CODE
,      CASHFLOW_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      BANK_ACCOUNT_TEXT#1
FROM CE.CE_STATEMENT_LINES;

Dependencies

[top of page]

CE.CE_STATEMENT_LINES does not reference any database object

CE.CE_STATEMENT_LINES is referenced by following:

SchemaCE
ViewCE_STATEMENT_LINES#