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_TERM_TEMPLATES_ALL

Object Details

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

PN_TERM_TEMPLATES_ALL stores the payment/billing term details defaults like Supplier/Customer information, Distribution accounts, Project related information etc.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_TERM_TEMPLATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME
PN_TERM_TEMPLATES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERM_TEMPLATE_ID
PN_TERM_TEMPLATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TERM_TEMPLATE_ID	NUMBER		Yes	Uniquely identifies the Term Template row.The value is populated using sequence PN_TERM_TEMPLATES_S.
NAME	VARCHAR2	(100)	Yes	Term template name.
SET_OF_BOOKS_ID	NUMBER		Yes	General Ledger Set of Books used. Associates the row in GL_SETS_OF_BOOKS with the row in this table.
CURRENCY_CODE	VARCHAR2	(30)		Functional Currency Code.
NORMALIZE	VARCHAR2	(1)		Normalize flag.
SCHEDULE_DAY	NUMBER			Day of the month for which schedules are to be created.
PAYMENT_PURPOSE_CODE	VARCHAR2	(30)		Identifies the purpose of the term for example rent,operating expense etc. The value is derived from the lookup_code in FND_LOOKUPS where lookup_type=PN_PAYMENT_PURPOSE_TYPE.
PAYMENT_TERM_TYPE_CODE	VARCHAR2	(30)		Identifies the type of the term, for example base rent,escalation etc. The value is derived from the lookup_code in FND_LOOKUPS where lookup_type=PN_PAYMENT_TERM_TYPE.
ACCRUAL_ACCOUNT_ID	NUMBER			Accrual Account Id.
PROJECT_ID	NUMBER			Project Id for calculating Account Id in AP.
TASK_ID	NUMBER			Task Id for calculating Account Id in AP.
ORGANIZATION_ID	NUMBER			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.
VENDOR_ID	NUMBER			Supplier identifier.
VENDOR_SITE_ID	NUMBER			Supplier site identifier.
CUSTOMER_ID	NUMBER			Customer identifier.
CUSTOMER_SITE_USE_ID	NUMBER			Customer Site Id for customer bill to site.
CUST_SHIP_SITE_ID	NUMBER			Customer Site Id for customer ship to site.
AP_AR_TERM_ID	NUMBER			Payment Term Id for calculation of Due Date.
CUST_TRX_TYPE_ID	NUMBER			Transaction Type Id to be passed to AR.
TAX_GROUP_ID	NUMBER			Tax Group Id for AP.
TAX_CODE_ID	NUMBER			Tax Code Id to be passed to AP/AR.
DISTRIBUTION_SET_ID	NUMBER			Distribution Set Id to be passed into AP.
INV_RULE_ID	NUMBER			Invoice Rule Id to be passed to AR.
ACCOUNT_RULE_ID	NUMBER			Accounting Rule Id to be passed into AR.
SALESREP_ID	NUMBER			Salesperson Id to be passed to AR.
TAX_INCLUDED	VARCHAR2	(1)		Tax Included is an indicator to show whether tax is included or not.
PO_HEADER_ID	NUMBER			Purchase Order header ID.
CUST_PO_NUMBER	VARCHAR2	(50)		Purchase Order number
RECEIPT_METHOD_ID	NUMBER			Receipt method Identifier.
ACTIVE	VARCHAR2	(1)		Active Flag.
DESCRIPTION	VARCHAR2	(100)		Description.
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).
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
LOCATION_ID	NUMBER	(15)		Location id of a location associated with TERM TEMPLATE.
TERM_TEMPLATE_TYPE	VARCHAR2	(30)		Identifies the type of the term template. The term template can be of type Billing or Payment.
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)		Tax classification code for payment term
INCLUDE_IN_VAR_RENT	VARCHAR2	(1)		Not used

Query Text

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


SELECT TERM_TEMPLATE_ID
,      NAME
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      NORMALIZE
,      SCHEDULE_DAY
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      ACCRUAL_ACCOUNT_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUST_SHIP_SITE_ID
,      AP_AR_TERM_ID
,      CUST_TRX_TYPE_ID
,      TAX_GROUP_ID
,      TAX_CODE_ID
,      DISTRIBUTION_SET_ID
,      INV_RULE_ID
,      ACCOUNT_RULE_ID
,      SALESREP_ID
,      TAX_INCLUDED
,      PO_HEADER_ID
,      CUST_PO_NUMBER
,      RECEIPT_METHOD_ID
,      ACTIVE
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      LOCATION_ID
,      TERM_TEMPLATE_TYPE
,      TAX_CLASSIFICATION_CODE
,      INCLUDE_IN_VAR_RENT
FROM PN.PN_TERM_TEMPLATES_ALL;

Dependencies

[top of page]

PN.PN_TERM_TEMPLATES_ALL does not reference any database object

PN.PN_TERM_TEMPLATES_ALL is referenced by following:

PN: PN_TERM_TEMPLATES_ALL#