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.

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

TABLE: JA.JA_CN_CFS_ACTIVITIES_ALL

Object Details

Object Name:	JA_CN_CFS_ACTIVITIES_ALL
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JA_CN_CFS_ACTIVITIES_ALL
Subobject Name:
Status:	VALID

The 'JA_CN_CFS_ACTIVITIES_ALL' table stores transaction information related to detailed cash flow items, data in the table are based on detailed transactions or transaction lines and belong to a specific legal entity, so they can be used for the intention of audit or reconciliation. Also, 'Cash flow statement program' will calculate amount of final cash flow items and generate 'Cash flow statement' upon this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JA_CN_CFS_ACTIVITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CFS_ACTIVITY_ID
JA_CN_CFS_ACTIVITIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DETAILED_CFS_ITEM
JA_CN_CFS_ACTIVITIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY_ID PERIOD_NAME SOURCE

Columns

Name	Datatype	Length	Mandatory	Comments
CFS_ACTIVITY_ID	NUMBER		Yes	Identifier for each record
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Identifier of legal entity
LEDGER_ID	NUMBER	(15)	Yes	Ledger ID
ORG_ID	NUMBER	(15)		Identifier of operating unit
TRX_ID	NUMBER	(15)		Transaction id
TRX_NUMBER	VARCHAR2	(100)		Transition number
TRX_LINE_ID	VARCHAR2	(16)		Transaction line id
TRANSACTION_TYPE	VARCHAR2	(20)		Transaction type
DOCUMENT_SEQUENCE_NUMBER	NUMBER			Document sequence number
TRANSACTION_DATE	DATE		Yes	Transaction date
GL_DATE	DATE		Yes	GL date
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
FUNC_CURR_CODE	VARCHAR2	(15)	Yes	Functional currency code
FUNC_AMOUNT	NUMBER		Yes	Amount in functional currency code
ORIGINAL_CURR_CODE	VARCHAR2	(15)	Yes	Original currency code
ORIGINAL_AMOUNT	NUMBER		Yes	Amount in original currency code
CURRENCY_CONVERSION_RATE	NUMBER			Exchange rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Exchange rate type
CURRENCY_CONVERSION_DATE	DATE			Date of exchange rate
DESCRIPTION	VARCHAR2	(240)		Description of transaction line
DETAILED_CFS_ITEM	VARCHAR2	(150)	Yes	Detailed cash flow item
INTERCOMPANY_FLAG	VARCHAR2	(1)		A flag to indicate if current transaction is intercompany or not, if yes, then 'Y', otherwise 'N'
REFERENCE_NUMBER	VARCHAR2	(100)		Check Number For AP/ Receipt Number for AR
THIRD_PARTY_NAME	VARCHAR2	(360)		Customer Name for AR/ Vendor Name for AP
THIRD_PARTY_NUMBER	VARCHAR2	(30)		Customer Number for AR/ Vendor Number for AP
EVENT_CLASS_CODE	VARCHAR2	(30)		Event class code
SOURCE_APPLICATION_ID	NUMBER	(15)		Internal id of the application
ANALYTICAL_CRITERION_CODE	VARCHAR2	(30)		Analytical criterion code
SOURCE_VALUE	VARCHAR2	(30)		Item source
CASH_ITEM_DESC	VARCHAR2	(240)		Cash flow item description
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
SOURCE	VARCHAR2	(50)		Transaction Source
UPGRADE_FLAG	VARCHAR2	(1)		Upgrade flag
BALANCING_SEGMENT	VARCHAR2	(25)		Balance segment value

Query Text

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


SELECT CFS_ACTIVITY_ID
,      LEGAL_ENTITY_ID
,      LEDGER_ID
,      ORG_ID
,      TRX_ID
,      TRX_NUMBER
,      TRX_LINE_ID
,      TRANSACTION_TYPE
,      DOCUMENT_SEQUENCE_NUMBER
,      TRANSACTION_DATE
,      GL_DATE
,      PERIOD_NAME
,      FUNC_CURR_CODE
,      FUNC_AMOUNT
,      ORIGINAL_CURR_CODE
,      ORIGINAL_AMOUNT
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      DESCRIPTION
,      DETAILED_CFS_ITEM
,      INTERCOMPANY_FLAG
,      REFERENCE_NUMBER
,      THIRD_PARTY_NAME
,      THIRD_PARTY_NUMBER
,      EVENT_CLASS_CODE
,      SOURCE_APPLICATION_ID
,      ANALYTICAL_CRITERION_CODE
,      SOURCE_VALUE
,      CASH_ITEM_DESC
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE
,      UPGRADE_FLAG
,      BALANCING_SEGMENT
FROM JA.JA_CN_CFS_ACTIVITIES_ALL;

Dependencies

[top of page]

JA.JA_CN_CFS_ACTIVITIES_ALL does not reference any database object

JA.JA_CN_CFS_ACTIVITIES_ALL is referenced by following:

APPS: JA_CN_CFS_ACTIVITIES_ALL