VIEW: GML.OP_ORDR_DTL#

Source

View Text - Preformatted

select PRICE_ID PRICE_ID, PRICE_SELECTED_IND PRICE_SELECTED_IND, ORDER_ID ORDER_ID, LINE_ID LINE_ID, LINE_NO LINE_NO, INVOICE_ID INVOICE_ID, INVOICELINE_NO INVOICELINE_NO, BOL_ID BOL_ID, BOLLINE_NO BOLLINE_NO, RETURN_ID RETURN_ID, ITEM_ID ITEM_ID, GENERIC_ID GENERIC_ID, LINE_DESC LINE_DESC, SALESPKG_ID SALESPKG_ID, LINE_COMMENT LINE_COMMENT, ORDER_QTY1 ORDER_QTY1, ORDER_QTY2 ORDER_QTY2, ORDER_UM1 ORDER_UM1, ORDER_UM2 ORDER_UM2, SHIPADDR_ID SHIPADDR_ID, SHIPCUST_ID SHIPCUST_ID, SHIPPER_CODE SHIPPER_CODE, CONSIGNEE_ID CONSIGNEE_ID, SHIP_MTHD SHIP_MTHD, TO_WHSE TO_WHSE, FROM_WHSE FROM_WHSE, FOB_CODE FOB_CODE, NET_WT NET_WT, DEBARKATION_PORT DEBARKATION_PORT, SOLDTOCUST_ID SOLDTOCUST_ID, TARE_WT TARE_WT, PALLET_WT PALLET_WT, FRTBILL_WT FRTBILL_WT, SHIP_STATUS SHIP_STATUS, SHIPWT_UM SHIPWT_UM, BASE_PRICE BASE_PRICE, NET_PRICE NET_PRICE, EXTENDED_PRICE EXTENDED_PRICE, PRICE_UM PRICE_UM, BILLING_CURRENCY BILLING_CURRENCY, BASE_CURRENCY BASE_CURRENCY, EXCHANGE_RATE EXCHANGE_RATE, TERMS_CODE TERMS_CODE, BILL_QTY BILL_QTY, REQUESTED_SHIPDATE REQUESTED_SHIPDATE, PROMISED_SHIPDATE PROMISED_SHIPDATE, LIST_PRICE LIST_PRICE, SCHED_SHIPDATE SCHED_SHIPDATE, ACTUAL_SHIPDATE ACTUAL_SHIPDATE, REQUIRED_DLVDATE REQUIRED_DLVDATE, ACTUAL_DLVDATE ACTUAL_DLVDATE, BASE_COST BASE_COST, QC_GRADE_WANTED QC_GRADE_WANTED, COMPLETED_IND COMPLETED_IND, REPRICE_SHIPMENT REPRICE_SHIPMENT, SLSREP_CODE SLSREP_CODE, COMMISSION_CODE COMMISSION_CODE, NET_COMMISSION NET_COMMISSION, MUL_DIV_SIGN MUL_DIV_SIGN, NET_TAX NET_TAX, BACKORDREAS_CODE BACKORDREAS_CODE, BATCH_ID BATCH_ID, LOCKBOX_CODE LOCKBOX_CODE, HOLDREAS_CODE HOLDREAS_CODE, HOLD_EXPIRATION HOLD_EXPIRATION, ALLOC_IND ALLOC_IND, GL_POSTED_IND GL_POSTED_IND, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, DELETE_MARK DELETE_MARK, TRANS_CNT TRANS_CNT, TEXT_CODE TEXT_CODE, CUSTPO_NO CUSTPO_NO, EXPORTED_DATE EXPORTED_DATE, COA_REQUIRED COA_REQUIRED, SYSTEM_PRICE SYSTEM_PRICE, PRESALES_ORDLINE_ID PRESALES_ORDLINE_ID, PRICEREAS_CODE PRICEREAS_CODE, LINE_STATUS LINE_STATUS, PRICEFF_ID PRICEFF_ID, LINE_TYPE LINE_TYPE, ALLOC_QTY ALLOC_QTY, INVENTORY_QTY INVENTORY_QTY, BACKORDER_FLAG BACKORDER_FLAG, IN_USE IN_USE, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, SHIP_QTY1 SHIP_QTY1, EMBARKATION_PORT EMBARKATION_PORT, SHIP_QTY2 SHIP_QTY2, SHIP_VOLUME SHIP_VOLUME, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID, CONTACT_ID CONTACT_ID, MINSHIP_PCT MINSHIP_PCT, SHIPVOLUME_UM SHIPVOLUME_UM, FRTBILL_MTHD FRTBILL_MTHD, MAXSHIP_PCT MAXSHIP_PCT, NET_FREIGHT NET_FREIGHT, FRT_COST FRT_COST, CHANGEREAS_CODE CHANGEREAS_CODE, REFERENCE_LINE_ID REFERENCE_LINE_ID, HOLD_CHANGE_IND HOLD_CHANGE_IND, UPGRADE_FLAG UPGRADE_FLAG, UPGRADE_DATE UPGRADE_DATE, OPM_SHIPCUST_ID OPM_SHIPCUST_ID, OPM_SOLDTOCUST_ID OPM_SOLDTOCUST_ID, OPM_ULTIMATE_SHIPCUST_ID OPM_ULTIMATE_SHIPCUST_ID, RETNREAS_CODE RETNREAS_CODE, RMA RMA from "GML"."OP_ORDR_DTL"

View Text - HTML Formatted

