VIEW: JA.JAI_AP_TDS_REPOSITORY#

Source

View Text - Preformatted

select TDS_REPOSITORY_ID TDS_REPOSITORY_ID, INVOICE_ID INVOICE_ID, INVOICE_NUMBER INVOICE_NUMBER, TDS_AUTHORITY_ID TDS_AUTHORITY_ID, TDS_AUTHORITY_SITE_ID TDS_AUTHORITY_SITE_ID, TDS_INVOICE_TYPE TDS_INVOICE_TYPE, THRESHOLD_GRP_ID THRESHOLD_GRP_ID, THRESHOLD_HDR_ID THRESHOLD_HDR_ID, THRESHOLD_TYPE_ID THRESHOLD_TYPE_ID, THRESHOLD_SLAB_ID THRESHOLD_SLAB_ID, EVENT EVENT, SOURCE_INVOICE_ID SOURCE_INVOICE_ID, SOURCE_INVOICE_TYPE SOURCE_INVOICE_TYPE, SOURCE_INVOICE_AMT SOURCE_INVOICE_AMT, SOURCE_ID SOURCE_ID, SOURCE_SITE_ID SOURCE_SITE_ID, SOURCE_INVOICE_DATE SOURCE_INVOICE_DATE, ACCOUNTING_DATE ACCOUNTING_DATE, APPLIED_FROM_INVOICE_ID APPLIED_FROM_INVOICE_ID, APPLIED_FROM_INVOICE_TYPE APPLIED_FROM_INVOICE_TYPE, APPLIED_FROM_INVOICE_AMT APPLIED_FROM_INVOICE_AMT, APPLIED_FROM_SUPPLIER_ID APPLIED_FROM_SUPPLIER_ID, APPLIED_FROM_SUPPLIER_SITE_ID APPLIED_FROM_SUPPLIER_SITE_ID, APPLIED_FROM_INVOICE_DATE APPLIED_FROM_INVOICE_DATE, APPLIED_FROM_ACCTG_DATE APPLIED_FROM_ACCTG_DATE, FROM_SLAB_ID FROM_SLAB_ID, APPLIED_TO_INVOICE_ID APPLIED_TO_INVOICE_ID, APPLIED_TO_INVOICE_TYPE APPLIED_TO_INVOICE_TYPE, APPLIED_TO_INVOICE_AMT APPLIED_TO_INVOICE_AMT, APPLIED_TO_SUPPLIER_ID APPLIED_TO_SUPPLIER_ID, APPLIED_TO_SUPPLIER_SITE_ID APPLIED_TO_SUPPLIER_SITE_ID, APPLIED_TO_INVOICE_DATE APPLIED_TO_INVOICE_DATE, APPLIED_TO_ACCTG_DATE APPLIED_TO_ACCTG_DATE, APPLIED_AMOUNT APPLIED_AMOUNT, TO_SLAB_ID TO_SLAB_ID, UNAPPLIED_AMOUNT UNAPPLIED_AMOUNT, TDS_ACCOUNTING_DATE TDS_ACCOUNTING_DATE, REGIME_ID REGIME_ID, REGIME_CODE REGIME_CODE, ORG_ID ORG_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ORG_TAN_NUMBER ORG_TAN_NUMBER, SECTION_TYPE SECTION_TYPE, SECTION_CODE SECTION_CODE, TAX_RATE TAX_RATE, TAX_ID TAX_ID, TAX_CATEGORY_ID TAX_CATEGORY_ID, TDS_PAID TDS_PAID, INVOICE_DELETED INVOICE_DELETED, SOURCE_INVOICE_DELETED SOURCE_INVOICE_DELETED, PRIOR_THRESHOLD PRIOR_THRESHOLD, CHALLAN_NUMBER CHALLAN_NUMBER, CHECK_DATE CHECK_DATE, CHECK_DEPOSIT_DATE CHECK_DEPOSIT_DATE, BSR_CODE BSR_CODE, PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID, TDS_INV_TAX_AMOUNT TDS_INV_TAX_AMOUNT, SUPPLIER_CM_AMOUNT SUPPLIER_CM_AMOUNT, BASE_TAX_AMOUNT BASE_TAX_AMOUNT, REQUIRED_FOR_ETDS REQUIRED_FOR_ETDS, MIGRATED MIGRATED, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY from "JA"."JAI_AP_TDS_REPOSITORY"

