[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
PN.PN_PAYMENT_TERMS_EFC does not reference any database object
PN.PN_PAYMENT_TERMS_EFC is referenced by following:
|
|
|