VIEW: AMS.AMS_DM_FINNUM_STG#

Source

View Text - Preformatted

select PARTY_ID PARTY_ID, GROSS_ANNUAL_INCOME GROSS_ANNUAL_INCOME, DEBT_TO_INCOME_RATIO DEBT_TO_INCOME_RATIO, NUM_CREDIT_LINES NUM_CREDIT_LINES, NUM_TRADE_LINES NUM_TRADE_LINES, NET_WORTH NET_WORTH, TOTAL_ASSETS TOTAL_ASSETS, TOT_DEBT_OUTSTANDING TOT_DEBT_OUTSTANDING, BANKRUPTCY_FLAG BANKRUPTCY_FLAG, HIGH_RISK_FRAUD_FLAG HIGH_RISK_FRAUD_FLAG, GROSS_ANNUAL_SALES GROSS_ANNUAL_SALES, GROWTH_RATE_SALES_YEAR GROWTH_RATE_SALES_YEAR, GROWTH_RATE_NET_PROF_YEAR GROWTH_RATE_NET_PROF_YEAR, CURRENT_ASSETS CURRENT_ASSETS, CURRENT_LIABILITIES CURRENT_LIABILITIES, TOTAL_DEBTS TOTAL_DEBTS, NET_PROFIT NET_PROFIT, TANGIBLE_NET_PROFIT TANGIBLE_NET_PROFIT, CAPITAL_AMOUNT CAPITAL_AMOUNT, CAPITAL_TYPE_INDICATOR CAPITAL_TYPE_INDICATOR, ACCOUNTS_RECEIVABLE ACCOUNTS_RECEIVABLE, RETAINED_EARNINGS RETAINED_EARNINGS from "AMS"."AMS_DM_FINNUM_STG"

View Text - HTML Formatted

SELECT PARTY_ID PARTY_ID
, GROSS_ANNUAL_INCOME GROSS_ANNUAL_INCOME
, DEBT_TO_INCOME_RATIO DEBT_TO_INCOME_RATIO
, NUM_CREDIT_LINES NUM_CREDIT_LINES
, NUM_TRADE_LINES NUM_TRADE_LINES
, NET_WORTH NET_WORTH
, TOTAL_ASSETS TOTAL_ASSETS
, TOT_DEBT_OUTSTANDING TOT_DEBT_OUTSTANDING
, BANKRUPTCY_FLAG BANKRUPTCY_FLAG
, HIGH_RISK_FRAUD_FLAG HIGH_RISK_FRAUD_FLAG
, GROSS_ANNUAL_SALES GROSS_ANNUAL_SALES
, GROWTH_RATE_SALES_YEAR GROWTH_RATE_SALES_YEAR
, GROWTH_RATE_NET_PROF_YEAR GROWTH_RATE_NET_PROF_YEAR
, CURRENT_ASSETS CURRENT_ASSETS
, CURRENT_LIABILITIES CURRENT_LIABILITIES
, TOTAL_DEBTS TOTAL_DEBTS
, NET_PROFIT NET_PROFIT
, TANGIBLE_NET_PROFIT TANGIBLE_NET_PROFIT
, CAPITAL_AMOUNT CAPITAL_AMOUNT
, CAPITAL_TYPE_INDICATOR CAPITAL_TYPE_INDICATOR
, ACCOUNTS_RECEIVABLE ACCOUNTS_RECEIVABLE
, RETAINED_EARNINGS RETAINED_EARNINGS
FROM "AMS"."AMS_DM_FINNUM_STG"