Debts


Every debts for each contract account is listed in this model. Debts are displayed along side with their dunning procedure and status. This Sigma data model can be used to track the daily status of debts, plan debt collection campaigns and analyze debts per BP, CA, products, geographical data or any other attribute. This data model shows all information that is shown in SAP’s FPL9 transaction but in a much more clearer way which also allows for massive analysis.

  • SAP Tables: DFKKOP, FKKMAZE, FKKVKP, EVER, BUT000, EANL

Payments


Series of Sigma data models that displays the payments, credit card payments, direct debit payments, installment plans and statistical documents not included in invoices. These models can be used to track the financial balance of the SAP/FICA module, analyze customers payments behavior and more.

  • SAP Tables: DFKKOP, DFKKKO, DFKKOPK

Dunning


Dunning procedures and levels are displayed in this Sigma Data Model As well as
Alert documents.

  • Sap Tables: dfkkmako, dfkkmaze, dfkkcoh
 

Installment Plans Management


Keeps track of your installments plans. Current status of periodical payments, current status of debt. This Sigma Data Model helps financial planing and risk management.

  • SAP Tables: DFKKOP, FKKMAZE, FKKVKP, EVER, BUT000, EANL
 

Credit Cards Transactions


All credit card transactions with additional info about the card being used, place and time of payment, payment channel, the issuer and the credit card cleaning information.

  • SAP Tables: DFKKOP, DFKKKO, DFKKOPK
 

Transfer of Debts between CA


Debts can be transferred between contract accounts for many reasons. This Sigma Data Model holds the information about all transfer that has been done. Original CA, Target CA, reason, date of transfer, amount, personnel involved.

  • Sap Tables: dfkkop , dfkkko
 

Refunds


Keeps track of refunds made to customers. All details of checks, personnel involved, reasons, amounts day of issue and more.

  • SAP Tables: DFKKOP,  DFKKCR
 

Outgoing documents


All outgoing messages (letters, bills, alerts,SMS, emails, faxes) sent to customers via distribution channels.

  • SAP Tables:
 

Payments denial (returns)


Payments returns from credit card companies or from banks.

  • Sap Tables: dfkkop , dfkkko, dfkkrh
 

Interests Locks


Keeps track of  locks done in FICA. Personnel involved, reasons and lock procedures. Detail of bills involved under the lock terms and more.

  • SAP Tables: DFKKLOCKS,  SWWIHEAD
view other selected sigma data models: