[Home] [Help] [Dependency Information]

VIEW: GML.GML_GASNO_SHIPMENTS#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

GML

GML_GASNO_SHIPMENTS

APPS

GML_GASNO_SHIPMENTS