VIEW: FTE.FTE_INVOICE_HEADERS#

Source

View Text - Preformatted

select BILL_OF_LADING_ESTIMATE BILL_OF_LADING_ESTIMATE, INVOICE_HEADER_ID INVOICE_HEADER_ID, BILL_NUMBER BILL_NUMBER, BILL_STATUS BILL_STATUS, BILL_DATE BILL_DATE, BILL_TYPE BILL_TYPE, BILL_REF BILL_REF, BOL BOL, PICKUP_DATE PICKUP_DATE, PICKUP_LOCATION_ID PICKUP_LOCATION_ID, PICKUP_LOC_ADDRLINE PICKUP_LOC_ADDRLINE, PICKUP_LOC_CITY PICKUP_LOC_CITY, PICKUP_LOC_STATE PICKUP_LOC_STATE, PICKUP_LOC_COUNTRY PICKUP_LOC_COUNTRY, PICKUP_LOC_POSTALCODE PICKUP_LOC_POSTALCODE, DROPOFF_DATE DROPOFF_DATE, DROPOFF_LOCATION_ID DROPOFF_LOCATION_ID, DROPOFF_LOC_ADDRLINE DROPOFF_LOC_ADDRLINE, DROPOFF_LOC_CITY DROPOFF_LOC_CITY, DROPOFF_LOC_STATE DROPOFF_LOC_STATE, DROPOFF_LOC_COUNTRY DROPOFF_LOC_COUNTRY, DROPOFF_LOC_POSTALCODE DROPOFF_LOC_POSTALCODE, SCAC_CODE SCAC_CODE, CARRIER_ID CARRIER_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, VEHICLE_TYPE VEHICLE_TYPE, LOADED_DISTANCE_UOM LOADED_DISTANCE_UOM, LOADED_DISTANCE LOADED_DISTANCE, UNLOADED_DISTANCE_UOM UNLOADED_DISTANCE_UOM, UNLOADED_DISTANCE UNLOADED_DISTANCE, BILLED_TIME_UOM BILLED_TIME_UOM, BILLED_TIME BILLED_TIME, TOTAL_AMOUNT TOTAL_AMOUNT, APPROVED_AMOUNT APPROVED_AMOUNT, CURRENCY_CODE CURRENCY_CODE, REMARKS REMARKS, EDIT_AUDIT_DETAIL EDIT_AUDIT_DETAIL, EDIT_BILL EDIT_BILL, SOURCE SOURCE, 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, ORG_ID ORG_ID, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CARRIER_NAME CARRIER_NAME, DROPOFF_LOCATION DROPOFF_LOCATION, PICKUP_LOCATION PICKUP_LOCATION from "FTE"."FTE_INVOICE_HEADERS"

View Text - HTML Formatted

SELECT BILL_OF_LADING_ESTIMATE BILL_OF_LADING_ESTIMATE
, INVOICE_HEADER_ID INVOICE_HEADER_ID
, BILL_NUMBER BILL_NUMBER
, BILL_STATUS BILL_STATUS
, BILL_DATE BILL_DATE
, BILL_TYPE BILL_TYPE
, BILL_REF BILL_REF
, BOL BOL
, PICKUP_DATE PICKUP_DATE
, PICKUP_LOCATION_ID PICKUP_LOCATION_ID
, PICKUP_LOC_ADDRLINE PICKUP_LOC_ADDRLINE
, PICKUP_LOC_CITY PICKUP_LOC_CITY
, PICKUP_LOC_STATE PICKUP_LOC_STATE
, PICKUP_LOC_COUNTRY PICKUP_LOC_COUNTRY
, PICKUP_LOC_POSTALCODE PICKUP_LOC_POSTALCODE
, DROPOFF_DATE DROPOFF_DATE
, DROPOFF_LOCATION_ID DROPOFF_LOCATION_ID
, DROPOFF_LOC_ADDRLINE DROPOFF_LOC_ADDRLINE
, DROPOFF_LOC_CITY DROPOFF_LOC_CITY
, DROPOFF_LOC_STATE DROPOFF_LOC_STATE
, DROPOFF_LOC_COUNTRY DROPOFF_LOC_COUNTRY
, DROPOFF_LOC_POSTALCODE DROPOFF_LOC_POSTALCODE
, SCAC_CODE SCAC_CODE
, CARRIER_ID CARRIER_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, VEHICLE_TYPE VEHICLE_TYPE
, LOADED_DISTANCE_UOM LOADED_DISTANCE_UOM
, LOADED_DISTANCE LOADED_DISTANCE
, UNLOADED_DISTANCE_UOM UNLOADED_DISTANCE_UOM
, UNLOADED_DISTANCE UNLOADED_DISTANCE
, BILLED_TIME_UOM BILLED_TIME_UOM
, BILLED_TIME BILLED_TIME
, TOTAL_AMOUNT TOTAL_AMOUNT
, APPROVED_AMOUNT APPROVED_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, REMARKS REMARKS
, EDIT_AUDIT_DETAIL EDIT_AUDIT_DETAIL
, EDIT_BILL EDIT_BILL
, SOURCE SOURCE
, 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
, ORG_ID ORG_ID
, DISTRIBUTION_ACCOUNT_ID DISTRIBUTION_ACCOUNT_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CARRIER_NAME CARRIER_NAME
, DROPOFF_LOCATION DROPOFF_LOCATION
, PICKUP_LOCATION PICKUP_LOCATION
FROM "FTE"."FTE_INVOICE_HEADERS"