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: AX.AX_VARIANCES_EFC#

Source

View Text - Preformatted


select ORGANIZATION_ID ORGANIZATION_ID, SECONDARY_INVENTORY_NAME SECONDARY_INVENTORY_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ACCOUNTING_PERIOD_ID ACCOUNTING_PERIOD_ID, VARIANCE_TYPE VARIANCE_TYPE, CODE_COMBINATION_ID CODE_COMBINATION_ID, VARIANCE_AMOUNT VARIANCE_AMOUNT, ONHAND_AMOUNT ONHAND_AMOUNT, ISSUED_AMOUNT ISSUED_AMOUNT, PREVIOUS_VARIANCE PREVIOUS_VARIANCE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SET_OF_BOOKS_ID SET_OF_BOOKS_ID from "AX"."AX_VARIANCES_EFC"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, SECONDARY_INVENTORY_NAME SECONDARY_INVENTORY_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ACCOUNTING_PERIOD_ID ACCOUNTING_PERIOD_ID
, VARIANCE_TYPE VARIANCE_TYPE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, VARIANCE_AMOUNT VARIANCE_AMOUNT
, ONHAND_AMOUNT ONHAND_AMOUNT
, ISSUED_AMOUNT ISSUED_AMOUNT
, PREVIOUS_VARIANCE PREVIOUS_VARIANCE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM "AX"."AX_VARIANCES_EFC"