Project Revenue Type

This table shows the LN table from which fields are retrieved for the dimension:

Table Description
Enum Enum

This table shows the attribute mapping to LN table fields for the dimension:

Attribute Mapping
Project Revenue Type Project Revenue Type:
  • Advance Payment
  • Installment
  • Inst. Additional Work
  • Cost Plus
  • Extension
  • Unit Rate
  • Holdback
  • Delivery Based
  • Progress Payment Request
  • Fees and Penalties
  • Credit Note
Project Revenue Type Filter Project Revenue Type enum constant name from LN:
  • Advance Payment – tppdm.invt.advance
  • Installment – tppdm.invt.installment
  • Inst. Additional Work – tppdm.invt.inst.add.work
  • Cost Plus – tppdm.invt.cost.plus
  • Extension – tppdm.invt.extension
  • Unit Rate – tppdm.invt.unit.rate
  • Holdback – tppdm.invt.holdback
  • Delivery Based – tppdm.invt.delivery
  • Progress Payment Request – tppdm.invt.prog.paymnt.req
  • Fees and Penalties – tppdm.invt.fees.penalties
  • Credit Note – tppdm.invt.credit.note
Project Revenue Type Filter Project Revenue Type enum constant name from LN:
  • Advance Payment – 1
  • Installment – 2
  • Inst. Additional Work –3
  • Cost Plus – 4
  • Extension – 5
  • Unit Rate – 6
  • Holdback – 7
  • Delivery Based – 8
  • Progress Payment Request – 9
  • Fees and Penalties – 10
  • Credit Note – 11
deleted 1 if deleted in LN, else 0