VIEW: FTE.FTE_INVOICE_LINES#

Source

View Text - Preformatted

select INVOICE_LINE_ID INVOICE_LINE_ID, INVOICE_HEADER_ID INVOICE_HEADER_ID, INVOICE_LINE_NUM INVOICE_LINE_NUM, INVOICE_LINE_TYPE INVOICE_LINE_TYPE, LADING_QUANTITY LADING_QUANTITY, LADING_UNIT LADING_UNIT, DESCRIPTION DESCRIPTION, FREIGHT_CLASS FREIGHT_CLASS, TOTAL_WEIGHT TOTAL_WEIGHT, WEIGHT_UOM WEIGHT_UOM, TOTAL_VOLUME TOTAL_VOLUME, VOLUME_UOM VOLUME_UOM, RATE_AMOUNT RATE_AMOUNT, RATE_TYPE RATE_TYPE, DISCOUNT_UOM DISCOUNT_UOM, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, DISCOUNT_TYPE DISCOUNT_TYPE, DISCOUNT_DISC DISCOUNT_DISC, SURCHARGE_UOM SURCHARGE_UOM, SURCHARGE_AMOUNT SURCHARGE_AMOUNT, SURCHARGE_TYPE SURCHARGE_TYPE, SURCHARGE_DISC SURCHARGE_DISC, APPROVED_AMOUNT APPROVED_AMOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RATE_BASIS RATE_BASIS, RATE_BASIS_UOM RATE_BASIS_UOM from "FTE"."FTE_INVOICE_LINES"

View Text - HTML Formatted

SELECT INVOICE_LINE_ID INVOICE_LINE_ID
, INVOICE_HEADER_ID INVOICE_HEADER_ID
, INVOICE_LINE_NUM INVOICE_LINE_NUM
, INVOICE_LINE_TYPE INVOICE_LINE_TYPE
, LADING_QUANTITY LADING_QUANTITY
, LADING_UNIT LADING_UNIT
, DESCRIPTION DESCRIPTION
, FREIGHT_CLASS FREIGHT_CLASS
, TOTAL_WEIGHT TOTAL_WEIGHT
, WEIGHT_UOM WEIGHT_UOM
, TOTAL_VOLUME TOTAL_VOLUME
, VOLUME_UOM VOLUME_UOM
, RATE_AMOUNT RATE_AMOUNT
, RATE_TYPE RATE_TYPE
, DISCOUNT_UOM DISCOUNT_UOM
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, DISCOUNT_TYPE DISCOUNT_TYPE
, DISCOUNT_DISC DISCOUNT_DISC
, SURCHARGE_UOM SURCHARGE_UOM
, SURCHARGE_AMOUNT SURCHARGE_AMOUNT
, SURCHARGE_TYPE SURCHARGE_TYPE
, SURCHARGE_DISC SURCHARGE_DISC
, APPROVED_AMOUNT APPROVED_AMOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RATE_BASIS RATE_BASIS
, RATE_BASIS_UOM RATE_BASIS_UOM
FROM "FTE"."FTE_INVOICE_LINES"