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_CHG

Object Details

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

OP_ORDR_CHG table contains Charges (discounts, freight, allowances) for an entire sales order and/or individual sales order lines. The table is populated during sales order entry, either manually (the user enters charges which apply to the order or order line) or automatically by the pricing logic in order entry (and corresponding setup of charges in Order Fulfillment).
If the charge applies to the entire order, then the line_id is NULL. If the charge applies to a specific sales order line, then the line_id contains the appropriate value.
If the sales order was created from an Order Profile, then the PRESALES_CHARGELINE_ID contains the reference to the charge line from the Profile (if one was copied).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_CHG_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_LINE_ID
OP_ORDR_CHGI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_ID LINE_ID CHARGE_LINE_NO
OP_ORDR_CHGI3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHARGE_LINE_ID	NUMBER	(10)	Yes	Surrogate key to uniquely identify this line.
LINE_ID	NUMBER	(10)		References the order line to which these charges pertain. Fk to op_ordr_dtl.
ORDER_ID	NUMBER	(10)	Yes	References the order to which these charges pertain. Fk to op_ordr_hdr.
CHARGE_ID	NUMBER	(10)	Yes	Surrogate key for charge code. Charge for this line. Fk to op_chrg_mst.
CHARGE_LINE_NO	NUMBER	(5)	Yes	Line number for the charge lines. Assigned by the system.
CHARGE_RATE	NUMBER			Rate/percentage if charge is a percentage of the line, order value. Valid values are 0 <= x <=1.
CHARGE_LINE_AMOUNT	NUMBER			Flat charge amount for the line, or order, if the charge is a flat amount.
CHARGE_UNIT_AMOUNT	NUMBER			Amount of the charge on a per unit basis, if the charge is assessed in that manner. Must be entered along with the charge_uom.
CHARGE_QTY	NUMBER		Yes	Quantity from the order or line to which the per unit charge applies. Defaults from the total order qty or order qty, depending if the charge is for an order or line.
CHARGE_UOM	VARCHAR2	(4)		Unit of measure corresponding to the charge_qty and charge_unit_amount for per-unit charges. Fk to sy_uoms_mst.
BILLABLE_IND	NUMBER	(5)	Yes	Indicates if the charge is billed to the customer. Defaults from op_chrg_mst and can be changed by user.
PRESALES_CHARGELINE_ID	NUMBER	(10)		Reference back to presales order charge, if charge was copied from a presales order (i.e., an order profile or blanket order).
EXTENDED_AMOUNT	NUMBER		Yes	Computed charge for the line or order calculated by one of the following: 1) charge_unit_amount * charge_qty, 2) charge rate * extended_price of the line or total order value, 3) charge_line_amount
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
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module

Query Text

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


SELECT CHARGE_LINE_ID
,      LINE_ID
,      ORDER_ID
,      CHARGE_ID
,      CHARGE_LINE_NO
,      CHARGE_RATE
,      CHARGE_LINE_AMOUNT
,      CHARGE_UNIT_AMOUNT
,      CHARGE_QTY
,      CHARGE_UOM
,      BILLABLE_IND
,      PRESALES_CHARGELINE_ID
,      EXTENDED_AMOUNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GML.OP_ORDR_CHG;

Dependencies

[top of page]

GML.OP_ORDR_CHG does not reference any database object

GML.OP_ORDR_CHG is referenced by following:

APPS: OP_ORDR_CHG