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_GPOAO_ORDERS#

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, DOCUMENT_CODE 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, ORDER_ID ORDER_ID, ORDER_NO ORDER_NO, ORGN_CODE ORGN_CODE, ORDER_COMMENT ORDER_COMMENT, ORDER_STATUS ORDER_STATUS, CUSTPO_NO CUSTPO_NO, SO_DATE SO_DATE, 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, BILLTO_CUST_ID BILLTO_CUST_ID, BILLTO_CODE_INT BILLTO_CODE_INT, BILLTO_CODE_EXT1 BILLTO_CODE_EXT1, BILLTO_CODE_EXT2 BILLTO_CODE_EXT2, BILLTO_CODE_EXT3 BILLTO_CODE_EXT3, BILLTO_CODE_EXT4 BILLTO_CODE_EXT4, BILLTO_CODE_EXT5 BILLTO_CODE_EXT5, BILLTO_CUST_NAME BILLTO_CUST_NAME, BILLTO_ADDR1 BILLTO_ADDR1, BILLTO_ADDR2 BILLTO_ADDR2, BILLTO_ADDR3 BILLTO_ADDR3, BILLTO_ADDR4 BILLTO_ADDR4, BILLTO_POSTAL_CODE BILLTO_POSTAL_CODE, BILLTO_COUNTRY_CODE_INT BILLTO_COUNTRY_CODE_INT, BILLTO_COUNTRY_CODE_EXT1 BILLTO_COUNTRY_CODE_EXT1, BILLTO_COUNTRY_CODE_EXT2 BILLTO_COUNTRY_CODE_EXT2, BILLTO_COUNTRY_CODE_EXT3 BILLTO_COUNTRY_CODE_EXT3, BILLTO_COUNTRY_CODE_EXT4 BILLTO_COUNTRY_CODE_EXT4, BILLTO_COUNTRY_CODE_EXT5 BILLTO_COUNTRY_CODE_EXT5, BILLTO_STATE_CODE_INT BILLTO_STATE_CODE_INT, BILLTO_STATE_CODE_EXT1 BILLTO_STATE_CODE_EXT1, BILLTO_STATE_CODE_EXT2 BILLTO_STATE_CODE_EXT2, BILLTO_STATE_CODE_EXT3 BILLTO_STATE_CODE_EXT3, BILLTO_STATE_CODE_EXT4 BILLTO_STATE_CODE_EXT4, BILLTO_STATE_CODE_EXT5 BILLTO_STATE_CODE_EXT5, BILLTO_PROVINCE_CODE_INT BILLTO_PROVINCE_CODE_INT, BILLTO_PROVINCE_CODE_EXT1 BILLTO_PROVINCE_CODE_EXT1, BILLTO_PROVINCE_CODE_EXT2 BILLTO_PROVINCE_CODE_EXT2, BILLTO_PROVINCE_CODE_EXT3 BILLTO_PROVINCE_CODE_EXT3, BILLTO_PROVINCE_CODE_EXT4 BILLTO_PROVINCE_CODE_EXT4, BILLTO_PROVINCE_CODE_EXT5 BILLTO_PROVINCE_CODE_EXT5, BILLTO_COUNTY BILLTO_COUNTY, BILLTO_LAST_NAME BILLTO_LAST_NAME, BILLTO_FIRST_NAME BILLTO_FIRST_NAME, BILLTO_JOB_TITLE BILLTO_JOB_TITLE, BILLTO_AREA_CODE BILLTO_AREA_CODE, BILLTO_TELEPHONE BILLTO_TELEPHONE, 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, SHIPADDR_ID SHIPADDR_ID, SHIPADDR_ADDR1 SHIPADDR_ADDR1, SHIPADDR_ADDR2 SHIPADDR_ADDR2, SHIPADDR_ADDR3 SHIPADDR_ADDR3, SHIPADDR_ADDR4 SHIPADDR_ADDR4, SHIPADDR_POSTAL_CODE SHIPADDR_POSTAL_CODE, SHIPADDR_COUNTRY_CODE_INT SHIPADDR_COUNTRY_CODE_INT, SHIPADDR_COUNTRY_CODE_EXT1 SHIPADDR_COUNTRY_CODE_EXT1, SHIPADDR_COUNTRY_CODE_EXT2 SHIPADDR_COUNTRY_CODE_EXT2, SHIPADDR_COUNTRY_CODE_EXT3 SHIPADDR_COUNTRY_CODE_EXT3, SHIPADDR_COUNTRY_CODE_EXT4 SHIPADDR_COUNTRY_CODE_EXT4, SHIPADDR_COUNTRY_CODE_EXT5 SHIPADDR_COUNTRY_CODE_EXT5, SHIPADDR_STATE_CODE_INT SHIPADDR_STATE_CODE_INT, SHIPADDR_STATE_CODE_EXT1 SHIPADDR_STATE_CODE_EXT1, SHIPADDR_STATE_CODE_EXT2 SHIPADDR_STATE_CODE_EXT2, SHIPADDR_STATE_CODE_EXT3 SHIPADDR_STATE_CODE_EXT3, SHIPADDR_STATE_CODE_EXT4 SHIPADDR_STATE_CODE_EXT4, SHIPADDR_STATE_CODE_EXT5 SHIPADDR_STATE_CODE_EXT5, SHIPADDR_PROVINCE_CODE_INT SHIPADDR_PROVINCE_CODE_INT, SHIPADDR_PROVINCE_CODE_EXT1 SHIPADDR_PROVINCE_CODE_EXT1, SHIPADDR_PROVINCE_CODE_EXT2 SHIPADDR_PROVINCE_CODE_EXT2, SHIPADDR_PROVINCE_CODE_EXT3 SHIPADDR_PROVINCE_CODE_EXT3, SHIPADDR_PROVINCE_CODE_EXT4 SHIPADDR_PROVINCE_CODE_EXT4, SHIPADDR_PROVINCE_CODE_EXT5 SHIPADDR_PROVINCE_CODE_EXT5, SHIPADDR_COUNTY SHIPADDR_COUNTY, EDI_TRANS_CNT EDI_TRANS_CNT, PRINT_COUNT PRINT_COUNT, PRINT_DATE PRINT_DATE, 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, SO_HEADER_CATEGORY SO_HEADER_CATEGORY, SO_HEADER_ATTRIBUTE1 SO_HEADER_ATTRIBUTE1, SO_HEADER_ATTRIBUTE2 SO_HEADER_ATTRIBUTE2, SO_HEADER_ATTRIBUTE3 SO_HEADER_ATTRIBUTE3, SO_HEADER_ATTRIBUTE4 SO_HEADER_ATTRIBUTE4, SO_HEADER_ATTRIBUTE5 SO_HEADER_ATTRIBUTE5, SO_HEADER_ATTRIBUTE6 SO_HEADER_ATTRIBUTE6, SO_HEADER_ATTRIBUTE7 SO_HEADER_ATTRIBUTE7, SO_HEADER_ATTRIBUTE8 SO_HEADER_ATTRIBUTE8, SO_HEADER_ATTRIBUTE9 SO_HEADER_ATTRIBUTE9, SO_HEADER_ATTRIBUTE10 SO_HEADER_ATTRIBUTE10, SO_HEADER_ATTRIBUTE11 SO_HEADER_ATTRIBUTE11, SO_HEADER_ATTRIBUTE12 SO_HEADER_ATTRIBUTE12, SO_HEADER_ATTRIBUTE13 SO_HEADER_ATTRIBUTE13, SO_HEADER_ATTRIBUTE14 SO_HEADER_ATTRIBUTE14, SO_HEADER_ATTRIBUTE15 SO_HEADER_ATTRIBUTE15, SO_HEADER_ATTRIBUTE16 SO_HEADER_ATTRIBUTE16, SO_HEADER_ATTRIBUTE17 SO_HEADER_ATTRIBUTE17, SO_HEADER_ATTRIBUTE18 SO_HEADER_ATTRIBUTE18, SO_HEADER_ATTRIBUTE19 SO_HEADER_ATTRIBUTE19, SO_HEADER_ATTRIBUTE20 SO_HEADER_ATTRIBUTE20, SO_HEADER_ATTRIBUTE21 SO_HEADER_ATTRIBUTE21, SO_HEADER_ATTRIBUTE22 SO_HEADER_ATTRIBUTE22, SO_HEADER_ATTRIBUTE23 SO_HEADER_ATTRIBUTE23, SO_HEADER_ATTRIBUTE24 SO_HEADER_ATTRIBUTE24, SO_HEADER_ATTRIBUTE25 SO_HEADER_ATTRIBUTE25, SO_HEADER_ATTRIBUTE26 SO_HEADER_ATTRIBUTE26, SO_HEADER_ATTRIBUTE27 SO_HEADER_ATTRIBUTE27, SO_HEADER_ATTRIBUTE28 SO_HEADER_ATTRIBUTE28, SO_HEADER_ATTRIBUTE29 SO_HEADER_ATTRIBUTE29, SO_HEADER_ATTRIBUTE30 SO_HEADER_ATTRIBUTE30, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, 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, ORDER_STATUS_CODE ORDER_STATUS_CODE from "GML"."GML_GPOAO_ORDERS"

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
, DOCUMENT_CODE 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
, ORDER_ID ORDER_ID
, ORDER_NO ORDER_NO
, ORGN_CODE ORGN_CODE
, ORDER_COMMENT ORDER_COMMENT
, ORDER_STATUS ORDER_STATUS
, CUSTPO_NO CUSTPO_NO
, SO_DATE SO_DATE
, 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
, BILLTO_CUST_ID BILLTO_CUST_ID
, BILLTO_CODE_INT BILLTO_CODE_INT
, BILLTO_CODE_EXT1 BILLTO_CODE_EXT1
, BILLTO_CODE_EXT2 BILLTO_CODE_EXT2
, BILLTO_CODE_EXT3 BILLTO_CODE_EXT3
, BILLTO_CODE_EXT4 BILLTO_CODE_EXT4
, BILLTO_CODE_EXT5 BILLTO_CODE_EXT5
, BILLTO_CUST_NAME BILLTO_CUST_NAME
, BILLTO_ADDR1 BILLTO_ADDR1
, BILLTO_ADDR2 BILLTO_ADDR2
, BILLTO_ADDR3 BILLTO_ADDR3
, BILLTO_ADDR4 BILLTO_ADDR4
, BILLTO_POSTAL_CODE BILLTO_POSTAL_CODE
, BILLTO_COUNTRY_CODE_INT BILLTO_COUNTRY_CODE_INT
, BILLTO_COUNTRY_CODE_EXT1 BILLTO_COUNTRY_CODE_EXT1
, BILLTO_COUNTRY_CODE_EXT2 BILLTO_COUNTRY_CODE_EXT2
, BILLTO_COUNTRY_CODE_EXT3 BILLTO_COUNTRY_CODE_EXT3
, BILLTO_COUNTRY_CODE_EXT4 BILLTO_COUNTRY_CODE_EXT4
, BILLTO_COUNTRY_CODE_EXT5 BILLTO_COUNTRY_CODE_EXT5
, BILLTO_STATE_CODE_INT BILLTO_STATE_CODE_INT
, BILLTO_STATE_CODE_EXT1 BILLTO_STATE_CODE_EXT1
, BILLTO_STATE_CODE_EXT2 BILLTO_STATE_CODE_EXT2
, BILLTO_STATE_CODE_EXT3 BILLTO_STATE_CODE_EXT3
, BILLTO_STATE_CODE_EXT4 BILLTO_STATE_CODE_EXT4
, BILLTO_STATE_CODE_EXT5 BILLTO_STATE_CODE_EXT5
, BILLTO_PROVINCE_CODE_INT BILLTO_PROVINCE_CODE_INT
, BILLTO_PROVINCE_CODE_EXT1 BILLTO_PROVINCE_CODE_EXT1
, BILLTO_PROVINCE_CODE_EXT2 BILLTO_PROVINCE_CODE_EXT2
, BILLTO_PROVINCE_CODE_EXT3 BILLTO_PROVINCE_CODE_EXT3
, BILLTO_PROVINCE_CODE_EXT4 BILLTO_PROVINCE_CODE_EXT4
, BILLTO_PROVINCE_CODE_EXT5 BILLTO_PROVINCE_CODE_EXT5
, BILLTO_COUNTY BILLTO_COUNTY
, BILLTO_LAST_NAME BILLTO_LAST_NAME
, BILLTO_FIRST_NAME BILLTO_FIRST_NAME
, BILLTO_JOB_TITLE BILLTO_JOB_TITLE
, BILLTO_AREA_CODE BILLTO_AREA_CODE
, BILLTO_TELEPHONE BILLTO_TELEPHONE
, 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
, SHIPADDR_ID SHIPADDR_ID
, SHIPADDR_ADDR1 SHIPADDR_ADDR1
, SHIPADDR_ADDR2 SHIPADDR_ADDR2
, SHIPADDR_ADDR3 SHIPADDR_ADDR3
, SHIPADDR_ADDR4 SHIPADDR_ADDR4
, SHIPADDR_POSTAL_CODE SHIPADDR_POSTAL_CODE
, SHIPADDR_COUNTRY_CODE_INT SHIPADDR_COUNTRY_CODE_INT
, SHIPADDR_COUNTRY_CODE_EXT1 SHIPADDR_COUNTRY_CODE_EXT1
, SHIPADDR_COUNTRY_CODE_EXT2 SHIPADDR_COUNTRY_CODE_EXT2
, SHIPADDR_COUNTRY_CODE_EXT3 SHIPADDR_COUNTRY_CODE_EXT3
, SHIPADDR_COUNTRY_CODE_EXT4 SHIPADDR_COUNTRY_CODE_EXT4
, SHIPADDR_COUNTRY_CODE_EXT5 SHIPADDR_COUNTRY_CODE_EXT5
, SHIPADDR_STATE_CODE_INT SHIPADDR_STATE_CODE_INT
, SHIPADDR_STATE_CODE_EXT1 SHIPADDR_STATE_CODE_EXT1
, SHIPADDR_STATE_CODE_EXT2 SHIPADDR_STATE_CODE_EXT2
, SHIPADDR_STATE_CODE_EXT3 SHIPADDR_STATE_CODE_EXT3
, SHIPADDR_STATE_CODE_EXT4 SHIPADDR_STATE_CODE_EXT4
, SHIPADDR_STATE_CODE_EXT5 SHIPADDR_STATE_CODE_EXT5
, SHIPADDR_PROVINCE_CODE_INT SHIPADDR_PROVINCE_CODE_INT
, SHIPADDR_PROVINCE_CODE_EXT1 SHIPADDR_PROVINCE_CODE_EXT1
, SHIPADDR_PROVINCE_CODE_EXT2 SHIPADDR_PROVINCE_CODE_EXT2
, SHIPADDR_PROVINCE_CODE_EXT3 SHIPADDR_PROVINCE_CODE_EXT3
, SHIPADDR_PROVINCE_CODE_EXT4 SHIPADDR_PROVINCE_CODE_EXT4
, SHIPADDR_PROVINCE_CODE_EXT5 SHIPADDR_PROVINCE_CODE_EXT5
, SHIPADDR_COUNTY SHIPADDR_COUNTY
, EDI_TRANS_CNT EDI_TRANS_CNT
, PRINT_COUNT PRINT_COUNT
, PRINT_DATE PRINT_DATE
, 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
, SO_HEADER_CATEGORY SO_HEADER_CATEGORY
, SO_HEADER_ATTRIBUTE1 SO_HEADER_ATTRIBUTE1
, SO_HEADER_ATTRIBUTE2 SO_HEADER_ATTRIBUTE2
, SO_HEADER_ATTRIBUTE3 SO_HEADER_ATTRIBUTE3
, SO_HEADER_ATTRIBUTE4 SO_HEADER_ATTRIBUTE4
, SO_HEADER_ATTRIBUTE5 SO_HEADER_ATTRIBUTE5
, SO_HEADER_ATTRIBUTE6 SO_HEADER_ATTRIBUTE6
, SO_HEADER_ATTRIBUTE7 SO_HEADER_ATTRIBUTE7
, SO_HEADER_ATTRIBUTE8 SO_HEADER_ATTRIBUTE8
, SO_HEADER_ATTRIBUTE9 SO_HEADER_ATTRIBUTE9
, SO_HEADER_ATTRIBUTE10 SO_HEADER_ATTRIBUTE10
, SO_HEADER_ATTRIBUTE11 SO_HEADER_ATTRIBUTE11
, SO_HEADER_ATTRIBUTE12 SO_HEADER_ATTRIBUTE12
, SO_HEADER_ATTRIBUTE13 SO_HEADER_ATTRIBUTE13
, SO_HEADER_ATTRIBUTE14 SO_HEADER_ATTRIBUTE14
, SO_HEADER_ATTRIBUTE15 SO_HEADER_ATTRIBUTE15
, SO_HEADER_ATTRIBUTE16 SO_HEADER_ATTRIBUTE16
, SO_HEADER_ATTRIBUTE17 SO_HEADER_ATTRIBUTE17
, SO_HEADER_ATTRIBUTE18 SO_HEADER_ATTRIBUTE18
, SO_HEADER_ATTRIBUTE19 SO_HEADER_ATTRIBUTE19
, SO_HEADER_ATTRIBUTE20 SO_HEADER_ATTRIBUTE20
, SO_HEADER_ATTRIBUTE21 SO_HEADER_ATTRIBUTE21
, SO_HEADER_ATTRIBUTE22 SO_HEADER_ATTRIBUTE22
, SO_HEADER_ATTRIBUTE23 SO_HEADER_ATTRIBUTE23
, SO_HEADER_ATTRIBUTE24 SO_HEADER_ATTRIBUTE24
, SO_HEADER_ATTRIBUTE25 SO_HEADER_ATTRIBUTE25
, SO_HEADER_ATTRIBUTE26 SO_HEADER_ATTRIBUTE26
, SO_HEADER_ATTRIBUTE27 SO_HEADER_ATTRIBUTE27
, SO_HEADER_ATTRIBUTE28 SO_HEADER_ATTRIBUTE28
, SO_HEADER_ATTRIBUTE29 SO_HEADER_ATTRIBUTE29
, SO_HEADER_ATTRIBUTE30 SO_HEADER_ATTRIBUTE30
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, 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
, ORDER_STATUS_CODE ORDER_STATUS_CODE
FROM "GML"."GML_GPOAO_ORDERS"