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

TABLE: OKL.OKL_SYS_ACCT_OPTS_ALL

Object Details
Object Name: OKL_SYS_ACCT_OPTS_ALL
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_SYS_ACCT_OPTS_ALL
Subobject Name:
Status: VALID


Set of book and accounting options details for each operating unit. This table contains one record for each operating unit. This is the first table to be populated as part of accounting setup in OKL when user selects a set of books id for the current operating unit. This table also has options for rounding and for applying the rounding differences.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_SYS_ACCT_OPTS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKL_SYS_ACCT_OPTS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAEL_REP_CURRENCY_CODE
OKL_SYS_ACCT_OPTS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAEL_APPLY_ROUNDING_DIFFERENCE
OKL_SYS_ACCT_OPTS_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCC_APPLY_ROUNDING_DIFFERENCE
OKL_SYS_ACCT_OPTS_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCC_REP_CURRENCY_CODE
OKL_SYS_ACCT_OPTS_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCODE_COMBINATION_ID
OKL_SYS_ACCT_OPTS_ALL_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column
CC_REP_CURRENCY_CODE VARCHAR2 (9) Yes Not used
CODE_COMBINATION_ID NUMBER

Key flexfield combination defining column
AEL_REP_CURRENCY_CODE VARCHAR2 (9) Yes Not used
SET_OF_BOOKS_ID NUMBER
Yes Accounting books defining column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
REC_CCID NUMBER (15)
Not used
REALIZED_GAIN_CCID NUMBER (15)
Not used
REALIZED_LOSS_CCID NUMBER (15)
Not used
CC_APPLY_ROUNDING_DIFFERENCE VARCHAR2 (30) Yes Cross currency rounding difference application option. Possible values are Add to High, Add to Low and Add New Line. Depending upon the value of this field, the rounding difference is either added to highest amount line, or lowest amount line or a new line created. Points to FND lookup OKL_APPLY_ROUNDING_DIFF
AEL_APPLY_ROUNDING_DIFFERENCE VARCHAR2 (30)
Accounting rounding difference application option. Possible values are Add to High, Add to Low and Add New Line. Depending upon the value of this field, the rounding difference is either added to highest amount line, or lowest amount line or a new line created. Points to FND lookup OKL_APPLY_ROUNDING_DIFF
TAX_CCID NUMBER (15)
Not used
CROSS_CURRENCY_CCID NUMBER (15)
Not used
ROUNDING_CCID NUMBER (15)
Not used
AR_CLEARING_CCID NUMBER (15)
Not used
PAYABLES_CCID NUMBER (15)
Not used
LIABLITY_CCID NUMBER (15)
Not used
PRE_PAYMENT_CCID NUMBER (15)
Not used
FUT_DATE_PAY_CCID NUMBER (15)
Not used
CC_ROUNDING_RULE VARCHAR2 (90)
Cross currency rounding rule. Possible values are Round Down, Round up or Round Nearest. Points to FND lookup OKL_ROUNDING_RULE
CC_PRECISION NUMBER (15)
Not used
CC_MIN_ACCT_UNIT NUMBER (15)
Not used
DIS_TAKEN_CCID NUMBER (15)
Not used
AP_CLEARING_CCID NUMBER (15)
Not used
AEL_ROUNDING_RULE VARCHAR2 (90)
Cross currency rounding rule. Possible values are Round Down, Round up or Round Nearest. Points to FND lookup OKL_ROUNDING_RULE
AEL_PRECISION NUMBER (15)
Not used
AEL_MIN_ACCT_UNIT NUMBER (15)
Not used
ACCRUAL_REVERSAL_DAYS NUMBER (4)
Used by accrual program to determine number of days prior to accrual days for which income needs to be reversed.
LKE_HOLD_DAYS NUMBER

Number of days after asset sale date within which a new asset needs to be procurred and exchanged for like kind asset.
ORG_ID NUMBER (15)
Operating unit identifier
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column
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
STM_APPLY_ROUNDING_DIFFERENCE VARCHAR2 (30)
Cross currency rounding difference application option. Possible values are Add to High, Add to First and Add to Last. Points to FND lookup OKL_STRM_APPLY_ROUNDING_DIFF
STM_ROUNDING_RULE VARCHAR2 (90)
Stream rounding rule. Possible values are Round Down, Round up or Round Nearest. Points to FND lookup OKL_ROUNDING_RULE
VALIDATE_KHR_START_DATE VARCHAR2 (30)
Validate Contract Start Date
ACCOUNT_DERIVATION VARCHAR2 (30)
Stores the lookup_code for the account derivation option
ISG_ARREARS_PAY_DATES_OPTION VARCHAR2 (60)
ISG Arrears Pay Dates Option
PAY_DIST_SET_ID NUMBER

Payables Distribution Set Identifier
SECONDARY_REP_METHOD VARCHAR2 (30)
Secondary Representation Method
Query Text

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


SELECT ID
,      CC_REP_CURRENCY_CODE
,      CODE_COMBINATION_ID
,      AEL_REP_CURRENCY_CODE
,      SET_OF_BOOKS_ID
,      OBJECT_VERSION_NUMBER
,      REC_CCID
,      REALIZED_GAIN_CCID
,      REALIZED_LOSS_CCID
,      CC_APPLY_ROUNDING_DIFFERENCE
,      AEL_APPLY_ROUNDING_DIFFERENCE
,      TAX_CCID
,      CROSS_CURRENCY_CCID
,      ROUNDING_CCID
,      AR_CLEARING_CCID
,      PAYABLES_CCID
,      LIABLITY_CCID
,      PRE_PAYMENT_CCID
,      FUT_DATE_PAY_CCID
,      CC_ROUNDING_RULE
,      CC_PRECISION
,      CC_MIN_ACCT_UNIT
,      DIS_TAKEN_CCID
,      AP_CLEARING_CCID
,      AEL_ROUNDING_RULE
,      AEL_PRECISION
,      AEL_MIN_ACCT_UNIT
,      ACCRUAL_REVERSAL_DAYS
,      LKE_HOLD_DAYS
,      ORG_ID
,      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
,      STM_APPLY_ROUNDING_DIFFERENCE
,      STM_ROUNDING_RULE
,      VALIDATE_KHR_START_DATE
,      ACCOUNT_DERIVATION
,      ISG_ARREARS_PAY_DATES_OPTION
,      PAY_DIST_SET_ID
,      SECONDARY_REP_METHOD
FROM OKL.OKL_SYS_ACCT_OPTS_ALL;

Dependencies

[top of page]

OKL.OKL_SYS_ACCT_OPTS_ALL does not reference any database object

OKL.OKL_SYS_ACCT_OPTS_ALL is referenced by following:

SchemaAPPS
SynonymOKL_SYS_ACCT_OPTS
SynonymOKL_SYS_ACCT_OPTS_ALL