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

VIEW: JA.JAI_RGM_SETTLEMENTS#

Object Details
Object Name: JAI_RGM_SETTLEMENTS#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SETTLEMENT_ID NUMBER (15) Yes
REGIME_ID NUMBER (15) Yes
PRIMARY_REGISTRATION_NO VARCHAR2 (240) Yes
SETTLEMENT_DATE DATE
Yes
STATUS VARCHAR2 (50) Yes
SYSTEM_INVOICE_NO VARCHAR2 (50)
MANUAL_INVOICE_NO VARCHAR2 (50)
TAX_AUTHORITY_ID NUMBER (15)
TAX_AUTHORITY_SITE_ID NUMBER (15)
CALCULATED_AMOUNT NUMBER

PAYMENT_AMOUNT NUMBER

CHALLAN_NO VARCHAR2 (30)
CHALLAN_DATE DATE

CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
LAST_SETTLEMENT_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
INVOICE_ID NUMBER (15)
ITEM_CLASSIFICATION VARCHAR2 (100)
PAYMENT_DATE DATE

REVERSE_CHARGE_FLAG VARCHAR2 (1)
Query Text

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


SELECT SETTLEMENT_ID
,      REGIME_ID
,      PRIMARY_REGISTRATION_NO
,      SETTLEMENT_DATE
,      STATUS
,      SYSTEM_INVOICE_NO
,      MANUAL_INVOICE_NO
,      TAX_AUTHORITY_ID
,      TAX_AUTHORITY_SITE_ID
,      CALCULATED_AMOUNT
,      PAYMENT_AMOUNT
,      CHALLAN_NO
,      CHALLAN_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_SETTLEMENT_DATE
,      OBJECT_VERSION_NUMBER
,      INVOICE_ID
,      ITEM_CLASSIFICATION
,      PAYMENT_DATE
,      REVERSE_CHARGE_FLAG
FROM JA.JAI_RGM_SETTLEMENTS#;

Dependencies

[top of page]

JA.JAI_RGM_SETTLEMENTS# references the following:

SchemaJA
TableJAI_RGM_SETTLEMENTS
JA.JAI_RGM_SETTLEMENTS# is referenced by following:

SchemaAPPS
SynonymJAI_RGM_SETTLEMENTS