Skip to content

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

TABLE: FEM.FEM_CUST_FINANCIAL_INFO

Object Details
Object Name: FEM_CUST_FINANCIAL_INFO
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID


Customer Financial Information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_CUST_FINANCIAL_INFO_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnLEDGER_ID
ColumnCUSTOMER_ID
FEM_CUST_FINANCIAL_INFO_01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATED_BY_REQUEST_ID
ColumnCREATED_BY_OBJECT_ID
ColumnCUSTOMER_ID
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_ID NUMBER
Yes Calendar Period
DATASET_CODE NUMBER
Yes Dataset Code
SOURCE_SYSTEM_CODE NUMBER
Yes Source System Code (Identifies the source system from where the data is coming).
LEDGER_ID NUMBER
Yes Ledger
CUSTOMER_ID NUMBER
Yes Unique numeric identifier of the Customer
CREATED_BY_OBJECT_ID NUMBER (9) Yes Object that created the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
CREATED_BY_REQUEST_ID NUMBER
Yes Request that created the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
LAST_UPDATED_BY_OBJECT_ID NUMBER (9) Yes Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
LAST_UPDATED_BY_REQUEST_ID NUMBER
Yes Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
GEOGRAPHY_ID NUMBER

Geographic Location
USE_TOTAL_ASSETS_FLAG VARCHAR2 (30)
Flag indicating whether Total Assets or Total Sales in calculating Firm Size Adjustment.
ASSETS_CPI NUMBER

Assets Consumer Price Index
CASH_AND_EQUIVALENTS NUMBER

Cash and Equivalents
CASH_ASSETS NUMBER

Cash to Assets Ratio
COST_OF_GOODS_SOLD NUMBER

Cost of Goods Sold
CURRENT_ASSETS NUMBER

Current Customer Assets
CURRENT_LIABILITIES NUMBER

Current Customer Liabilities
DEBT_SERVICES_COVERAGE_RATIO NUMBER

Debt Services Coverage Ratio
EBIT NUMBER

Earnings Before Interest and Taxes
EXTERNAL_PD NUMBER

External Probability of Default
EXTRAODINARY_ITEMS NUMBER

Extraordinary Items of a Customer
FISCAL_YEAR NUMBER (5)
Fiscal Year
INTEREST_EXPENSES NUMBER

Interest Expenses of a Customer
INVENTORIES_COGS NUMBER

Customer Inventories to Cost of Goods Sold
INVENTORY NUMBER

Inventory
LIABILITIES NUMBER

Liabilities of a Customer
LIABILITIES_ASSETS NUMBER

Liabilities to Assets Ratio of a Customer
NET_INCOME NUMBER

Total Earnings
NET_INCOME_ASSETS NUMBER

Net Income to Assets Ratio of a Customer
NET_INCOME_GROWTH NUMBER

Net Income growth percentage of a Customer
QUICK_RATIO NUMBER

Quick Ratio of Customer
REPORTED_DATE DATE

Reporting date of Information
RETAINED_EARNINGS NUMBER

Retained Earnings
RETAINED_EARNINGS_ASSETS NUMBER

Retained Earnings to Assets ratio
SALES_GROWTH NUMBER

Customer Sales to growth ratio.
TOTAL_ASSETS NUMBER

Total Assets of a Customer
TOTAL_SALES NUMBER

Total Sales of a Customer
ALPHANUMERIC_MEASURE01 VARCHAR2 (4000)
Alphanumeric Measure1
ALPHANUMERIC_MEASURE02 VARCHAR2 (4000)
Alphanumeric Measure2
ALPHANUMERIC_MEASURE03 VARCHAR2 (4000)
Alphanumeric Measure3
ALPHANUMERIC_MEASURE04 VARCHAR2 (4000)
Alphanumeric Measure4
ALPHANUMERIC_MEASURE05 VARCHAR2 (4000)
Alphanumeric Measure5
ALPHANUMERIC_MEASURE06 VARCHAR2 (4000)
Alphanumeric Measure6
ALPHANUMERIC_MEASURE07 VARCHAR2 (4000)
Alphanumeric Measure7
ALPHANUMERIC_MEASURE08 VARCHAR2 (4000)
Alphanumeric Measure8
ALPHANUMERIC_MEASURE09 VARCHAR2 (4000)
Alphanumeric Measure9
ALPHANUMERIC_MEASURE10 VARCHAR2 (4000)
Alphanumeric Measure10
DATE_MEASURE01 DATE

