Sample CSV File for Mass Payment Transfer
,436878000000,P,ROBL,HCMATCH,770018000000,,,,120
,436229000000,P,ENTR,HCMATCH,770018000000,,,,100
436560000000,,E,NSF,HCMATCH,770018000000,,,,180
,436912000000,P,ACCT,HCMATCH,770018000000,,,,200
Let us assume that the payment transfer file is uploaded and transformed using a file request type with the following field transformation details:
Sequence | Field Name | Map Field XPath |
---|---|---|
1 | Payment Event ID | C1-TransferPaymentService/paymentEventId |
2 | Payment ID | C1-TransferPaymentService/paymentId |
3 | Transfer Type | C1-TransferPaymentService/transferType |
4 | Transfer Reason | C1-TransferPaymentService/transferReason |
5 | Match Type | C1-TransferPaymentService/matchType |
6 | Match Type Value | C1-TransferPaymentService/matchTypeValue |
7 | Source System | C1-TransferPaymentService/sourceSystem |
8 | External Transaction Id | C1-TransferPaymentService/externalTransactionId |
9 | External Source system Id | C1-TransferPaymentService/externalSourceId |
10 | Transfer Amount | C1-TransferPaymentService/transferAmount |
On successfully uploading and transforming the data, the system creates a transformed payload for each CSV file record. The transformed payload stores the payment transfer data in the following tags:
Service Payload | Tag Name | CSV File Record 1 | CSV File Record 2 | CSV File Record 3 | CSV File Record 4 |
---|---|---|---|---|---|
C1-Transfer Payment Service |
paymentEventId | - | - | 436560000000 | - |
paymentId | 436878000000 | 436229000000 | - | 436912000000 | |
transferType | P | P | E | P | |
transferReason | ROBL | ENTR | NSF | ACCT | |
matchType | HCMATCH | HCMATCH | HCMATCH | HCMATCH | |
matchTypeValue | 770018000000 | 770018000000 | 770018000000 | 770018000000 | |
sourceSystem | - | - | - | - | |
externalTransactionId | - | - | - | - | |
externalSourceId | - | - | - | - | |
transferAmount | 120 | 100 | 180 | 200 |
Related Topics
For more information on... | See... |
---|---|
CSV File Format for Mass Payment Transfer | CSV File Format for Mass Payment Transfer |