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.

VIEW: JA.JAI_AR_SUP_LINES#

Source

View Text - Preformatted


select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, LINE_NUMBER LINE_NUMBER, SUP_INV_TYPE SUP_INV_TYPE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, DESCRIPTION DESCRIPTION, QUANTITY QUANTITY, UNIT_CODE UNIT_CODE, TAX_CATEGORY_ID TAX_CATEGORY_ID, OLD_SELLING_PRICE OLD_SELLING_PRICE, NEW_SELLING_PRICE NEW_SELLING_PRICE, EXIST_LINE_AMT EXIST_LINE_AMT, EXIST_EXCISE_AMT EXIST_EXCISE_AMT, EXIST_OTHER_AMT EXIST_OTHER_AMT, NEW_LINE_AMT NEW_LINE_AMT, NEW_EXCISE_AMT NEW_EXCISE_AMT, NEW_OTHER_AMT NEW_OTHER_AMT, OLD_ASSESSABLE_VALUE OLD_ASSESSABLE_VALUE, NEW_ASSESSABLE_VALUE NEW_ASSESSABLE_VALUE, PL_MAPPING_ID PL_MAPPING_ID, AL_MAPPING_ID AL_MAPPING_ID, LINE_DIFF_AMT LINE_DIFF_AMT, EXCISE_DIFF_AMT EXCISE_DIFF_AMT, OTHER_DIFF_AMT OTHER_DIFF_AMT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_AR_SUP_LINES"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, LINE_NUMBER LINE_NUMBER
, SUP_INV_TYPE SUP_INV_TYPE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DESCRIPTION DESCRIPTION
, QUANTITY QUANTITY
, UNIT_CODE UNIT_CODE
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, OLD_SELLING_PRICE OLD_SELLING_PRICE
, NEW_SELLING_PRICE NEW_SELLING_PRICE
, EXIST_LINE_AMT EXIST_LINE_AMT
, EXIST_EXCISE_AMT EXIST_EXCISE_AMT
, EXIST_OTHER_AMT EXIST_OTHER_AMT
, NEW_LINE_AMT NEW_LINE_AMT
, NEW_EXCISE_AMT NEW_EXCISE_AMT
, NEW_OTHER_AMT NEW_OTHER_AMT
, OLD_ASSESSABLE_VALUE OLD_ASSESSABLE_VALUE
, NEW_ASSESSABLE_VALUE NEW_ASSESSABLE_VALUE
, PL_MAPPING_ID PL_MAPPING_ID
, AL_MAPPING_ID AL_MAPPING_ID
, LINE_DIFF_AMT LINE_DIFF_AMT
, EXCISE_DIFF_AMT EXCISE_DIFF_AMT
, OTHER_DIFF_AMT OTHER_DIFF_AMT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_AR_SUP_LINES"