Skip to end of metadata
Go to start of metadata

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.


Table: BATCH_RECEIPT

Stores the receipt for each batch.

Column

Description

ID

Autonumbered primary key for the transmission.

EXTERNAL_ID

External identifier from the batch. This is in the XML upload, and will be generated by the external system.

ENTITY_ID

User or system that uploaded the transactions.

INCOMING_DATE

When the batch goes through initial verification, the datetime stamp of this action will be stored here.

TOTAL_TRANS

The number of total discrete transactions in the batch.

TOTAL_VALUE

The total value of all transactions within the batch.

TOTAL_ACCEPTED

The total number of accepted transactions in the batch.

TOTAL_ACCEPTED_CREDITS

The total value of all accepted credits.

TOTAL_ACCEPTED_DEBITS

The total value of all accepted debits.

TOTAL_REJECTED

The number of transactions that were rejected.

TOTAL_VALUE_REJECTED

The total value of all rejected transactions.

BATCH_RESPONDED

When the system sends its reply to the external system, the datestamp is recorded here.

INCOMING_XML_ID_FK

Pointer to XML table for the incoming XML message.

OUTGOING_XML_ID_FK

Pointer to XML table for the outgoing XML message.

STATUS

Status of the batch.
Q – In Process ("queued")
F – Failed – The entire batch was rejected. This means that the batch can be resent (after corrections) with the same batch number.
P – Partial, at least one of the transactions was added to the system. The batch number associated with this batch cannot be reused.
E – Entire, the whole batch was accepted. The batch number cannot be reused.

Table: XML

Simple storage of XML documents.

Column

Description

ID

Autonumbered primary key for the XML document.

CREATION_DATE

Date that the document was stored by KSA.

CREATOR_ID

Identification of the user of system that sent the message.

XML_DOCUMENT

CLOB storing the actual XML document.

  • No labels