VIEW: EC.ECE_AR_TRX_LINE_TAX#

Source

View Text - Preformatted

select COMMUNICATION_METHOD COMMUNICATION_METHOD, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_ID TRANSACTION_ID, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, TAX_LINE_NUMBER TAX_LINE_NUMBER, TAX_AMOUNT TAX_AMOUNT, TAX_RATE TAX_RATE, TAX_PRECEDENCE TAX_PRECEDENCE, VAT_TAX_CODE_INT VAT_TAX_CODE_INT, VAT_TAX_CODE_EXT1 VAT_TAX_CODE_EXT1, VAT_TAX_CODE_EXT2 VAT_TAX_CODE_EXT2, VAT_TAX_CODE_EXT3 VAT_TAX_CODE_EXT3, VAT_TAX_CODE_EXT4 VAT_TAX_CODE_EXT4, VAT_TAX_CODE_EXT5 VAT_TAX_CODE_EXT5, TAX_ATTRIBUTE_CATEGORY TAX_ATTRIBUTE_CATEGORY, TAX_ATTRIBUTE1 TAX_ATTRIBUTE1, TAX_ATTRIBUTE2 TAX_ATTRIBUTE2, TAX_ATTRIBUTE3 TAX_ATTRIBUTE3, TAX_ATTRIBUTE4 TAX_ATTRIBUTE4, TAX_ATTRIBUTE5 TAX_ATTRIBUTE5, TAX_ATTRIBUTE6 TAX_ATTRIBUTE6, TAX_ATTRIBUTE7 TAX_ATTRIBUTE7, TAX_ATTRIBUTE8 TAX_ATTRIBUTE8, TAX_ATTRIBUTE9 TAX_ATTRIBUTE9, TAX_ATTRIBUTE10 TAX_ATTRIBUTE10, TAX_ATTRIBUTE11 TAX_ATTRIBUTE11, TAX_ATTRIBUTE12 TAX_ATTRIBUTE12, TAX_ATTRIBUTE13 TAX_ATTRIBUTE13, TAX_ATTRIBUTE14 TAX_ATTRIBUTE14, TAX_ATTRIBUTE15 TAX_ATTRIBUTE15, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, TAX_TYPE TAX_TYPE, TAX_TYPE_EXT1 TAX_TYPE_EXT1, TAX_TYPE_EXT2 TAX_TYPE_EXT2, TAX_TYPE_EXT3 TAX_TYPE_EXT3, TAX_TYPE_EXT4 TAX_TYPE_EXT4, TAX_TYPE_EXT5 TAX_TYPE_EXT5, DESCRIPTION DESCRIPTION, LOCATION LOCATION, TAX_CLASSIFICATION TAX_CLASSIFICATION, TAX_CLASSIFICATION_EXT1 TAX_CLASSIFICATION_EXT1, TAX_CLASSIFICATION_EXT2 TAX_CLASSIFICATION_EXT2, TAX_CLASSIFICATION_EXT3 TAX_CLASSIFICATION_EXT3, TAX_CLASSIFICATION_EXT4 TAX_CLASSIFICATION_EXT4, TAX_CLASSIFICATION_EXT5 TAX_CLASSIFICATION_EXT5, VAT_TRANSACTION_TYPE VAT_TRANSACTION_TYPE, VAT_TRANSACTION_TYPE_EXT1 VAT_TRANSACTION_TYPE_EXT1, VAT_TRANSACTION_TYPE_EXT2 VAT_TRANSACTION_TYPE_EXT2, VAT_TRANSACTION_TYPE_EXT3 VAT_TRANSACTION_TYPE_EXT3, VAT_TRANSACTION_TYPE_EXT4 VAT_TRANSACTION_TYPE_EXT4, VAT_TRANSACTION_TYPE_EXT5 VAT_TRANSACTION_TYPE_EXT5, VAT_TAX_ATTRIBUTE_CATEGORY VAT_TAX_ATTRIBUTE_CATEGORY, VAT_TAX_ATTRIBUTE1 VAT_TAX_ATTRIBUTE1, VAT_TAX_ATTRIBUTE2 VAT_TAX_ATTRIBUTE2, VAT_TAX_ATTRIBUTE3 VAT_TAX_ATTRIBUTE3, VAT_TAX_ATTRIBUTE4 VAT_TAX_ATTRIBUTE4, VAT_TAX_ATTRIBUTE5 VAT_TAX_ATTRIBUTE5, VAT_TAX_ATTRIBUTE6 VAT_TAX_ATTRIBUTE6, VAT_TAX_ATTRIBUTE7 VAT_TAX_ATTRIBUTE7, VAT_TAX_ATTRIBUTE8 VAT_TAX_ATTRIBUTE8, VAT_TAX_ATTRIBUTE9 VAT_TAX_ATTRIBUTE9, VAT_TAX_ATTRIBUTE10 VAT_TAX_ATTRIBUTE10, VAT_TAX_ATTRIBUTE11 VAT_TAX_ATTRIBUTE11, VAT_TAX_ATTRIBUTE12 VAT_TAX_ATTRIBUTE12, VAT_TAX_ATTRIBUTE13 VAT_TAX_ATTRIBUTE13, VAT_TAX_ATTRIBUTE14 VAT_TAX_ATTRIBUTE14, VAT_TAX_ATTRIBUTE15 VAT_TAX_ATTRIBUTE15, RUN_ID RUN_ID, TRANSACTION_RECORD_ID TRANSACTION_RECORD_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "EC"."ECE_AR_TRX_LINE_TAX"

