Reconcile Report

BATCH_NO

AN 20

M

2C2P+YYMMDD (Payin BATCH NO)+NN

LINE_NO

N 5

M

H = Total Line No. , D= Line number

TYPE_TABLE

AN 1

M

H=Header, D=Detail

BANK_CODE

AN 25

M

Bank Swift Code

ACCOUNT_NO

AN 25

M

Merchant Bank Account Number

PAYIN_DATE

AN 10

M

DD/MM/YYYY

VAT_NO

AN 25

M

0107536000633 (Merchant Tax Registation No)

ORDER_DATE

AN 10

M

Customer order date [format : DD/MM/YYYY]

ORDER_TIME

AN 6

M

Customer order time [format : HHMMSS]

PAYMENT_DATE

AN 10

M

Customer pay date [format : DD/MM/YYYY]

PAYMENT_TIME

AN 6

M

Customer pay time [format : HHMMSS]

MERCHANT_ID

AN 15

M

Merchant ID defined by 2C2P

ORDER_ID

AN 20

M

Unique merchant order number

• Example: 00000000010000091203
• Note: The same order number may appear in the file for different payment methods. For instance, 1 line item for Loyalty and 1 line item for Card Payment

INVOICE_NO

AN 50

M

Merchant Invoice Number

PAYMENT_TYPE

AN 3

M

Payment channel codes

• 001 = Credit and debit cards
• 002 = Cash payment channels
• 003 = Direct debit
• 004 = Others
• 005 = Refund
• 006 = Installment Payment
• 007 = Loyalty Payment
• 008 = Chargeback

PAYMENT_CHANNEL

AN 30

M

Refer to Payment Channel Matrix Table

AGENT_CODE

AN 30

M

Refer to Agent Code

AMOUNT

N 15

M

Amount in 2-decimal value

• Example: 1000.00

DISCOUNT

N 15

M

Discount amount (Always 0)

TRANSACTION_FEE

N 15

M

Transaction fee, if needed

COMMISSION_FEE

N 15

M

Service fee charged to Merchant (MDR)

COM_VAT_AMOUNT

N 15

M

Commission Vat Amount (7 % of Commission Fee)

TAX Invoice No

AN 50

M

Tax invoice number which 2C2P issues to merchant on daily settlement

TAX Invoice Date

AN 10

M

Issuance date of tax Invoice (Pay-in date)

• In DD/MM/YYYY format

TAX Invoice COM Amount

N 15

M

Tax Invoice COM Amount from Tax Invoice issued to merchant

TAX Invoice VAT Amount

N 15

M

Tax Invoice VAT Amount from Tax Invoice VAT issued to merchant

TAX Invoice SUM Amount

N 15

M

Tax Invoice Sum Amount = TAX Invoice Com Amount + TAX Invoice VAT Amount

WHT_NO

AN 50

O

WHT Number (Blank)

WHT_AMOUNT

N 15

M

Withholding Tax Amount (3% of ServiceFee)

PAYIN_AMOUNT

N 15

M

Total Payin Amount (Include Refund) (Amount - Commission Fee - COM_VAT_Amount + WHT Amount - EWT Amount)

SHIPPING_FEE

N 15

M

Shipping cost charged by Merchant (Always 0)

CurrencyCode

AN 3

M

ISO 4217 Currency Code

approval_code

AN 10

M

Authorization code from issuing bank

• This field is only applicable when the customer pays with credit or debit card

eci

AN 2

M

ECI value

• This field is only applicable when the customer pays with credit or debit card

masked_pan/Payment Ref Code

AN 20

M / O

(Optional) First 6 and last 4 digits of the credit card.

• Example: 444321XXXXXX3212
• This field is only applicable when the customer pays with credit or debit card