CST_XLA_DISTRIBUTION_LINES_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
DISTRIBUTION_LINE_ID DISTRIBUTION_ID CODE_COMBINATION_ID COST_ELEMENT_ID ENTERED_CURRENCY_AMOUNT LEDGER_AMOUNT EVENT_ID TRANSACTION_COST_ID LINE_NUMBER ACCOUNTING_LINE_TYPE ENTERED_CURRENCY_CODE EXCHANGE_RATE EXCHANGE_DATE EXCHANGE_RATE_TYPE COST_ID SOURCE_TABLE NEG_ENTERED_CURRENCY_AMOUNT NEG_LEDGER_AMOUNT

Query

SQL_Statement

SELECT distribution_line_id distribution_line_id , distribution_id distribution_id , code_combination_id code_combination_id , cost_element_id cost_element_id , entered_currency_amount entered_currency_amount , ledger_amount ledger_amount , event_id event_id , transaction_cost_id transaction_cost_id , line_number line_number , accounting_line_type accounting_line_type , entered_currency_code entered_currency_code , exchange_rate exchange_rate , exchange_date exchange_date , exchange_rate_type exchange_rate_type , cost_id cost_id , source_table source_table, -1 * entered_currency_amount neg_entered_currency_amount , -1 * ledger_amount neg_ledger_amount FROM cst_cost_distribution_lines