VIEW: JA.JAI_RGM_SETTLEMENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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