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

Source

View Text - Preformatted


select ACCT_HRC_ID ACCT_HRC_ID, CO_CODE CO_CODE, ACCT_TTL_TYPE ACCT_TTL_TYPE, ORGN_CODE_PRI ORGN_CODE_PRI, WHSE_CODE_PRI WHSE_CODE_PRI, ITEM_PRI ITEM_PRI, VENDOR_PRI VENDOR_PRI, CUSTOMER_PRI CUSTOMER_PRI, REASON_CODE_PRI REASON_CODE_PRI, ICGL_CLASS_PRI ICGL_CLASS_PRI, VENDGL_CLASS_PRI VENDGL_CLASS_PRI, CUSTGL_CLASS_PRI CUSTGL_CLASS_PRI, CURRENCY_CODE_PRI CURRENCY_CODE_PRI, ROUTING_PRI ROUTING_PRI, CHARGE_PRI CHARGE_PRI, TAX_AUTH_PRI TAX_AUTH_PRI, AQUI_COST_CODE_PRI AQUI_COST_CODE_PRI, RESOURCE_PRI RESOURCE_PRI, COST_CMPNTCLS_PRI COST_CMPNTCLS_PRI, COST_ANALYSIS_PRI COST_ANALYSIS_PRI, 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, ORDER_TYPE_PRI ORDER_TYPE_PRI, GL_BUSINESS_CLASS_PRI GL_BUSINESS_CLASS_PRI, GL_PRODUCT_LINE_PRI GL_PRODUCT_LINE_PRI, LINE_TYPE_PRI LINE_TYPE_PRI, AR_TRX_TYPE_PRI AR_TRX_TYPE_PRI from "GMF"."GL_ACCT_HRC"

View Text - HTML Formatted

SELECT ACCT_HRC_ID ACCT_HRC_ID
, CO_CODE CO_CODE
, ACCT_TTL_TYPE ACCT_TTL_TYPE
, ORGN_CODE_PRI ORGN_CODE_PRI
, WHSE_CODE_PRI WHSE_CODE_PRI
, ITEM_PRI ITEM_PRI
, VENDOR_PRI VENDOR_PRI
, CUSTOMER_PRI CUSTOMER_PRI
, REASON_CODE_PRI REASON_CODE_PRI
, ICGL_CLASS_PRI ICGL_CLASS_PRI
, VENDGL_CLASS_PRI VENDGL_CLASS_PRI
, CUSTGL_CLASS_PRI CUSTGL_CLASS_PRI
, CURRENCY_CODE_PRI CURRENCY_CODE_PRI
, ROUTING_PRI ROUTING_PRI
, CHARGE_PRI CHARGE_PRI
, TAX_AUTH_PRI TAX_AUTH_PRI
, AQUI_COST_CODE_PRI AQUI_COST_CODE_PRI
, RESOURCE_PRI RESOURCE_PRI
, COST_CMPNTCLS_PRI COST_CMPNTCLS_PRI
, COST_ANALYSIS_PRI COST_ANALYSIS_PRI
, 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
, ORDER_TYPE_PRI ORDER_TYPE_PRI
, GL_BUSINESS_CLASS_PRI GL_BUSINESS_CLASS_PRI
, GL_PRODUCT_LINE_PRI GL_PRODUCT_LINE_PRI
, LINE_TYPE_PRI LINE_TYPE_PRI
, AR_TRX_TYPE_PRI AR_TRX_TYPE_PRI
FROM "GMF"."GL_ACCT_HRC"