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_ALL

Object Details

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

PN_PAYMENT_ITEMS_ALL stores payment and billing items associated with a payment or a billing schedule respectively. The items are generated by the system through a concurrent batch process for every payment and billing term defined in a lease. Payment item describes the details of payments to be made to a supplier. Billing item describes the details of receipts from a customer for a leased or owned property.
An item can be classified as a CASH or NORMALIZED item. PAYMENT_ITEM_TYPE_LOOKUP_CODE column identifies such a transaction. CASH items are transferred to AP and AR respectively based upon the lease class.
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_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_ITEM_ID
PN_PAYMENT_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DUE_DATE
PN_PAYMENT_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID
PN_PAYMENT_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_TERM_ID
PN_PAYMENT_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID
PN_PAYMENT_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
PN_PAYMENT_ITEMS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_SITE_USE_ID
PN_PAYMENT_ITEMS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPORT_GROUP_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_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).
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			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	Associates the payment term row in PN_PAYMENT_TERMS_ALL with the payment or billing item row
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.
DESCRIPTION	VARCHAR2	(50)		Obsolete. To be deleted
COMMENTS	VARCHAR2	(240)		Obsolete. To be deleted
EXPORT_TO_AP_FLAG	VARCHAR2	(1)		Identifies whether this transaction should be exported to Oracle Accounts Payable. Valid values: Y - Export, N - Do not export. The data element is null 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.
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
ENTERED_BY_LEASE	VARCHAR2	(1)		Identify whether this transaction was created through the lease process or during Authorizing payment or billing items. Valid values: N - Not created by lease, NULL - Created by lease.
EXPORT_GROUP_ID	VARCHAR2	(240)		Group Identifier. Group together the set of transactions exported in one batch.
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 Oracle Receivables. 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.
AR_REF_CODE	VARCHAR2	(30)		Reference Code for an Invoice in AR to relate it in PN.
CUST_SHIP_SITE_ID	NUMBER	(15)		Customer Site Id for customer ship to site.
ACCOUNTED_AMOUNT	NUMBER			Holds value of actual amount in functional currency, converted using user defined conversion type
ACCOUNTED_DATE	DATE			The date on which the accounted amount is calculated.
GROUPING_RULE_ID	NUMBER	(15)		Associates the grouping rule name in PN_PAY_GROUP_RULES_ALL with the payment item.
ADJ_START_DATE	DATE			Start Date of adjustment item created.
ADJ_END_DATE	DATE			End Date of adjustment item created
LAST_ADJUSTMENT_TYPE_CODE	VARCHAR2	(30)		Code for last Adjustment Type, as a result of which the adjustment item has been created.
XLA_EVENT_ID	NUMBER	(15)		Subledger Accounting event identifier

Query Text

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


SELECT PAYMENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      DESCRIPTION
,      COMMENTS
,      EXPORT_TO_AP_FLAG
,      TRANSFERRED_TO_AP_FLAG
,      AP_INVOICE_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      ENTERED_BY_LEASE
,      EXPORT_GROUP_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      EXPORT_TO_AR_FLAG
,      TRANSFERRED_TO_AR_FLAG
,      AR_TRX_NUM
,      AR_REF_CODE
,      CUST_SHIP_SITE_ID
,      ACCOUNTED_AMOUNT
,      ACCOUNTED_DATE
,      GROUPING_RULE_ID
,      ADJ_START_DATE
,      ADJ_END_DATE
,      LAST_ADJUSTMENT_TYPE_CODE
,      XLA_EVENT_ID
FROM PN.PN_PAYMENT_ITEMS_ALL;

Dependencies

[top of page]

PN.PN_PAYMENT_ITEMS_ALL does not reference any database object

PN.PN_PAYMENT_ITEMS_ALL is referenced by following:

APPS: PN_PAYMENT_ITEMS; PN_PAYMENT_ITEMS_ALL