[Home] [Help] [Dependency Information]
Object Name: | FUN_BAL_RESULTS_T# |
---|---|
Object Type: | VIEW |
Owner: | FUN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | ||
BAL_SEG_VAL | VARCHAR2 | (25) | ||
ENTERED_AMT_DR | NUMBER | (15) | ||
ENTERED_AMT_CR | NUMBER | (15) | ||
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | ||
EXCHANGE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
ACCOUNTED_AMT_DR | NUMBER | |||
ACCOUNTED_AMT_CR | NUMBER | |||
CCID | NUMBER | (15) | ||
JGZZ_RECON_STATUS | VARCHAR2 | (1) | ||
JGZZ_RECON_DATE | DATE | |||
JGZZ_RECON_ID | NUMBER | (15) | ||
JGZZ_RECON_REF | VARCHAR2 | (240) | ||
JGZZ_RECON_CONTEXT | VARCHAR2 | (30) | ||
DR_BSV | VARCHAR2 | (25) | ||
CR_BSV | VARCHAR2 | (25) | ||
ACCT_TYPE | VARCHAR2 | (1) | ||
TEMPLATE_ID | NUMBER | (15) | ||
LE_ID | NUMBER | (15) | ||
BALANCING_TYPE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_ID
, BAL_SEG_VAL
, ENTERED_AMT_DR
, ENTERED_AMT_CR
, ENTERED_CURRENCY_CODE
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, ACCOUNTED_AMT_DR
, ACCOUNTED_AMT_CR
, CCID
, JGZZ_RECON_STATUS
, JGZZ_RECON_DATE
, JGZZ_RECON_ID
, JGZZ_RECON_REF
, JGZZ_RECON_CONTEXT
, DR_BSV
, CR_BSV
, ACCT_TYPE
, TEMPLATE_ID
, LE_ID
, BALANCING_TYPE
FROM FUN.FUN_BAL_RESULTS_T#;
|
|
|