[Home] [Help] [Dependency Information]
Object Name: | JA_CN_CFS_ACTIVITIES_ALL# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CFS_ACTIVITY_ID | NUMBER | Yes | ||
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
LEDGER_ID | NUMBER | (15) | Yes | |
ORG_ID | NUMBER | (15) | ||
TRX_ID | NUMBER | (15) | ||
TRX_NUMBER | VARCHAR2 | (100) | ||
TRX_LINE_ID | VARCHAR2 | (16) | ||
TRANSACTION_TYPE | VARCHAR2 | (20) | ||
DOCUMENT_SEQUENCE_NUMBER | NUMBER | |||
TRANSACTION_DATE | DATE | Yes | ||
GL_DATE | DATE | Yes | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
FUNC_CURR_CODE | VARCHAR2 | (15) | Yes | |
FUNC_AMOUNT | NUMBER | Yes | ||
ORIGINAL_CURR_CODE | VARCHAR2 | (15) | Yes | |
ORIGINAL_AMOUNT | NUMBER | Yes | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
DETAILED_CFS_ITEM | VARCHAR2 | (150) | Yes | |
INTERCOMPANY_FLAG | VARCHAR2 | (1) | ||
REFERENCE_NUMBER | VARCHAR2 | (100) | ||
THIRD_PARTY_NAME | VARCHAR2 | (360) | ||
THIRD_PARTY_NUMBER | VARCHAR2 | (30) | ||
EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
SOURCE_APPLICATION_ID | NUMBER | (15) | ||
ANALYTICAL_CRITERION_CODE | VARCHAR2 | (30) | ||
SOURCE_VALUE | VARCHAR2 | (30) | ||
CASH_ITEM_DESC | VARCHAR2 | (240) | ||
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) | ||
SOURCE | VARCHAR2 | (50) | ||
UPGRADE_FLAG | VARCHAR2 | (1) | ||
BALANCING_SEGMENT | VARCHAR2 | (25) | ||
CASH_TRX_ID | NUMBER | (15) | ||
CASH_TRX_LINE_ID | VARCHAR2 | (16) | ||
JE_HEADER_ID | NUMBER | (15) | ||
JE_LINE_NUM | NUMBER | (15) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) |
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
, CASH_TRX_ID
, CASH_TRX_LINE_ID
, JE_HEADER_ID
, JE_LINE_NUM
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
FROM JA.JA_CN_CFS_ACTIVITIES_ALL#;
|
|
|