VIEW: JA.JAI_CMN_TAXES_ALL#

Source

View Text - Preformatted

select TAX_ID TAX_ID, TAX_NAME TAX_NAME, TAX_DESCR TAX_DESCR, TAX_TYPE TAX_TYPE, TAX_RATE TAX_RATE, TAX_AMOUNT TAX_AMOUNT, UOM_CODE UOM_CODE, ADHOC_FLAG ADHOC_FLAG, VENDOR_ID VENDOR_ID, VENDOR_FLAG VENDOR_FLAG, VENDOR_SITE_ID VENDOR_SITE_ID, MODIFIABLE_FLAG MODIFIABLE_FLAG, TAX_ACCOUNT_ID TAX_ACCOUNT_ID, MOD_CR_PERCENTAGE MOD_CR_PERCENTAGE, STFORM_TYPE STFORM_TYPE, ORIG_TAX_PERCENTAGE ORIG_TAX_PERCENTAGE, TDS_SECTION TDS_SECTION, CURRENCY_FLAG CURRENCY_FLAG, START_DATE START_DATE, END_DATE END_DATE, 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, ORG_ID ORG_ID, SURCHARGE_RATE SURCHARGE_RATE, SURCHARGE_FLAG SURCHARGE_FLAG, ROUNDING_FACTOR ROUNDING_FACTOR, DUTY_DRAWBACK_FLAG DUTY_DRAWBACK_FLAG, DUTY_DRAWBACK_PERCENTAGE DUTY_DRAWBACK_PERCENTAGE, VAT_FLAG VAT_FLAG, SECTION_TYPE SECTION_TYPE, SECTION_CODE SECTION_CODE, CESS_RATE CESS_RATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SH_CESS_RATE SH_CESS_RATE, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, TAX_TYPE_ID TAX_TYPE_ID, REVERSE_CHARGE_FLAG REVERSE_CHARGE_FLAG, AUTO_CREATE_CATEGORY AUTO_CREATE_CATEGORY from "JA"."JAI_CMN_TAXES_ALL"

View Text - HTML Formatted

SELECT TAX_ID TAX_ID
, TAX_NAME TAX_NAME
, TAX_DESCR TAX_DESCR
, TAX_TYPE TAX_TYPE
, TAX_RATE TAX_RATE
, TAX_AMOUNT TAX_AMOUNT
, UOM_CODE UOM_CODE
, ADHOC_FLAG ADHOC_FLAG
, VENDOR_ID VENDOR_ID
, VENDOR_FLAG VENDOR_FLAG
, VENDOR_SITE_ID VENDOR_SITE_ID
, MODIFIABLE_FLAG MODIFIABLE_FLAG
, TAX_ACCOUNT_ID TAX_ACCOUNT_ID
, MOD_CR_PERCENTAGE MOD_CR_PERCENTAGE
, STFORM_TYPE STFORM_TYPE
, ORIG_TAX_PERCENTAGE ORIG_TAX_PERCENTAGE
, TDS_SECTION TDS_SECTION
, CURRENCY_FLAG CURRENCY_FLAG
, START_DATE START_DATE
, END_DATE END_DATE
, 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
, ORG_ID ORG_ID
, SURCHARGE_RATE SURCHARGE_RATE
, SURCHARGE_FLAG SURCHARGE_FLAG
, ROUNDING_FACTOR ROUNDING_FACTOR
, DUTY_DRAWBACK_FLAG DUTY_DRAWBACK_FLAG
, DUTY_DRAWBACK_PERCENTAGE DUTY_DRAWBACK_PERCENTAGE
, VAT_FLAG VAT_FLAG
, SECTION_TYPE SECTION_TYPE
, SECTION_CODE SECTION_CODE
, CESS_RATE CESS_RATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SH_CESS_RATE SH_CESS_RATE
, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TAX_TYPE_ID TAX_TYPE_ID
, REVERSE_CHARGE_FLAG REVERSE_CHARGE_FLAG
, AUTO_CREATE_CATEGORY AUTO_CREATE_CATEGORY
FROM "JA"."JAI_CMN_TAXES_ALL"