eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: JA.JAI_MTL_TRXS#

Source

View Text - Preformatted


select TRANSACTION_ID TRANSACTION_ID, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, FROM_ORGANIZATION FROM_ORGANIZATION, TO_ORGANIZATION TO_ORGANIZATION, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, FROM_SUBINVENTORY FROM_SUBINVENTORY, TO_SUBINVENTORY TO_SUBINVENTORY, LOCATION_ID LOCATION_ID, QUANTITY QUANTITY, TAXCATEGORY_ID TAXCATEGORY_ID, TAX_AMOUNT TAX_AMOUNT, QTY_REGISTER QTY_REGISTER, AMT_REGISTER AMT_REGISTER, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, SELLING_PRICE SELLING_PRICE, VAT_INVOICE_NO VAT_INVOICE_NO, ASSESSABLE_VALUE ASSESSABLE_VALUE, VAT_ASSESSABLE_VALUE VAT_ASSESSABLE_VALUE, TRANSACTION_DATE TRANSACTION_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, TRANSACTION_UOM TRANSACTION_UOM, TRANSACTION_COMMIT_DATE TRANSACTION_COMMIT_DATE, GST_INVOICE_NO GST_INVOICE_NO, GST_ASSESSABLE_VALUE GST_ASSESSABLE_VALUE from "JA"."JAI_MTL_TRXS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, FROM_ORGANIZATION FROM_ORGANIZATION
, TO_ORGANIZATION TO_ORGANIZATION
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, FROM_SUBINVENTORY FROM_SUBINVENTORY
, TO_SUBINVENTORY TO_SUBINVENTORY
, LOCATION_ID LOCATION_ID
, QUANTITY QUANTITY
, TAXCATEGORY_ID TAXCATEGORY_ID
, TAX_AMOUNT TAX_AMOUNT
, QTY_REGISTER QTY_REGISTER
, AMT_REGISTER AMT_REGISTER
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, SELLING_PRICE SELLING_PRICE
, VAT_INVOICE_NO VAT_INVOICE_NO
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, VAT_ASSESSABLE_VALUE VAT_ASSESSABLE_VALUE
, TRANSACTION_DATE TRANSACTION_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
, TRANSACTION_UOM TRANSACTION_UOM
, TRANSACTION_COMMIT_DATE TRANSACTION_COMMIT_DATE
, GST_INVOICE_NO GST_INVOICE_NO
, GST_ASSESSABLE_VALUE GST_ASSESSABLE_VALUE
FROM "JA"."JAI_MTL_TRXS"