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: GMF.GL_ALOC_BAS#

Source

View Text - Preformatted


select ALLOC_ID ALLOC_ID, LINE_NO LINE_NO, ALLOC_METHOD ALLOC_METHOD, ITEM_ID ITEM_ID, BASIS_ACCOUNT_KEY BASIS_ACCOUNT_KEY, BASIS_ACCOUNT_DESC BASIS_ACCOUNT_DESC, BALANCE_TYPE BALANCE_TYPE, BAS_YTD_PTD BAS_YTD_PTD, FIXED_PERCENT FIXED_PERCENT, CMPNTCLS_ID CMPNTCLS_ID, ANALYSIS_CODE#1 ANALYSIS_CODE, WHSE_CODE WHSE_CODE, 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, TRANS_CNT TRANS_CNT, TEXT_CODE TEXT_CODE, DELETE_MARK DELETE_MARK, BASIS_ACCOUNT_ID BASIS_ACCOUNT_ID, BASIS_TYPE BASIS_TYPE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID from "GMF"."GL_ALOC_BAS"

View Text - HTML Formatted

SELECT ALLOC_ID ALLOC_ID
, LINE_NO LINE_NO
, ALLOC_METHOD ALLOC_METHOD
, ITEM_ID ITEM_ID
, BASIS_ACCOUNT_KEY BASIS_ACCOUNT_KEY
, BASIS_ACCOUNT_DESC BASIS_ACCOUNT_DESC
, BALANCE_TYPE BALANCE_TYPE
, BAS_YTD_PTD BAS_YTD_PTD
, FIXED_PERCENT FIXED_PERCENT
, CMPNTCLS_ID CMPNTCLS_ID
, ANALYSIS_CODE#1 ANALYSIS_CODE
, WHSE_CODE WHSE_CODE
, 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
, TRANS_CNT TRANS_CNT
, TEXT_CODE TEXT_CODE
, DELETE_MARK DELETE_MARK
, BASIS_ACCOUNT_ID BASIS_ACCOUNT_ID
, BASIS_TYPE BASIS_TYPE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
FROM "GMF"."GL_ALOC_BAS"