DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.AR_CMGT_FINANCIAL_DATA

Object Details
Object Name: AR_CMGT_FINANCIAL_DATA
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_CMGT_FINANCIAL_DATA
Subobject Name:
Status: VALID


The AR_CMGT_FINANCIAL_DATA table stores financial statements information about the company under credit review. This data is usually found in the company's Annual Report or via a credit agency service. Storing this information lets you compare financial statements data over time during subsequent credit reviews.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CMGT_FINANCIAL_DATA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFINANCIAL_DATA_ID
AR_CMGT_FINANCIAL_DATA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREDIT_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
FINANCIAL_DATA_ID NUMBER (15) Yes Identifier of the financial statements data entered during the credit review.
CREDIT_REQUEST_ID NUMBER (15) Yes Identifier of the credit request. Foreign key to the AR_CMGT_CREDIT_REQUESTS table.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REPORTING_CURRENCY VARCHAR2 (30)
Currency used on the financial statement data.
MONETARY_UNIT NUMBER

Currency multiplier for the market capitalization amount. E.g.For example, 000 indicates that the amount is multiplied by 1000.
CURR_FIN_ST_DATE DATE

End date of the period for the financial statement.
REPORTING_PERIOD VARCHAR2 (30)
Length of time represented on the financial statement, e.g.,such as Annual, Quarterly, Month-to-date, Year-to-date
CASH NUMBER

Value of Cash on the financial statement
ACCOUNTS_PAYABLE NUMBER

Value of Accounts Payable on the financial statement
NET_RECEIVABLES NUMBER

Net Receivables amount on the financial statement.
SHORT_TERM_DEBT NUMBER

Short Term Debt amount on the financial statement.
INVENTORIES NUMBER

Value of Inventory on the financial statement.
OTHER_CUR_LIABILITIES NUMBER

Value of Current Liabilities on the financial statement.
OTHER_CUR_ASSETS NUMBER

Value of Other Current Assets on the financial statement.
TOTAL_CUR_LIABILITIES NUMBER

Value of Total Current Liabilities on the financial statement.
TOTAL_CUR_ASSETS NUMBER

Value of Total Current Assets on the financial statement.
LONG_TERM_DEBT NUMBER

Value of Long Term Debt on the financial statement.
NET_FIXED_ASSETS NUMBER

Value of Net Fixed Assets on the financial statement.
OTHER_NON_CUR_LIABILITIES NUMBER

Value of Other Non-Current Liabilities on the financial statement.
OTHER_NON_CUR_ASSETS NUMBER

Value of Other Non-Current Assets on the financial statement.
TOTAL_LIABILITIES NUMBER

Value of Total Liabilities on the financial statement
TOTAL_ASSETS NUMBER

Value of Total Assets on the financial statement
STOCKHOLDER_EQUITY NUMBER

Value of Stockholders Equity on the financial statement
TOTAL_LIABILITIES_EQUITY NUMBER

Value of Total Liabilities & Stockholders Equity on the financial statement
REVENUE NUMBER

Value of Revenue on the financial statement
NON_OPERATING_INCOME NUMBER

Value of Non-Operating Income on the financial statement
COST_OF_GOODS_SOLD NUMBER

Value of Cost of Goods Sold on the financial statement
NON_OPERATING_EXPENSES NUMBER

Value of Non-Operating Expenses on the financial statement
SGA_EXPENSES NUMBER

Value of Operating Expenses on the financial statement
PRE_TAX_NET_INCOME NUMBER

Value of Net Income Before Taxes on the financial statement
OPERATING_INCOME NUMBER

Value of Operating Income on the financial statement
INCOME_TAXES NUMBER

Value of Income Tax on the financial statement
OPERATING_MARGIN NUMBER

Value of Gross Margin on the financial statement
NET_INCOME NUMBER

Value of Net Income on the financial statement
EARNINGS_PER_SHARE NUMBER

Value of Earnings Per Share on the financial statement
CASE_FOLDER_ID NUMBER (15)
Identifier of the credit review case folder. Foreign key to the AR_CMGT_CASE_FOLDERS table.
PARTY_ID NUMBER (15)
Party identifier
CUST_ACCOUNT_ID NUMBER (15)
Customer account identifier
SITE_USE_ID NUMBER (15)
Customer site identifier
Query Text

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;

Dependencies

[top of page]

AR.AR_CMGT_FINANCIAL_DATA does not reference any database object

AR.AR_CMGT_FINANCIAL_DATA is referenced by following:

SchemaAPPS
SynonymAR_CMGT_FINANCIAL_DATA