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. | |
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Tax Driver: Tax classification code for payment term. | ||
| PRIMARY_INTENDED_USE_CODE | VARCHAR2 | 30 | Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level. | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Tax Driver: Identifies the taxable nature of a noninventory based item for tax determination or tax reporting. | ||
| PRODUCT_FISCAL_CLASSIFICATION | VARCHAR2 | 240 | Tax Driver: Product fiscal classification | ||
| PRODUCT_TYPE | VARCHAR2 | 240 | Tax Driver: Type of product. Possible values are Goods and Services. This value defaults from Inventory Item attributes or is entered by the user. | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Tax Driver: Transactions category assigned by user. | ||
| USER_DEFINED_FISCAL_CLASS | VARCHAR2 | 240 | Tax Driver: Fiscal Classification. | ||
| WITHHOLDING_TAX_GROUP_ID | NUMBER | 18 | Tax Driver: Withholding tax group identifier. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Tax Driver: Classification used by a tax authority to categorize a document associated with a transaction for a tax. | ||
| FIRST_PTY_REG_ID | NUMBER | 18 | Tax Driver: Deploying company's Tax Registration number | ||
| THIRD_PTY_REG_ID | NUMBER | 18 | Tax Driver: Bill-to Customer Tax Registration Number | ||
| TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Indicates whether tax is included or not. | ||
| UPFRONT_TAX_APPLICABLE_FLAG | VARCHAR2 | 1 | Indicates whether upfront tax is applicable or not. | ||
| ENABLE_SUBLEASES_FLAG | VARCHAR2 | 1 | Indicates whether subleases are allowed or not. | ||
| ARREARS_PAY_DT_TREATMENT_CODE | VARCHAR2 | 30 | Indicates whether the payment due date is included in day count calculation for the present value derivation when the payment is in arrears. Possible values are Beginning of the day and End of the day. | ||
| 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 |