VIEW: JA.JAI_RCV_LINE_TAXES#

Source

View Text - Preformatted

select SHIPMENT_LINE_ID SHIPMENT_LINE_ID, TAX_LINE_NO TAX_LINE_NO, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, TAX_ID TAX_ID, TAX_NAME TAX_NAME, CURRENCY CURRENCY, TAX_RATE TAX_RATE, QTY_RATE QTY_RATE, UOM UOM, TAX_AMOUNT TAX_AMOUNT, TAX_TYPE TAX_TYPE, MODVAT_FLAG MODVAT_FLAG, VENDOR_ID VENDOR_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, CLAIMABLE_AMOUNT CLAIMABLE_AMOUNT, CLAIMED_AMOUNT CLAIMED_AMOUNT, MODVAT_CLAIMED_AMOUNT MODVAT_CLAIMED_AMOUNT, TRANSACTION_ID TRANSACTION_ID, VENDOR_SITE_ID VENDOR_SITE_ID, PRECEDENCE_1 PRECEDENCE_1, PRECEDENCE_2 PRECEDENCE_2, PRECEDENCE_3 PRECEDENCE_3, PRECEDENCE_4 PRECEDENCE_4, PRECEDENCE_5 PRECEDENCE_5, TAX_TARGET_AMOUNT TAX_TARGET_AMOUNT, ASSESSABLE_VALUE ASSESSABLE_VALUE, THIRD_PARTY_FLAG THIRD_PARTY_FLAG, ATTRIBUTE_DESC ATTRIBUTE_DESC, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, TAX_MODIFIED_MANUALLY TAX_MODIFIED_MANUALLY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PRECEDENCE_6 PRECEDENCE_6, PRECEDENCE_7 PRECEDENCE_7, PRECEDENCE_8 PRECEDENCE_8, PRECEDENCE_9 PRECEDENCE_9, PRECEDENCE_10 PRECEDENCE_10, BOE_COPIED_FLAG BOE_COPIED_FLAG from "JA"."JAI_RCV_LINE_TAXES"

View Text - HTML Formatted

SELECT SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, TAX_LINE_NO TAX_LINE_NO
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, TAX_ID TAX_ID
, TAX_NAME TAX_NAME
, CURRENCY CURRENCY
, TAX_RATE TAX_RATE
, QTY_RATE QTY_RATE
, UOM UOM
, TAX_AMOUNT TAX_AMOUNT
, TAX_TYPE TAX_TYPE
, MODVAT_FLAG MODVAT_FLAG
, VENDOR_ID VENDOR_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
, CLAIMABLE_AMOUNT CLAIMABLE_AMOUNT
, CLAIMED_AMOUNT CLAIMED_AMOUNT
, MODVAT_CLAIMED_AMOUNT MODVAT_CLAIMED_AMOUNT
, TRANSACTION_ID TRANSACTION_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, PRECEDENCE_1 PRECEDENCE_1
, PRECEDENCE_2 PRECEDENCE_2
, PRECEDENCE_3 PRECEDENCE_3
, PRECEDENCE_4 PRECEDENCE_4
, PRECEDENCE_5 PRECEDENCE_5
, TAX_TARGET_AMOUNT TAX_TARGET_AMOUNT
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, THIRD_PARTY_FLAG THIRD_PARTY_FLAG
, ATTRIBUTE_DESC ATTRIBUTE_DESC
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, TAX_MODIFIED_MANUALLY TAX_MODIFIED_MANUALLY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRECEDENCE_6 PRECEDENCE_6
, PRECEDENCE_7 PRECEDENCE_7
, PRECEDENCE_8 PRECEDENCE_8
, PRECEDENCE_9 PRECEDENCE_9
, PRECEDENCE_10 PRECEDENCE_10
, BOE_COPIED_FLAG BOE_COPIED_FLAG
FROM "JA"."JAI_RCV_LINE_TAXES"