[Home] [Help] [Dependency Information]
Object Name: | AR_CMGT_FINANCIAL_DATA# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FINANCIAL_DATA_ID | NUMBER | (15) | Yes | |
CREDIT_REQUEST_ID | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REPORTING_CURRENCY | VARCHAR2 | (30) | ||
MONETARY_UNIT | NUMBER | |||
CURR_FIN_ST_DATE | DATE | |||
REPORTING_PERIOD | VARCHAR2 | (30) | ||
CASH | NUMBER | |||
ACCOUNTS_PAYABLE | NUMBER | |||
NET_RECEIVABLES | NUMBER | |||
SHORT_TERM_DEBT | NUMBER | |||
INVENTORIES | NUMBER | |||
OTHER_CUR_LIABILITIES | NUMBER | |||
OTHER_CUR_ASSETS | NUMBER | |||
TOTAL_CUR_LIABILITIES | NUMBER | |||
TOTAL_CUR_ASSETS | NUMBER | |||
LONG_TERM_DEBT | NUMBER | |||
NET_FIXED_ASSETS | NUMBER | |||
OTHER_NON_CUR_LIABILITIES | NUMBER | |||
OTHER_NON_CUR_ASSETS | NUMBER | |||
TOTAL_LIABILITIES | NUMBER | |||
TOTAL_ASSETS | NUMBER | |||
STOCKHOLDER_EQUITY | NUMBER | |||
TOTAL_LIABILITIES_EQUITY | NUMBER | |||
REVENUE | NUMBER | |||
NON_OPERATING_INCOME | NUMBER | |||
COST_OF_GOODS_SOLD | NUMBER | |||
NON_OPERATING_EXPENSES | NUMBER | |||
SGA_EXPENSES | NUMBER | |||
PRE_TAX_NET_INCOME | NUMBER | |||
OPERATING_INCOME | NUMBER | |||
INCOME_TAXES | NUMBER | |||
OPERATING_MARGIN | NUMBER | |||
NET_INCOME | NUMBER | |||
EARNINGS_PER_SHARE | NUMBER | |||
CASE_FOLDER_ID | NUMBER | (15) | ||
PARTY_ID | NUMBER | (15) | ||
CUST_ACCOUNT_ID | NUMBER | (15) | ||
SITE_USE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT FINANCIAL_DATA_ID
, CREDIT_REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REPORTING_CURRENCY
, MONETARY_UNIT
, CURR_FIN_ST_DATE
, REPORTING_PERIOD
, CASH
, ACCOUNTS_PAYABLE
, NET_RECEIVABLES
, SHORT_TERM_DEBT
, INVENTORIES
, OTHER_CUR_LIABILITIES
, OTHER_CUR_ASSETS
, TOTAL_CUR_LIABILITIES
, TOTAL_CUR_ASSETS
, LONG_TERM_DEBT
, NET_FIXED_ASSETS
, OTHER_NON_CUR_LIABILITIES
, OTHER_NON_CUR_ASSETS
, TOTAL_LIABILITIES
, TOTAL_ASSETS
, STOCKHOLDER_EQUITY
, TOTAL_LIABILITIES_EQUITY
, REVENUE
, NON_OPERATING_INCOME
, COST_OF_GOODS_SOLD
, NON_OPERATING_EXPENSES
, SGA_EXPENSES
, PRE_TAX_NET_INCOME
, OPERATING_INCOME
, INCOME_TAXES
, OPERATING_MARGIN
, NET_INCOME
, EARNINGS_PER_SHARE
, CASE_FOLDER_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, SITE_USE_ID
FROM AR.AR_CMGT_FINANCIAL_DATA#;
|
|
|