VIEW: GML.OP_PRSL_HDR#

Source

View Text - Preformatted

select HOLD_EXPIRATION HOLD_EXPIRATION, PRESALES_ORD_ID PRESALES_ORD_ID, SOLDTOCUST_ID SOLDTOCUST_ID, ORGN_CODE ORGN_CODE, PRESALES_ORD_NO PRESALES_ORD_NO, PRESALES_ORD_DESC PRESALES_ORD_DESC, SHIPCUST_ID SHIPCUST_ID, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID, PRESALES_ORD_TYPE PRESALES_ORD_TYPE, CONSIGNEE_ID CONSIGNEE_ID, CUSTTRADE_CLASS CUSTTRADE_CLASS, EFFECTIVE_DATE EFFECTIVE_DATE, EXPIRATION_DATE EXPIRATION_DATE, BILLCUST_ID BILLCUST_ID, REMIT_TO_LOCKBOX REMIT_TO_LOCKBOX, SHIPADDR_ID SHIPADDR_ID, CONTACT_ID CONTACT_ID, PROFORMA_INVOICE_REQD PROFORMA_INVOICE_REQD, SHIP_MTHD SHIP_MTHD, SHIPPER_CODE SHIPPER_CODE, SLSREP_CODE SLSREP_CODE, COMMISSION_CODE COMMISSION_CODE, BILLING_CURRENCY BILLING_CURRENCY, TO_WHSE TO_WHSE, FROM_WHSE FROM_WHSE, EMBARKATION_PORT EMBARKATION_PORT, DEBARKATION_PORT DEBARKATION_PORT, FOB_CODE FOB_CODE, TERMS_CODE TERMS_CODE, FRTBILL_MTHD FRTBILL_MTHD, ORDER_TYPE ORDER_TYPE, CUSTPO_NO CUSTPO_NO, CONTRACT_NO CONTRACT_NO, ORDER_EXCHANGE_RATE ORDER_EXCHANGE_RATE, MUL_DIV_SIGN MUL_DIV_SIGN, ORDER_COMMENT ORDER_COMMENT, COA_REQUIRED COA_REQUIRED, BACKORDER_IND BACKORDER_IND, MINSHIP_PCT MINSHIP_PCT, MAXSHIP_PCT MAXSHIP_PCT, MIN_CLOSE_PERCENT MIN_CLOSE_PERCENT, ORDER_MAX_VALUE ORDER_MAX_VALUE, ORDER_OPEN_VALUE ORDER_OPEN_VALUE, ORDER_SHIPPED_VALUE ORDER_SHIPPED_VALUE, ORDER_AVAIL_VALUE ORDER_AVAIL_VALUE, ORDER_SCHEDULE_VALUE ORDER_SCHEDULE_VALUE, NUM_RELEASES NUM_RELEASES, ENABLE_AUTO_RELEASE ENABLE_AUTO_RELEASE, HOLDREAS_CODE HOLDREAS_CODE, STATUS_IND STATUS_IND, 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, IN_USE IN_USE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, 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, 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_PRSL_HDR"

View Text - HTML Formatted

SELECT HOLD_EXPIRATION HOLD_EXPIRATION
, PRESALES_ORD_ID PRESALES_ORD_ID
, SOLDTOCUST_ID SOLDTOCUST_ID
, ORGN_CODE ORGN_CODE
, PRESALES_ORD_NO PRESALES_ORD_NO
, PRESALES_ORD_DESC PRESALES_ORD_DESC
, SHIPCUST_ID SHIPCUST_ID
, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID
, PRESALES_ORD_TYPE PRESALES_ORD_TYPE
, CONSIGNEE_ID CONSIGNEE_ID
, CUSTTRADE_CLASS CUSTTRADE_CLASS
, EFFECTIVE_DATE EFFECTIVE_DATE
, EXPIRATION_DATE EXPIRATION_DATE
, BILLCUST_ID BILLCUST_ID
, REMIT_TO_LOCKBOX REMIT_TO_LOCKBOX
, SHIPADDR_ID SHIPADDR_ID
, CONTACT_ID CONTACT_ID
, PROFORMA_INVOICE_REQD PROFORMA_INVOICE_REQD
, SHIP_MTHD SHIP_MTHD
, SHIPPER_CODE SHIPPER_CODE
, SLSREP_CODE SLSREP_CODE
, COMMISSION_CODE COMMISSION_CODE
, BILLING_CURRENCY BILLING_CURRENCY
, TO_WHSE TO_WHSE
, FROM_WHSE FROM_WHSE
, EMBARKATION_PORT EMBARKATION_PORT
, DEBARKATION_PORT DEBARKATION_PORT
, FOB_CODE FOB_CODE
, TERMS_CODE TERMS_CODE
, FRTBILL_MTHD FRTBILL_MTHD
, ORDER_TYPE ORDER_TYPE
, CUSTPO_NO CUSTPO_NO
, CONTRACT_NO CONTRACT_NO
, ORDER_EXCHANGE_RATE ORDER_EXCHANGE_RATE
, MUL_DIV_SIGN MUL_DIV_SIGN
, ORDER_COMMENT ORDER_COMMENT
, COA_REQUIRED COA_REQUIRED
, BACKORDER_IND BACKORDER_IND
, MINSHIP_PCT MINSHIP_PCT
, MAXSHIP_PCT MAXSHIP_PCT
, MIN_CLOSE_PERCENT MIN_CLOSE_PERCENT
, ORDER_MAX_VALUE ORDER_MAX_VALUE
, ORDER_OPEN_VALUE ORDER_OPEN_VALUE
, ORDER_SHIPPED_VALUE ORDER_SHIPPED_VALUE
, ORDER_AVAIL_VALUE ORDER_AVAIL_VALUE
, ORDER_SCHEDULE_VALUE ORDER_SCHEDULE_VALUE
, NUM_RELEASES NUM_RELEASES
, ENABLE_AUTO_RELEASE ENABLE_AUTO_RELEASE
, HOLDREAS_CODE HOLDREAS_CODE
, STATUS_IND STATUS_IND
, 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
, IN_USE IN_USE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, 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
, 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_PRSL_HDR"