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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GML.OP_ORDR_HDR

Object Details

Object Name:	OP_ORDR_HDR
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_ORDR_HDR
Subobject Name:
Status:	VALID

This table is the Sales Order Header table and contains default information for the order. The only data which does not exist on each order line is the BILLCUST_ID, ORDER_DATE and ORDER_TYPE. There is only one Bill-To customer for an order. Most of the remaining information is contained on each sales order line. The ORDER_TYPE controls the processing of the order and is used to designate different types of orders for various purposes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_HDR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORDER_ID
OP_ORDR_HDR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORDER_TYPE ORGN_CODE ORDER_NO RELEASE_NO
OP_ORDR_HDR_I1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_NO
OP_ORDR_HDR_I2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILLCUST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_ID	NUMBER	(10)	Yes	Surrogate key for order. Alternate primary key is orgn_code + order_no + release_no + order_type
ORDER_TYPE	NUMBER	(5)	Yes	Order type; fk to op_ordr_type
IN_USE	NUMBER	(10)		Not currently used
DEBARKATION_PORT	VARCHAR2	(8)		Port of entry/port shipment is unloaded; fk to op_port_mst.
BILLCUST_ID	NUMBER	(15)	Yes	Default third party to be invoiced; fk to op_cust_mst.
SHIPCUST_ID	NUMBER	(15)	Yes	Default shipping (destination) customer; fk to op_cust_mst.
SHIPADDR_ID	NUMBER	(10)		Shipping destination; defaults from op_cust_mst.addr_id for shipcust_id of this record; fk to sy_addr_mst.
SHIPPER_CODE	VARCHAR2	(4)		Fk to op_ship_mst; sets defaults for lines.
SOLDTOCUST_ID	NUMBER	(15)		Third-party customer to the sales transaction. Defaults from customer association, if established.
CUSTPO_NO	VARCHAR2	(40)		Customer purchase order number
CONTACT_ID	NUMBER	(10)		Customer contact reference. Fk to op_cust_con.
SLSREP_CODE	VARCHAR2	(8)		Fk to op_slsr_mst. Sales rep for order. Sets defaults for lines.
COMMISSION_CODE	VARCHAR2	(8)		Fk to op_commission Commission code default.
BILLING_CURRENCY	VARCHAR2	(4)	Yes	Currency that customer is billed in and currency of order. Fk to gl_curr_mst.
FROM_WHSE	VARCHAR2	(4)		Shipping warehouse; fk to ic_whse_mst.
TO_WHSE	VARCHAR2	(4)		Destination warehouse for intra-enterprise shipments and consignments. Fk to ic_whse_mst.
FOB_CODE	VARCHAR2	(4)		Fk to op_fobc_mst. Free-on-board code default.
TERMS_CODE	VARCHAR2	(4)		Payment terms code; fk to op_term_mst.
ORGN_CODE	VARCHAR2	(4)	Yes	Organization code; all sales orders are organization specific; fk to sy_orgn_mst.
ORDER_COMMENT	VARCHAR2	(70)		Freeform text/comments.
COMPLETED_IND	NUMBER	(5)	Yes	Indicates "completed" status of order; valid values are: 0 means that order is open and has not been completely shipped; 1 means that the order has been completely shipped; -1 means that the order has been cancelled.
REGISTERED_IND	NUMBER	(5)		Registered indicator - not currently used.
PRINT_COUNT	NUMBER	(5)	Yes	Print count is incremented when sales order confirmation is printed to a printer. Shows number of times that this report has been printed for the order.
LOCKBOX_CODE	VARCHAR2	(8)		Remit-to lockbox; not modified in sales order, but carried through to invoicing. Fk to op_lkbx_mst.
ORDER_STATUS	NUMBER	(5)	Yes	Status of order. Fk to op_ordr_status.
COA_REQUIRED	NUMBER	(5)		Indicates if certificate of analysis is required for order. Value of 0 means that no coa is required; value of 1 means that coa is required; defaults to 0. Sets defaults for lines. For future use.
DATE_PRINTED	DATE			Contains last date that the sales order confirmation was printed.
ORDER_NO	VARCHAR2	(32)	Yes	Order number assigned by either system or user. Unique within an organization.
HOLDREAS_CODE	VARCHAR2	(4)	Yes	Hold reason code default; fk to op_hold_cds.
EMBARKATION_PORT	VARCHAR2	(8)		Port of loading/port of discharge for shipments; fk to op_port_mst.
HOLD_EXPIRATION	DATE		Yes	Hold expiration date; defaults to system maximum date and can be modified by user.
ORDER_DATE	DATE		Yes	Date that order was placed.
REQUESTED_SHIPDATE	DATE		Yes	Date requested for shipment. Default for order lines.
PROMISED_SHIPDATE	DATE		Yes	Promised ship date. Default for all order lines.
SCHED_SHIPDATE	DATE		Yes	Scheduled ship date. Default for all order lines. Date used as transaction date for pending inventory transactions for the order (unless changed on one or more order lines).
REQUIRED_DLVDATE	DATE		Yes	Required delivery date. Date required by customer. Default for all order lines. Date can be used to calculate scheduled ship date.
RELEASE_NO	NUMBER	(5)		Release number (for future use).
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Logical delete. 0 means active record; 1 means "deleted".
PRESALES_ORD_ID	NUMBER	(10)		Link to origin of sales order if created from a presales order, i.e., an order profile or blanket order.
TOTAL_OPEN_AMOUNT	NUMBER		Yes	Total unshipped amount of the order. Updated by order entry and shipping. For a new order, this total equals the total order amount. As lines are shipped, they are decremented from this total. Field used for credit checking with Oracle AR.
SOURCE_IND	NUMBER	(5)		Indicates the source of the order. Normal value is 0, however, if order originates from a Blanket Sales Order, then the value of this column is 2. If the order originates from an EDI Inbound PO, then the value is 3.
EDI_TRANS_COUNT	NUMBER	(5)		For future use with EDI orders
CONSIGNEE_ID	NUMBER	(10)		Ultimate customer when consignment inventory is shipped to a gemms-managed warehouse.
ULTIMATE_SHIPCUST_ID	NUMBER	(15)		Ultimate shipping (destination) customer when shipcust is a freight forwarder or distribution center; fk to op_cust_mst.
SHIP_MTHD	VARCHAR2	(4)		Fk to op_ship_mth; sets defaults for lines.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
CHANGEREAS_CODE	VARCHAR2	(4)		Reason code for changes to an order; fk to sy_reas_cds.
FRTBILL_MTHD	VARCHAR2	(4)		Freight bill method default; fk to op_frgt_mth.
UPGRADE_FLAG	VARCHAR2	(2)		For OM Migration: 'Y' indcates order has been migrated to OM
UPGRADE_DATE	DATE			For OM Migration only: date order was migrated
OPM_SHIPCUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes
OPM_BILLCUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes
OPM_SOLDTOCUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes
OPM_ULTIMATE_SHIPCUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

GML.OP_ORDR_HDR does not reference any database object

GML.OP_ORDR_HDR is referenced by following:

APPS: OP_ORDR_HDR