FND Design Data [Home] [Help]

Table: CE_STATEMENT_LINES

Product: CE - Cash Management
Description: Bank statement lines
Implementation/DBA Data: TableCE.CE_STATEMENT_LINES
Primary Key: CE_STATEMENT_LINES_PK
  1. ColumnSTATEMENT_LINE_ID
Primary Key: CE_STATEMENT_LINES_UK1
  1. ColumnSTATEMENT_HEADER_ID
  2. ColumnLINE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
CE_STATEMENT_LINES FK Joins to TableCE_STATEMENT_HEADERS_ALL CE_STATEMENT_LINES.STATEMENT_HEADER_ID
CE_STATEMENT_LINES FK Joins to TableCE_TRANSACTION_CODES CE_STATEMENT_LINES.TRX_CODE_ID
CE_STATEMENT_LINES FK Joins to TableFND_CURRENCIES CE_STATEMENT_LINES.CURRENCY_CODE
CE_STATEMENT_LINES FK Joins to TableGL_DAILY_CONVERSION_TYPES CE_STATEMENT_LINES.EXCHANGE_RATE_TYPE
CE_STATEMENT_LINES FK Joins to TableGL_CODE_COMBINATIONS CE_STATEMENT_LINES.GL_ACCOUNT_CCID
TableCE_JE_MESSAGES FK Joins to CE_STATEMENT_LINES CE_JE_MESSAGES.STATEMENT_LINE_ID
TableCE_RECONCILIATION_ERRORS FK Joins to CE_STATEMENT_LINES CE_RECONCILIATION_ERRORS.STATEMENT_LINE_ID
TableCE_STATEMENT_RECONCILS_ALL FK Joins to CE_STATEMENT_LINES CE_STATEMENT_RECONCILS_ALL.STATEMENT_LINE_ID