PN Tables (136)

PN - Property Manager — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`PN_ACCOUNTING_EVENTS_ALL`	18	The accounting events table
`PN_ADDRESSES_ALL`	51	Information on locations and service providers
`PN_ADJUSTMENT_DETAILS`	13	Details of an adjustment.
`PN_ADJUSTMENT_SUMMARIES`	9	Summary of Adjustement.
`PN_AE_HEADERS_ALL`	24	The accounting headers table
`PN_AE_LINES_ALL`	56	The accounting lines table
`PN_COMPANIES_ALL`	27	Information pertaining to a service provider
`PN_COMPANY_SITES_ALL`	29	Site information of a service provider
`PN_CONTACTS_ALL`	31	Contact information identified at the site level of a service provider
`PN_CONTACT_ASSIGNMENTS_ALL`	29	Llinks locations or leases with the site of a service provider.
`PN_CONTACT_ASSIGN_HISTORY`	30	Track changes in contacts linked to the lease
`PN_CURRENCIES`	7	Information about currency_code and conversion_type
`PN_DISTRIBUTIONS_ALL`	29	The table stores distributions for a payment term
`PN_DISTRIBUTIONS_HISTORY`	28	Distributions History Table.
`PN_EMP_SPACE_ASSIGN_ITF`	43	PN_EMP_SPACE_ASSIGN_ITF Interface Table.
`PN_INDEX_EXCLUDE_TERM_ALL`	10	This table has terms which have to excluded from the calculation of the Rent increase.
`PN_INDEX_HISTORY_HEADERS`	25	PN_INDEX_HISTORY_HEADERS stores index information. Indexes help to account for inflation when calculating rent increases
`PN_INDEX_HISTORY_LINES`	31	PN_INDEX_HISTORY_LINES stores all the relevant details associated with an Index type including index dates and index values.
`PN_INDEX_LEASES_ALL`	74	PN_INDEX_LEASES_ALL stores all the rent increases associated with an existing lease.
`PN_INDEX_LEASE_CONSTRAINTS_ALL`	29	PN_INDEX_LEASE_CONSTRAINTS_ALL stores the constraints that apply to the rent increase.
`PN_INDEX_LEASE_PERIODS_ALL`	44	PN_INDEX_LEASE_PERIODS_ALL stores the relevant details associated with all the rent increase periods.
`PN_INDEX_LEASE_TERMS_ALL`	14	This table stores the index payment terms.
`PN_INSURANCE_REQUIREMENTS_ALL`	35	Insurance details related to a lease.
`PN_INSUR_REQUIRE_HISTORY`	35	Track changes to insurance details related to a lease
`PN_LANDLORD_SERVICES_ALL`	38	Information about the services provided by the landlord to the tenant.
`PN_LANDLORD_SERVICE_HISTORY`	39	Track changes in the service provided by the landlord to the tenant
`PN_LEASES_ALL`	21	Lease information
`PN_LEASE_CHANGES_ALL`	34	Lease abstracted, amended and edited
`PN_LEASE_DETAILS_ALL`	36	Lease dates and accounting information
`PN_LEASE_DETAILS_HISTORY`	38	Track changes to the lease details data elements
`PN_LEASE_MILESTONES_ALL`	35	Information about important events in a lease
`PN_LEASE_OPTIONS_ITF`	73	PN_LEASE_OPTIONS_ITF Interface Table.
`PN_LEASE_TRANSACTIONS_ALL`	11	Transactions performed on a lease
`PN_LOCATIONS_ALL`	67	Space definition
`PN_LOCATIONS_ITF`	91	Space definition data to be imported or exported in and out of Oracle Property Manager
`PN_LOCATION_FEATURES_ALL`	30	Information on features available in a building
`PN_LOCATION_PARKS`	28	Information on Regions and Office Parks
`PN_LOC_ACC_MAP_ALL`	92	Stores the information for mapping of expense accounts to the location.
`PN_LOC_ACC_MAP_HDR_ALL`	24	Stores mapping accounts to location header information.
`PN_MILESTONES_ITF`	62	PN_MILESTONES_ITF Interface Table.
`PN_NOTE_DETAILS`	10	Multiple lines of text associated with a note type.
`PN_NOTE_HEADERS`	25	Type of note in a lease
`PN_OPEX_AGREEMENTS_ALL`	71	This table stores method and overview information for operating expense agreements.
`PN_OPEX_CRITICAL_DATES_ALL`	30	This table stores information on critical dates for operating expense agreements.
`PN_OPEX_EST_PAYMENTS_ALL`	33	This table stores estimated payment information for operating expense agreements.
`PN_OPEX_EXP_GRPS_ALL`	34	This table stores expense group information for operating expense agreements.
`PN_OPEX_NOTES_ALL`	31	This table stores the information related to the 'Notes' section on various sub tabs in an Opex Agreement.
`PN_OPEX_PRORAT_BASIS_DTLS_ALL`	30	This table stores pro rata basis information for operating expense agreeements.
`PN_OPEX_RECON_ALL`	79	This table stores reconciliation overview information for operating expenses
`PN_OPEX_RECON_CRDT_ALL`	28	This table stores information on critical dates for operating expense reconciliations
`PN_OPEX_RECON_DETAILS_ALL`	30	This table stores reconciliation review information for operating expenses
`PN_OPEX_RECON_EXP_GRP_ALL`	40	This table stores expense group information for operating expense reconciliations
`PN_OPEX_RECON_PRTBS_ALL`	42	This table stores pro rata basis information for operating expense reconciliations
`PN_OPTIONS_ALL`	40	Details of specified terms for a specific period in a lease contract
`PN_OPTIONS_HISTORY`	41	Track changes in option details related to a lease
`PN_PAYMENT_ITEMS_ALL`	58	Payment and billing items associated with a payment or a billing schedule
`PN_PAYMENT_ITEMS_EFC`	26	Shadow table for PN_PAYMENT_ITEMS_ALL for supporting Euro functional currency
`PN_PAYMENT_SCHEDULES_ALL`	33	Payment or billing schedules for both landlord and the tenant
`PN_PAYMENT_TERMS_ALL`	110	Payment and billing terms defined in a lease
`PN_PAYMENT_TERMS_EFC`	20	Shadow table for PN_PAYMENT_TERMS_ALL for supporting Euro functional currency.
`PN_PAYMENT_TERMS_HISTORY`	103	Term History table.
`PN_PAY_GROUP_BYS`	24	Stores Group By information.
`PN_PAY_GROUP_RULES`	24	Stores grouping rules information.
`PN_PHONES_ALL`	30	Telecommuting information to reach a contact
`PN_PROPERTIES_ALL`	36	Stores the properties information.
`PN_REC_AGREEMENTS_ALL`	35	Recovery Agreement set up table
`PN_REC_AGR_LINABAT_ALL`	29	Recovery Abatement set up table
`PN_REC_AGR_LINAREA_ALL`	29	Recovery Area set up table
`PN_REC_AGR_LINCONST_ALL`	32	Recovery Constraint set up table
`PN_REC_AGR_LINES_ALL`	33	Recovery Lines set up table
`PN_REC_AGR_LINEXP_ALL`	27	Recovery Expense set up table
`PN_REC_ARCL_ALL`	30	Stores area class header information.
`PN_REC_ARCL_DTLLN_ALL`	48	Stores drilldown information associated with an area class detail
`PN_REC_ARCL_DTL_ALL`	38	Stores area class details summary header information
`PN_REC_ARCL_EXC_ALL`	29	Stores area class exclusions information.
`PN_REC_CALC_PERIODS_ALL`	27	Calculation Periods table
`PN_REC_EXPCL_ALL`	33	Stores expense class setup information
`PN_REC_EXPCL_DTLACC_ALL`	35	Stores drilldown information associated with an expense class line detail.
`PN_REC_EXPCL_DTLLN_ALL`	39	Stores expense class line details associated with a summary header.
`PN_REC_EXPCL_DTL_ALL`	30	Stores expense class details header information.
`PN_REC_EXPCL_INC_ALL`	28	Stores expense class inclusions associated with an expense class
`PN_REC_EXPCL_TYPE_ALL`	25	Stores expense class types associated with an expense class
`PN_REC_EXP_ITF`	35	Recovery Expense Interface Table.
`PN_REC_EXP_LINE_ALL`	30	Stores the expense lines header information.
`PN_REC_EXP_LINE_DTL_ALL`	39	Stores recovery expense lines and recovery expense line allocations information.
`PN_REC_LINBILL_ALL`	25	Calculation Periods table
`PN_REC_PERIOD_BILL_ALL`	27	Billed terms for a period and line table
`PN_REC_PERIOD_LINES_ALL`	51	Recovery lines and the amount calculated for a period
`PN_RENT_INCREASE_DETAILACC_ITF`	106	This table is used to create the RXi Rent Increase Account Detail Report
`PN_RENT_INCREASE_DETAIL_ITF`	102	This table is used to create the RXi Rent Increase Detail Report
`PN_RENT_INCREASE_SUMMARY_ITF`	60	This table is used to create the RXi Rent Increase Summary Report
`PN_RENT_ROLL_LEASE_EXP_ITF`	68	PN_RENT_ROLL_LEASE_EXP_ITF Interface Table.
`PN_RIGHTS_ALL`	32	Stores the rights information for leases
`PN_RIGHTS_HISTORY`	33	Stores the rights history for lease amendments
`PN_SET_MILESTONES`	28	Milestone setup information to be associated with a milestone set
`PN_SET_TYPES`	10	Type of milestones grouping
`PN_SPACE_ALLOCATIONS_ALL`	29	Space assignment information for an employee, contractor or the cost center.
`PN_SPACE_ALLOC_ITF`	37	No Longer Used
`PN_SPACE_ASSIGN_CUST_ALL`	41	Stores the customer space assignment information.
`PN_SPACE_ASSIGN_EMP_ALL`	36	Stores the employee space assignment information
`PN_SPACE_ASSIGN_LEASE_ITF`	67	PN_SPACE_ASSIGN_LEASE_ITF Interface Table.
`PN_SPACE_ASSIGN_LOC_ITF`	62	PN_SPACE_ASSIGN_LOC_ITF Interface Table.
`PN_SPACE_UTIL_LEASE_ITF`	51	PN_SPACE_UTIL_LEASE_ITF Interface Table.
`PN_SPACE_UTIL_LOC_ITF`	46	PN_SPACE_UTIL_LOC_ITF Interface Table.
`PN_SYSTEM_SETUP_OPTIONS`	39	Property Manager system setup options for operating units.
`PN_TENANCIES_ALL`	50	Information on leased or subleased locations
`PN_TENANCIES_HISTORY`	50	Track changes in the leased or subleased locations
`PN_TERM_TEMPLATES_ALL`	59	PN_TERM_TEMPLATES_ALL stores the payment/billing term details defaults.
`PN_VAR_ABATEMENTS_ALL`	13	Stores recurring abatements information for an invoice.
`PN_VAR_ABAT_DEFAULTS_ALL`	31	This table stores setup information for abatements and allowances.
`PN_VAR_BKDT_DEFAULTS_ALL`	36	This table stores setup information for breakpoint details by organization.
`PN_VAR_BKHD_DEFAULTS_ALL`	39	This table stores setup information for breakpoints by organization.
`PN_VAR_BKPTS_DET_ALL`	36	Stores breakpoint related information to be used in the calculation of variable rent for each line item.
`PN_VAR_BKPTS_HEAD_ALL`	34	Stores breakpoint related detail information to be used in the calculation of variable rent for each line item.
`PN_VAR_CONSTRAINTS_ALL`	34	Stores constraints to be applied to a period for the calculation of variable rent.
`PN_VAR_CONSTR_DEFAULTS_ALL`	32	This table stores setup information for constraints by organization.
`PN_VAR_CONSTR_TEMPLATES_ALL`	13	Constraints Templates
`PN_VAR_DEDUCTIONS_ALL`	36	Stores deductions to be applied to each line item for calculation of variable rent.
`PN_VAR_DEDUCT_ARCH_ALL`	43	This table stores deduction data that was modified during batch import.
`PN_VAR_GRP_DATES_ALL`	21	Stores critical dates related to the variable rent agreement generated by the periods generation program.
`PN_VAR_LINES_ALL`	34	Stores information related to line items associated within each period for a variable rent.
`PN_VAR_LINE_DEFAULTS_ALL`	32	This table stores default line setup information for variable rent by organization.
`PN_VAR_LINE_TEMPLATES_ALL`	27	This table stores line setup information for variable rent by organization.
`PN_VAR_PERIODS_ALL`	31	Stores information about periods generated by the periods generation program for the duration of variable rent.
`PN_VAR_RENTS_ALL`	46	Stores variable rent agreement information.
`PN_VAR_RENT_DATES_ALL`	46	Stores GL Calendar to be used and variable agreement related date frequencies.
`PN_VAR_RENT_INV_ALL`	48	Stores the calculated variable rent details for a period and for an invoice date.
`PN_VAR_RENT_SUMM_ALL`	36	Stores the calculated variable rent for a line item for a group date.
`PN_VAR_REPORT_DATES_ALL`	27	This table stores report dates of variable rent by group date.
`PN_VAR_TEMPLATES_ALL`	46	This table stores templates containing default values for variable rent agreements.
`PN_VAR_TRX_DETAILS_ALL`	22	This table stores information on variable rent records.
`PN_VAR_TRX_HEADERS_ALL`	40	This table stores details of variable rent calculations
`PN_VAR_VOL_ARCH_ALL`	52	This table stores volume data that was modified during batch import.
`PN_VAR_VOL_HIST_ALL`	45	Stores volume history related to a line item.
`PN_VOL_HIST_BATCH_ITF`	13	Interface table to contain batch information.
`PN_VOL_HIST_LINES_ITF`	21	Interface table to contain batch lines information.