Project Contract Revenue

The Project contract line is based on these project Invoice tables:

  • Advances - tppin010
  • Settled Advances - tppn011
  • Installments - tppin020
  • Holdback - tppin040
  • Unit Rate Invoice - tppin050
  • Cost Plus Transactions - tpppc200
  • Project Extension – tpptc050
  • Fees and Penalties – tppin080
  • Delivery Based Invoice – tppin060 and tppdm700
  • Manual Revenues - tpppc301
  • Revenue Transaction - tpppc305

This diagram shows the star schema:

Project contract revenue star schema