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

TABLE: CE.CE_SYSTEM_PARAMETERS

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


The CE_SYSTEM_PARAMETERS_ALL table stores system-level options in Cash Management. Each row contains the set of books identifier, automatic reconciliation options, matching orders, and so forth for each of your organizations.
This table corresponds to the System Parameters form.
If you allow reconciling to third party system transactions via open interface, you need to set OPEN_INTERFACE_FLOAT_STATUS and OPEN_INTERFACE_CLEAR_STATUS. The System Parameters form does not supply any fields to enter values for these columns. You will need to supply them by accessing the database directly.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books identifier
CASHBOOK_BEGIN_DATE DATE
Yes Date from which to show transactions
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
SHOW_CLEARED_FLAG VARCHAR2 (1) Yes Flag to specify whether or not to include cleared but not reconciled transactions as available transactions for matching, Y or N
INTERFACE_PURGE_FLAG VARCHAR2 (1)
Flag to indicate whether or not to purge data from the interface tables after a successful import of the data into the blank statement tables
INTERFACE_ARCHIVE_FLAG VARCHAR2 (1)
Flag to indicate whether or not to archive data from the interface tables while purging them after a successful import of the data into the statement tables, Y or N
LINE_AUTOCREATION_FLAG VARCHAR2 (1)
Flag to indicate whether or not to allow addition of statement lines when statements are created automatically, Y or N
ENABLE_OPEN_INTERFACE_FLAG_OLD VARCHAR2 (1)
No longer used
OI_FLOAT_STATUS_OLD VARCHAR2 (30)
No longer used
OI_CLEAR_STATUS_OLD VARCHAR2 (30)
No longer used
AMOUNT_TOLERANCE_OLD NUMBER

No longer used
PERCENT_TOLERANCE_OLD NUMBER

No Longer Used
RECEIVABLES_TRX_ID_OLD NUMBER (15)
No Longer Used
DIFFERENCES_ACCOUNT_OLD VARCHAR2 (30)
No Longer Used
FX_DIFFERENCE_HANDLING_OLD VARCHAR2 (30)
No longer used
LINES_PER_COMMIT NUMBER (15)
Number of statement lines to be automatically reconciled before a commit is issued
ORG_ID_OLD NUMBER (15)
No Longer Used
AP_MATCHING_ORDER_OLD VARCHAR2 (1)
No longer used
AR_MATCHING_ORDER_OLD VARCHAR2 (1)
No longer used
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
FLOAT_HANDLING_FLAG_OLD VARCHAR2 (1)
No Longer Used
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
SHOW_VOID_PAYMENT_FLAG VARCHAR2 (1)
Flag to specify whether or not to display void payment as available for reconciliation.
OI_MATCHING_CODE_OLD VARCHAR2 (1)
No longer used
EXCHANGE_RATE_TYPE_OLD VARCHAR2 (30)
No Longer Used
EXCHANGE_RATE_DATE_OLD VARCHAR2 (10)
No Longer Used
SIGNING_AUTHORITY_APPR_FLAG VARCHAR2 (1)
Flag to indicate whether the Signing Authority is approved Manually or through Workflow.
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier
CE_DIFFERENCES_ACCOUNT_OLD VARCHAR2 (30)
No Longer Used
AUTHORIZATION_BAT VARCHAR2 (30)
Authorization
CASHFLOW_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Cashflow Exchange Rate Type
BSC_EXCHANGE_DATE_TYPE VARCHAR2 (10)
Bank Statement Cashflow Exchange Rate Date
BAT_EXCHANGE_DATE_TYPE VARCHAR2 (10)
Bank Account Transfer Exchange Rate Date
MANUAL_AMOUNT_TOLERANCE_OLD NUMBER

No longer used
MANUAL_PERCENT_TOLERANCE_OLD NUMBER

No longer used
Query Text

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


SELECT SET_OF_BOOKS_ID
,      CASHBOOK_BEGIN_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SHOW_CLEARED_FLAG
,      INTERFACE_PURGE_FLAG
,      INTERFACE_ARCHIVE_FLAG
,      LINE_AUTOCREATION_FLAG
,      ENABLE_OPEN_INTERFACE_FLAG_OLD
,      OI_FLOAT_STATUS_OLD
,      OI_CLEAR_STATUS_OLD
,      AMOUNT_TOLERANCE_OLD
,      PERCENT_TOLERANCE_OLD
,      RECEIVABLES_TRX_ID_OLD
,      DIFFERENCES_ACCOUNT_OLD
,      FX_DIFFERENCE_HANDLING_OLD
,      LINES_PER_COMMIT
,      ORG_ID_OLD
,      AP_MATCHING_ORDER_OLD
,      AR_MATCHING_ORDER_OLD
,      LAST_UPDATE_LOGIN
,      FLOAT_HANDLING_FLAG_OLD
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHOW_VOID_PAYMENT_FLAG
,      OI_MATCHING_CODE_OLD
,      EXCHANGE_RATE_TYPE_OLD
,      EXCHANGE_RATE_DATE_OLD
,      SIGNING_AUTHORITY_APPR_FLAG
,      LEGAL_ENTITY_ID
,      CE_DIFFERENCES_ACCOUNT_OLD
,      AUTHORIZATION_BAT
,      CASHFLOW_EXCHANGE_RATE_TYPE
,      BSC_EXCHANGE_DATE_TYPE
,      BAT_EXCHANGE_DATE_TYPE
,      MANUAL_AMOUNT_TOLERANCE_OLD
,      MANUAL_PERCENT_TOLERANCE_OLD
FROM CE.CE_SYSTEM_PARAMETERS;

Dependencies

[top of page]

CE.CE_SYSTEM_PARAMETERS does not reference any database object

CE.CE_SYSTEM_PARAMETERS is referenced by following:

SchemaAPPS
SynonymCE_SYSTEM_PARAMETERS