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: GML.GML_GASNO_SHIPMENTS#

Source

View Text - Preformatted


select MAP_ID MAP_ID, COMMUNICATION_METHOD COMMUNICATION_METHOD, TEST_INDICATOR TEST_INDICATOR, DOCUMENT_ID DOCUMENT_ID, TP_HEADER_ID TP_HEADER_ID, TP_DETAIL_ID TP_DETAIL_ID, RUN_ID RUN_ID, DOCUMENT_PURPOSE_CODE DOCUMENT_PURPOSE_CODE, TP_DOCUMENT_CODE TP_DOCUMENT_CODE, TP_CODE TP_CODE, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT, TP_DESCRIPTION TP_DESCRIPTION, TP_REFERENCE1 TP_REFERENCE1, TP_REFERENCE2 TP_REFERENCE2, TRANSACTION_DATE TRANSACTION_DATE, TP_HEADER_CATEGORY TP_HEADER_CATEGORY, TP_HEADER_ATTRIBUTE1 TP_HEADER_ATTRIBUTE1, TP_HEADER_ATTRIBUTE2 TP_HEADER_ATTRIBUTE2, TP_HEADER_ATTRIBUTE3 TP_HEADER_ATTRIBUTE3, TP_HEADER_ATTRIBUTE4 TP_HEADER_ATTRIBUTE4, TP_HEADER_ATTRIBUTE5 TP_HEADER_ATTRIBUTE5, TP_HEADER_ATTRIBUTE6 TP_HEADER_ATTRIBUTE6, TP_HEADER_ATTRIBUTE7 TP_HEADER_ATTRIBUTE7, TP_HEADER_ATTRIBUTE8 TP_HEADER_ATTRIBUTE8, TP_HEADER_ATTRIBUTE9 TP_HEADER_ATTRIBUTE9, TP_HEADER_ATTRIBUTE10 TP_HEADER_ATTRIBUTE10, TP_HEADER_ATTRIBUTE11 TP_HEADER_ATTRIBUTE11, TP_HEADER_ATTRIBUTE12 TP_HEADER_ATTRIBUTE12, TP_HEADER_ATTRIBUTE13 TP_HEADER_ATTRIBUTE13, TP_HEADER_ATTRIBUTE14 TP_HEADER_ATTRIBUTE14, TP_HEADER_ATTRIBUTE15 TP_HEADER_ATTRIBUTE15, TP_DETAIL_CATEGORY TP_DETAIL_CATEGORY, TP_DETAIL_ATTRIBUTE1 TP_DETAIL_ATTRIBUTE1, TP_DETAIL_ATTRIBUTE2 TP_DETAIL_ATTRIBUTE2, TP_DETAIL_ATTRIBUTE3 TP_DETAIL_ATTRIBUTE3, TP_DETAIL_ATTRIBUTE4 TP_DETAIL_ATTRIBUTE4, TP_DETAIL_ATTRIBUTE5 TP_DETAIL_ATTRIBUTE5, BOL_ID BOL_ID, BOL_NO BOL_NO, ORGN_CODE ORGN_CODE, BOL_COMMENT BOL_COMMENT, WAYBILL_NO WAYBILL_NO, FRTBILL_MTHD_INT FRTBILL_MTHD_INT, FRTBILL_MTHD_EXT1 FRTBILL_MTHD_EXT1, FRTBILL_MTHD_EXT2 FRTBILL_MTHD_EXT2, FRTBILL_MTHD_EXT3 FRTBILL_MTHD_EXT3, FRTBILL_MTHD_EXT4 FRTBILL_MTHD_EXT4, FRTBILL_MTHD_EXT5 FRTBILL_MTHD_EXT5, FRTBILL_DESC FRTBILL_DESC, EMBARKATION_PORT_INT EMBARKATION_PORT_INT, EMBARKATION_PORT_EXT1 EMBARKATION_PORT_EXT1, EMBARKATION_PORT_EXT2 EMBARKATION_PORT_EXT2, EMBARKATION_PORT_EXT3 EMBARKATION_PORT_EXT3, EMBARKATION_PORT_EXT4 EMBARKATION_PORT_EXT4, EMBARKATION_PORT_EXT5 EMBARKATION_PORT_EXT5, EMBARKATION_PORT_DESC EMBARKATION_PORT_DESC, DEBARKATION_PORT_INT DEBARKATION_PORT_INT, DEBARKATION_PORT_EXT1 DEBARKATION_PORT_EXT1, DEBARKATION_PORT_EXT2 DEBARKATION_PORT_EXT2, DEBARKATION_PORT_EXT3 DEBARKATION_PORT_EXT3, DEBARKATION_PORT_EXT4 DEBARKATION_PORT_EXT4, DEBARKATION_PORT_EXT5 DEBARKATION_PORT_EXT5, DEBARKATION_PORT_DESC DEBARKATION_PORT_DESC, FOB_CODE_INT FOB_CODE_INT, FOB_CODE_EXT1 FOB_CODE_EXT1, FOB_CODE_EXT2 FOB_CODE_EXT2, FOB_CODE_EXT3 FOB_CODE_EXT3, FOB_CODE_EXT4 FOB_CODE_EXT4, FOB_CODE_EXT5 FOB_CODE_EXT5, FOB_NAME FOB_NAME, SHIPPER_CODE_INT SHIPPER_CODE_INT, SHIPPER_CODE_EXT1 SHIPPER_CODE_EXT1, SHIPPER_CODE_EXT2 SHIPPER_CODE_EXT2, SHIPPER_CODE_EXT3 SHIPPER_CODE_EXT3, SHIPPER_CODE_EXT4 SHIPPER_CODE_EXT4, SHIPPER_CODE_EXT5 SHIPPER_CODE_EXT5, SHIPPER_NAME SHIPPER_NAME, SHIP_MTHD_INT SHIP_MTHD_INT, SHIP_MTHD_EXT1 SHIP_MTHD_EXT1, SHIP_MTHD_EXT2 SHIP_MTHD_EXT2, SHIP_MTHD_EXT3 SHIP_MTHD_EXT3, SHIP_MTHD_EXT4 SHIP_MTHD_EXT4, SHIP_MTHD_EXT5 SHIP_MTHD_EXT5, METH_DESC1 METH_DESC1, NET_WT NET_WT, TARE_WT TARE_WT, PALLET_WT PALLET_WT, BOLSHIP_WT BOLSHIP_WT, BOL_UM_INT BOL_UM_INT, BOL_UM_EXT1 BOL_UM_EXT1, BOL_UM_EXT2 BOL_UM_EXT2, BOL_UM_EXT3 BOL_UM_EXT3, BOL_UM_EXT4 BOL_UM_EXT4, BOL_UM_EXT5 BOL_UM_EXT5, SHIP_VOLUME SHIP_VOLUME, SHIPVOLUME_UM_INT SHIPVOLUME_UM_INT, SHIPVOLUME_UM_EXT1 SHIPVOLUME_UM_EXT1, SHIPVOLUME_UM_EXT2 SHIPVOLUME_UM_EXT2, SHIPVOLUME_UM_EXT3 SHIPVOLUME_UM_EXT3, SHIPVOLUME_UM_EXT4 SHIPVOLUME_UM_EXT4, SHIPVOLUME_UM_EXT5 SHIPVOLUME_UM_EXT5, SHIPTO_CUST_ID SHIPTO_CUST_ID, SHIPTO_CODE_INT SHIPTO_CODE_INT, SHIPTO_CODE_EXT1 SHIPTO_CODE_EXT1, SHIPTO_CODE_EXT2 SHIPTO_CODE_EXT2, SHIPTO_CODE_EXT3 SHIPTO_CODE_EXT3, SHIPTO_CODE_EXT4 SHIPTO_CODE_EXT4, SHIPTO_CODE_EXT5 SHIPTO_CODE_EXT5, SHIPTO_CUST_NAME SHIPTO_CUST_NAME, SHIPTO_ADDR1 SHIPTO_ADDR1, SHIPTO_ADDR2 SHIPTO_ADDR2, SHIPTO_ADDR3 SHIPTO_ADDR3, SHIPTO_ADDR4 SHIPTO_ADDR4, SHIPTO_POSTAL_CODE SHIPTO_POSTAL_CODE, SHIPTO_COUNTRY_CODE_INT SHIPTO_COUNTRY_CODE_INT, SHIPTO_COUNTRY_CODE_EXT1 SHIPTO_COUNTRY_CODE_EXT1, SHIPTO_COUNTRY_CODE_EXT2 SHIPTO_COUNTRY_CODE_EXT2, SHIPTO_COUNTRY_CODE_EXT3 SHIPTO_COUNTRY_CODE_EXT3, SHIPTO_COUNTRY_CODE_EXT4 SHIPTO_COUNTRY_CODE_EXT4, SHIPTO_COUNTRY_CODE_EXT5 SHIPTO_COUNTRY_CODE_EXT5, SHIPTO_STATE_CODE_INT SHIPTO_STATE_CODE_INT, SHIPTO_STATE_CODE_EXT1 SHIPTO_STATE_CODE_EXT1, SHIPTO_STATE_CODE_EXT2 SHIPTO_STATE_CODE_EXT2, SHIPTO_STATE_CODE_EXT3 SHIPTO_STATE_CODE_EXT3, SHIPTO_STATE_CODE_EXT4 SHIPTO_STATE_CODE_EXT4, SHIPTO_STATE_CODE_EXT5 SHIPTO_STATE_CODE_EXT5, SHIPTO_PROVINCE_CODE_INT SHIPTO_PROVINCE_CODE_INT, SHIPTO_PROVINCE_CODE_EXT1 SHIPTO_PROVINCE_CODE_EXT1, SHIPTO_PROVINCE_CODE_EXT2 SHIPTO_PROVINCE_CODE_EXT2, SHIPTO_PROVINCE_CODE_EXT3 SHIPTO_PROVINCE_CODE_EXT3, SHIPTO_PROVINCE_CODE_EXT4 SHIPTO_PROVINCE_CODE_EXT4, SHIPTO_PROVINCE_CODE_EXT5 SHIPTO_PROVINCE_CODE_EXT5, SHIPTO_COUNTY SHIPTO_COUNTY, SHIPTO_LAST_NAME SHIPTO_LAST_NAME, SHIPTO_FIRST_NAME SHIPTO_FIRST_NAME, SHIPTO_JOB_TITLE SHIPTO_JOB_TITLE, SHIPTO_AREA_CODE SHIPTO_AREA_CODE, SHIPTO_TELEPHONE SHIPTO_TELEPHONE, BOLADDR_ID BOLADDR_ID, BOLADDR_ADDR1 BOLADDR_ADDR1, BOLADDR_ADDR2 BOLADDR_ADDR2, BOLADDR_ADDR3 BOLADDR_ADDR3, BOLADDR_ADDR4 BOLADDR_ADDR4, BOLADDR_POSTAL_CODE BOLADDR_POSTAL_CODE, BOLADDR_COUNTRY_CODE_INT BOLADDR_COUNTRY_CODE_INT, BOLADDR_COUNTRY_CODE_EXT1 BOLADDR_COUNTRY_CODE_EXT1, BOLADDR_COUNTRY_CODE_EXT2 BOLADDR_COUNTRY_CODE_EXT2, BOLADDR_COUNTRY_CODE_EXT3 BOLADDR_COUNTRY_CODE_EXT3, BOLADDR_COUNTRY_CODE_EXT4 BOLADDR_COUNTRY_CODE_EXT4, BOLADDR_COUNTRY_CODE_EXT5 BOLADDR_COUNTRY_CODE_EXT5, BOLADDR_STATE_CODE_INT BOLADDR_STATE_CODE_INT, BOLADDR_STATE_CODE_EXT1 BOLADDR_STATE_CODE_EXT1, BOLADDR_STATE_CODE_EXT2 BOLADDR_STATE_CODE_EXT2, BOLADDR_STATE_CODE_EXT3 BOLADDR_STATE_CODE_EXT3, BOLADDR_STATE_CODE_EXT4 BOLADDR_STATE_CODE_EXT4, BOLADDR_STATE_CODE_EXT5 BOLADDR_STATE_CODE_EXT5, BOLADDR_PROVINCE_CODE_INT BOLADDR_PROVINCE_CODE_INT, BOLADDR_PROVINCE_CODE_EXT1 BOLADDR_PROVINCE_CODE_EXT1, BOLADDR_PROVINCE_CODE_EXT2 BOLADDR_PROVINCE_CODE_EXT2, BOLADDR_PROVINCE_CODE_EXT3 BOLADDR_PROVINCE_CODE_EXT3, BOLADDR_PROVINCE_CODE_EXT4 BOLADDR_PROVINCE_CODE_EXT4, BOLADDR_PROVINCE_CODE_EXT5 BOLADDR_PROVINCE_CODE_EXT5, BOLADDR_COUNTY BOLADDR_COUNTY, EDI_TRANS_CNT EDI_TRANS_CNT, DROPOFF_TIME DROPOFF_TIME, PICKUP_TIME PICKUP_TIME, PRINT_COUNT PRINT_COUNT, PRINT_DATE PRINT_DATE, DEMURRAGE_AMT DEMURRAGE_AMT, DEMURRAGE_CURRENCY_CODE_INT DEMURRAGE_CURRENCY_CODE_INT, DEMURRAGE_CURRENCY_EXT1 DEMURRAGE_CURRENCY_EXT1, DEMURRAGE_CURRENCY_EXT2 DEMURRAGE_CURRENCY_EXT2, DEMURRAGE_CURRENCY_EXT3 DEMURRAGE_CURRENCY_EXT3, DEMURRAGE_CURRENCY_EXT4 DEMURRAGE_CURRENCY_EXT4, DEMURRAGE_CURRENCY_EXT5 DEMURRAGE_CURRENCY_EXT5, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, FROM_WHSE FROM_WHSE, FROM_WHSE_NAME FROM_WHSE_NAME, FROM_WHSE_CONTACT FROM_WHSE_CONTACT, FROM_WHSE_PHONE FROM_WHSE_PHONE, FROM_WHSE_ADDR1 FROM_WHSE_ADDR1, FROM_WHSE_ADDR2 FROM_WHSE_ADDR2, FROM_WHSE_ADDR3 FROM_WHSE_ADDR3, FROM_WHSE_ADDR4 FROM_WHSE_ADDR4, FROM_WHSE_POSTAL_CODE FROM_WHSE_POSTAL_CODE, FROM_WHSE_COUNTRY_CODE_INT FROM_WHSE_COUNTRY_CODE_INT, FROM_WHSE_COUNTRY_CODE_EXT1 FROM_WHSE_COUNTRY_CODE_EXT1, FROM_WHSE_COUNTRY_CODE_EXT2 FROM_WHSE_COUNTRY_CODE_EXT2, FROM_WHSE_COUNTRY_CODE_EXT3 FROM_WHSE_COUNTRY_CODE_EXT3, FROM_WHSE_COUNTRY_CODE_EXT4 FROM_WHSE_COUNTRY_CODE_EXT4, FROM_WHSE_COUNTRY_CODE_EXT5 FROM_WHSE_COUNTRY_CODE_EXT5, FROM_WHSE_STATE_CODE_INT FROM_WHSE_STATE_CODE_INT, FROM_WHSE_STATE_CODE_EXT1 FROM_WHSE_STATE_CODE_EXT1, FROM_WHSE_STATE_CODE_EXT2 FROM_WHSE_STATE_CODE_EXT2, FROM_WHSE_STATE_CODE_EXT3 FROM_WHSE_STATE_CODE_EXT3, FROM_WHSE_STATE_CODE_EXT4 FROM_WHSE_STATE_CODE_EXT4, FROM_WHSE_STATE_CODE_EXT5 FROM_WHSE_STATE_CODE_EXT5, FROM_WHSE_PROVINCE_CODE_INT FROM_WHSE_PROVINCE_CODE_INT, FROM_WHSE_PROVINCE_CODE_EXT1 FROM_WHSE_PROVINCE_CODE_EXT1, FROM_WHSE_PROVINCE_CODE_EXT2 FROM_WHSE_PROVINCE_CODE_EXT2, FROM_WHSE_PROVINCE_CODE_EXT3 FROM_WHSE_PROVINCE_CODE_EXT3, FROM_WHSE_PROVINCE_CODE_EXT4 FROM_WHSE_PROVINCE_CODE_EXT4, FROM_WHSE_PROVINCE_CODE_EXT5 FROM_WHSE_PROVINCE_CODE_EXT5, FROM_WHSE_COUNTY FROM_WHSE_COUNTY, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "GML"."GML_GASNO_SHIPMENTS"

