Reconcile Report For IPP

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 define 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

Date issue Tax Invoice (Pay-in date), format DD/MM/YYYY

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 (%)

IPP_Amount

N 15

O

Customer IPP Pay per month amount = Amount/Term (For merchant Pay interest)

Pay_INT_By

AN 5

O

Interest is paid by Merchant or Cardholder (M=Merchant, C=Customer)

Term

N 5

O

Payment Term (4, 6, 10 months)

INT_Rate

N 5

O

IPP Interest rate per month

IPP_INT_Amount

N 15

O

IPP Interest all month that merchant absorb = (Amount x INT_Rate x Term/100)

IPP_VAT

N 15

O

IPP VAT Amount = IPP_INT_AMOUNT x 7%

IPP_MDR

N 15

O

IPP MDR Amount = Amount x MDR/100

BANK PROMO CODE

AN 20

O

Bank Promotion Code

BANK PROMO NAME

AN 50

O

Bank Promotion Name

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

1. QR Payment = QR Ref ID