View Text - HTML Formatted

SELECT COMMUNICATION_METHOD COMMUNICATION_METHOD
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_ID TRANSACTION_ID
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, TAX_LINE_NUMBER TAX_LINE_NUMBER
, TAX_AMOUNT TAX_AMOUNT
, TAX_RATE TAX_RATE
, TAX_PRECEDENCE TAX_PRECEDENCE
, VAT_TAX_CODE_INT VAT_TAX_CODE_INT
, VAT_TAX_CODE_EXT1 VAT_TAX_CODE_EXT1
, VAT_TAX_CODE_EXT2 VAT_TAX_CODE_EXT2
, VAT_TAX_CODE_EXT3 VAT_TAX_CODE_EXT3
, VAT_TAX_CODE_EXT4 VAT_TAX_CODE_EXT4
, VAT_TAX_CODE_EXT5 VAT_TAX_CODE_EXT5
, TAX_ATTRIBUTE_CATEGORY TAX_ATTRIBUTE_CATEGORY
, TAX_ATTRIBUTE1 TAX_ATTRIBUTE1
, TAX_ATTRIBUTE2 TAX_ATTRIBUTE2
, TAX_ATTRIBUTE3 TAX_ATTRIBUTE3
, TAX_ATTRIBUTE4 TAX_ATTRIBUTE4
, TAX_ATTRIBUTE5 TAX_ATTRIBUTE5
, TAX_ATTRIBUTE6 TAX_ATTRIBUTE6
, TAX_ATTRIBUTE7 TAX_ATTRIBUTE7
, TAX_ATTRIBUTE8 TAX_ATTRIBUTE8
, TAX_ATTRIBUTE9 TAX_ATTRIBUTE9
, TAX_ATTRIBUTE10 TAX_ATTRIBUTE10
, TAX_ATTRIBUTE11 TAX_ATTRIBUTE11
, TAX_ATTRIBUTE12 TAX_ATTRIBUTE12
, TAX_ATTRIBUTE13 TAX_ATTRIBUTE13
, TAX_ATTRIBUTE14 TAX_ATTRIBUTE14
, TAX_ATTRIBUTE15 TAX_ATTRIBUTE15
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TAX_TYPE TAX_TYPE
, TAX_TYPE_EXT1 TAX_TYPE_EXT1
, TAX_TYPE_EXT2 TAX_TYPE_EXT2
, TAX_TYPE_EXT3 TAX_TYPE_EXT3
, TAX_TYPE_EXT4 TAX_TYPE_EXT4
, TAX_TYPE_EXT5 TAX_TYPE_EXT5
, DESCRIPTION DESCRIPTION
, LOCATION LOCATION
, TAX_CLASSIFICATION TAX_CLASSIFICATION
, TAX_CLASSIFICATION_EXT1 TAX_CLASSIFICATION_EXT1
, TAX_CLASSIFICATION_EXT2 TAX_CLASSIFICATION_EXT2
, TAX_CLASSIFICATION_EXT3 TAX_CLASSIFICATION_EXT3
, TAX_CLASSIFICATION_EXT4 TAX_CLASSIFICATION_EXT4
, TAX_CLASSIFICATION_EXT5 TAX_CLASSIFICATION_EXT5
, VAT_TRANSACTION_TYPE VAT_TRANSACTION_TYPE
, VAT_TRANSACTION_TYPE_EXT1 VAT_TRANSACTION_TYPE_EXT1
, VAT_TRANSACTION_TYPE_EXT2 VAT_TRANSACTION_TYPE_EXT2
, VAT_TRANSACTION_TYPE_EXT3 VAT_TRANSACTION_TYPE_EXT3
, VAT_TRANSACTION_TYPE_EXT4 VAT_TRANSACTION_TYPE_EXT4
, VAT_TRANSACTION_TYPE_EXT5 VAT_TRANSACTION_TYPE_EXT5
, VAT_TAX_ATTRIBUTE_CATEGORY VAT_TAX_ATTRIBUTE_CATEGORY
, VAT_TAX_ATTRIBUTE1 VAT_TAX_ATTRIBUTE1
, VAT_TAX_ATTRIBUTE2 VAT_TAX_ATTRIBUTE2
, VAT_TAX_ATTRIBUTE3 VAT_TAX_ATTRIBUTE3
, VAT_TAX_ATTRIBUTE4 VAT_TAX_ATTRIBUTE4
, VAT_TAX_ATTRIBUTE5 VAT_TAX_ATTRIBUTE5
, VAT_TAX_ATTRIBUTE6 VAT_TAX_ATTRIBUTE6
, VAT_TAX_ATTRIBUTE7 VAT_TAX_ATTRIBUTE7
, VAT_TAX_ATTRIBUTE8 VAT_TAX_ATTRIBUTE8
, VAT_TAX_ATTRIBUTE9 VAT_TAX_ATTRIBUTE9
, VAT_TAX_ATTRIBUTE10 VAT_TAX_ATTRIBUTE10
, VAT_TAX_ATTRIBUTE11 VAT_TAX_ATTRIBUTE11
, VAT_TAX_ATTRIBUTE12 VAT_TAX_ATTRIBUTE12
, VAT_TAX_ATTRIBUTE13 VAT_TAX_ATTRIBUTE13
, VAT_TAX_ATTRIBUTE14 VAT_TAX_ATTRIBUTE14
, VAT_TAX_ATTRIBUTE15 VAT_TAX_ATTRIBUTE15
, RUN_ID RUN_ID
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "EC"."ECE_AR_TRX_LINE_TAX"