VIEW: GML.OP_ORDR_HDR#

Source

View Text - Preformatted

select ORDER_ID ORDER_ID, ORDER_TYPE ORDER_TYPE, IN_USE IN_USE, DEBARKATION_PORT DEBARKATION_PORT, BILLCUST_ID BILLCUST_ID, SHIPCUST_ID SHIPCUST_ID, SHIPADDR_ID SHIPADDR_ID, SHIPPER_CODE SHIPPER_CODE, SOLDTOCUST_ID SOLDTOCUST_ID, CUSTPO_NO CUSTPO_NO, CONTACT_ID CONTACT_ID, SLSREP_CODE SLSREP_CODE, COMMISSION_CODE COMMISSION_CODE, BILLING_CURRENCY BILLING_CURRENCY, FROM_WHSE FROM_WHSE, TO_WHSE TO_WHSE, FOB_CODE FOB_CODE, TERMS_CODE TERMS_CODE, ORGN_CODE ORGN_CODE, ORDER_COMMENT ORDER_COMMENT, COMPLETED_IND COMPLETED_IND, REGISTERED_IND REGISTERED_IND, PRINT_COUNT PRINT_COUNT, LOCKBOX_CODE LOCKBOX_CODE, ORDER_STATUS ORDER_STATUS, COA_REQUIRED COA_REQUIRED, DATE_PRINTED DATE_PRINTED, ORDER_NO ORDER_NO, HOLDREAS_CODE HOLDREAS_CODE, EMBARKATION_PORT EMBARKATION_PORT, HOLD_EXPIRATION HOLD_EXPIRATION, ORDER_DATE ORDER_DATE, REQUESTED_SHIPDATE REQUESTED_SHIPDATE, PROMISED_SHIPDATE PROMISED_SHIPDATE, SCHED_SHIPDATE SCHED_SHIPDATE, REQUIRED_DLVDATE REQUIRED_DLVDATE, RELEASE_NO RELEASE_NO, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TEXT_CODE TEXT_CODE, DELETE_MARK DELETE_MARK, PRESALES_ORD_ID PRESALES_ORD_ID, TOTAL_OPEN_AMOUNT TOTAL_OPEN_AMOUNT, SOURCE_IND SOURCE_IND, EDI_TRANS_COUNT EDI_TRANS_COUNT, CONSIGNEE_ID CONSIGNEE_ID, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID, SHIP_MTHD SHIP_MTHD, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE6 ATTRIBUTE6, CHANGEREAS_CODE CHANGEREAS_CODE, FRTBILL_MTHD FRTBILL_MTHD, UPGRADE_FLAG UPGRADE_FLAG, UPGRADE_DATE UPGRADE_DATE, OPM_SHIPCUST_ID OPM_SHIPCUST_ID, OPM_BILLCUST_ID OPM_BILLCUST_ID, OPM_SOLDTOCUST_ID OPM_SOLDTOCUST_ID, OPM_ULTIMATE_SHIPCUST_ID OPM_ULTIMATE_SHIPCUST_ID from "GML"."OP_ORDR_HDR"

View Text - HTML Formatted

SELECT ORDER_ID ORDER_ID
, ORDER_TYPE ORDER_TYPE
, IN_USE IN_USE
, DEBARKATION_PORT DEBARKATION_PORT
, BILLCUST_ID BILLCUST_ID
, SHIPCUST_ID SHIPCUST_ID
, SHIPADDR_ID SHIPADDR_ID
, SHIPPER_CODE SHIPPER_CODE
, SOLDTOCUST_ID SOLDTOCUST_ID
, CUSTPO_NO CUSTPO_NO
, CONTACT_ID CONTACT_ID
, SLSREP_CODE SLSREP_CODE
, COMMISSION_CODE COMMISSION_CODE
, BILLING_CURRENCY BILLING_CURRENCY
, FROM_WHSE FROM_WHSE
, TO_WHSE TO_WHSE
, FOB_CODE FOB_CODE
, TERMS_CODE TERMS_CODE
, ORGN_CODE ORGN_CODE
, ORDER_COMMENT ORDER_COMMENT
, COMPLETED_IND COMPLETED_IND
, REGISTERED_IND REGISTERED_IND
, PRINT_COUNT PRINT_COUNT
, LOCKBOX_CODE LOCKBOX_CODE
, ORDER_STATUS ORDER_STATUS
, COA_REQUIRED COA_REQUIRED
, DATE_PRINTED DATE_PRINTED
, ORDER_NO ORDER_NO
, HOLDREAS_CODE HOLDREAS_CODE
, EMBARKATION_PORT EMBARKATION_PORT
, HOLD_EXPIRATION HOLD_EXPIRATION
, ORDER_DATE ORDER_DATE
, REQUESTED_SHIPDATE REQUESTED_SHIPDATE
, PROMISED_SHIPDATE PROMISED_SHIPDATE
, SCHED_SHIPDATE SCHED_SHIPDATE
, REQUIRED_DLVDATE REQUIRED_DLVDATE
, RELEASE_NO RELEASE_NO
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TEXT_CODE TEXT_CODE
, DELETE_MARK DELETE_MARK
, PRESALES_ORD_ID PRESALES_ORD_ID
, TOTAL_OPEN_AMOUNT TOTAL_OPEN_AMOUNT
, SOURCE_IND SOURCE_IND
, EDI_TRANS_COUNT EDI_TRANS_COUNT
, CONSIGNEE_ID CONSIGNEE_ID
, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID
, SHIP_MTHD SHIP_MTHD
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE6 ATTRIBUTE6
, CHANGEREAS_CODE CHANGEREAS_CODE
, FRTBILL_MTHD FRTBILL_MTHD
, UPGRADE_FLAG UPGRADE_FLAG
, UPGRADE_DATE UPGRADE_DATE
, OPM_SHIPCUST_ID OPM_SHIPCUST_ID
, OPM_BILLCUST_ID OPM_BILLCUST_ID
, OPM_SOLDTOCUST_ID OPM_SOLDTOCUST_ID
, OPM_ULTIMATE_SHIPCUST_ID OPM_ULTIMATE_SHIPCUST_ID
FROM "GML"."OP_ORDR_HDR"