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_HAC_INTERFACE

Object Details

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

OP_ORDR_HAC_INTERFACE (OPM Order Entry Open Interface Header Charges table) is one of the open interface tables used by the EDI transaction GPOI (Purchase Order Inbound). This particular table contains charges, including charge amounts, related to all lines of the OPM sales order being imported. It contains foreign key oi_order_id which references the OP_ORDR_HDR_INTERFACE table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_HAC_INTERFACE_I0	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OI_ORDER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OI_ORDER_ID	NUMBER		Yes	Reference to order from interface table that contains this charge. fk to op_ordr_hdr_interface table
ERROR_CODE	NUMBER			If a transaction error occurs, the Order Entry Open Interface will populate this field with an internal error code. See the error description and the transaction log file for a detailed explanation of the error.
ERROR_DESC	VARCHAR2	(240)		If a transaction error occurs, the Order Entry Open Interface will populate this field with an description of the error. See the transaction log file for more details of the error.
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
SAC_INDICATOR_INT	VARCHAR2	(1)		Indicates if charge is billable to customer. Valid values are: 0 means that the charge is not billed to bill to customer; 1 means that the charge is billed to the bill to customer.
SAC_CODE_INT	VARCHAR2	(32)		Code which uniquely identifies this charge. fk to op_chrg_mst.
SAC_METHOD_INT	NUMBER			grouping of charges for reporting purposes. Values are: 0 = miscellaneous; 1 = freight; 10 = taxes; 20 = discounts; 30 = allowances; fk to sy_type_mst
CHARGE_LINE_AMOUNT	NUMBER			Flat charge amount for the order.
CHARGE_RATE	NUMBER			Rate/percentage of order. Valid values 0 < x <= 1
CHARGE_UNIT_AMOUNT	NUMBER			Amount of the charge on a per unit basis.
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.
CHARGE_QTY	NUMBER			Quantity from the order for which the per unit charge applies.
SAC_DESCRIPTION	VARCHAR2	(70)		Description for Charge Code

Query Text

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


SELECT OI_ORDER_ID
,      ERROR_CODE
,      ERROR_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SAC_INDICATOR_INT
,      SAC_CODE_INT
,      SAC_METHOD_INT
,      CHARGE_LINE_AMOUNT
,      CHARGE_RATE
,      CHARGE_UNIT_AMOUNT
,      CHARGE_UOM
,      CHARGE_QTY
,      SAC_DESCRIPTION
FROM GML.OP_ORDR_HAC_INTERFACE;

Dependencies

[top of page]

GML.OP_ORDR_HAC_INTERFACE does not reference any database object

GML.OP_ORDR_HAC_INTERFACE is referenced by following:

APPS: OP_ORDR_HAC_INTERFACE