In this page:
Table of Contents |
---|
Overview
Warehouse Cash Activity inbound interface is designed to load and update data in CASHDBO.CASH_ACTIVITY database table.
Incoming message format: EagleML (WarehouseCashActivity complex type).
...
To load or update data in Warehouse Cash Activity tables, send your CSV message to the eagle_default_in_csv_warehouse stream
Master Transaction Number Logic
Single Mode Load
Values in the incoming file | Values loaded to DB |
originalTransactionNumber NULL masterTransactionNum NULL | Error: Original Transaction Number cannot be null |
originalTransactionNumber FILLED masterTransactionNum NULL | - masterTransactionNum copies the originalTransactionNumber value: - if sending the same message again, the values remain the same (as from the file): - change originalTransactionNumber value to FILLED_B, masterTransactionNum copies this value and a new record is created: |
originalTransactionNumber FILLED_C masterTransactionNum FILLED_D | - values from file loaded into DB: - change originalTransactionNumber to FILLED_Е, the record will update with the new originalTransactionNumber value: - change masterTransactionNum на FILLED_F, the record will update with the new masterTransactionNum value: - change both: originalTransactionNumber to FILLED_G and masterTransactionNum to FILLED_H, a new record is created: |
Batch Mode Load
If no masterTransactionNum value is provided in the loading file, the masterTransactionNum value will reflect the originalTransactionNumber value from the record:
Anchor | ||||
---|---|---|---|---|
|
...