[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_RG_ROUND_HDRS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUNDING_ID | NUMBER | Yes | ||
SOURCE_HEADER_ID | NUMBER | |||
EXCISE_INVOICE_NO | VARCHAR2 | (40) | ||
EXCISE_INVOICE_DATE | DATE | |||
EXCISE_AMT_BEFORE_ROUNDING | NUMBER | |||
EXCISE_AMT_AFTER_ROUNDING | NUMBER | |||
REGISTER_ID | NUMBER | |||
SOURCE | VARCHAR2 | (25) | ||
SRC_TRANSACTION_TYPE | VARCHAR2 | (40) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
BASIC_ED | NUMBER | |||
ROUNDED_BASIC_ED | NUMBER | |||
ADDITIONAL_ED | NUMBER | |||
ROUNDED_ADDITIONAL_ED | NUMBER | |||
OTHER_ED | NUMBER | |||
ROUNDED_OTHER_ED | NUMBER | |||
EXCISE_EDU_CESS | NUMBER | |||
ROUNDED_EXCISE_EDU_CESS | NUMBER | |||
CVD_EDU_CESS | NUMBER | |||
ROUNDED_CVD_EDU_CESS | NUMBER | |||
REGISTER | VARCHAR2 | (10) | ||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
REQUEST_ID | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | |||
ADDITIONAL_CVD | NUMBER | (38) | ||
ROUNDED_ADDITIONAL_CVD | NUMBER | (38) | ||
ROUNDED_SH_CVD_EDU_CESS | NUMBER | |||
ROUNDED_SH_EXCISE_EDU_CESS | NUMBER | |||
SH_CVD_EDU_CESS | NUMBER | |||
SH_EXCISE_EDU_CESS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROUNDING_ID
, SOURCE_HEADER_ID
, EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE
, EXCISE_AMT_BEFORE_ROUNDING
, EXCISE_AMT_AFTER_ROUNDING
, REGISTER_ID
, SOURCE
, SRC_TRANSACTION_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, BASIC_ED
, ROUNDED_BASIC_ED
, ADDITIONAL_ED
, ROUNDED_ADDITIONAL_ED
, OTHER_ED
, ROUNDED_OTHER_ED
, EXCISE_EDU_CESS
, ROUNDED_EXCISE_EDU_CESS
, CVD_EDU_CESS
, ROUNDED_CVD_EDU_CESS
, REGISTER
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, OBJECT_VERSION_NUMBER
, ADDITIONAL_CVD
, ROUNDED_ADDITIONAL_CVD
, ROUNDED_SH_CVD_EDU_CESS
, ROUNDED_SH_EXCISE_EDU_CESS
, SH_CVD_EDU_CESS
, SH_EXCISE_EDU_CESS
FROM JA.JAI_CMN_RG_ROUND_HDRS#;
|
|
|