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

user_defined_1

AN 150

O

Reference number, booking number, tracking number or order number for merchant use.

user_defined_2

AN 150

O

Reference number, booking number, tracking number or order number for merchant use.

user_defined_3

AN 150

O

Reference number, booking number, tracking number or order number for merchant

user_defined_4

AN 150

O

Reference number, booking number, tracking number or order number for merchant use.

user_defined_5

AN 150

O

Reference number, booking number, tracking number or order number for merchant use.

MDR

N 5

M

Full Payment MDR in percentage (%)

refund_note

AN 250

O

Refund / Chargeback notes

Issuer country

AN 3

O

Card Issuer Country

CARD_BRAND

AN 30

O

Refer to

Payment Channel Matrix Table

TxnID

N 10

O

Txn ID in PGW and 123

Merchant_Name

AN 300

O

Merchant's name in 2C2P records

Ref ID

AN 20

O

QR Payment = QR Ref ID

Cardholder name

AN 150

O

Cardholder's name

Product Description

AN 250

O

Product description

Promotion Code

AN 50

O

Merchant's Promotion Code

Acquirer Discount

N 15

O

Discount given to cardholder by acquirer

Acquirer Discount Currency

AN 3

O

Currency of Discount given to cardholder by acquirer

MCP Amount

N 15

O

Cardholder's paid amount

MCP Currency

AN 3

O

Cardholder's paid currency

MCP Exchange Rate

N 15

O

Cardholder's paid currency to merchant currency

EWT Amount

N 15

O

EWT Amount if applicable

Custom Data 1

AN 150

O

Custom dataset from 2C2P

Custom Data 2

AN 150

O

Custom dataset from 2C2P

Redeemed Points

N 15

O

Redeemed points

Redeemed Points Amount

N 15

O

Points amount

Redeemed Voucher Name

AN 50

O

Voucher code redeemed

Redeemed Voucher Quantity

N 15

O

Number of vouchers redeemed

Redeemed Voucher Amount

N 15

O

Total redeemed voucher amount