[Home] [Help] [Dependency Information]
Object Name: | JA_CN_CFS_CALCULATIONS_GT |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_CN_CFS_CALCULATIONS_GT |
Subobject Name: | |
Status: | VALID |
The 'JA_CN_CFS_CALCULATIONS_GT' table is a global temporary table on session level, which is to store calculation lines for items that have calculation definition in FSG Row Set defined for Cash Flow Statement. Values stored in the column 'CAL_AXIS_SEQ' are line number of FSG rows that do not have calculation definition in Row Set and would be calculated by account assignment or cash flow item assignment.
JA.JA_CN_CFS_CALCULATIONS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_CN_CFS_CALCULATIONS_GT_N1 | NORMAL | NONUNIQUE |
AXIS_SET_ID
AXIS_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Identify of application |
AXIS_SET_ID | NUMBER | (15) | Yes | Definite column for the row set these axes belong to |
AXIS_SEQ | NUMBER | Yes | Sequence number for this row | |
CALCULATION_SEQ | NUMBER | Sequence number of the calculation step | ||
OPERATOR | VARCHAR2 | (10) | Operator to use in the calculation, for cash flow statement, supported operator is '+'/'-' | |
OPERATOR_FLAG | NUMBER | A flag for operator, if operator is '+', then this flag is 1, else if operator is '-', then this flag is '-1', otherwise, the flag is '0' | ||
CAL_AXIS_SEQ | NUMBER | Sequence number to perform calculation with | ||
CONSTANT | NUMBER | Constant value to perform calculation with |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, AXIS_SET_ID
, AXIS_SEQ
, CALCULATION_SEQ
, OPERATOR
, OPERATOR_FLAG
, CAL_AXIS_SEQ
, CONSTANT
FROM JA.JA_CN_CFS_CALCULATIONS_GT;
JA.JA_CN_CFS_CALCULATIONS_GT does not reference any database object
JA.JA_CN_CFS_CALCULATIONS_GT is referenced by following:
|
|
|