Data Model Diagrams

Lease – Client Payable

------------------------
|   rls Lease          |
|======================|
|   por_s: portfolio   |
|   com_s: company     |
|   reg_s: region      |
|   off_s: office      |
|   lse_s: lease       |
------------------------
         |    |
         |    |                 ------------------------
         |    |                 |   rar A/R            |
         |    |                 |======================|
         |    | p/c/r/o/lse_s   |   por_s: portfolio   |
         |    +---------------->|   com_s: company     |
         |                      |   reg_s: region      |
         |                      |   off_s: office      |
         |                      |   lse_s: lease       |
         |                      |   invo_s: invoice    |
         |                      ------------------------
         |                                 |
         |                                 |
         |                                 |              -----------------------------------------
         |                                 | invo_s       |   vrtp_rcr Recurring Charge Payable   |
         |                                 +------------->|=======================================|
         | lse_s                                          |   invo_s: invoice                     |
         +----------------------------------------------->|   lse_s: lease                        |
                                                          |   client_id_s: vendor/broker          |
                                                          -----------------------------------------

  A table join of the rar table with the vrtp_rcr view on invo_s is indexed and does not require a search of the entire rtp table.

A table join of the rls table with the vrtp_rcr view on lse_s is non-indexed and requires a search of the entire rtp table .

  Refer to model diagrams for Vendor – Vendor Detail and Broker – Broker Detail for additional Client Payable relationships.