VIEW: JA.JAI_AR_ETCS_T#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, CHALLAN_LINE_NUM CHALLAN_LINE_NUM, DEDUCTEE_LINE_NUM DEDUCTEE_LINE_NUM, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_DATE SOURCE_DOCUMENT_DATE, SOURCE_DOCUMENT_TYPE SOURCE_DOCUMENT_TYPE, LINE_AMT LINE_AMT, EXEMPTED_FLAG EXEMPTED_FLAG, TCS_TAX_RATE TCS_TAX_RATE, TCS_AMT TCS_AMT, SURCHARGE_AMT SURCHARGE_AMT, CESS_AMT CESS_AMT, TCS_CHECK_ID TCS_CHECK_ID, CHALLAN_NO CHALLAN_NO, CHALLAN_DATE CHALLAN_DATE, BANK_BRANCH_CODE BANK_BRANCH_CODE, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, PARTY_CODE PARTY_CODE, PARTY_PAN PARTY_PAN, CHECK_NUMBER CHECK_NUMBER, CERTIFICATE_ISSUE_DATE CERTIFICATE_ISSUE_DATE, TCS_CHECK_DATE TCS_CHECK_DATE, COLLECTION_FLAG COLLECTION_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_AR_ETCS_T"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, CHALLAN_LINE_NUM CHALLAN_LINE_NUM
, DEDUCTEE_LINE_NUM DEDUCTEE_LINE_NUM
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_DATE SOURCE_DOCUMENT_DATE
, SOURCE_DOCUMENT_TYPE SOURCE_DOCUMENT_TYPE
, LINE_AMT LINE_AMT
, EXEMPTED_FLAG EXEMPTED_FLAG
, TCS_TAX_RATE TCS_TAX_RATE
, TCS_AMT TCS_AMT
, SURCHARGE_AMT SURCHARGE_AMT
, CESS_AMT CESS_AMT
, TCS_CHECK_ID TCS_CHECK_ID
, CHALLAN_NO CHALLAN_NO
, CHALLAN_DATE CHALLAN_DATE
, BANK_BRANCH_CODE BANK_BRANCH_CODE
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_CODE PARTY_CODE
, PARTY_PAN PARTY_PAN
, CHECK_NUMBER CHECK_NUMBER
, CERTIFICATE_ISSUE_DATE CERTIFICATE_ISSUE_DATE
, TCS_CHECK_DATE TCS_CHECK_DATE
, COLLECTION_FLAG COLLECTION_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_AR_ETCS_T"