This table requires activation of Lease Accounting functional area. This table stores SLA level data for Lease Accounting Schedules
Module:
REF_AE_HEADER_ID , TRANSACTION_ID, TEMP_LINE_NUM , TRANSACTION_LINE_ID, AE_HEADER_ID, APPLICATION_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 38 | 0 | True | Accounting transaction identifier | ||
| TRANSACTION_LINE_ID | NUMBER | 38 | 0 | True | Accounting transaction line identifier. | ||
| AE_HEADER_ID | NUMBER | 38 | 0 | True | Subledger journal entry identifier. | ||
| TEMP_LINE_NUM | NUMBER | 38 | 0 | True | Intermediary line number generated by the accounting engine when the entries are in most detail form. | ||
| APPLICATION_ID | NUMBER | 38 | 0 | True | Identifier of a functional area within a software suite of products. | ||
| REF_AE_HEADER_ID | NUMBER | 38 | 0 | True | Reversed subledger journal entry header identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System Generated Unique Identifier | ||||
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| LEASE_ID | NUMBER | 38 | 0 | Lease identifier. | DW_LEASE_CONTRACT_D | LEASE_ID | |
| LEASE_DETAIL_ID | NUMBER | 38 | 0 | Lease detail identifier. | DW_LEASE_CONTRACT_D | LEASE_DETAIL_ID | |
| SCHEDULE_HEADER_ID | NUMBER | 38 | 0 | Schedule header identifier. | DW_LEASE_SCHEDULE_DETAIL_CF | SCHEDULE_HEADER_ID | |
| ACCRUAL_SCHEDULE_ID | NUMBER | 38 | 0 | Accrual schedule identifier. | DW_LEASE_SCHEDULE_DETAIL_CF | ACCRUAL_SCHEDULE_ID | |
| PAYMENT_ITEM_ID | NUMBER | 38 | 0 | Payment item identifier. | |||
| PAYMENT_HEADER_ID | NUMBER | 38 | 0 | Payment header identifier. | DW_LEASE_PAYMENT_HEADER_CF | PAYMENT_HEADER_ID | |
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier for the lease contract. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| LEASE_ASSET_ID | NUMBER | 38 | 0 | Asset identifier to uniquely identify an asset in this table. | DW_LEASE_ASSET_D | LEASE_ASSET_ID | |
| ASSET_LOCATION_ID | NUMBER | 38 | 0 | Site information at which the asset is being installed | DW_WORKER_LOCATION_D | LOCATION_ID | |
| INVENTORY_ORG_ID | NUMBER | 38 | 0 | Inventory item operating unit identifier. | DW_INVENTORY_ITEM_D | ORGANIZATION_ID | |
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory item identifier. It is associated with the item being chosen as asset from the inventory system. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| EMPLOYEE_ID | NUMBER | 38 | 0 | Employee with whom the asset is tagged with. | DW_PERSON_NAME_CURRENT_D | PERSON_ID | |
| PROPERTY_ID | NUMBER | 38 | 0 | Attribute indicating the property identifier of the property. | DW_LEASE_PROPERTIES_D | PROPERTY_ID | |
| SUPPLIER_ID | NUMBER | 38 | 0 | Supplier identifier. It is used to send the information to Payables during the payment process. | DW_PARTY_D | SUPPLIER_ID | |
| SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site identifier. It is used to send the information to Payables during the payment process. | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| PAYMENT_TERM_ID | NUMBER | 38 | 0 | Payment term identifier for calculation of due date. | DW_AP_TERMS_D_TL | PAYMENT_TERMS_ID | |
| VERSION_NUM | NUMBER | 38 | 0 | Version Number of Lease for which this event got created | |||
| TRANSACTION_NUMBER | VARCHAR2 | 32 | Accounting transaction reference number. | ||||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 32 | Accounting transaction type. | DW_FLA_ACCT_TRN_TYPE_LKP_TL | TRANSACTION_TYPE_CODE | ||
| TRANSACTION_DATE | DATE | Source reference date. This is Payment items due date or Schedule header transaction date or Accrual schedule date. | |||||
| TRANSACTION_STATUS_CODE | VARCHAR2 | 32 | Accounting transaction status code. | ||||
| REGIME_CODE | VARCHAR2 | 32 | Regime code. This drives the accounting model and reporting for the lease. | DW_FLA_REGIME_CODE_LKP_TL | FLA_REGIME_CODE | ||
| PAYMENT_NUMBER | VARCHAR2 | 32 | Payment number. Payment header to which the accounting line belongs to. | ||||
| LINKED_TRANSACTION_ID | NUMBER | 38 | 0 | Linked transaction ID column. This will be used to maintain link between two transactions. | |||
| PARENT_TRANSACTION_ID | NUMBER | 38 | 0 | Source Transaction Identifier in case this transaction is for a reversal. | |||
| SCHD_PARENT_RECORD_ID | NUMBER | 38 | 0 | It contains parent booking or amendement schedule header. | |||
| ACCOUNTED_IN_GL_FLAG | VARCHAR2 | 16 | Indicates if the accounting was done into general ledger. | DW_Y_N_D_TL | CODE | ||
| ACCOUNTING_TIEBACK_DATE | DATE | Date the accounted amounts are derived and tied back. | |||||
| ACCOUNTING_SCHEDULE_TYPE_CODE | VARCHAR2 | 32 | Schedule type code. | DW_FLA_SLA_SCHEDULE_TYPE_LKP_TL | SCHEDULE_TYPE_CODE | ||
| LINE_NUM | NUMBER | 38 | 0 | Line number for the accounting transaction line. | |||
| ENTERED_AMOUNT | BIGDECIMAL | 10 | Transaction amount in entered currency. | ||||
| ACCOUNTED_AMOUNT | BIGDECIMAL | 10 | Transaction amount in accounted currency. | ||||
| CONVERSION_RATE | NUMBER | Exchange rate. | |||||
| CONVERSION_RATE_TYPE_CODE | VARCHAR2 | 32 | Exchange rate type for foreign currency amounts. | ||||
| CONVERSION_DATE | DATE | Date exchange rate is effective from. | |||||
| REVERSED_FLAG | VARCHAR2 | 16 | Indicates if this transaction is reversed. | DW_Y_N_D_TL | CODE | ||
| PARENT_TRANSACTION_LINE_ID | NUMBER | 38 | 0 | Parent transaction Identifier in case this transaction is for a reversal. | |||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 32 | Short name of a lookup type that is shared across application used to classify journal entry lines. | DW_XLA_ACCOUNT_CLASS_LKP_TL | ACCOUNTING_CLASS_CODE | ||
| SUBLEDGER_FACT_LINKAGE_ID | VARCHAR2 | 128 | Column concat of ae_header_id, ref_ae_header_id, temp_line_num | ||||
| GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 | GL account identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
| GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment for the ledger. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT | ||
| GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE | ||
| COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | ||
| COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | ||
| NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT | ||
| NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE | ||
| GL_SEGMENT1 | VARCHAR2 | 32 | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line. | ||||
| XLA_LEDGER_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line. | ||||
| XLA_ENTERED_DR | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
| XLA_ENTERED_CR | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
| XLA_ACCOUNTED_DR | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line. | ||||
| XLA_ACCOUNTED_CR | BIGDECIMAL | 10 | Unrounded accounted credit for journal entry line. | ||||
| XLA_MANUAL_OVERRIDE_FLAG | VARCHAR2 | 16 | Flag to identify if the CCID is overridden. | DW_Y_N_D_TL | CODE | ||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| GLOBAL_CURRENCY_EXCH_RATE | BIGDECIMAL | 10 | Global currency conversion rate. | ||||
| XLA_GLOBAL_AMOUNT | BIGDECIMAL | 10 | XLA Amount in Global Currency | ||||
| XLA_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded debit amount for the journal line in Global Currency. | ||||
| XLA_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded Credit amount for the journal line in Global Currency. | ||||
| SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | 32 | Classification of transaction source distribution | ||||
| ACCOUNTING_LINE_CODE | VARCHAR2 | 32 | Short name of a rule to convert transactional data into a journal entry line. | ||||
| ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 16 | Type of journal line rule: Debit, Credit, Gain or Loss. | ||||
| AE_LINE_NUM | NUMBER | 38 | 0 | Number that is associated with each subledger journal entry line. | DW_XLA_EVENT_CLASSES_LKP_TL | EVENT_CLASS_CODE | |
| ENTITY_CODE | VARCHAR2 | 32 | Entity Code | DW_XLA_EVENT_CLASSES_LKP_TL | ENTITY_CODE | ||
| XLA_EVENT_CLASS_CODE | VARCHAR2 | 32 | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. | ||||
| XLA_EVENT_TYPE_CODE | VARCHAR2 | 32 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||||
| XLA_LINE_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | XLA Line Amount in transaction Currency | ||||
| XLA_LINE_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
| XLA_LINE_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
| XLA_LINE_LEDGER_AMOUNT | BIGDECIMAL | 10 | XLA Line Amount in Ledger Currency | ||||
| XLA_LINE_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit amount of the journal entry line. | ||||
| XLA_LINE_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted credit amount of the journal entry line. | ||||
| XLA_LINE_GLOBAL_AMOUNT | BIGDECIMAL | 10 | XLA Line Amount in Global Currency | ||||
| XLA_LINE_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded Global debit amount of the journal entry line. | ||||
| XLA_LINE_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded Global credit amount of the journal entry line. | ||||
| XLA_LEDGER_ID | NUMBER | 38 | 0 | Self-contained accounting information set for single or multiple legal or management entities. | DW_LEDGER_D | LEDGER_ID | |
| XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| XLA_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Entered currency for the transaction data | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| XLA_ACCOUNTING_DATE | DATE | Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | The GL period type in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | GL Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| ACCOUNTING_CREATION_DATE | TIMESTAMP | indicates the date and time of the creation of the cost accounting row | |||||
| PAYMENT_ITEM_PERIOD_NAME | VARCHAR2 | 32 | Period in which payment item falls in. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| PAYMENT_ITEM_DUE_DATE | DATE | Due date of the payment item as per the schedule in Payment Lines. | |||||
| PAYMENT_ITEM_START_DATE | DATE | Beginning date of the payment item. | |||||
| PAYMENT_ITEM_END_DATE | DATE | Ending date of the payment item. This is based on the Payment Line. | |||||
| PAYMENT_START_DATE | DATE | Date from which the first payment starts. | |||||
| PAYMENT_END_DATE | DATE | Date on which the payment ends. | |||||
| PRIMARY_INTENDED_USE | VARCHAR2 | 32 | Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level. | ||||
| PAYMENT_FREQUENCY_CODE | VARCHAR2 | 32 | Payment frequency code. | DW_FLA_PAYMENT_FREQUENCY_LKP_TL | PAYMENT_FREQUENCY_CODE | ||
| PAYMENT_STATUS_CODE | VARCHAR2 | 32 | Status of payment. | DW_FLA_PAYMENT_STATUS_LKP_TL | PAYMENT_STATUS_CODE | ||
| PAYMENT_PURPOSE_CODE | VARCHAR2 | 32 | Payment purpose. | DW_FLA_PAYMENT_PURPOSE_LKP_TL | PAYMENT_PURPOSE_CODE | ||
| OPTION_TYPE_CODE | VARCHAR2 | 32 | Option type code. | DW_FLA_LEASE_OPTION_TYPE_LKP_TL | LEASE_OPTION_TYPE_CODE | ||
| OPTION_STATUS_CODE | VARCHAR2 | 32 | Option status code. | DW_FLA_OPTION_STATUS_LKP_TL | LEASE_OPTION_STATUS_CODE | ||
| REVENUE_METHOD_CODE | VARCHAR2 | 32 | Indicates the method for spread of generated revenue. | DW_FLA_REVENUE_METHOD_CODE_LKP_TL | REVENUE_METHOD_CODE | ||
| PAYMENT_TYPE_CODE | VARCHAR2 | 32 | Payment type. | DW_FLA_PAYMENT_TYPE_LKP_TL | PAYMENT_TYPE_CODE | ||
| APPROVAL_STATUS_CODE | VARCHAR2 | 32 | Indicates if the payment item is approved for Payables invoice creation. | DW_FLA_PAY_ITEM_APPR_STATUS_LKP_TL | PAY_ITEM_APPR_STATUS_CODE | ||
| INVOICE_NUM | VARCHAR2 | 64 | Stores the invoice number generated and sent to Payables for the payment item. | ||||
| INVOICE_LINE_NUMBER | NUMBER | 38 | 0 | Stores the invoice line number generated and sent to Payables for the payment item. | |||
| REF_PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 | Purchase order number for reference purpose. | ||||
| PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 | Purchase order number | ||||
| PURCHASE_ORDER_LINE_NUMBER | NUMBER | Purchase Order Line number | |||||
| PAYMENT_TEMPLATE_NAME | VARCHAR2 | 512 | Payment term name. It describes the payment term name. | ||||
| ROU_ASSET_FLAG | VARCHAR2 | 16 | Indicates whether to generate right of use schedule for respective payment term or not. | DW_Y_N_D_TL | CODE | ||
| LIABILITY_FLAG | VARCHAR2 | 16 | Indicates if liability schedule for respective payment term should be generated or not. | DW_Y_N_D_TL | CODE | ||
| ARREARS_FLAG | VARCHAR2 | 16 | Indicates if the payment is in arrear or not. | DW_Y_N_D_TL | CODE | ||
| INTERCOMPANY_FLAG | VARCHAR2 | 16 | Intercompany flag. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_ACCOUNTED_FLAG | VARCHAR2 | 16 | Indicates if the payment item is transferred for accounting. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_ADJUSTMENT_FLAG | VARCHAR2 | 16 | Indicates if the payment item is created because of an adjustment. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_REVERSAL_FLAG | VARCHAR2 | 16 | Indicates if the payment item is created because of a reversal of generated payment items. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_FOR_STUB_FLAG | VARCHAR2 | 16 | Indicates whether the payment item was generated for a stub payment line. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_INTERCOMPANY_FLAG | VARCHAR2 | 16 | Intercompany flag. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_PRIMARY_INTENDED_USE | VARCHAR2 | 32 | Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level. | ||||
| OPTION_FLAG | VARCHAR2 | 16 | Option flag which indicates if the payment items are generated for an option or not. | DW_Y_N_D_TL | CODE | ||
| AMORTIZE_EXEMPT_PAYMENT_FLAG | VARCHAR2 | 16 | Flag to indicate if the exempt payment should be amortized over the term of the payment. | DW_Y_N_D_TL | CODE | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 32 | Tax classification code for payment term. | ||||
| TAX_INCLUDED_FLAG | VARCHAR2 | 16 | Indicates whether tax is included or not. | DW_Y_N_D_TL | CODE | ||
| PRODUCT_CATEGORY | VARCHAR2 | 256 | Identifies the taxable nature of a noninventory based item for tax determination or tax reporting. | ||||
| PRODUCT_FISCAL_CLASSIFICATION | VARCHAR2 | 256 | Tax Driver: Product fiscal classification | ||||
| PRODUCT_TYPE | VARCHAR2 | 256 | Tax Driver: Type of product. Possible values are Goods and Services. | ||||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 256 | Tax Driver: Transactions category assigned by user. | ||||
| USER_DEFINED_FISCAL_CLASS | VARCHAR2 | 256 | Tax Driver: Fiscal Classification. | ||||
| PAYMENT_SCHEDULE_TYPE_CODE | VARCHAR2 | 32 | Indicates the type of schedule. | DW_FLA_SCHEDULE_METHOD_CODE_LKP_TL | SCHEDULE_METHOD_CODE | ||
| ACCRUAL_PERIOD_NAME | VARCHAR2 | 16 | Accrual period in which accrual falls in. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| ACCRUAL_SCHEDULE_DATE | DATE | End date of the accrual period. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| SCHD_TRANSACTION_TYPE_CODE | VARCHAR2 | 32 | Transaction type. | DW_FLA_ACCT_TRN_TYPE_LKP_TL | TRANSACTION_TYPE_CODE | ||
| SCHD_TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 32 | Transaction sub type | DW_FLA_TRN_SUBTYPE_LKP_TL | TRANSACTION_SUBTYPE_CODE | ||
| LEASE_CLASSIFICATION_CODE | VARCHAR2 | 32 | Lease classification code. | DW_FLA_LEASE_CLASSIFICATION_LKP_TL | LEASE_CLASSIFICATION_CODE | ||
| ACCRUED_FLAG | VARCHAR2 | 16 | Indicates if schedules are accrued or not. | DW_Y_N_D_TL | CODE | ||
| ACCRUAL_REVERSAL_FLAG | VARCHAR2 | 16 | Indicates if this accrual is reversed, in case if amendment commencement date is earlier than latest accrual period. | DW_Y_N_D_TL | CODE | ||
| EXPIRED_ROU_FLAG | VARCHAR2 | 16 | Indicates if the right of use has expired because of an impairment. | DW_Y_N_D_TL | CODE | ||
| XLA_CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
| XLA_LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
| SUPPLIER_PARTY_ID | NUMBER | 38 | 0 | Party identifier |
Copyright © 2019, 2026, Oracle and/or its affiliates.