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: PO.RCV_CHARGES_INTERFACE

Object Details

Object Name:	RCV_CHARGES_INTERFACE
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.RCV_CHARGES_INTERFACE
Subobject Name:
Status:	VALID

RCV_CHARGES_INTERFACE stores charge data that will be used to import charges into Receiving system through ROI. Each charge record needs to have a backing item transaction for Receiving processor to pick it up. For header level charge, a reference to RCV_HEADERS_INTERFACE is required, while for line level charge, a reference to RCV_TRNSACTIONS_INTERFACE is required.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_CHARGES_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_HEADER_INTERFACE_ID
RCV_CHARGES_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_INTERFACE_ID
RCV_CHARGES_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_FACTOR_ID
RCV_CHARGES_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_FACTOR_CODE
RCV_CHARGES_INTERFACE_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_CHARGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_CHARGE_ID	NUMBER		Yes	Entity identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
GROUP_ID	NUMBER			Interface processig group identifier
AMOUNT	NUMBER			Charge amount
CURRENCY_CODE	VARCHAR2	(15)		Currency code of the charge
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
COST_FACTOR_ID	NUMBER			Idenditier of the type of cost factor
COST_FACTOR_CODE	VARCHAR2	(30)		Cost Factor Code for specifying the type of the charge.
PARENT_HEADER_INTERFACE_ID	NUMBER			Identifier of the parent item transaction header interface. Required for header level charges.
PARENT_INTERFACE_ID	NUMBER			Identifier of the parent item transaction interface. Required for line level charges.
VENDOR_ID	NUMBER			Identifier of the charge providor
VENDOR_SITE_ID	NUMBER			Identifier of the charge providor site
PROCESSING_STATUS_CODE	VARCHAR2	(1)	Yes	The status of preprocessing this charge
TRANSACTION_STATUS_CODE	VARCHAR2	(1)	Yes	The status code of processing this charge

Query Text

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


SELECT INTERFACE_CHARGE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      GROUP_ID
,      AMOUNT
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      COST_FACTOR_ID
,      COST_FACTOR_CODE
,      PARENT_HEADER_INTERFACE_ID
,      PARENT_INTERFACE_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PROCESSING_STATUS_CODE
,      TRANSACTION_STATUS_CODE
FROM PO.RCV_CHARGES_INTERFACE;

Dependencies

[top of page]

PO.RCV_CHARGES_INTERFACE does not reference any database object

PO.RCV_CHARGES_INTERFACE is referenced by following:

PO: RCV_CHARGES_INTERFACE#