Version vom 3. November 2013, 23:42 Uhr

This page gives an overview over the things I did to implement FreiBier:

Application Dictionary

Tables

• BAY_Contract
• RV_Fact_Acct_BAY (Database View)
• BAY_Statistikperiode
• BAY_Umsatzstatistik
• BAY_TradingUnit

Columns

• in Table C_ElementValue:
  • oldValue
• In M_Product:
  • isDeposit
  • BAY_TRadingUnit_ID
• In C_Invoice:
  • BAY_Contract_ID
• In C_Payment:
  • BAY_Contract_ID

Windows

• Artikelstammdaten (Kopie von Artikel komplett angepasst)
• Verträge
• Statistikperiode
• Gebinde

Tabs

Fields

• BAY_Contract_ID in C_Invoice and C_Payment
• Change Type of UserElement1_ID in Fact_Acct, RV_Fact_Acct, etc. to BAY_Contract

References

• Listenreferenzen
  • Vertragsstatus: Bonikonto(8), beendet(9), vorbereitet (1), aktiv(2), gestört(3)
• Tabellenreferenz
  • BAY_Contract (else it can not be used with a column name other that BAY_Contact_ID - like UserElement1_ID)
• Tabellenreferenzen mit Auswahl
  • Pfandartikel

Process

• CreateAllPayments (with field in I_BankStatement)

Reports

Code (and Database)

• • Processes - I created some code for new Processes
  • Views - I modified and created some database views