eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: AR.AR_CMGT_FINANCIAL_DATA#

Source

View Text - Preformatted


select FINANCIAL_DATA_ID FINANCIAL_DATA_ID, CREDIT_REQUEST_ID CREDIT_REQUEST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REPORTING_CURRENCY REPORTING_CURRENCY, MONETARY_UNIT MONETARY_UNIT, CURR_FIN_ST_DATE CURR_FIN_ST_DATE, REPORTING_PERIOD REPORTING_PERIOD, CASH CASH, ACCOUNTS_PAYABLE ACCOUNTS_PAYABLE, NET_RECEIVABLES NET_RECEIVABLES, SHORT_TERM_DEBT SHORT_TERM_DEBT, INVENTORIES INVENTORIES, OTHER_CUR_LIABILITIES OTHER_CUR_LIABILITIES, OTHER_CUR_ASSETS OTHER_CUR_ASSETS, TOTAL_CUR_LIABILITIES TOTAL_CUR_LIABILITIES, TOTAL_CUR_ASSETS TOTAL_CUR_ASSETS, LONG_TERM_DEBT LONG_TERM_DEBT, NET_FIXED_ASSETS NET_FIXED_ASSETS, OTHER_NON_CUR_LIABILITIES OTHER_NON_CUR_LIABILITIES, OTHER_NON_CUR_ASSETS OTHER_NON_CUR_ASSETS, TOTAL_LIABILITIES TOTAL_LIABILITIES, TOTAL_ASSETS TOTAL_ASSETS, STOCKHOLDER_EQUITY STOCKHOLDER_EQUITY, TOTAL_LIABILITIES_EQUITY TOTAL_LIABILITIES_EQUITY, REVENUE REVENUE, NON_OPERATING_INCOME NON_OPERATING_INCOME, COST_OF_GOODS_SOLD COST_OF_GOODS_SOLD, NON_OPERATING_EXPENSES NON_OPERATING_EXPENSES, SGA_EXPENSES SGA_EXPENSES, PRE_TAX_NET_INCOME PRE_TAX_NET_INCOME, OPERATING_INCOME OPERATING_INCOME, INCOME_TAXES INCOME_TAXES, OPERATING_MARGIN OPERATING_MARGIN, NET_INCOME NET_INCOME, EARNINGS_PER_SHARE EARNINGS_PER_SHARE, CASE_FOLDER_ID CASE_FOLDER_ID, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, SITE_USE_ID SITE_USE_ID from "AR"."AR_CMGT_FINANCIAL_DATA"

View Text - HTML Formatted

SELECT FINANCIAL_DATA_ID FINANCIAL_DATA_ID
, CREDIT_REQUEST_ID CREDIT_REQUEST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REPORTING_CURRENCY REPORTING_CURRENCY
, MONETARY_UNIT MONETARY_UNIT
, CURR_FIN_ST_DATE CURR_FIN_ST_DATE
, REPORTING_PERIOD REPORTING_PERIOD
, CASH CASH
, ACCOUNTS_PAYABLE ACCOUNTS_PAYABLE
, NET_RECEIVABLES NET_RECEIVABLES
, SHORT_TERM_DEBT SHORT_TERM_DEBT
, INVENTORIES INVENTORIES
, OTHER_CUR_LIABILITIES OTHER_CUR_LIABILITIES
, OTHER_CUR_ASSETS OTHER_CUR_ASSETS
, TOTAL_CUR_LIABILITIES TOTAL_CUR_LIABILITIES
, TOTAL_CUR_ASSETS TOTAL_CUR_ASSETS
, LONG_TERM_DEBT LONG_TERM_DEBT
, NET_FIXED_ASSETS NET_FIXED_ASSETS
, OTHER_NON_CUR_LIABILITIES OTHER_NON_CUR_LIABILITIES
, OTHER_NON_CUR_ASSETS OTHER_NON_CUR_ASSETS
, TOTAL_LIABILITIES TOTAL_LIABILITIES
, TOTAL_ASSETS TOTAL_ASSETS
, STOCKHOLDER_EQUITY STOCKHOLDER_EQUITY
, TOTAL_LIABILITIES_EQUITY TOTAL_LIABILITIES_EQUITY
, REVENUE REVENUE
, NON_OPERATING_INCOME NON_OPERATING_INCOME
, COST_OF_GOODS_SOLD COST_OF_GOODS_SOLD
, NON_OPERATING_EXPENSES NON_OPERATING_EXPENSES
, SGA_EXPENSES SGA_EXPENSES
, PRE_TAX_NET_INCOME PRE_TAX_NET_INCOME
, OPERATING_INCOME OPERATING_INCOME
, INCOME_TAXES INCOME_TAXES
, OPERATING_MARGIN OPERATING_MARGIN
, NET_INCOME NET_INCOME
, EARNINGS_PER_SHARE EARNINGS_PER_SHARE
, CASE_FOLDER_ID CASE_FOLDER_ID
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SITE_USE_ID SITE_USE_ID
FROM "AR"."AR_CMGT_FINANCIAL_DATA"