FLA_SYSTEM_OPTIONS_ALL
FLA_SYSTEM_OPTIONS_ALL contains setup options at the operating unit level. There is one row for each operating unit. It retains information such as the operating unit's ledger, interest calculation method, and inventory item master org and so on.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FLA_SYSTEM_OPTIONS_ALL_PK |
SYSTEM_OPTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SYSTEM_OPTION_ID | NUMBER | 18 | Yes | System setup option identifier. This is the primary key of the table. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier as defined in general ledger. | |
| PRIMARY_REGIME_CODE | VARCHAR2 | 30 | Yes | Primary regime code. This drives the accounting model and reporting for the lease in the primary ledger. | |
| SECONDARY_REGIME_CODE | VARCHAR2 | 30 | Optional secondary regime code. The value selected should be different from what is selected as primary regime code. | ||
| CALENDAR_ID | NUMBER | 18 | Calendar identifier from General Ledger Calendars. This is used for schedules calculations purpose. | ||
| DEFAULT_CURRENCY_CONV_TYPE | VARCHAR2 | 30 | Default currency conversion type which should be used for the leases. | ||
| INTEREST_METHOD_CODE | VARCHAR2 | 30 | Yes | Interest method. Possible values are DAILY COMPOUND, LINEAR COMPOUND, or SIMPLE INTEREST. | |
| AMORTIZATION_FREQUENCY_CODE | VARCHAR2 | 30 | Frequency at which the amortization is calculated. Possible values are DAILY and PERIODICALLY. | ||
| INVENTORY_MASTER_ORG_ID | NUMBER | 18 | Inventory item master operating unit identifier. | ||
| AUTO_LEASE_NUMBER_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the lease number is automatically generated or not. | |
| AUTO_ASSET_NUMBER_FLAG | VARCHAR2 | 1 | Indicates whether the asset number is automatically generated or not. | ||
| AUTO_PAYMENT_TERM_NUMBER_FLAG | VARCHAR2 | 1 | Indicates whether the payment term number is automatically generated or not. | ||
| AUTO_OPTION_NUMBER_FLAG | VARCHAR2 | 1 | Indicates whether the options number is automatically generated or not. | ||
| CONSOLIDATE_ADJ_ITEMS_FLAG | VARCHAR2 | 1 | Indicates whether the adjustments should be consolidated into one item or not. | ||
| SECONDARY_LEDGER_ID | NUMBER | 18 | Ledger identification as defined in general ledger. This will carry the Secondary Ledger and used for secondary regime accounting. | ||
| AP_INTEGRATION_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether the integration to Oracle Payables is enabled for the Business unit or not. | ||
| LEASE_TRX_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates if the lease approval is enabled for the business unit. | ||
| LEASE_IMPORT_APPROVAL_CODE | VARCHAR2 | 30 | Indicates the option for approval during import of lease data. | ||
| ALLOW_PROPERTY_DEFINITION_FLAG | VARCHAR2 | 1 | Indicates whether the property definition is allowed for the leases. | ||
| LIABILITY_RECLASS_FLAG | VARCHAR2 | 1 | The flag indicates whether reclassification of liability needs to be done. | ||
| LIABILITY_RECLASS_FROM_DATE | DATE | Date from which the liability reclassification is processed. | |||
| ENABLE_REVENUE_LEASES_FLAG | VARCHAR2 | 1 | Indicates revenue leases are enabled for the business unit. | ||
| ENABLE_OPTIONS_REV_AMORT_FLAG | VARCHAR2 | 1 | Indicates the revenue amortization is applicable for options. | ||
| AR_INTEGRATION_ENABLED_FLAG | VARCHAR2 | 1 | Indicates the integration to Oracle Receivables is enabled for the Business unit. | ||
| ENABLE_EXP_PROPERTY_VAL_CODE | VARCHAR2 | 30 | Yes | Indicates the property validations need to be executed when the expense lease is validated. | |
| ENABLE_REV_PROPERTY_VAL_CODE | VARCHAR2 | 30 | Yes | Indicates the property validations need to be executed when the revenue lease is validated. | |
| PRIM_PROP_SCOPE_CHANGE_CODE | VARCHAR2 | 30 | Scope change method for leases with asset classification as property in primary accounting standard. Values can be Unit based percentage and Liability based percentage. | ||
| SECD_PROP_SCOPE_CHANGE_CODE | VARCHAR2 | 30 | Scope change method for leases with asset classification as property in secondary accounting standard. Values can be Unit based percentage and Liability based percentage. | ||
| PRIM_EQUIP_SCOPE_CHANGE_CODE | VARCHAR2 | 30 | Scope change method for leases with asset classification as equipment in primary accounting standard. Values can be Unit based percentage and Liability based percentage. | ||
| SECD_EQUIP_SCOPE_CHANGE_CODE | VARCHAR2 | 30 | Scope change method for leases with asset classification as equipment in secondary accounting standard. Values can be Unit based percentage and Liability based percentage. | ||
| LIABILITY_RECLASS_METHOD_CODE | VARCHAR2 | 30 | Liability reclassification method. Values can be long term liability balance and long term liability balance and present value of payments. | ||
| REQUIRE_PROPERTY_DEFN_CODE | VARCHAR2 | 30 | Yes | Indicates if the property association for expense leases is mandatory at the business unit level. Possible values are Mandatory and Optional. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FLA_SYSTEM_OPTIONS_U1 | Unique | FUSION_TS_TX_IDX | SYSTEM_OPTION_ID |
| FLA_SYSTEM_OPTIONS_U2 | Unique | FUSION_TS_TX_IDX | ORG_ID |