SELECT PRICE_ID PRICE_ID
, PRICE_SELECTED_IND PRICE_SELECTED_IND
, ORDER_ID ORDER_ID
, LINE_ID LINE_ID
, LINE_NO LINE_NO
, INVOICE_ID INVOICE_ID
, INVOICELINE_NO INVOICELINE_NO
, BOL_ID BOL_ID
, BOLLINE_NO BOLLINE_NO
, RETURN_ID RETURN_ID
, ITEM_ID ITEM_ID
, GENERIC_ID GENERIC_ID
, LINE_DESC LINE_DESC
, SALESPKG_ID SALESPKG_ID
, LINE_COMMENT LINE_COMMENT
, ORDER_QTY1 ORDER_QTY1
, ORDER_QTY2 ORDER_QTY2
, ORDER_UM1 ORDER_UM1
, ORDER_UM2 ORDER_UM2
, SHIPADDR_ID SHIPADDR_ID
, SHIPCUST_ID SHIPCUST_ID
, SHIPPER_CODE SHIPPER_CODE
, CONSIGNEE_ID CONSIGNEE_ID
, SHIP_MTHD SHIP_MTHD
, TO_WHSE TO_WHSE
, FROM_WHSE FROM_WHSE
, FOB_CODE FOB_CODE
, NET_WT NET_WT
, DEBARKATION_PORT DEBARKATION_PORT
, SOLDTOCUST_ID SOLDTOCUST_ID
, TARE_WT TARE_WT
, PALLET_WT PALLET_WT
, FRTBILL_WT FRTBILL_WT
, SHIP_STATUS SHIP_STATUS
, SHIPWT_UM SHIPWT_UM
, BASE_PRICE BASE_PRICE
, NET_PRICE NET_PRICE
, EXTENDED_PRICE EXTENDED_PRICE
, PRICE_UM PRICE_UM
, BILLING_CURRENCY BILLING_CURRENCY
, BASE_CURRENCY BASE_CURRENCY
, EXCHANGE_RATE EXCHANGE_RATE
, TERMS_CODE TERMS_CODE
, BILL_QTY BILL_QTY
, REQUESTED_SHIPDATE REQUESTED_SHIPDATE
, PROMISED_SHIPDATE PROMISED_SHIPDATE
, LIST_PRICE LIST_PRICE
, SCHED_SHIPDATE SCHED_SHIPDATE
, ACTUAL_SHIPDATE ACTUAL_SHIPDATE
, REQUIRED_DLVDATE REQUIRED_DLVDATE
, ACTUAL_DLVDATE ACTUAL_DLVDATE
, BASE_COST BASE_COST
, QC_GRADE_WANTED QC_GRADE_WANTED
, COMPLETED_IND COMPLETED_IND
, REPRICE_SHIPMENT REPRICE_SHIPMENT
, SLSREP_CODE SLSREP_CODE
, COMMISSION_CODE COMMISSION_CODE
, NET_COMMISSION NET_COMMISSION
, MUL_DIV_SIGN MUL_DIV_SIGN
, NET_TAX NET_TAX
, BACKORDREAS_CODE BACKORDREAS_CODE
, BATCH_ID BATCH_ID
, LOCKBOX_CODE LOCKBOX_CODE
, HOLDREAS_CODE HOLDREAS_CODE
, HOLD_EXPIRATION HOLD_EXPIRATION
, ALLOC_IND ALLOC_IND
, GL_POSTED_IND GL_POSTED_IND
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, DELETE_MARK DELETE_MARK
, TRANS_CNT TRANS_CNT
, TEXT_CODE TEXT_CODE
, CUSTPO_NO CUSTPO_NO
, EXPORTED_DATE EXPORTED_DATE
, COA_REQUIRED COA_REQUIRED
, SYSTEM_PRICE SYSTEM_PRICE
, PRESALES_ORDLINE_ID PRESALES_ORDLINE_ID
, PRICEREAS_CODE PRICEREAS_CODE
, LINE_STATUS LINE_STATUS
, PRICEFF_ID PRICEFF_ID
, LINE_TYPE LINE_TYPE
, ALLOC_QTY ALLOC_QTY
, INVENTORY_QTY INVENTORY_QTY
, BACKORDER_FLAG BACKORDER_FLAG
, IN_USE IN_USE
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, SHIP_QTY1 SHIP_QTY1
, EMBARKATION_PORT EMBARKATION_PORT
, SHIP_QTY2 SHIP_QTY2
, SHIP_VOLUME SHIP_VOLUME
, ULTIMATE_SHIPCUST_ID ULTIMATE_SHIPCUST_ID
, CONTACT_ID CONTACT_ID
, MINSHIP_PCT MINSHIP_PCT
, SHIPVOLUME_UM SHIPVOLUME_UM
, FRTBILL_MTHD FRTBILL_MTHD
, MAXSHIP_PCT MAXSHIP_PCT
, NET_FREIGHT NET_FREIGHT
, FRT_COST FRT_COST
, CHANGEREAS_CODE CHANGEREAS_CODE
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, HOLD_CHANGE_IND HOLD_CHANGE_IND
, UPGRADE_FLAG UPGRADE_FLAG
, UPGRADE_DATE UPGRADE_DATE
, OPM_SHIPCUST_ID OPM_SHIPCUST_ID
, OPM_SOLDTOCUST_ID OPM_SOLDTOCUST_ID
, OPM_ULTIMATE_SHIPCUST_ID OPM_ULTIMATE_SHIPCUST_ID
, RETNREAS_CODE RETNREAS_CODE
, RMA RMA
FROM "GML"."OP_ORDR_DTL"