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_DAC_INTERFACE

Object Details

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

OP_ORDR_DAC_INTERFACE (OPM Order Entry Open Interface Detail Charges table) is one of the open interface tables used by the EDI transaction GPOI (Purchase Order Inbound). This particular table contains charges related to individual detail lines for sales orders being imported. These lines are stored in the op_ordr_dtl_interface table. One detail line can have multiple charges however each charge may be related to only one detail line. It contains foreign key oi_line_id which references OP_ORDR_DTL_INTERFACE.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_ORDR_DAC_INTERFACE_I0	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OI_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OI_LINE_ID	NUMBER		Yes	Reference to line from interface table that contains this charge. fk to op_ordr_dtl_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 line.
CHARGE_RATE	NUMBER			Rate/percentage of line. 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 line 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_LINE_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_DAC_INTERFACE;

Dependencies

[top of page]

GML.OP_ORDR_DAC_INTERFACE does not reference any database object

GML.OP_ORDR_DAC_INTERFACE is referenced by following:

GML: OP_ORDR_DAC_INTERFACE#