FA_XLA_EXT_LINES_B_GT

This is a temporary table which is used internally by Oracle.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

FA_XLA_EXT_LINES_B_GT_PK

EVENT_ID, LINE_NUMBER, LEDGER_ID

Columns

Name Datatype Length Precision Not-null Comments
EVENT_ID NUMBER 18 Yes Oracle internal use only.
LINE_NUMBER NUMBER 38 Yes Oracle internal use only.
BOOK_TYPE_CODE VARCHAR2 30 Oracle internal use only.
ASSET_NUMBER VARCHAR2 30 Oracle internal use only.
ASSET_ID NUMBER 18 Oracle internal use only.
OWNED_LEASED VARCHAR2 15 Oracle internal use only.
TAG_NUMBER VARCHAR2 15 Oracle internal use only.
SERIAL_NUMBER VARCHAR2 35 Oracle internal use only.
MODEL_NUMBER VARCHAR2 40 Oracle internal use only.
ASSET_TYPE VARCHAR2 11 Oracle internal use only.
PROPERTY_TYPE VARCHAR2 30 Oracle internal use only.
PROPERTY_CLASS VARCHAR2 4 Oracle internal use only.
MANUFACTURER_NAME VARCHAR2 360 Oracle internal use only.
CURRENT_UNITS NUMBER 18 Oracle internal use only.
NEW_USED VARCHAR2 4 Oracle internal use only.
INVENTORIAL VARCHAR2 3 Oracle internal use only.
IN_USE VARCHAR2 3 Oracle internal use only.
ASSET_CAT_ATTR_CAT_CODE VARCHAR2 210 Oracle internal use only.
ASSET_CAT_ATTR1 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR2 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR3 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR4 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR5 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR6 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR7 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR8 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR9 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR10 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR11 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR12 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR13 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR14 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR15 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR16 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR17 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR18 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR19 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR20 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR21 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR22 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR23 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR24 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR25 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR26 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR27 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR28 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR29 VARCHAR2 150 Oracle internal use only.
ASSET_CAT_ATTR30 VARCHAR2 150 Oracle internal use only.
DISTRIBUTION_ID NUMBER 18 Oracle internal use only.
ENTERED_AMOUNT NUMBER Oracle internal use only.
BONUS_ENTERED_AMOUNT NUMBER Oracle internal use only.
SOURCE_TYPE_CODE VARCHAR2 15 Oracle internal use only.
DEPRN_OVERRIDE_FLAG VARCHAR2 1 Oracle internal use only.
ADJUSTMENT_LINE_ID NUMBER 18 Oracle internal use only.
SOURCE_DEST_CODE VARCHAR2 15 Oracle internal use only.
SOURCE_LINE_ID NUMBER 18 Oracle internal use only.
ASSET_INVOICE_ID NUMBER 18 Oracle internal use only.
PAYABLES_CCID NUMBER 18 Oracle internal use only.
PO_VENDOR_ID NUMBER 18 Oracle internal use only.
PO_NUMBER VARCHAR2 30 Oracle internal use only.
INVOICE_DATE DATE Oracle internal use only.
INVOICE_NUMBER VARCHAR2 50 Oracle internal use only.
INVOICE_ID NUMBER 18 Oracle internal use only.
INVOICE_LINE_NUMBER NUMBER 18 Oracle internal use only.
INVOICE_DISTRIBUTION_ID NUMBER 18 Oracle internal use only.
AP_DISTRIBUTION_LINE_NUMBER NUMBER 18 Oracle internal use only.
PROJECT_ID NUMBER 18 Oracle internal use only.
TASK_ID NUMBER 18 Oracle internal use only.
PROJECT_ASSET_LINE_ID NUMBER 18 Oracle internal use only.
FEEDER_SYSTEM_NAME VARCHAR2 40 Oracle internal use only.
ASSET_INVOICES_ATTR1 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR2 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR3 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR4 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR5 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR6 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR7 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR8 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR9 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR10 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR11 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR12 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR13 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR14 VARCHAR2 150 Oracle internal use only.
ASSET_INVOICES_ATTR15 VARCHAR2 150 Oracle internal use only.
DATE_PLACED_IN_SERVICE DATE Oracle internal use only.
CONVERSION_DATE DATE Oracle internal use only.
SHORT_FISCAL_YEAR_FLAG VARCHAR2 3 Oracle internal use only.
COST NUMBER Oracle internal use only.
GROUP_ASSET_ID NUMBER 18 Oracle internal use only.
TRACKING_METHOD VARCHAR2 30 Oracle internal use only.
CAT_FLEXFIELD_SEGMENT1 VARCHAR2 30 Oracle internal use only.
CAT_FLEXFIELD_SEGMENT2 VARCHAR2 30 Oracle internal use only.
CAT_FLEXFIELD_SEGMENT3 VARCHAR2 30 Oracle internal use only.
CAT_FLEXFIELD_SEGMENT4 VARCHAR2 30 Oracle internal use only.
CAT_FLEXFIELD_SEGMENT5 VARCHAR2 30 Oracle internal use only.
CAT_FLEXFIELD_SEGMENT6 VARCHAR2 30 Oracle internal use only.
CAT_FLEXFIELD_SEGMENT7 VARCHAR2 30 Oracle internal use only.
CAT_ID NUMBER 18 Oracle internal use only.
CAT_TYPE VARCHAR2 30 Oracle internal use only.
CAT_ATTR1 VARCHAR2 150 Oracle internal use only.
CAT_ATTR2 VARCHAR2 150 Oracle internal use only.
CAT_ATTR3 VARCHAR2 150 Oracle internal use only.
CAT_ATTR4 VARCHAR2 150 Oracle internal use only.
CAT_ATTR5 VARCHAR2 150 Oracle internal use only.
CAT_ATTR6 VARCHAR2 150 Oracle internal use only.
CAT_ATTR7 VARCHAR2 150 Oracle internal use only.
CAT_ATTR8 VARCHAR2 150 Oracle internal use only.
CAT_ATTR9 VARCHAR2 150 Oracle internal use only.
CAT_ATTR10 VARCHAR2 150 Oracle internal use only.
CAT_ATTR11 VARCHAR2 150 Oracle internal use only.
CAT_ATTR12 VARCHAR2 150 Oracle internal use only.
CAT_ATTR13 VARCHAR2 150 Oracle internal use only.
CAT_ATTR14 VARCHAR2 150 Oracle internal use only.
CAT_ATTR15 VARCHAR2 150 Oracle internal use only.
BONUS_RESERVE_ACCT_CCID NUMBER 18 Oracle internal use only.
ASSET_COST_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
ASSET_CLEARING_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
CIP_COST_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
CIP_CLEARING_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
RESERVE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
DEPRN_EXPENSE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
BONUS_EXPENSE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
UNPLAN_EXPENSE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
CAT_BOOKS_ATTR1 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR2 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR3 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR4 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR5 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR6 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR7 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR8 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR9 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR10 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR11 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR12 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR13 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR14 VARCHAR2 150 Oracle internal use only.
CAT_BOOKS_ATTR15 VARCHAR2 150 Oracle internal use only.
EXPENSE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
UNITS_ASSIGNED NUMBER 18 Oracle internal use only.
EMPLOYEE_ID NUMBER 18 Oracle internal use only.
LOCATION_ID NUMBER 18 Oracle internal use only.
LOCATION_KEY_SEGMENT1 VARCHAR2 30 Oracle internal use only.
LOCATION_KEY_SEGMENT2 VARCHAR2 30 Oracle internal use only.
LOCATION_KEY_SEGMENT3 VARCHAR2 30 Oracle internal use only.
LOCATION_KEY_SEGMENT4 VARCHAR2 30 Oracle internal use only.
LOCATION_KEY_SEGMENT5 VARCHAR2 30 Oracle internal use only.
LOCATION_KEY_SEGMENT6 VARCHAR2 30 Oracle internal use only.
LOCATION_KEY_SEGMENT7 VARCHAR2 30 Oracle internal use only.
LOCATIONS_ATTR1 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR2 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR3 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR4 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR5 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR6 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR7 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR8 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR9 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR10 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR11 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR12 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR13 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR14 VARCHAR2 150 Oracle internal use only.
LOCATIONS_ATTR15 VARCHAR2 150 Oracle internal use only.
BONUS_RESERVE_RETIRED NUMBER Oracle internal use only.
COST_RETIRED NUMBER Oracle internal use only.
NBV_RETIRED NUMBER Oracle internal use only.
GAIN_LOSS_AMOUNT NUMBER Oracle internal use only.
PROCEEDS_OF_SALE_AMOUNT NUMBER Oracle internal use only.
COST_OF_REMOVAL_AMOUNT NUMBER Oracle internal use only.
RETIREMENT_TYPE VARCHAR2 30 Oracle internal use only.
RETIREMENTS_ATTR1 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR2 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR3 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR4 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR5 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR6 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR7 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR8 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR9 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR10 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR11 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR12 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR13 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR14 VARCHAR2 150 Oracle internal use only.
RETIREMENTS_ATTR15 VARCHAR2 150 Oracle internal use only.
TRANSACTION_HEADER_ID NUMBER 18 Oracle internal use only.
TRANSACTION_TYPE_CODE VARCHAR2 20 Oracle internal use only.
TRANSACTION_SUBTYPE VARCHAR2 30 Oracle internal use only.
TRANSACTION_KEY VARCHAR2 2 Oracle internal use only.
TRANSACTION_NAME VARCHAR2 240 Oracle internal use only.
SOURCE_TRANSACTION_HEADER_ID NUMBER 18 Oracle internal use only.
CALLING_INTERFACE VARCHAR2 30 Oracle internal use only.
AMORTIZATION_START_DATE DATE Oracle internal use only.
TRANSACTIONS_ATTR1 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR2 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR3 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR4 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR5 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR6 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR7 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR8 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR9 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR10 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR11 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR12 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR13 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR14 VARCHAR2 150 Oracle internal use only.
TRANSACTIONS_ATTR15 VARCHAR2 150 Oracle internal use only.
ASSET_KEY_CCID NUMBER 18 Oracle internal use only.
ASSET_KEY_SEGMENT1 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT2 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT3 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT4 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT5 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT6 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT7 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT8 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT9 VARCHAR2 30 Oracle internal use only.
ASSET_KEY_SEGMENT10 VARCHAR2 30 Oracle internal use only.
DEPRN_BASIS_RULE_ID NUMBER 18 Oracle internal use only.
PRORATE_DATE DATE Oracle internal use only.
REFERENCE_NUM VARCHAR2 15 Oracle internal use only.
SOLD_TO VARCHAR2 30 Oracle internal use only.
TRADE_IN_ASSET_ID NUMBER 18 Oracle internal use only.
CURRENCY_CODE VARCHAR2 15 Oracle internal use only.
GENERATED_CCID NUMBER 18 Oracle internal use only.
LEDGER_ID NUMBER 18 Yes Oracle internal use only.
DISTRIBUTION_TYPE_CODE VARCHAR2 30 Oracle internal use only.
TRANSACTION_REFERENCE_ID NUMBER 18 Oracle internal use only.
ADJUSTMENT_TYPE VARCHAR2 15 Oracle internal use only.
DEPRN_RUN_ID NUMBER 18 Oracle internal use only.
TAX_BOOK_TYPE_CODE VARCHAR2 30 Oracle internal use only.
IMPAIR_EXPENSE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
IMPAIR_RESERVE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
OVERRIDE_ACCOUNT_SEGMENT VARCHAR2 25 Oracle internal use only.
CAPITAL_ADJ_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
GENERAL_FUND_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
REVAL_RESERVE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
REVAL_AMORT_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
REVAL_LOSS_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
REVAL_ENTERED_AMOUNT NUMBER Oracle internal use only.
INSERTION_ORDER NUMBER 18 Oracle internal use only.
LEASE_LIABILITY_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
LEASE_GAIN_LOSS_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
LEASE_CLEARING_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
LEASE_EXPENSE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
LEASE_INT_EXPENSE_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
LEASE_LIABILITY_ENTERED_AMOUNT NUMBER Oracle internal use only.
DEPRN_RESERVE_ENTERED_AMOUNT NUMBER Oracle internal use only.
LEASE_RUN_ID NUMBER 18 Oracle internal use only.
LEASE_TYPE_CODE VARCHAR2 30 Oracle internal use only.
PERIODIC_LEASE_LIABILITY_AMT NUMBER Oracle internal use only.
PERIODIC_LEASE_CLEARING_AMOUNT NUMBER Oracle internal use only.
LEASE_RATE_GAIN_LOSS_AMOUNT NUMBER Oracle internal use only.
LEASE_RATE_GAIN_LOSS_ACCT_CCID NUMBER 18 Oracle internal use only.
COST_WRITE_OFF_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
REVALUED_COST_ACCOUNT_CCID NUMBER 18 Default account used to record the revalued asset cost.
BACKLOG_DEPRN_RSV_ACCT_CCID NUMBER 18 Default account used to record the revaluation of the prior year accumulated depreciation.
COUNTERPARTY_EXPENSE_ACCT_CCID NUMBER 18 Oracle internal use only.
ANNUITY_INT_ENTERED_AMOUNT NUMBER Oracle internal use only.
ANNUITY_INT_EXP_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
ANNUITY_INT_REV_ACCOUNT_CCID NUMBER 18 Oracle internal use only.
COUNTERPARTY_BAL_SEG_VAL1 VARCHAR2 25 Oracle internal use only.
COUNTERPARTY_BAL_SEG_VAL2 VARCHAR2 25 Oracle internal use only.
COUNTERPARTY_BAL_SEG_VAL3 VARCHAR2 25 Oracle internal use only.
COUNTERPARTY_CC_SEG_VAL VARCHAR2 25 Oracle internal use only.

Indexes

Index Uniqueness Columns
FA_XLA_EXT_LINES_B_GT_U1 Unique EVENT_ID, LINE_NUMBER, LEDGER_ID