VIEW: JA.JAI_AP_TDS_PAYMENTS#

Source

View Text - Preformatted

select CHECK_ID CHECK_ID, CHECK_DATE CHECK_DATE, CHECK_NUMBER CHECK_NUMBER, BANK_NAME BANK_NAME, CURRENCY_CODE CURRENCY_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, CHECK_DEPOSIT_DATE CHECK_DEPOSIT_DATE, CHALLAN_NO CHALLAN_NO, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, 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, FIN_YEAR FIN_YEAR, FORM16_HDR_ID FORM16_HDR_ID, INVOICE_DATE INVOICE_DATE, OPERATING_UNIT_ID OPERATING_UNIT_ID, ORG_TAN_NUM ORG_TAN_NUM, PARENT_INVOICE_ID PARENT_INVOICE_ID, TAX_AMOUNT TAX_AMOUNT, TAX_AUTHORITY_ID TAX_AUTHORITY_ID, TAX_AUTHORITY_SITE_ID TAX_AUTHORITY_SITE_ID, TDS_SECTION TDS_SECTION, TDS_TAX_ID TDS_TAX_ID, TDS_TAX_RATE TDS_TAX_RATE, BSR_CODE BSR_CODE, PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID from "JA"."JAI_AP_TDS_PAYMENTS"

View Text - HTML Formatted

SELECT CHECK_ID CHECK_ID
, CHECK_DATE CHECK_DATE
, CHECK_NUMBER CHECK_NUMBER
, BANK_NAME BANK_NAME
, CURRENCY_CODE CURRENCY_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, CHECK_DEPOSIT_DATE CHECK_DEPOSIT_DATE
, CHALLAN_NO CHALLAN_NO
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, 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
, FIN_YEAR FIN_YEAR
, FORM16_HDR_ID FORM16_HDR_ID
, INVOICE_DATE INVOICE_DATE
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, ORG_TAN_NUM ORG_TAN_NUM
, PARENT_INVOICE_ID PARENT_INVOICE_ID
, TAX_AMOUNT TAX_AMOUNT
, TAX_AUTHORITY_ID TAX_AUTHORITY_ID
, TAX_AUTHORITY_SITE_ID TAX_AUTHORITY_SITE_ID
, TDS_SECTION TDS_SECTION
, TDS_TAX_ID TDS_TAX_ID
, TDS_TAX_RATE TDS_TAX_RATE
, BSR_CODE BSR_CODE
, PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID
FROM "JA"."JAI_AP_TDS_PAYMENTS"