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_ALL

Object Details

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

PN_PAYMENT_TERMS_ALL stores the payment and billing terms defined in a lease. The terms can be for base rent, abatement, escalation, retro adjustment, direct, etc. The details of a term are used to create payment or billing schedules and payment or billing items.
This table is partitioned by org.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_PAYMENT_TERMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_TERM_ID
PN_PAYMENT_TERMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_ID LEASE_CHANGE_ID
PN_PAYMENT_TERMS_N100	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_BILLREC_ID
PN_PAYMENT_TERMS_N101	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AMOUNT_TYPE
PN_PAYMENT_TERMS_N102	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REC_AGR_LINE_ID
PN_PAYMENT_TERMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
PN_PAYMENT_TERMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID
PN_PAYMENT_TERMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INDEX_PERIOD_ID
PN_PAYMENT_TERMS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VAR_RENT_INV_ID
PN_PAYMENT_TERMS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_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_S
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).
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_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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			Associates the account id in GL_CODE_COMBINATIONS table with the lease term
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.
TARGET_DATE	DATE			The date on which the term of the type PRE-PAYMENT is to be offset with the due date. For all other terms, this data element is null.
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			Currency conversion rate
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ORG_ID	NUMBER	(15)		Organization identifier
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.
NORMALIZE	VARCHAR2	(1)		Identify whether the Items related to the term need to be Normalized. valid Values: Y - Normalize, N - Don not Normalize
LOCATION_ID	NUMBER	(15)		Location Id of the location associated with the lease
SCHEDULE_DAY	NUMBER	(15)		Day of the month for which schedules are to be created.
CUST_SHIP_SITE_ID	NUMBER	(15)		Customer Site Id for customer ship to site.
AP_AR_TERM_ID	NUMBER	(15)		Payment Term Id for calculation of Term date.
CUST_TRX_TYPE_ID	NUMBER	(15)		Transaction Type Id to be passed to AR.
PROJECT_ID	NUMBER	(15)		Project Id for calculating account id in AP.
TASK_ID	NUMBER	(15)		Task Id for calculating account id in AP.
ORGANIZATION_ID	NUMBER	(15)		Organization Id for calculating account id in AP.
EXPENDITURE_TYPE	VARCHAR2	(30)		Expenditure Type for calculating Account Id in AP.
EXPENDITURE_ITEM_DATE	DATE			Expenditure Item Date for calculating Account Id in AP.
TAX_GROUP_ID	NUMBER	(15)		Tax Group Id for AP.
TAX_CODE_ID	NUMBER	(15)		Tax Code Id for AP/AR.
TAX_INCLUDED	VARCHAR2	(1)		Tax included is an indicator to show that tax is included or not.
DISTRIBUTION_SET_ID	NUMBER	(15)		Distribution Set Id to be passed into AP.
INV_RULE_ID	NUMBER	(15)		Invoice Rule Id to be apssed into AR.
ACCOUNT_RULE_ID	NUMBER	(15)		Accounting Rule Id to be passed into AR.
SALESREP_ID	NUMBER	(15)		Salesperson Id to be passed into AR
APPROVED_BY	NUMBER	(15)		Approver Name for Index Payment Term.
STATUS	VARCHAR2	(30)		Status of Index Payment Term.
INDEX_PERIOD_ID	NUMBER			Index Period Id for Index Payment Term.
INDEX_TERM_INDICATOR	VARCHAR2	(30)		Index Term Indicator for Index Payment Term.
PO_HEADER_ID	VARCHAR2	(30)		Purchase Order Id to be passed into AP.
CUST_PO_NUMBER	VARCHAR2	(50)		Status of Index Payment Term.
RECEIPT_METHOD_ID	NUMBER	(15)		Receipt Method Id.
PROJECT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Project Attribute Category for passing Context to AR.
PROJECT_ATTRIBUTE1	VARCHAR2	(150)		Segment1 for Project Flex field.
PROJECT_ATTRIBUTE2	VARCHAR2	(150)		Segment2 for Project Flex field.
PROJECT_ATTRIBUTE3	VARCHAR2	(150)		Segment3 for Project Flex field.
PROJECT_ATTRIBUTE4	VARCHAR2	(150)		Segment4 for Project Flex field.
PROJECT_ATTRIBUTE5	VARCHAR2	(150)		Segment5 for Project Flex field.
PROJECT_ATTRIBUTE6	VARCHAR2	(150)		Segment6 for Project Flex field.
PROJECT_ATTRIBUTE7	VARCHAR2	(150)		Segment7 for Project Flex field.
PROJECT_ATTRIBUTE8	VARCHAR2	(150)		Segment8 for Project Flex field.
PROJECT_ATTRIBUTE9	VARCHAR2	(150)		Segment9 for Project Flex field.
PROJECT_ATTRIBUTE10	VARCHAR2	(150)		Segment10 for Project Flex field.
PROJECT_ATTRIBUTE11	VARCHAR2	(150)		Segment11 for Project Flex field.
PROJECT_ATTRIBUTE12	VARCHAR2	(150)		Segment12 for Project Flex field.
PROJECT_ATTRIBUTE13	VARCHAR2	(150)		Segment13 for Project Flex field.
PROJECT_ATTRIBUTE14	VARCHAR2	(150)		Segment14 for Project Flex field.
PROJECT_ATTRIBUTE15	VARCHAR2	(150)		Segment15 for Project Flex field.
VAR_RENT_INV_ID	NUMBER	(38)		Associates the row in this table with a variable rent invoice row in table pn_var_rent_inv_all.
VAR_RENT_TYPE	VARCHAR2	(20)		Determines the term type if term is a variable rent term. The column can have one of the following values ,'ACTUAL', 'FORECASTED' or 'VARIANCE'.
CHANGED_FLAG	VARCHAR2	(20)		Verifies that the Term is Early End Dated when the EDIT command is used. Valid values are Y (Term is Early End Dated) and N (Early End Dated Term processed) and NULL.
NORM_START_DATE	DATE			The Date from when Normalization starts. When the term is added using the AMEND command, Normalization starts from the Amendment Commencement Date for schedules in Draft Mode. Otherwise, normalization starts from the date of the next Draft Schedule.
TERM_TEMPLATE_ID	NUMBER	(15)		Term Template ID of Term Template, which is used to default term details at term level
EVENT_TYPE_CODE	VARCHAR2	(30)		The event type associated with the payment term
LEASE_STATUS	VARCHAR2	(30)		Lease Status
NORM_END_DATE	DATE			The date on which normalization ends
RECOVERABLE_FLAG	VARCHAR2	(1)		Identifies whether the payment term is used for recovery purposes
PERIOD_BILLREC_ID	NUMBER	(15)		Associates a billed record for a period from PN_REC_PERIOD_BILL_ALL table
AMOUNT_TYPE	VARCHAR2	(30)		Amount Type of the record
REC_AGR_LINE_ID	NUMBER	(15)		Associates a line for a billed record for a period from PN_REC_PERIOD_BILL_ALL table
GROUPING_RULE_ID	NUMBER	(15)		Associates the grouping rule name in PN_PAY_GROUP_RULES_ALL with the payment term.
AREA_TYPE_CODE	VARCHAR2	(30)		Area type code.
AREA	NUMBER			Total area associated with the payment term.
TERM_ALTERED_FLAG	VARCHAR2	(1)		The value Y of this field indicated that the term has undergone some changes and history has been created for the term.
SOURCE_CODE	VARCHAR2	(30)		This field indicates the source of term i.e. Lease Abstract, Amend, Edit, Variable Rent, Index Rent and Recovery modules.
TERM_COMMENTS	VARCHAR2	(2000)		User entered comments for a term.
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity for payment term
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)		Tax classification code for payment term
INDEX_NORM_FLAG	VARCHAR2	(1)		Flag indicating whether index rent term is normalized.
PARENT_TERM_ID	NUMBER			Identifier of the payment term.
INCLUDE_IN_VAR_RENT	VARCHAR2	(30)		Specifies whether term is included in natural breakpoint basis.
UPDATE_NBP_FLAG	VARCHAR2	(1)		Flag indicating if natural breakpoint is to be regenerated .
RECUR_BB_CALC_DATE	DATE			Calculation date used as transaction date for recurring backbill.
OPEX_TYPE	VARCHAR2	(30)		Code identifying payment type: (CATCHUP=catch-up payment ESTPMT=estimated payment, RECON=reconciled payment)
OPEX_AGR_ID	NUMBER			Identifier of the agreement for which the term is being created
OPEX_RECON_ID	NUMBER			Identifier of the reconciliation for which the term is being created

