DBA Data[Home] [Help] [Dependency Information]

TABLE: PN.PN_PAYMENT_TERMS_HISTORY

Object Details
Object Name: PN_PAYMENT_TERMS_HISTORY
Object Type: TABLE
Owner: PN
FND Design Data: TablePN.PN_PAYMENT_TERMS_HISTORY
Subobject Name:
Status: VALID


This table stores history of payment/billing terms. When a term is changed, its history is created and it stored in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PN_PAYMENT_TERMS_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTERM_HISTORY_ID
PN_PAYMENT_TERMS_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_TERM_ID
PN_PAYMENT_TERMS_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISTRIBUTION_CHANGE_ID
PN_PAYMENT_TERMS_HISTORY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEASE_CHANGE_ID
Columns
Name Datatype Length Mandatory Comments
TERM_HISTORY_ID NUMBER (15) Yes Unique Identifier of the term history row. This is the primary key of table.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column.
CREATION_DATE DATE
Yes Standard WHO column.
CREATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
PAYMENT_TERM_ID NUMBER (15) Yes Term Id, to which term history row belongs .
DISTRIBUTION_CHANGE_ID NUMBER (15) Yes Reference column to PN_DISTRIBUTIONS_HISTORY table.
PREV_TERM_HISTORY_ID NUMBER (15)
Reference column to previous term history row of the same term.
ADJUSTMENT_TYPE_CODE VARCHAR2 (30)
Identifies the type of adjustment for which the term history row was created.
TOTAL_ADJ_AMOUNT NUMBER

Total of adjustment amounts created corresponding to the term history row.
PAYMENT_PURPOSE_CODE VARCHAR2 (30) Yes Identifies the purpose of the term history row.
PAYMENT_TERM_TYPE_CODE VARCHAR2 (30) Yes Identifies the type of the term history row, for example, base, escalation, pre-payment, etc.
FREQUENCY_CODE VARCHAR2 (30) Yes The frequency of the term history row, specifying how often the term would come into effect, for example, monthly, annually, etc.
LEASE_ID NUMBER (15) Yes Associates the lease row in PN_LEASES_ALL with the term history row.
LEASE_CHANGE_ID NUMBER (15) Yes Associates the lease, amend, or edit row in PN_LEASE_CHANGES_ALL with the term history row.
START_DATE DATE
Yes History of start date of the term.
END_DATE DATE
Yes History of end date of the term.
VENDOR_ID NUMBER (15)
Associates the row in PO_VENDORS with the term history row. The data element is null for a billing term history row.
VENDOR_SITE_ID NUMBER (15)
Associates the row in PO_VENDOR_SITES with the term history row. The data element is null for a billing term history row.
TARGET_DATE DATE

History of date on which the term of the type PRE-PAYMENT was to be offset with the due date. For all other terms, this data element is null.
ACTUAL_AMOUNT NUMBER

History of amount to be paid or billed.
ESTIMATED_AMOUNT NUMBER

History of estimated amount to be paid or billed.
SET_OF_BOOKS_ID NUMBER (15) Yes General Ledger Set of Books used. Associates the row in GL_SETS_OF_BOOKS with the payment or billing term history row.
CURRENCY_CODE VARCHAR2 (15) Yes Functional currency code.
RATE NUMBER

Currency conversion rate.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment column.
CUSTOMER_ID NUMBER (15)
Associates the customer row in HZ_CUST_ACCOUNTS with the term history row. The data element is null for a payment term history row.
CUSTOMER_SITE_USE_ID NUMBER (15)
Associate the customer's bill to site with the term history row. The data element is null for a payment type history row.
NORMALIZE VARCHAR2 (1)
Identify whether the Items related to the term history need to be Normalized. valid Values: Y - Normalize, N - Don not Normalize.
LOCATION_ID NUMBER (15)
Associates the location row in PN_LOCATIONS_ALL with the term history row.
SCHEDULE_DAY NUMBER (15)
Day of the month on which schedules are to be created and it is used to derive the schedule dates of term.
CUST_SHIP_SITE_ID NUMBER (15)
Associate the customer's ship to site with the term history row. The data element is null for a payment type history row.
AP_AR_TERM_ID NUMBER (15)
History of Term Id populated from Payables/Receivables to calculate the Due Date.
CUST_TRX_TYPE_ID NUMBER (15)
History of Transaction Type Id populated from Receivables and passed to Receivables while exporting an invoice.
PROJECT_ID NUMBER (15)
History of Project Id for calculating account id in Payables.
TASK_ID NUMBER (15)
History of Task Id for calculating account id in Payables.
ORGANIZATION_ID NUMBER (15)
History of Organization Id for calculating account id in Payables.
EXPENDITURE_TYPE VARCHAR2 (30)
History of Expenditure Type for calculating account id in Payables.
EXPENDITURE_ITEM_DATE DATE

