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: ICX.ICX_WEB_STORE_OPTIONS#

Source

View Text - Preformatted


select GUEST_USERNAME GUEST_USERNAME, GUEST_PASSWORD GUEST_PASSWORD, GUEST_PRICE_LIST_ID GUEST_PRICE_LIST_ID, COMPANY_HOME_PAGE_URL COMPANY_HOME_PAGE_URL, ITEM_TEMPLATE ITEM_TEMPLATE, CATEGORY_TEMPLATE CATEGORY_TEMPLATE, ITEM_DESC ITEM_DESC, FCURRENCY_CODE FCURRENCY_CODE, FREIGHT_AMT FREIGHT_AMT, FREIGHT_FLAG FREIGHT_FLAG, NON_SHIPITEM_ID NON_SHIPITEM_ID, ORG_ID ORG_ID, ORDER_TYPE_ID ORDER_TYPE_ID, CATEGORY_SET_ID CATEGORY_SET_ID, PRICE_LIST_ID PRICE_LIST_ID, ORDER_SOURCE_ID ORDER_SOURCE_ID, USE_WEB_ORDER_TYPE USE_WEB_ORDER_TYPE, USE_WEB_PRICE_LIST USE_WEB_PRICE_LIST, USE_ORDER_IMPORT_PRICING_RULES USE_ORDER_IMPORT_PRICING_RULES, 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, CONSUMER_ALLOW_CREDIT_CARDS CONSUMER_ALLOW_CREDIT_CARDS, PARTNER_ALLOW_CREDIT_CARDS PARTNER_ALLOW_CREDIT_CARDS, CREDIT_CARD_ORDER_TYPE_ID CREDIT_CARD_ORDER_TYPE_ID, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, OTS_CARTRIDGE_PATH OTS_CARTRIDGE_PATH, ENABLE_CALL_BACK ENABLE_CALL_BACK, EMAIL_CARTRIDGE_PATH EMAIL_CARTRIDGE_PATH, ENABLE_EMAIL ENABLE_EMAIL, DEFAULT_EMAIL_ADDRESS DEFAULT_EMAIL_ADDRESS, DEFAULT_UOM DEFAULT_UOM from "ICX"."ICX_WEB_STORE_OPTIONS"

View Text - HTML Formatted

SELECT GUEST_USERNAME GUEST_USERNAME
, GUEST_PASSWORD GUEST_PASSWORD
, GUEST_PRICE_LIST_ID GUEST_PRICE_LIST_ID
, COMPANY_HOME_PAGE_URL COMPANY_HOME_PAGE_URL
, ITEM_TEMPLATE ITEM_TEMPLATE
, CATEGORY_TEMPLATE CATEGORY_TEMPLATE
, ITEM_DESC ITEM_DESC
, FCURRENCY_CODE FCURRENCY_CODE
, FREIGHT_AMT FREIGHT_AMT
, FREIGHT_FLAG FREIGHT_FLAG
, NON_SHIPITEM_ID NON_SHIPITEM_ID
, ORG_ID ORG_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, PRICE_LIST_ID PRICE_LIST_ID
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, USE_WEB_ORDER_TYPE USE_WEB_ORDER_TYPE
, USE_WEB_PRICE_LIST USE_WEB_PRICE_LIST
, USE_ORDER_IMPORT_PRICING_RULES USE_ORDER_IMPORT_PRICING_RULES
, 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
, CONSUMER_ALLOW_CREDIT_CARDS CONSUMER_ALLOW_CREDIT_CARDS
, PARTNER_ALLOW_CREDIT_CARDS PARTNER_ALLOW_CREDIT_CARDS
, CREDIT_CARD_ORDER_TYPE_ID CREDIT_CARD_ORDER_TYPE_ID
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, OTS_CARTRIDGE_PATH OTS_CARTRIDGE_PATH
, ENABLE_CALL_BACK ENABLE_CALL_BACK
, EMAIL_CARTRIDGE_PATH EMAIL_CARTRIDGE_PATH
, ENABLE_EMAIL ENABLE_EMAIL
, DEFAULT_EMAIL_ADDRESS DEFAULT_EMAIL_ADDRESS
, DEFAULT_UOM DEFAULT_UOM
FROM "ICX"."ICX_WEB_STORE_OPTIONS"