Explanation of Activity: Invoice Due Date Passed


can anybody help me understanding how the activity “Invoice Due Date Passed” is defined?
I have a few cases, where this occures more than one time in the process and I wonder how this is possible.

Thank you for your help!


Hi Carina,

In principle this section is not sufficient to define an activity. The excerpt only represents the extraction of the relevant information from your database (SELECT). If I understand you correctly, you would like to understand how the individual parts are put together. In order to define an activity in Celonis, a case key, a name and a timestamp are required. In addition, as in your case, several additional columns are added, such as the sorting. I assume that all columns are self explanatory except the timestamp creation. Therefore, I suppose that your question refers to the creation of the timestamp. The creation of the timestamp is somewhat more complex in this case, since possible cash discounts are to be taken into account here.

Field ZBD3T describes the payment period, field ZFBDT contains the baseline date for due date calculation, and ZBD1T/ZBD2T contain information on possible cash discounts. The time stamp for the Invoice Due Date Passed activity is determined from this information. The corresponding days are added to the baseline date.

I hope that this information helps you to understand how this activity is created. If there are any open questions, please feel free to contact us again.

Best regards,