...
Master/Original Transaction Number Logic
Single Mode Load
Values in the incoming file | Values loaded to DB |
|---|---|
Both values are not set or missing originalTransactionNumber is NULL | You will get the following error: Original Transaction Number cannot be null |
Only original transaction number set originalTransactionNumber = FILLED | - masterTransactionNum copies the originalTransactionNumber value:
- if you send the same message again, the values will remain the same (as from the file):
- change originalTransactionNumber value to FILLED_B, once again masterTransactionNum copies this value and a new record will be created:  |
Both values are set: originalTransactionNumber = FILLED_C | - first load: values from file loaded into DB:
- if you change originalTransactionNumber to FILLED_Е, the record will be updated updated with the new originalTransactionNumber value:
- if you change masterTransactionNum to FILLED_F, the record will be updated with the new masterTransactionNum value:
- if you change both: originalTransactionNumber to FILLED_G and masterTransactionNum to FILLED_H, a new record will be created:
|
Batch Mode Load
If no masterTransactionNum value is provided in the file for load, masterTransactionNum value will reflect the originalTransactionNumber value from the record:
...