View Text - HTML Formatted

SELECT MAP_ID MAP_ID
, COMMUNICATION_METHOD COMMUNICATION_METHOD
, TEST_INDICATOR TEST_INDICATOR
, DOCUMENT_ID DOCUMENT_ID
, TP_HEADER_ID TP_HEADER_ID
, TP_DETAIL_ID TP_DETAIL_ID
, RUN_ID RUN_ID
, DOCUMENT_PURPOSE_CODE DOCUMENT_PURPOSE_CODE
, TP_DOCUMENT_CODE TP_DOCUMENT_CODE
, TP_CODE TP_CODE
, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, TP_DESCRIPTION TP_DESCRIPTION
, TP_REFERENCE1 TP_REFERENCE1
, TP_REFERENCE2 TP_REFERENCE2
, TRANSACTION_DATE TRANSACTION_DATE
, TP_HEADER_CATEGORY TP_HEADER_CATEGORY
, TP_HEADER_ATTRIBUTE1 TP_HEADER_ATTRIBUTE1
, TP_HEADER_ATTRIBUTE2 TP_HEADER_ATTRIBUTE2
, TP_HEADER_ATTRIBUTE3 TP_HEADER_ATTRIBUTE3
, TP_HEADER_ATTRIBUTE4 TP_HEADER_ATTRIBUTE4
, TP_HEADER_ATTRIBUTE5 TP_HEADER_ATTRIBUTE5
, TP_HEADER_ATTRIBUTE6 TP_HEADER_ATTRIBUTE6
, TP_HEADER_ATTRIBUTE7 TP_HEADER_ATTRIBUTE7
, TP_HEADER_ATTRIBUTE8 TP_HEADER_ATTRIBUTE8
, TP_HEADER_ATTRIBUTE9 TP_HEADER_ATTRIBUTE9
, TP_HEADER_ATTRIBUTE10 TP_HEADER_ATTRIBUTE10
, TP_HEADER_ATTRIBUTE11 TP_HEADER_ATTRIBUTE11
, TP_HEADER_ATTRIBUTE12 TP_HEADER_ATTRIBUTE12
, TP_HEADER_ATTRIBUTE13 TP_HEADER_ATTRIBUTE13
, TP_HEADER_ATTRIBUTE14 TP_HEADER_ATTRIBUTE14
, TP_HEADER_ATTRIBUTE15 TP_HEADER_ATTRIBUTE15
, TP_DETAIL_CATEGORY TP_DETAIL_CATEGORY
, TP_DETAIL_ATTRIBUTE1 TP_DETAIL_ATTRIBUTE1
, TP_DETAIL_ATTRIBUTE2 TP_DETAIL_ATTRIBUTE2
, TP_DETAIL_ATTRIBUTE3 TP_DETAIL_ATTRIBUTE3
, TP_DETAIL_ATTRIBUTE4 TP_DETAIL_ATTRIBUTE4
, TP_DETAIL_ATTRIBUTE5 TP_DETAIL_ATTRIBUTE5
, BOL_ID BOL_ID
, BOL_NO BOL_NO
, ORGN_CODE ORGN_CODE
, BOL_COMMENT BOL_COMMENT
, WAYBILL_NO WAYBILL_NO
, FRTBILL_MTHD_INT FRTBILL_MTHD_INT
, FRTBILL_MTHD_EXT1 FRTBILL_MTHD_EXT1
, FRTBILL_MTHD_EXT2 FRTBILL_MTHD_EXT2
, FRTBILL_MTHD_EXT3 FRTBILL_MTHD_EXT3
, FRTBILL_MTHD_EXT4 FRTBILL_MTHD_EXT4
, FRTBILL_MTHD_EXT5 FRTBILL_MTHD_EXT5
, FRTBILL_DESC FRTBILL_DESC
, EMBARKATION_PORT_INT EMBARKATION_PORT_INT
, EMBARKATION_PORT_EXT1 EMBARKATION_PORT_EXT1
, EMBARKATION_PORT_EXT2 EMBARKATION_PORT_EXT2
, EMBARKATION_PORT_EXT3 EMBARKATION_PORT_EXT3
, EMBARKATION_PORT_EXT4 EMBARKATION_PORT_EXT4
, EMBARKATION_PORT_EXT5 EMBARKATION_PORT_EXT5
, EMBARKATION_PORT_DESC EMBARKATION_PORT_DESC
, DEBARKATION_PORT_INT DEBARKATION_PORT_INT
, DEBARKATION_PORT_EXT1 DEBARKATION_PORT_EXT1
, DEBARKATION_PORT_EXT2 DEBARKATION_PORT_EXT2
, DEBARKATION_PORT_EXT3 DEBARKATION_PORT_EXT3
, DEBARKATION_PORT_EXT4 DEBARKATION_PORT_EXT4
, DEBARKATION_PORT_EXT5 DEBARKATION_PORT_EXT5
, DEBARKATION_PORT_DESC DEBARKATION_PORT_DESC
, FOB_CODE_INT FOB_CODE_INT
, FOB_CODE_EXT1 FOB_CODE_EXT1
, FOB_CODE_EXT2 FOB_CODE_EXT2
, FOB_CODE_EXT3 FOB_CODE_EXT3
, FOB_CODE_EXT4 FOB_CODE_EXT4
, FOB_CODE_EXT5 FOB_CODE_EXT5
, FOB_NAME FOB_NAME
, SHIPPER_CODE_INT SHIPPER_CODE_INT
, SHIPPER_CODE_EXT1 SHIPPER_CODE_EXT1
, SHIPPER_CODE_EXT2 SHIPPER_CODE_EXT2
, SHIPPER_CODE_EXT3 SHIPPER_CODE_EXT3
, SHIPPER_CODE_EXT4 SHIPPER_CODE_EXT4
, SHIPPER_CODE_EXT5 SHIPPER_CODE_EXT5
, SHIPPER_NAME SHIPPER_NAME
, SHIP_MTHD_INT SHIP_MTHD_INT
, SHIP_MTHD_EXT1 SHIP_MTHD_EXT1
, SHIP_MTHD_EXT2 SHIP_MTHD_EXT2
, SHIP_MTHD_EXT3 SHIP_MTHD_EXT3
, SHIP_MTHD_EXT4 SHIP_MTHD_EXT4
, SHIP_MTHD_EXT5 SHIP_MTHD_EXT5
, METH_DESC1 METH_DESC1
, NET_WT NET_WT
, TARE_WT TARE_WT
, PALLET_WT PALLET_WT
, BOLSHIP_WT BOLSHIP_WT
, BOL_UM_INT BOL_UM_INT
, BOL_UM_EXT1 BOL_UM_EXT1
, BOL_UM_EXT2 BOL_UM_EXT2
, BOL_UM_EXT3 BOL_UM_EXT3
, BOL_UM_EXT4 BOL_UM_EXT4
, BOL_UM_EXT5 BOL_UM_EXT5
, SHIP_VOLUME SHIP_VOLUME
, SHIPVOLUME_UM_INT SHIPVOLUME_UM_INT
, SHIPVOLUME_UM_EXT1 SHIPVOLUME_UM_EXT1
, SHIPVOLUME_UM_EXT2 SHIPVOLUME_UM_EXT2
, SHIPVOLUME_UM_EXT3 SHIPVOLUME_UM_EXT3
, SHIPVOLUME_UM_EXT4 SHIPVOLUME_UM_EXT4
, SHIPVOLUME_UM_EXT5 SHIPVOLUME_UM_EXT5
, SHIPTO_CUST_ID SHIPTO_CUST_ID
, SHIPTO_CODE_INT SHIPTO_CODE_INT
, SHIPTO_CODE_EXT1 SHIPTO_CODE_EXT1
, SHIPTO_CODE_EXT2 SHIPTO_CODE_EXT2
, SHIPTO_CODE_EXT3 SHIPTO_CODE_EXT3
, SHIPTO_CODE_EXT4 SHIPTO_CODE_EXT4
, SHIPTO_CODE_EXT5 SHIPTO_CODE_EXT5
, SHIPTO_CUST_NAME SHIPTO_CUST_NAME
, SHIPTO_ADDR1 SHIPTO_ADDR1
, SHIPTO_ADDR2 SHIPTO_ADDR2
, SHIPTO_ADDR3 SHIPTO_ADDR3
, SHIPTO_ADDR4 SHIPTO_ADDR4
, SHIPTO_POSTAL_CODE SHIPTO_POSTAL_CODE
, SHIPTO_COUNTRY_CODE_INT SHIPTO_COUNTRY_CODE_INT
, SHIPTO_COUNTRY_CODE_EXT1 SHIPTO_COUNTRY_CODE_EXT1
, SHIPTO_COUNTRY_CODE_EXT2 SHIPTO_COUNTRY_CODE_EXT2
, SHIPTO_COUNTRY_CODE_EXT3 SHIPTO_COUNTRY_CODE_EXT3
, SHIPTO_COUNTRY_CODE_EXT4 SHIPTO_COUNTRY_CODE_EXT4
, SHIPTO_COUNTRY_CODE_EXT5 SHIPTO_COUNTRY_CODE_EXT5
, SHIPTO_STATE_CODE_INT SHIPTO_STATE_CODE_INT
, SHIPTO_STATE_CODE_EXT1 SHIPTO_STATE_CODE_EXT1
, SHIPTO_STATE_CODE_EXT2 SHIPTO_STATE_CODE_EXT2
, SHIPTO_STATE_CODE_EXT3 SHIPTO_STATE_CODE_EXT3
, SHIPTO_STATE_CODE_EXT4 SHIPTO_STATE_CODE_EXT4
, SHIPTO_STATE_CODE_EXT5 SHIPTO_STATE_CODE_EXT5
, SHIPTO_PROVINCE_CODE_INT SHIPTO_PROVINCE_CODE_INT
, SHIPTO_PROVINCE_CODE_EXT1 SHIPTO_PROVINCE_CODE_EXT1
, SHIPTO_PROVINCE_CODE_EXT2 SHIPTO_PROVINCE_CODE_EXT2
, SHIPTO_PROVINCE_CODE_EXT3 SHIPTO_PROVINCE_CODE_EXT3
, SHIPTO_PROVINCE_CODE_EXT4 SHIPTO_PROVINCE_CODE_EXT4
, SHIPTO_PROVINCE_CODE_EXT5 SHIPTO_PROVINCE_CODE_EXT5
, SHIPTO_COUNTY SHIPTO_COUNTY
, SHIPTO_LAST_NAME SHIPTO_LAST_NAME
, SHIPTO_FIRST_NAME SHIPTO_FIRST_NAME
, SHIPTO_JOB_TITLE SHIPTO_JOB_TITLE
, SHIPTO_AREA_CODE SHIPTO_AREA_CODE
, SHIPTO_TELEPHONE SHIPTO_TELEPHONE
, BOLADDR_ID BOLADDR_ID
, BOLADDR_ADDR1 BOLADDR_ADDR1
, BOLADDR_ADDR2 BOLADDR_ADDR2
, BOLADDR_ADDR3 BOLADDR_ADDR3
, BOLADDR_ADDR4 BOLADDR_ADDR4
, BOLADDR_POSTAL_CODE BOLADDR_POSTAL_CODE
, BOLADDR_COUNTRY_CODE_INT BOLADDR_COUNTRY_CODE_INT
, BOLADDR_COUNTRY_CODE_EXT1 BOLADDR_COUNTRY_CODE_EXT1
, BOLADDR_COUNTRY_CODE_EXT2 BOLADDR_COUNTRY_CODE_EXT2
, BOLADDR_COUNTRY_CODE_EXT3 BOLADDR_COUNTRY_CODE_EXT3
, BOLADDR_COUNTRY_CODE_EXT4 BOLADDR_COUNTRY_CODE_EXT4
, BOLADDR_COUNTRY_CODE_EXT5 BOLADDR_COUNTRY_CODE_EXT5
, BOLADDR_STATE_CODE_INT BOLADDR_STATE_CODE_INT
, BOLADDR_STATE_CODE_EXT1 BOLADDR_STATE_CODE_EXT1
, BOLADDR_STATE_CODE_EXT2 BOLADDR_STATE_CODE_EXT2
, BOLADDR_STATE_CODE_EXT3 BOLADDR_STATE_CODE_EXT3
, BOLADDR_STATE_CODE_EXT4 BOLADDR_STATE_CODE_EXT4
, BOLADDR_STATE_CODE_EXT5 BOLADDR_STATE_CODE_EXT5
, BOLADDR_PROVINCE_CODE_INT BOLADDR_PROVINCE_CODE_INT
, BOLADDR_PROVINCE_CODE_EXT1 BOLADDR_PROVINCE_CODE_EXT1
, BOLADDR_PROVINCE_CODE_EXT2 BOLADDR_PROVINCE_CODE_EXT2
, BOLADDR_PROVINCE_CODE_EXT3 BOLADDR_PROVINCE_CODE_EXT3
, BOLADDR_PROVINCE_CODE_EXT4 BOLADDR_PROVINCE_CODE_EXT4
, BOLADDR_PROVINCE_CODE_EXT5 BOLADDR_PROVINCE_CODE_EXT5
, BOLADDR_COUNTY BOLADDR_COUNTY
, EDI_TRANS_CNT EDI_TRANS_CNT
, DROPOFF_TIME DROPOFF_TIME
, PICKUP_TIME PICKUP_TIME
, PRINT_COUNT PRINT_COUNT
, PRINT_DATE PRINT_DATE
, DEMURRAGE_AMT DEMURRAGE_AMT
, DEMURRAGE_CURRENCY_CODE_INT DEMURRAGE_CURRENCY_CODE_INT
, DEMURRAGE_CURRENCY_EXT1 DEMURRAGE_CURRENCY_EXT1
, DEMURRAGE_CURRENCY_EXT2 DEMURRAGE_CURRENCY_EXT2
, DEMURRAGE_CURRENCY_EXT3 DEMURRAGE_CURRENCY_EXT3
, DEMURRAGE_CURRENCY_EXT4 DEMURRAGE_CURRENCY_EXT4
, DEMURRAGE_CURRENCY_EXT5 DEMURRAGE_CURRENCY_EXT5
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, FROM_WHSE FROM_WHSE
, FROM_WHSE_NAME FROM_WHSE_NAME
, FROM_WHSE_CONTACT FROM_WHSE_CONTACT
, FROM_WHSE_PHONE FROM_WHSE_PHONE
, FROM_WHSE_ADDR1 FROM_WHSE_ADDR1
, FROM_WHSE_ADDR2 FROM_WHSE_ADDR2
, FROM_WHSE_ADDR3 FROM_WHSE_ADDR3
, FROM_WHSE_ADDR4 FROM_WHSE_ADDR4
, FROM_WHSE_POSTAL_CODE FROM_WHSE_POSTAL_CODE
, FROM_WHSE_COUNTRY_CODE_INT FROM_WHSE_COUNTRY_CODE_INT
, FROM_WHSE_COUNTRY_CODE_EXT1 FROM_WHSE_COUNTRY_CODE_EXT1
, FROM_WHSE_COUNTRY_CODE_EXT2 FROM_WHSE_COUNTRY_CODE_EXT2
, FROM_WHSE_COUNTRY_CODE_EXT3 FROM_WHSE_COUNTRY_CODE_EXT3
, FROM_WHSE_COUNTRY_CODE_EXT4 FROM_WHSE_COUNTRY_CODE_EXT4
, FROM_WHSE_COUNTRY_CODE_EXT5 FROM_WHSE_COUNTRY_CODE_EXT5
, FROM_WHSE_STATE_CODE_INT FROM_WHSE_STATE_CODE_INT
, FROM_WHSE_STATE_CODE_EXT1 FROM_WHSE_STATE_CODE_EXT1
, FROM_WHSE_STATE_CODE_EXT2 FROM_WHSE_STATE_CODE_EXT2
, FROM_WHSE_STATE_CODE_EXT3 FROM_WHSE_STATE_CODE_EXT3
, FROM_WHSE_STATE_CODE_EXT4 FROM_WHSE_STATE_CODE_EXT4
, FROM_WHSE_STATE_CODE_EXT5 FROM_WHSE_STATE_CODE_EXT5
, FROM_WHSE_PROVINCE_CODE_INT FROM_WHSE_PROVINCE_CODE_INT
, FROM_WHSE_PROVINCE_CODE_EXT1 FROM_WHSE_PROVINCE_CODE_EXT1
, FROM_WHSE_PROVINCE_CODE_EXT2 FROM_WHSE_PROVINCE_CODE_EXT2
, FROM_WHSE_PROVINCE_CODE_EXT3 FROM_WHSE_PROVINCE_CODE_EXT3
, FROM_WHSE_PROVINCE_CODE_EXT4 FROM_WHSE_PROVINCE_CODE_EXT4
, FROM_WHSE_PROVINCE_CODE_EXT5 FROM_WHSE_PROVINCE_CODE_EXT5
, FROM_WHSE_COUNTY FROM_WHSE_COUNTY
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "GML"."GML_GASNO_SHIPMENTS"