For property details
select * from pn_properties_All
For companies details
SELECT * FROM PN_COMPANIES_ALL
For building details
select * from pn_buildings_v
For the detail of floors in a building
select * from pn_floors_v
For the detail of offices in a single floor
select * from pn_offices_v
For Lease details
SELECT * FROM PN_LEASES_ALL
For payment details
select * from pn_payment_terms_all
For Tenant details
select * from pn_tenancies_all
For Payment schedules
select * from pn_payment_schedules_all
For location details
select * from pn_locations_All
select * from pn_properties_All
For companies details
SELECT * FROM PN_COMPANIES_ALL
For building details
select * from pn_buildings_v
For the detail of floors in a building
select * from pn_floors_v
For the detail of offices in a single floor
select * from pn_offices_v
For Lease details
SELECT * FROM PN_LEASES_ALL
For payment details
select * from pn_payment_terms_all
For Tenant details
select * from pn_tenancies_all
For Payment schedules
select * from pn_payment_schedules_all
For location details
select * from pn_locations_All
Nice
ReplyDeleteHello,
ReplyDeleteI want to required update property update in system. did you ever same exercise