VIEW: GML.OP_PRSL_DTL#

Source

View Text - Preformatted

select HOLD_EXPIRATION HOLD_EXPIRATION, PRESALES_ORDLINE_ID PRESALES_ORDLINE_ID, PRESALES_ORDLINE_NO PRESALES_ORDLINE_NO, SALESPKG_ID SALESPKG_ID, ITEM_ID ITEM_ID, GENERIC_ID GENERIC_ID, DEBARKATION_PORT DEBARKATION_PORT, EMBARKATION_PORT EMBARKATION_PORT, REMIT_TO_LOCKBOX REMIT_TO_LOCKBOX, PRESALES_ORD_ID PRESALES_ORD_ID, BILLCUST_ID BILLCUST_ID, SHIPCUST_ID SHIPCUST_ID, CONSIGNEE_ID CONSIGNEE_ID, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID, SOLDTOCUST_ID SOLDTOCUST_ID, CUSTTRADE_CLASS CUSTTRADE_CLASS, 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, FOB_CODE FOB_CODE, TERMS_CODE TERMS_CODE, FRTBILL_MTHD FRTBILL_MTHD, COA_REQUIRED COA_REQUIRED, BACKORDER_IND BACKORDER_IND, MINSHIP_PCT MINSHIP_PCT, MAXSHIP_PCT MAXSHIP_PCT, HOLDREAS_CODE HOLDREAS_CODE, LINE_DESC LINE_DESC, LINE_COMMENT LINE_COMMENT, ORDER_QTY1 ORDER_QTY1, ORDER_QTY2 ORDER_QTY2, ORDER_UM1 ORDER_UM1, ORDER_UM2 ORDER_UM2, INVENTORY_QTY INVENTORY_QTY, QC_GRADE_WANTED QC_GRADE_WANTED, SPECMATCH_REQD SPECMATCH_REQD, STATUS_IND STATUS_IND, TRANS_CNT TRANS_CNT, CUSTPO_NO CUSTPO_NO, CUST_CONTRACT_NO CUST_CONTRACT_NO, EXCHANGE_RATE EXCHANGE_RATE, MUL_DIV_SIGN MUL_DIV_SIGN, MIN_CLOSE_PERCENT MIN_CLOSE_PERCENT, LINE_MAX_VALUE LINE_MAX_VALUE, LINE_MAX_QTY LINE_MAX_QTY, LINE_MIN_VALUE LINE_MIN_VALUE, LINE_MIN_QTY LINE_MIN_QTY, LINE_RELEASE_VALUE LINE_RELEASE_VALUE, LINE_RELEASE_QTY LINE_RELEASE_QTY, LINE_OPEN_VALUE LINE_OPEN_VALUE, LINE_OPEN_QTY LINE_OPEN_QTY, LINE_SHIP_VALUE LINE_SHIP_VALUE, LINE_SHIP_QTY LINE_SHIP_QTY, LINE_AVAIL_VALUE LINE_AVAIL_VALUE, LINE_AVAIL_QTY LINE_AVAIL_QTY, LINE_SCHED_VALUE LINE_SCHED_VALUE, LINE_SCHED_QTY LINE_SCHED_QTY, RELEASE_MAX_VALUE RELEASE_MAX_VALUE, RELEASE_MAX_QTY RELEASE_MAX_QTY, RELEASE_MIN_VALUE RELEASE_MIN_VALUE, RELEASE_MIN_QTY RELEASE_MIN_QTY, TEXT_CODE TEXT_CODE, DELETE_MARK DELETE_MARK, 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, 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_DTL"

View Text - HTML Formatted

SELECT HOLD_EXPIRATION HOLD_EXPIRATION
, PRESALES_ORDLINE_ID PRESALES_ORDLINE_ID
, PRESALES_ORDLINE_NO PRESALES_ORDLINE_NO
, SALESPKG_ID SALESPKG_ID
, ITEM_ID ITEM_ID
, GENERIC_ID GENERIC_ID
, DEBARKATION_PORT DEBARKATION_PORT
, EMBARKATION_PORT EMBARKATION_PORT
, REMIT_TO_LOCKBOX REMIT_TO_LOCKBOX
, PRESALES_ORD_ID PRESALES_ORD_ID
, BILLCUST_ID BILLCUST_ID
, SHIPCUST_ID SHIPCUST_ID
, CONSIGNEE_ID CONSIGNEE_ID
, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID
, SOLDTOCUST_ID SOLDTOCUST_ID
, CUSTTRADE_CLASS CUSTTRADE_CLASS
, 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
, FOB_CODE FOB_CODE
, TERMS_CODE TERMS_CODE
, FRTBILL_MTHD FRTBILL_MTHD
, COA_REQUIRED COA_REQUIRED
, BACKORDER_IND BACKORDER_IND
, MINSHIP_PCT MINSHIP_PCT
, MAXSHIP_PCT MAXSHIP_PCT
, HOLDREAS_CODE HOLDREAS_CODE
, LINE_DESC LINE_DESC
, LINE_COMMENT LINE_COMMENT
, ORDER_QTY1 ORDER_QTY1
, ORDER_QTY2 ORDER_QTY2
, ORDER_UM1 ORDER_UM1
, ORDER_UM2 ORDER_UM2
, INVENTORY_QTY INVENTORY_QTY
, QC_GRADE_WANTED QC_GRADE_WANTED
, SPECMATCH_REQD SPECMATCH_REQD
, STATUS_IND STATUS_IND
, TRANS_CNT TRANS_CNT
, CUSTPO_NO CUSTPO_NO
, CUST_CONTRACT_NO CUST_CONTRACT_NO
, EXCHANGE_RATE EXCHANGE_RATE
, MUL_DIV_SIGN MUL_DIV_SIGN
, MIN_CLOSE_PERCENT MIN_CLOSE_PERCENT
, LINE_MAX_VALUE LINE_MAX_VALUE
, LINE_MAX_QTY LINE_MAX_QTY
, LINE_MIN_VALUE LINE_MIN_VALUE
, LINE_MIN_QTY LINE_MIN_QTY
, LINE_RELEASE_VALUE LINE_RELEASE_VALUE
, LINE_RELEASE_QTY LINE_RELEASE_QTY
, LINE_OPEN_VALUE LINE_OPEN_VALUE
, LINE_OPEN_QTY LINE_OPEN_QTY
, LINE_SHIP_VALUE LINE_SHIP_VALUE
, LINE_SHIP_QTY LINE_SHIP_QTY
, LINE_AVAIL_VALUE LINE_AVAIL_VALUE
, LINE_AVAIL_QTY LINE_AVAIL_QTY
, LINE_SCHED_VALUE LINE_SCHED_VALUE
, LINE_SCHED_QTY LINE_SCHED_QTY
, RELEASE_MAX_VALUE RELEASE_MAX_VALUE
, RELEASE_MAX_QTY RELEASE_MAX_QTY
, RELEASE_MIN_VALUE RELEASE_MIN_VALUE
, RELEASE_MIN_QTY RELEASE_MIN_QTY
, TEXT_CODE TEXT_CODE
, DELETE_MARK DELETE_MARK
, 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
, 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_DTL"