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#

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, PRIMARY_COST_METHOD PRIMARY_COST_METHOD, ONHAND_QUANTITY ONHAND_QUANTITY, RECEIVED_QUANTITY RECEIVED_QUANTITY, VARIANCE_AMOUNT VARIANCE_AMOUNT, ONHAND_AMOUNT ONHAND_AMOUNT, ISSUED_AMOUNT ISSUED_AMOUNT, ONHAND_AMOUNT_FLAG ONHAND_AMOUNT_FLAG, ISSUED_AMOUNT_FLAG ISSUED_AMOUNT_FLAG, PREVIOUS_VARIANCE PREVIOUS_VARIANCE, CODE_COMBINATION_ID CODE_COMBINATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "AX"."AX_VARIANCES"

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
, PRIMARY_COST_METHOD PRIMARY_COST_METHOD
, ONHAND_QUANTITY ONHAND_QUANTITY
, RECEIVED_QUANTITY RECEIVED_QUANTITY
, VARIANCE_AMOUNT VARIANCE_AMOUNT
, ONHAND_AMOUNT ONHAND_AMOUNT
, ISSUED_AMOUNT ISSUED_AMOUNT
, ONHAND_AMOUNT_FLAG ONHAND_AMOUNT_FLAG
, ISSUED_AMOUNT_FLAG ISSUED_AMOUNT_FLAG
, PREVIOUS_VARIANCE PREVIOUS_VARIANCE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "AX"."AX_VARIANCES"