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_TERMS_EFC

Object Details

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

Shadow table for PN_PAYMENT_TERMS_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_TERMS_EFC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_TERM_ID
PN_PAYMENT_TERMS_EFC_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_ID LEASE_CHANGE_ID
PN_PAYMENT_TERMS_EFC_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
PN_PAYMENT_TERMS_EFC_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID
PN_PAYMENT_TERMS_EFC_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID CUSTOMER_SITE_USE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_TERM_ID	NUMBER		Yes	Uniquely identifies a lease term row. The value is populated using sequence PN_PAYMENT_TERMS_EFC_S
PAYMENT_PURPOSE_CODE	VARCHAR2	(30)	Yes	Identifies the purpose of the term, for example whether it is for rent, operating expense, insurance, etc. The value is derived from lookup_code in FND_LOOKUPS where lookup_type = `PN_PAYMENT_PURPOSE_TYPE'
PAYMENT_TERM_TYPE_CODE	VARCHAR2	(30)	Yes	Identifies the type of the term, fore example, base, escalation, pre-payment, etc. The value is derived from lookup_code in FND_LOOKUPS where lookup_type = 'PN_PAYMENT_TERM_TYPE'
FREQUENCY_CODE	VARCHAR2	(30)	Yes	The frequency of the term, specifying how often this term will come into effect, for example, monthly, annually, etc. The value is derived from lookup_code in FND_LOOKUPS where lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE'
LEASE_ID	NUMBER		Yes	Associates the lease row in PN_LEASES_ALL with the term row
LEASE_CHANGE_ID	NUMBER		Yes	Associates the lease, amend, or edit row in PN_LEASE_CHANGES_ALL with the term row
START_DATE	DATE		Yes	Start date of the term
END_DATE	DATE		Yes	End date of the term
CODE_COMBINATION_ID	NUMBER		Yes	Associates the account id in GL_CODE_COMBINATIONS table with the lease term
ACTUAL_AMOUNT	NUMBER			The amount to be paid or billed
ESTIMATED_AMOUNT	NUMBER			The estimated amount to be paid or billed
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 term row.
CURRENCY_CODE	VARCHAR2	(15)	Yes	Functional currency code.
RATE	NUMBER		Yes	Currency conversion rate
NORMALIZE	VARCHAR2	(1)		Identify whether the Items related to the term need to be Normalized. valid Values: Y - Normalize, N - Don not Normalize
VENDOR_ID	NUMBER			Associates the row in PO_VENDORS with the term row. The data element is null for a billing term row.
VENDOR_SITE_ID	NUMBER			Associates the row in PO_VENDOR_SITES with the payment or billing term. The data element is null for a billing term row
CUSTOMER_ID	NUMBER			Associates the customer row in HZ_CUST_ACCOUNTS with the term row. The data element is null for a payment term row
CUSTOMER_SITE_USE_ID	NUMBER			Associates the customer's bill to site with the term row. The data element is null for a payment term row.
ORG_ID	NUMBER	(15)		Operating Unit identifier

Query Text

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


SELECT PAYMENT_TERM_ID
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      FREQUENCY_CODE
,      LEASE_ID
,      LEASE_CHANGE_ID
,      START_DATE
,      END_DATE
,      CODE_COMBINATION_ID
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      RATE
,      NORMALIZE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      ORG_ID
FROM PN.PN_PAYMENT_TERMS_EFC;

Dependencies

[top of page]

PN.PN_PAYMENT_TERMS_EFC does not reference any database object

PN.PN_PAYMENT_TERMS_EFC is referenced by following:

APPS: PN_PAYMENT_TERMS_EFC