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: PN.PN_PAYMENT_ITEMS_EFC

Object Details

Object Name:	PN_PAYMENT_ITEMS_EFC
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_PAYMENT_ITEMS_EFC
Subobject Name:
Status:	VALID

Shadow table for PN_PAYMENT_ITEMS_ALL for supporting Euro
functional currency.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_PAYMENT_ITEMS_EFC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_ITEM_ID
PN_PAYMENT_ITEMS_EFC_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DUE_DATE
PN_PAYMENT_ITEMS_EFC_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID
PN_PAYMENT_ITEMS_EFC_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_TERM_ID
PN_PAYMENT_ITEMS_EFC_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_ITEM_ID	NUMBER		Yes	Uniquely identifies a payment or a billing item row. The value is populated using sequence PN_PAYMENT_ITEMS_EFC_S
DUE_DATE	DATE		Yes	Due date of a payment or billing item
SET_OF_BOOKS_ID	NUMBER		Yes	General Ledger Set of Books used. Associates the row in GL_SETS_OF_BOOKS with the payment or billing item row
CURRENCY_CODE	VARCHAR2	(15)	Yes	Functional currency code
EXPORT_CURRENCY_CODE	VARCHAR2	(15)		Currency code used to export payment and billing items
RATE	NUMBER		Yes	Currency conversion rate
PAYMENT_ITEM_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Yes	Identifies the type of payment or billing item. Valid values: CASH and NORMALIZED
PAYMENT_SCHEDULE_ID	NUMBER		Yes	Associates the payment schedule row in PN_PAYMENT_SCHEDULES_ALL with the payment or billing item row
PAYMENT_TERM_ID	NUMBER		Yes	Uniquely identifies a payment or a billing item row. The value is populated using sequence PN_PAYMENT_ITEMS_EFC_S
VENDOR_ID	NUMBER			Associates the row in PO_VENDORS with the payment or billing item. The data element is null for a billing item row
VENDOR_SITE_ID	NUMBER			Associates the row in PO_VENDOR_SITES with the payment or billing item. The data element is null for a billing item row
ACTUAL_AMOUNT	NUMBER			Actual amount to be paid or billed
EXPORT_CURRENCY_AMOUNT	NUMBER			The actual amount to be exported for payment or billing after currency conversion
ESTIMATED_AMOUNT	NUMBER			The estimate amount to be paid or billed
PERIOD_FRACTION	NUMBER			Reserved for rent calculation. Please do not use
EXPORT_TO_AP_FLAG	VARCHAR2	(1)		Identifies whether this transaction should be exported to Oracle Accounts for a billing item row
TRANSFERRED_TO_AP_FLAG	VARCHAR2	(1)		Identifies whether this transaction has been transferred to Oracle Accounts Payable interface tables. Valid values: Y - Transferred, N- Not Transferred.The data element is null for a billing item row.
AP_INVOICE_NUM	VARCHAR2	(50)		Stores the invoice number generated by Oracle Accounts Payable for a payment item. The data element is null for a billing item row
GROUP_ID	VARCHAR2	(240)		Group Identifier
CUSTOMER_ID	NUMBER			Associates the customer row in HZ_CUST_ACCOUNTS with the transaction row. The data element is null for a payment item row
CUSTOMER_SITE_USE_ID	NUMBER			Associates the customer's bill to site with the transaction row. The data element is null for a payment item row
EXPORT_TO_AR_FLAG	VARCHAR2	(1)		Identifies whether this transaction should be exported to Oracle Accounts Receivable. Valid values: Y - Export, N - Do not export. The data element is null for a payment item row.
TRANSFERRED_TO_AR_FLAG	VARCHAR2	(1)		Identify whether this transaction has been transferred to OracleReceivables. Valid values: Y - Transferred, N- Not Transferred. The data element is null for a payment item row
AR_TRX_NUM	VARCHAR2	(20)		Stores the transaction number generated by Oracle Receivables for a billing item. The data element is null for a payment item row
EXPORT_GROUP_ID	VARCHAR2	(240)		Group Identifier. Group together the set of transactions exported in one batch
ORG_ID	NUMBER	(15)		Operating Unit identifier

Query Text

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


SELECT PAYMENT_ITEM_ID
,      DUE_DATE
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      EXPORT_CURRENCY_CODE
,      RATE
,      PAYMENT_ITEM_TYPE_LOOKUP_CODE
,      PAYMENT_SCHEDULE_ID
,      PAYMENT_TERM_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ACTUAL_AMOUNT
,      EXPORT_CURRENCY_AMOUNT
,      ESTIMATED_AMOUNT
,      PERIOD_FRACTION
,      EXPORT_TO_AP_FLAG
,      TRANSFERRED_TO_AP_FLAG
,      AP_INVOICE_NUM
,      GROUP_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      EXPORT_TO_AR_FLAG
,      TRANSFERRED_TO_AR_FLAG
,      AR_TRX_NUM
,      EXPORT_GROUP_ID
,      ORG_ID
FROM PN.PN_PAYMENT_ITEMS_EFC;

Dependencies

[top of page]

PN.PN_PAYMENT_ITEMS_EFC does not reference any database object

PN.PN_PAYMENT_ITEMS_EFC is referenced by following:

PN: PN_PAYMENT_ITEMS_EFC#