KSA can accept transaction uploads of batches, following the XML schema provided. The system will keep track of the batches and the results of the batches so that the system can be reconciled with external systems.
Stores the receipt for each batch.
Autonumbered primary key for the transmission.
External identifier from the batch. This is in the XML upload, and will be generated by the external system.
User or system that uploaded the transactions.
When the batch goes through initial verification, the datetime stamp of this action will be stored here.
The number of total discrete transactions in the batch.
The total value of all transactions within the batch.
The total number of accepted transactions in the batch.
The total value of all accepted credits.
The total value of all accepted debits.
The number of transactions that were rejected.
The total value of all rejected transactions.
When the system sends its reply to the external system, the datestamp is recorded here.
Pointer to XML table for the incoming XML message.
Pointer to XML table for the outgoing XML message.
Status of the batch.
Simple storage of XML documents.
Autonumbered primary key for the XML document.
Date that the document was stored by KSA.
Identification of the user of system that sent the message.
CLOB storing the actual XML document.