Date Measure1
DATE_MEASURE02 DATE

Date Measure2
DATE_MEASURE03 DATE

Date Measure3
DATE_MEASURE04 DATE

Date Measure4
DATE_MEASURE05 DATE

Date Measure5
DATE_MEASURE06 DATE

Date Measure6
DATE_MEASURE07 DATE

Date Measure7
DATE_MEASURE08 DATE

Date Measure8
DATE_MEASURE09 DATE

Date Measure9
DATE_MEASURE10 DATE

Date Measure10
NUMERIC_MEASURE01 NUMBER

Numeric Measure1
NUMERIC_MEASURE02 NUMBER

Numeric Measure2
NUMERIC_MEASURE03 NUMBER

Numeric Measure3
NUMERIC_MEASURE04 NUMBER

Numeric Measure4
NUMERIC_MEASURE05 NUMBER

Numeric Measure5
NUMERIC_MEASURE06 NUMBER

Numeric Measure6
NUMERIC_MEASURE07 NUMBER

Numeric Measure7
NUMERIC_MEASURE08 NUMBER

Numeric Measure8
NUMERIC_MEASURE09 NUMBER

Numeric Measure9
NUMERIC_MEASURE10 NUMBER

Numeric Measure10
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CAL_PERIOD_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      LEDGER_ID
,      CUSTOMER_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      CURRENCY_CODE
,      GEOGRAPHY_ID
,      USE_TOTAL_ASSETS_FLAG
,      ASSETS_CPI
,      CASH_AND_EQUIVALENTS
,      CASH_ASSETS
,      COST_OF_GOODS_SOLD
,      CURRENT_ASSETS
,      CURRENT_LIABILITIES
,      DEBT_SERVICES_COVERAGE_RATIO
,      EBIT
,      EXTERNAL_PD
,      EXTRAODINARY_ITEMS
,      FISCAL_YEAR
,      INTEREST_EXPENSES
,      INVENTORIES_COGS
,      INVENTORY
,      LIABILITIES
,      LIABILITIES_ASSETS
,      NET_INCOME
,      NET_INCOME_ASSETS
,      NET_INCOME_GROWTH
,      QUICK_RATIO
,      REPORTED_DATE
,      RETAINED_EARNINGS
,      RETAINED_EARNINGS_ASSETS
,      SALES_GROWTH
,      TOTAL_ASSETS
,      TOTAL_SALES
,      ALPHANUMERIC_MEASURE01
,      ALPHANUMERIC_MEASURE02
,      ALPHANUMERIC_MEASURE03
,      ALPHANUMERIC_MEASURE04
,      ALPHANUMERIC_MEASURE05
,      ALPHANUMERIC_MEASURE06
,      ALPHANUMERIC_MEASURE07
,      ALPHANUMERIC_MEASURE08
,      ALPHANUMERIC_MEASURE09
,      ALPHANUMERIC_MEASURE10
,      DATE_MEASURE01
,      DATE_MEASURE02
,      DATE_MEASURE03
,      DATE_MEASURE04
,      DATE_MEASURE05
,      DATE_MEASURE06
,      DATE_MEASURE07
,      DATE_MEASURE08
,      DATE_MEASURE09
,      DATE_MEASURE10
,      NUMERIC_MEASURE01
,      NUMERIC_MEASURE02
,      NUMERIC_MEASURE03
,      NUMERIC_MEASURE04
,      NUMERIC_MEASURE05
,      NUMERIC_MEASURE06
,      NUMERIC_MEASURE07
,      NUMERIC_MEASURE08
,      NUMERIC_MEASURE09
,      NUMERIC_MEASURE10
FROM FEM.FEM_CUST_FINANCIAL_INFO;

Dependencies

[top of page]

FEM.FEM_CUST_FINANCIAL_INFO does not reference any database object

FEM.FEM_CUST_FINANCIAL_INFO is referenced by following:

SchemaAPPS
SynonymFEM_CUST_FINANCIAL_INFO