Reconcile Report For IPP

To generate Reconcile reports for IPP (instalment payment plans), refer to the guide below.

👍

Connect using SFTP

• IP Address : 52.76.184.174
• Port : 22
• Username : The merchant must fill in the SFTP setup form and send the request to support team. An account will be created for merchant to access 2c2p SFTP in demo and production environment.
• Response Path : /output
• Drop Time For Response File : Everyday Before 4.00AM GMT+7

How to get the report

1. At the specified time, 2C2P will drop a CSV file in the SFTP server. The file name follows the format Reconcile2c2p_B_v2.1_MID_CURRENCY_yyyy-MM-dd_HHmmss.csv
2. Merchant is required to get the file from SFTP Server.
3. For more information on the report's contents, refer to Data Parameters below.

🚧

File Format Specification

• File name format : Reconcile2c2p_B_v2.1_MID_CURRENCY_yyyy-MM-dd_HHmmss.csv
  - Reconcile2c2p_B_v2.1_JT_THB_2017-07-18_153136_all.csv
  - Reconcile2c2p_B_v2.1_JT_THB_2017-07-18_153136_ipp.csv
  - Reconcile2c2p_B_v2.1_JT_THB_2017-07-18_153136_nonIpp.csv
• Parameter delimiter : comma "," for CSV Format; and Other type is Fixed Length
• Record delimiter : line break

📘

Data Attribute Reference

Data Type

• A: Alphabet
• AN: Alphanumeric
• C: Characters
• B: Boolean
• D: Decimal
• N: Numeric

Mandatory attributes

• M: Mandatory
• C: Conditional
• O: Optional

Data Parameters

👍

Sample File

Download sample csv file here.

2C2P2023102301,2,H,test,0,12/10/2023,test,23/10/2023,000000,00/00/00,000000,702702000000000,00000000000000000000,00000000000000000000,000,000,000,4020.00,0.00,0.00,0.00,0.00,,,,,,,0.00,4020.00,0.00,SGD,000000,0,0,,,,,,,1340.00,,,,0.00,0.00,0.00,,,,,,,,,,,,,,,,,,,,,,,,,
2C2P2023102301,1,D,test,0,12/10/2023,test,11/10/2023,130643,11/10/2023,000000,702702000000000,rT1qtTw8siLut3MWQajjxPtLE,,006,VI,BANCO DAVIVIENDA S.A.,2010.00,0.00,0.00,0.00,0.00,2C2P-231011-0037,11/10/2023,1.65,0.10,1.75,,0.00,2010.00,0.00,SGD,368938,05,491647XXXXXX8295,36050,SHOPIFY,,,,0.00,670.00,M,3,0.00,0.00,0.00,0.00,,,,COL,VI,8041222,2C2P SG Test B,,Chow Sum,Payment for rT1qtTw8siLut3MWQajjxPtLE,,0.00,,,,,0.00,,,,,,,,
2C2P2023102301,2,D,test,0,12/10/2023,test,11/10/2023,131406,11/10/2023,000000,702702000000000,rOrzIYbG5GJylY3AL2xIV3uKZ,,006,VI,BANCO DAVIVIENDA S.A.,2010.00,0.00,0.00,0.00,0.00,2C2P-231011-0037,11/10/2023,1.65,0.10,1.75,,0.00,2010.00,0.00,SGD,190966,05,491647XXXXXX8295,36051,SHOPIFY,,,,0.00,670.00,M,3,0.00,0.00,0.00,0.00,,,,COL,VI,8041248,2C2P SG Test B,,Chow Sum,Payment for rOrzIYbG5GJylY3AL2xIV3uKZ,,0.00,,,,,0.00,,,,,,,,