History of Expenditure Item Date for calculating account id in Payables.
TAX_GROUP_ID NUMBER (15)
History of Tax Group Id, populated from Payables and passed to Payables while exporting payment item.
TAX_CODE_ID NUMBER (15)
History of Tax Code Id, populated from Payables/Receivables and passed to Payables/Receivables while exporting an item.
TAX_INCLUDED VARCHAR2 (1)
History of Tax Included indicator.
DISTRIBUTION_SET_ID NUMBER (15)
History of Distribution Set Id.
INV_RULE_ID NUMBER (15)
History of Invoice Rule Id.
ACCOUNT_RULE_ID NUMBER (15)
History of Salesrep Id.
SALESREP_ID NUMBER (15)
History of Salesrep Id.
APPROVED_BY NUMBER (15)
Approver Name for Index Payment Term.
STATUS VARCHAR2 (30)
Status of Index Payment Terms.
INDEX_PERIOD_ID NUMBER (15)
Associates Index Period row of Index Period Term with the term history row.
INDEX_TERM_INDICATOR VARCHAR2 (30)
Identifies whether the payment term is for backbill or recurring .
PO_HEADER_ID VARCHAR2 (30)
History of Purchase Order Header Id.
CUST_PO_NUMBER VARCHAR2 (50)
History of Purchase Order Number.
RECEIPT_METHOD_ID NUMBER (15)
History of Receipt Method Identifier.
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 (15)
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)
Indicates whether the term was changed or not.
NORM_START_DATE DATE

Normalization start date of the term.
TERM_TEMPLATE_ID NUMBER (15)
Associates Term Template row with the term history row.
EVENT_TYPE_CODE VARCHAR2 (30)
The event type associated with the term.
LEASE_STATUS VARCHAR2 (30)
Lease Status.
NORM_END_DATE DATE

Normalization end date of the term.
RECOVERABLE_FLAG VARCHAR2 (1)
Identifies whether the billing 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 with term history row.
AMOUNT_TYPE VARCHAR2 (30)
Amount Type of the term history row.
REC_AGR_LINE_ID NUMBER (15)
Associates a line for a billed record for a period from PN_REC_PERIOD_BILL_ALL table with term history row.
GROUPING_RULE_ID NUMBER (15)
Associates the grouping rule name in PN_PAY_GROUP_RULES_ALL with the term history.
AREA_TYPE_CODE VARCHAR2 (30)
Area Type Code.
AREA NUMBER

Total area associated with the term history row.
TERM_COMMENTS VARCHAR2 (2000)
Comments entered by user while created term history.
LEGAL_ENTITY_ID NUMBER (15)
Legal entity for payment term
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax classification code for payment term
Query Text

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


SELECT TERM_HISTORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_TERM_ID
,      DISTRIBUTION_CHANGE_ID
,      PREV_TERM_HISTORY_ID
,      ADJUSTMENT_TYPE_CODE
,      TOTAL_ADJ_AMOUNT
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      FREQUENCY_CODE
,      LEASE_ID
,      LEASE_CHANGE_ID
,      START_DATE
,      END_DATE
,      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
,      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_COMMENTS
,      LEGAL_ENTITY_ID
,      TAX_CLASSIFICATION_CODE
FROM PN.PN_PAYMENT_TERMS_HISTORY;

Dependencies

[top of page]

PN.PN_PAYMENT_TERMS_HISTORY does not reference any database object

PN.PN_PAYMENT_TERMS_HISTORY is referenced by following:

SchemaPN
ViewPN_PAYMENT_TERMS_HISTORY#