Query Text

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


SELECT PAYMENT_TERM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      FREQUENCY_CODE
,      LEASE_ID
,      LEASE_CHANGE_ID
,      START_DATE
,      END_DATE
,      CODE_COMBINATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      TARGET_DATE
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      RATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      NORMALIZE
,      LOCATION_ID
,      SCHEDULE_DAY
,      CUST_SHIP_SITE_ID
,      AP_AR_TERM_ID
,      CUST_TRX_TYPE_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      TAX_GROUP_ID
,      TAX_CODE_ID
,      TAX_INCLUDED
,      DISTRIBUTION_SET_ID
,      INV_RULE_ID
,      ACCOUNT_RULE_ID
,      SALESREP_ID
,      APPROVED_BY
,      STATUS
,      INDEX_PERIOD_ID
,      INDEX_TERM_INDICATOR
,      PO_HEADER_ID
,      CUST_PO_NUMBER
,      RECEIPT_METHOD_ID
,      PROJECT_ATTRIBUTE_CATEGORY
,      PROJECT_ATTRIBUTE1
,      PROJECT_ATTRIBUTE2
,      PROJECT_ATTRIBUTE3
,      PROJECT_ATTRIBUTE4
,      PROJECT_ATTRIBUTE5
,      PROJECT_ATTRIBUTE6
,      PROJECT_ATTRIBUTE7
,      PROJECT_ATTRIBUTE8
,      PROJECT_ATTRIBUTE9
,      PROJECT_ATTRIBUTE10
,      PROJECT_ATTRIBUTE11
,      PROJECT_ATTRIBUTE12
,      PROJECT_ATTRIBUTE13
,      PROJECT_ATTRIBUTE14
,      PROJECT_ATTRIBUTE15
,      VAR_RENT_INV_ID
,      VAR_RENT_TYPE
,      CHANGED_FLAG
,      NORM_START_DATE
,      TERM_TEMPLATE_ID
,      EVENT_TYPE_CODE
,      LEASE_STATUS
,      NORM_END_DATE
,      RECOVERABLE_FLAG
,      PERIOD_BILLREC_ID
,      AMOUNT_TYPE
,      REC_AGR_LINE_ID
,      GROUPING_RULE_ID
,      AREA_TYPE_CODE
,      AREA
,      TERM_ALTERED_FLAG
,      SOURCE_CODE
,      TERM_COMMENTS
,      LEGAL_ENTITY_ID
,      TAX_CLASSIFICATION_CODE
,      INDEX_NORM_FLAG
,      PARENT_TERM_ID
,      INCLUDE_IN_VAR_RENT
,      UPDATE_NBP_FLAG
,      RECUR_BB_CALC_DATE
,      OPEX_TYPE
,      OPEX_AGR_ID
,      OPEX_RECON_ID
FROM PN.PN_PAYMENT_TERMS_ALL;

Dependencies

[top of page]

PN.PN_PAYMENT_TERMS_ALL does not reference any database object

PN.PN_PAYMENT_TERMS_ALL is referenced by following:

PN: PN_PAYMENT_TERMS_ALL#