VIEW: JA.JAI_AP_TDS_INV_TAXES#

Source

View Text - Preformatted

select TDS_INV_TAX_ID TDS_INV_TAX_ID, INVOICE_ID INVOICE_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, AMOUNT AMOUNT, SECTION_TYPE SECTION_TYPE, DEFAULT_TYPE DEFAULT_TYPE, DEFAULT_SECTION_CODE DEFAULT_SECTION_CODE, DEFAULT_TAX_ID DEFAULT_TAX_ID, ACTUAL_SECTION_CODE ACTUAL_SECTION_CODE, ACTUAL_TAX_ID ACTUAL_TAX_ID, USER_DELETED_TAX_FLAG USER_DELETED_TAX_FLAG, DEFAULT_THRESHOLD_GRP_ID DEFAULT_THRESHOLD_GRP_ID, DEFAULT_CUM_THRESHOLD_SLAB_ID DEFAULT_CUM_THRESHOLD_SLAB_ID, DEFAULT_CUM_THRESHOLD_STAGE DEFAULT_CUM_THRESHOLD_STAGE, DEFAULT_SIN_THRESHOLD_SLAB_ID DEFAULT_SIN_THRESHOLD_SLAB_ID, DEFAULT_FROM DEFAULT_FROM, CONSIDER_FOR_REDEFAULT CONSIDER_FOR_REDEFAULT, TAX_AMOUNT TAX_AMOUNT, THRESHOLD_TRX_ID THRESHOLD_TRX_ID, THRESHOLD_GRP_ID THRESHOLD_GRP_ID, THRESHOLD_HDR_ID THRESHOLD_HDR_ID, THRESHOLD_SLAB_ID THRESHOLD_SLAB_ID, THRESHOLD_SLAB_ID_SINGLE THRESHOLD_SLAB_ID_SINGLE, PROCESS_STATUS PROCESS_STATUS, PROCESS_MESSAGE PROCESS_MESSAGE, CODEPATH CODEPATH, MATCH_STATUS_FLAG MATCH_STATUS_FLAG, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, CALC_TAX_AMOUNT CALC_TAX_AMOUNT, CONSIDER_AMT_FOR_TDS CONSIDER_AMT_FOR_TDS, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID, TAX_LINE_NO TAX_LINE_NO, TAX_TYPE TAX_TYPE, TAX_CATEGORY_ID TAX_CATEGORY_ID, PRECEDENCE_1 PRECEDENCE_1, PRECEDENCE_2 PRECEDENCE_2, PRECEDENCE_3 PRECEDENCE_3, PRECEDENCE_4 PRECEDENCE_4, PRECEDENCE_5 PRECEDENCE_5, PRECEDENCE_6 PRECEDENCE_6, PRECEDENCE_7 PRECEDENCE_7, PRECEDENCE_8 PRECEDENCE_8, PRECEDENCE_9 PRECEDENCE_9, PRECEDENCE_10 PRECEDENCE_10, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT, BASE_TAX_AMOUNT BASE_TAX_AMOUNT, ROUNDED_AMOUNT ROUNDED_AMOUNT, THRESHOLD_TRANSITION THRESHOLD_TRANSITION, JAI_DISTRIBUTION_ID JAI_DISTRIBUTION_ID, TAX_CATEGORY_OVERRIDEN TAX_CATEGORY_OVERRIDEN from "JA"."JAI_AP_TDS_INV_TAXES"

View Text - HTML Formatted

SELECT TDS_INV_TAX_ID TDS_INV_TAX_ID
, INVOICE_ID INVOICE_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, AMOUNT AMOUNT
, SECTION_TYPE SECTION_TYPE
, DEFAULT_TYPE DEFAULT_TYPE
, DEFAULT_SECTION_CODE DEFAULT_SECTION_CODE
, DEFAULT_TAX_ID DEFAULT_TAX_ID
, ACTUAL_SECTION_CODE ACTUAL_SECTION_CODE
, ACTUAL_TAX_ID ACTUAL_TAX_ID
, USER_DELETED_TAX_FLAG USER_DELETED_TAX_FLAG
, DEFAULT_THRESHOLD_GRP_ID DEFAULT_THRESHOLD_GRP_ID
, DEFAULT_CUM_THRESHOLD_SLAB_ID DEFAULT_CUM_THRESHOLD_SLAB_ID
, DEFAULT_CUM_THRESHOLD_STAGE DEFAULT_CUM_THRESHOLD_STAGE
, DEFAULT_SIN_THRESHOLD_SLAB_ID DEFAULT_SIN_THRESHOLD_SLAB_ID
, DEFAULT_FROM DEFAULT_FROM
, CONSIDER_FOR_REDEFAULT CONSIDER_FOR_REDEFAULT
, TAX_AMOUNT TAX_AMOUNT
, THRESHOLD_TRX_ID THRESHOLD_TRX_ID
, THRESHOLD_GRP_ID THRESHOLD_GRP_ID
, THRESHOLD_HDR_ID THRESHOLD_HDR_ID
, THRESHOLD_SLAB_ID THRESHOLD_SLAB_ID
, THRESHOLD_SLAB_ID_SINGLE THRESHOLD_SLAB_ID_SINGLE
, PROCESS_STATUS PROCESS_STATUS
, PROCESS_MESSAGE PROCESS_MESSAGE
, CODEPATH CODEPATH
, MATCH_STATUS_FLAG MATCH_STATUS_FLAG
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, CALC_TAX_AMOUNT CALC_TAX_AMOUNT
, CONSIDER_AMT_FOR_TDS CONSIDER_AMT_FOR_TDS
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, TAX_LINE_NO TAX_LINE_NO
, TAX_TYPE TAX_TYPE
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, PRECEDENCE_1 PRECEDENCE_1
, PRECEDENCE_2 PRECEDENCE_2
, PRECEDENCE_3 PRECEDENCE_3
, PRECEDENCE_4 PRECEDENCE_4
, PRECEDENCE_5 PRECEDENCE_5
, PRECEDENCE_6 PRECEDENCE_6
, PRECEDENCE_7 PRECEDENCE_7
, PRECEDENCE_8 PRECEDENCE_8
, PRECEDENCE_9 PRECEDENCE_9
, PRECEDENCE_10 PRECEDENCE_10
, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT
, BASE_TAX_AMOUNT BASE_TAX_AMOUNT
, ROUNDED_AMOUNT ROUNDED_AMOUNT
, THRESHOLD_TRANSITION THRESHOLD_TRANSITION
, JAI_DISTRIBUTION_ID JAI_DISTRIBUTION_ID
, TAX_CATEGORY_OVERRIDEN TAX_CATEGORY_OVERRIDEN
FROM "JA"."JAI_AP_TDS_INV_TAXES"