View Text - HTML Formatted

SELECT TDS_REPOSITORY_ID TDS_REPOSITORY_ID
, INVOICE_ID INVOICE_ID
, INVOICE_NUMBER INVOICE_NUMBER
, TDS_AUTHORITY_ID TDS_AUTHORITY_ID
, TDS_AUTHORITY_SITE_ID TDS_AUTHORITY_SITE_ID
, TDS_INVOICE_TYPE TDS_INVOICE_TYPE
, THRESHOLD_GRP_ID THRESHOLD_GRP_ID
, THRESHOLD_HDR_ID THRESHOLD_HDR_ID
, THRESHOLD_TYPE_ID THRESHOLD_TYPE_ID
, THRESHOLD_SLAB_ID THRESHOLD_SLAB_ID
, EVENT EVENT
, SOURCE_INVOICE_ID SOURCE_INVOICE_ID
, SOURCE_INVOICE_TYPE SOURCE_INVOICE_TYPE
, SOURCE_INVOICE_AMT SOURCE_INVOICE_AMT
, SOURCE_ID SOURCE_ID
, SOURCE_SITE_ID SOURCE_SITE_ID
, SOURCE_INVOICE_DATE SOURCE_INVOICE_DATE
, ACCOUNTING_DATE ACCOUNTING_DATE
, APPLIED_FROM_INVOICE_ID APPLIED_FROM_INVOICE_ID
, APPLIED_FROM_INVOICE_TYPE APPLIED_FROM_INVOICE_TYPE
, APPLIED_FROM_INVOICE_AMT APPLIED_FROM_INVOICE_AMT
, APPLIED_FROM_SUPPLIER_ID APPLIED_FROM_SUPPLIER_ID
, APPLIED_FROM_SUPPLIER_SITE_ID APPLIED_FROM_SUPPLIER_SITE_ID
, APPLIED_FROM_INVOICE_DATE APPLIED_FROM_INVOICE_DATE
, APPLIED_FROM_ACCTG_DATE APPLIED_FROM_ACCTG_DATE
, FROM_SLAB_ID FROM_SLAB_ID
, APPLIED_TO_INVOICE_ID APPLIED_TO_INVOICE_ID
, APPLIED_TO_INVOICE_TYPE APPLIED_TO_INVOICE_TYPE
, APPLIED_TO_INVOICE_AMT APPLIED_TO_INVOICE_AMT
, APPLIED_TO_SUPPLIER_ID APPLIED_TO_SUPPLIER_ID
, APPLIED_TO_SUPPLIER_SITE_ID APPLIED_TO_SUPPLIER_SITE_ID
, APPLIED_TO_INVOICE_DATE APPLIED_TO_INVOICE_DATE
, APPLIED_TO_ACCTG_DATE APPLIED_TO_ACCTG_DATE
, APPLIED_AMOUNT APPLIED_AMOUNT
, TO_SLAB_ID TO_SLAB_ID
, UNAPPLIED_AMOUNT UNAPPLIED_AMOUNT
, TDS_ACCOUNTING_DATE TDS_ACCOUNTING_DATE
, REGIME_ID REGIME_ID
, REGIME_CODE REGIME_CODE
, ORG_ID ORG_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ORG_TAN_NUMBER ORG_TAN_NUMBER
, SECTION_TYPE SECTION_TYPE
, SECTION_CODE SECTION_CODE
, TAX_RATE TAX_RATE
, TAX_ID TAX_ID
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, TDS_PAID TDS_PAID
, INVOICE_DELETED INVOICE_DELETED
, SOURCE_INVOICE_DELETED SOURCE_INVOICE_DELETED
, PRIOR_THRESHOLD PRIOR_THRESHOLD
, CHALLAN_NUMBER CHALLAN_NUMBER
, CHECK_DATE CHECK_DATE
, CHECK_DEPOSIT_DATE CHECK_DEPOSIT_DATE
, BSR_CODE BSR_CODE
, PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID
, TDS_INV_TAX_AMOUNT TDS_INV_TAX_AMOUNT
, SUPPLIER_CM_AMOUNT SUPPLIER_CM_AMOUNT
, BASE_TAX_AMOUNT BASE_TAX_AMOUNT
, REQUIRED_FOR_ETDS REQUIRED_FOR_ETDS
, MIGRATED MIGRATED
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "JA"."JAI_AP_TDS_REPOSITORY"