You are browsing the archive for Oracle Property Manager.

Annual Cash Flow Pro Forma Report (PNACFLPR)

 

NAME: Annual Cash Flow Pro Forma Report (PNACFLPR)
SHORT CODE: PNACFLPR
MODULE: Oracle Property Manager

Description: Annual Cash Flow Pro Forma Report (PNACFLPR)
Navigation: Oracle Property Manager Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Lease Number Low : Lease Number Low
  • Lease Number High : Lease Number High
  • Fiscal Date : Fiscal Date

 

Annual Accounting Pro Forma Report (PNAAPFOR)

 

NAME: Annual Accounting Pro Forma Report (PNAAPFOR)
SHORT CODE: PNAAPFOR
MODULE: Oracle Property Manager

Description: Annual Accounting Pro Forma Report (PNAAPFOR)
Navigation: Oracle Property Manager Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Lease Number Low : Lease Number Low
  • Lease Number High : Lease Number High
  • Fiscal Date : Fiscal Date

 

Property Manager Tables

Oracle Property Manager Tables:

  • PN_ACCOUNTING_EVENTS_ALL
  • PN_ADDRESSES_ALL
  • PN_ADJUSTMENT_DETAILS
  • PN_ADJUSTMENT_SUMMARIES
  • PN_AE_HEADERS_ALL
  • PN_AE_LINES_ALL
  • PN_COMPANIES_ALL
  • PN_COMPANY_SITES_ALL
  • PN_CONTACTS_ALL
  • PN_CONTACT_ASSIGNMENTS_ALL
  • PN_CONTACT_ASSIGN_HISTORY
  • PN_CURRENCIES
  • PN_DISTRIBUTIONS_ALL
  • PN_DISTRIBUTIONS_HISTORY
  • PN_EMP_SPACE_ASSIGN_ITF
  • PN_INDEX_EXCLUDE_TERM_ALL
  • PN_INDEX_HISTORY_HEADERS
  • PN_INDEX_HISTORY_LINES
  • PN_INDEX_LEASES_ALL
  • PN_INDEX_LEASE_CONSTRAINTS_ALL
  • PN_INDEX_LEASE_PERIODS_ALL
  • PN_INDEX_LEASE_TERMS_ALL
  • PN_INSURANCE_REQUIREMENTS_ALL
  • PN_INSUR_REQUIRE_HISTORY
  • PN_LANDLORD_SERVICES_ALL
  • PN_LANDLORD_SERVICE_HISTORY
  • PN_LEASES_ALL
  • PN_LEASE_CHANGES_ALL
  • PN_LEASE_DETAILS_ALL
  • PN_LEASE_DETAILS_HISTORY
  • PN_LEASE_MILESTONES_ALL
  • PN_LEASE_OPTIONS_ITF
  • PN_LEASE_TRANSACTIONS_ALL
  • PN_LOCATIONS_ALL
  • PN_LOCATIONS_ITF
  • PN_LOCATION_FEATURES_ALL
  • PN_LOCATION_PARKS
  • PN_LOC_ACC_MAP_ALL
  • PN_LOC_ACC_MAP_HDR_ALL
  • PN_MILESTONES_ITF
  • PN_NOTE_DETAILS
  • PN_NOTE_HEADERS
  • PN_OPTIONS_ALL
  • PN_OPTIONS_HISTORY
  • PN_PAYMENT_ITEMS_ALL
  • PN_PAYMENT_ITEMS_EFC
  • PN_PAYMENT_SCHEDULES_ALL
  • PN_PAYMENT_TERMS_ALL
  • PN_PAYMENT_TERMS_EFC
  • PN_PAYMENT_TERMS_HISTORY
  • PN_PAY_GROUP_BYS
  • PN_PAY_GROUP_RULES
  • PN_PHONES_ALL
  • PN_PROPERTIES_ALL
  • PN_REC_AGREEMENTS_ALL
  • PN_REC_AGR_LINABAT_ALL
  • PN_REC_AGR_LINAREA_ALL
  • PN_REC_AGR_LINCONST_ALL
  • PN_REC_AGR_LINES_ALL
  • PN_REC_AGR_LINEXP_ALL
  • PN_REC_ARCL_ALL
  • PN_REC_ARCL_DTLLN_ALL
  • PN_REC_ARCL_DTL_ALL
  • PN_REC_ARCL_EXC_ALL
  • PN_REC_CALC_PERIODS_ALL
  • PN_REC_EXPCL_ALL
  • PN_REC_EXPCL_DTLACC_ALL
  • PN_REC_EXPCL_DTLLN_ALL
  • PN_REC_EXPCL_DTL_ALL
  • PN_REC_EXPCL_INC_ALL
  • PN_REC_EXPCL_TYPE_ALL
  • PN_REC_EXP_ITF
  • PN_REC_EXP_LINE_ALL
  • PN_REC_EXP_LINE_DTL_ALL
  • PN_REC_LINBILL_ALL
  • PN_REC_PERIOD_BILL_ALL
  • PN_REC_PERIOD_LINES_ALL
  • PN_RENT_ROLL_LEASE_EXP_ITF
  • PN_RIGHTS_ALL
  • PN_RIGHTS_HISTORY
  • PN_SET_MILESTONES
  • PN_SET_TYPES
  • PN_SPACE_ALLOCATIONS_ALL
  • PN_SPACE_ALLOC_ITF
  • PN_SPACE_ASSIGN_CUST_ALL
  • PN_SPACE_ASSIGN_EMP_ALL
  • PN_SPACE_ASSIGN_LEASE_ITF
  • PN_SPACE_ASSIGN_LOC_ITF
  • PN_SPACE_UTIL_LEASE_ITF
  • PN_SPACE_UTIL_LOC_ITF
  • PN_SYSTEM_SETUP_OPTIONS
  • PN_TENANCIES_ALL
  • PN_TENANCIES_HISTORY
  • PN_TERM_TEMPLATES_ALL
  • PN_VAR_ABATEMENTS_ALL
  • PN_VAR_BKPTS_DET_ALL
  • PN_VAR_BKPTS_HEAD_ALL
  • PN_VAR_CONSTRAINTS_ALL
  • PN_VAR_DEDUCTIONS_ALL
  • PN_VAR_GRP_DATES_ALL
  • PN_VAR_LINES_ALL
  • PN_VAR_PERIODS_ALL
  • PN_VAR_RENTS_ALL
  • PN_VAR_RENT_DATES_ALL
  • PN_VAR_RENT_INV_ALL
  • PN_VAR_RENT_SUMM_ALL
  • PN_VAR_VOL_HIST_ALL
  • PN_VOL_HIST_BATCH_ITF
  • PN_VOL_HIST_LINES_ITF