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: FTE_LOAD_CHARGES_V

Product:	FTE - Transportation Execution
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT LOAD_CHARGE_ID
, LOAD_CHARGE_TYPE_CODE
, SUMMARY_FLAG
, SOURCE_SYSTEM_CODE
, PRICING_UOM_BASIS
, PRICING_UNIT_PRICE UNIT_PRICE
, C.LOAD_ID
, LOAD_DETAIL_ID
, C.LOAD_SCHEDULE_ID
, PRICING_UOM
, PRICING_LIST_LINE_TYPE_CODE
, PRICING_LEVEL_CODE
, PRICE_BREAK_TYPE_CODE
, CHARGE_TOTAL_VALUE
, DECODE(LOAD_CHARGE_TYPE_CODE
, 'PRICE'
, NULL
, 'CHARGE'
, V_ATTRIBUTE2
, V_ATTRIBUTE2) CHARGESUBTYPE
, C.LANE_ID
FROM FTE_LOAD_CHARGES C
, FTE_LOAD_SCHEDULES S
WHERE C.LOAD_SCHEDULE_ID = S.LOAD_SCHEDULE_ID
AND UPPER(S.STATUS_CODE) <> 'OBSOLETE'

Columns

Name
LOAD_CHARGE_ID
LOAD_CHARGE_TYPE_CODE
SUMMARY_FLAG
SOURCE_SYSTEM_CODE
PRICING_UOM_BASIS
UNIT_PRICE
LOAD_ID
LOAD_DETAIL_ID
LOAD_SCHEDULE_ID
PRICING_UOM
PRICING_LIST_LINE_TYPE_CODE
PRICING_LEVEL_CODE
PRICE_BREAK_TYPE_CODE
CHARGE_TOTAL_VALUE
CHARGESUBTYPE
LANE_ID