MMS - Settlement Report File

8min

About MMS - Settlement Report FIle 
﻿
﻿﻿ Report File uses by ﻿ to check the ﻿ report in offline mode until specific time. ﻿ Report File obtained by ﻿ the file on MMS - Settlement - Settlement Report﻿ ﻿.
﻿
MMS - Settlement Report File 
﻿
On ﻿ Report ﻿, there are 2 different ﻿s to ﻿ the report file. Those ﻿s are Excel ﻿ and Excel(Details) ﻿ . The file that has been successfully ﻿ from each of the ﻿ contains different format.
﻿
Excel
Settlement Report - Excel
﻿
File that ﻿ed through Excel ﻿ contain ﻿ summary of ﻿ whole ﻿ ﻿. The following table contains explanation related to ﻿ file content.
﻿
Header Name
Header Description
Remark
Brand Name
Name of ﻿ brand that own by ﻿﻿
﻿
I-MID
﻿﻿ ID
﻿
Type
﻿﻿ method type
﻿
Transaction
﻿﻿ ﻿ ﻿﻿
﻿
Transaction.Transaction
Total ﻿ ﻿ on each of ﻿﻿
﻿
Transaction.Amount
Total ﻿ nominal executed on each of ﻿﻿
﻿
Fee
Fee that ﻿ must pay
﻿
Fee.NICEPAY
Transaction calculation on ﻿ side
If the ﻿ type is ﻿ 
NICEPAY.Fee
MDR fee
﻿
NICEPAY.Installment Fee
MDR fee
﻿
NICEPAY.FDS Fee
FDS checking fee
﻿
NICEPAY.VAT
PPN 
11%
NICEPAY.Total
Total fee that ﻿ must pay to ﻿﻿
﻿
Fee.Bank/Mitra.Fee
Mandatory fee paid by ﻿ to ﻿/﻿ 
﻿
Scheduled Settlement Amount
Amount nominal that will be received by ﻿ after ﻿ ﻿﻿
﻿
Scheduled Settlement Amount.From NICEPAY
Transaction calculation from ﻿ side
If the ﻿ type is ﻿﻿
From NICEPAY.Scheduled Settlement Amount
Amount nominal that will be received by ﻿ after ﻿ ﻿﻿
﻿
From NICEPAY.Hold On
Unsettled settlement amount that pending from ﻿ ﻿﻿
Amount total is a minus originate from ﻿ Fee from facilitator ﻿, so ﻿ hold fund as debt and can't ﻿ to ﻿ ﻿ toward ﻿﻿
From NICEPAY.Hold Off
Release ﻿ pending settlement amount on ﻿ next period (Hold On release) occur if ﻿ total ﻿ amount is sufficient
Hold Off will decrease ﻿ total ﻿ Amount (Scheduled)
From NICEPAY.Setoff
Adding or deducting Scheduled ﻿ Amount according to ﻿ resolution of certain issues
Special for ﻿﻿
From NICEPAY.Refund
Amount nominal that going through refund ﻿﻿
﻿
From NICEPAY.Settlement Confirmation Amount
Final amount nominal that will be received by ﻿﻿
﻿
Scheduled Settlement Amount.From Bank/Mitra
Transaction calculation from ﻿/﻿ side
If ﻿ ﻿ type is ﻿﻿
From Bank/Mitra.Settlement Amount
Total final fee that will be received by ﻿ from total ﻿﻿
﻿
﻿
Excel Detail
Settlement Report - Excel(Detail)
﻿
File that ﻿ed through Excel(Details) ﻿ contain the summary of ﻿ whole ﻿ and ﻿ detail from every ﻿ own by ﻿. 
﻿
The following is the table explanation for that part.
Settlement Report - Excel(Detail) - Summary
﻿
Header Name
Header Description
Remark
Brand Name
Name of ﻿ brand that own by ﻿﻿
﻿
I-MID
﻿﻿ ID
﻿
Type
﻿﻿ method type
﻿
From NICEPAY
Transaction calculation from ﻿ side
If the ﻿ type is ﻿﻿
From NICEPAY.Transaction
﻿﻿ ﻿ ﻿﻿
﻿
Transaction.Number
Total ﻿ done on each of ﻿﻿
﻿
Transaction.Amount
Total ﻿ nominal executed on each of ﻿﻿
﻿
From NICEPAY.Fee
Fee that ﻿ must pay to ﻿﻿
﻿
Fee.Full Payment
MDR fee
﻿
Fee.Installment
MDR fee
﻿
Fee.NICEPAY
MDR fee
﻿
Fee.VAT
PPN 
11%
Fee.Total
Total fee that ﻿ must pay to ﻿﻿
﻿
From NICEPAY.Settlement Amount(Scheduled)
Amount nominal that will ﻿ through ﻿ ﻿﻿
﻿
Settlement Amount(Scheduled).Scheduled Amount
Amount nominal that will be received by ﻿ after ﻿ ﻿﻿
﻿
Settlement Amount(Scheduled).Hold On
Unsettled settlement amount that pending from ﻿ ﻿﻿
Amount total is a minus originate from ﻿ Fee from ﻿ ﻿, so the hold fund as debt and can't ﻿ to ﻿ ﻿ toward ﻿﻿
Settlement Amount(Scheduled).Hold Off
Release ﻿ pending settlement amount on ﻿ next period (Hold On release) occur if ﻿ total ﻿ amount is sufficient
Hold Off will decrease ﻿ total ﻿ Amount (Scheduled)
Settlement Amount(Scheduled).Setoff
Adding or deducting ﻿ Amount (Scheduled) according to ﻿ resolution of certain issues
Special for ﻿﻿
Settlement Amount(Scheduled).Refund
Amount nominal that going through refund ﻿﻿
﻿
From NICEPAY.Settlement Amount(Scheduled)
Final amount nominal that will be received by ﻿﻿
﻿
From Bank/Mitra
Transaction calculation from ﻿/﻿﻿
If the ﻿ type is ﻿﻿
From Bank/Mitra.Transaction
Information detail related to on-going ﻿ ﻿﻿
﻿
Transaction.Transaction
Total on-going ﻿s ﻿﻿
﻿
Transaction.Amount
Total ﻿ amount paid by ﻿﻿
﻿
From Bank/Mitra.Fee
Fee that ﻿ must paid to ﻿﻿
﻿
Fee.Full Payment
MDR fee
﻿
Fee.Installment (Onus)
MDR fee
﻿
Fee.Installment (Offus)
MDR fee
﻿
From Bank/Mitra.Settlement Amount
Total final fee that will be received by ﻿ from total ﻿﻿
﻿
Settlement Report - Excel(Detail) - Each Transaction Detail
﻿
The following table contains explanation related to the detail transaction.
Header Name
Header Description
Remark
Date
Data collection on specific process
﻿
Date.Settlement
Transaction date through ﻿ ﻿﻿
﻿
Date.Approved
Transaction approval date
﻿
Date.Purchase
Goods purchase date
﻿
Date.Cancelled
Transaction cancelled date
﻿
Merchant Information
Collection of ﻿ ﻿ on a ﻿ ﻿﻿
﻿
Merchant Information.Brand Name
Name of {{th}} brand that own by ﻿﻿
﻿
Merchant Information.I-MID
﻿﻿ ID
﻿
Type
Collection of type on a ﻿ ﻿﻿
﻿
Type.Settlement
﻿﻿ ﻿ type
﻿
Type.Payment Method
﻿﻿ method on a ﻿ 
MA - ﻿ 
PG - ﻿/Direct
Type.Status
Transaction ﻿﻿
﻿
Type.Month
To acknowledge the month of occur ﻿ until ﻿ is successful
﻿
From NICEPAY
Transaction calculation from ﻿ side
If ﻿ type is ﻿﻿
From NICEPAY.Transaction
Transaction ﻿s by User from ﻿ side
﻿
Transaction.Amount
Amount nominal paid by User from ﻿ side on a ﻿ detail
Amount ﻿ that have been deducted with Fee ﻿ and tax 11%
From NICEPAY.Fee
Fee that ﻿ must paid to ﻿﻿
﻿
Fee.Full Payment
﻿﻿ ﻿ channel fee on the ﻿﻿
﻿
Fee.Installment
MDR fee
﻿
Fee.NICEPAY
MDR fee
﻿
Fee.VAT
PPN 
11%
Fee.Total
Total fee that ﻿ must paid to ﻿﻿
﻿
From NICEPAY.Settlement
Amount ﻿ that will going through ﻿ ﻿﻿
﻿
Settlement.Amount
Amount ﻿ had been deduct with Fee ﻿ and {{tax}} 11%
﻿
From Bank/Mitra
﻿﻿ ﻿ calculation from ﻿/﻿ side
If ﻿ type is ﻿﻿
From Bank/Mitra.Transaction
Transaction ﻿s by user from ﻿ side
﻿
Transaction.Amount
Amount nominal that must User paid from ﻿ side on a ﻿ detail
﻿
From Bank/MitraFee
Fee that ﻿ must paid to ﻿﻿
﻿
Fee.Full Payment
﻿﻿ fee
﻿
Fee.Installment (Onus)
﻿﻿ fee
﻿
Fee.Installment (Offus)
{﻿ fee
﻿
From Bank/Mitra.Settlement
Amount ﻿ that will going through ﻿ ﻿﻿
﻿
Settlement.Amount
Amount nominal that ﻿ will received
﻿
Bank/Mitra Type
﻿﻿/﻿ type used on the ﻿﻿
﻿
Bank/Mitra Type.Acquire
Name of ﻿/﻿ used on the ﻿﻿
﻿
Bank/Mitra Type.Issuer
Name of ﻿/﻿ used on the ﻿﻿
Specific for ﻿ ﻿﻿
Approval Code/Account No
Account number/approval code from an on-going ﻿ detail
﻿
Order Number
Number of on-going order ﻿﻿
﻿
Buyer
User name that execute the ﻿﻿
﻿
Product Name
Product name from ﻿ data
﻿
TID
Transaction ID 
﻿
Batch No
Batch number to identify ﻿ ﻿ that going through batch ﻿﻿
﻿

Header Name	Header Description	Remark
Brand Name	Name of brand that own by
I-MID	ID
Type	method type
Transaction
Transaction.Transaction	Total on each of
Transaction.Amount	Total nominal executed on each of
Fee	Fee that must pay
Fee.NICEPAY	Transaction calculation on side	If the type is
NICEPAY.Fee	MDR fee
NICEPAY.Installment Fee	MDR fee
NICEPAY.FDS Fee	FDS checking fee
NICEPAY.VAT	PPN	11%
NICEPAY.Total	Total fee that must pay to
Fee.Bank/Mitra.Fee	Mandatory fee paid by to /
Scheduled Settlement Amount	Amount nominal that will be received by after
Scheduled Settlement Amount.From NICEPAY	Transaction calculation from side	If the type is
From NICEPAY.Scheduled Settlement Amount	Amount nominal that will be received by after
From NICEPAY.Hold On	Unsettled settlement amount that pending from	Amount total is a minus originate from Fee from facilitator , so hold fund as debt and can't to toward
From NICEPAY.Hold Off	Release pending settlement amount on next period (Hold On release) occur if total amount is sufficient	Hold Off will decrease total Amount (Scheduled)
From NICEPAY.Setoff	Adding or deducting Scheduled Amount according to resolution of certain issues	Special for
From NICEPAY.Refund	Amount nominal that going through refund
From NICEPAY.Settlement Confirmation Amount	Final amount nominal that will be received by
Scheduled Settlement Amount.From Bank/Mitra	Transaction calculation from / side	If type is
From Bank/Mitra.Settlement Amount	Total final fee that will be received by from total

Header Name	Header Description	Remark
Brand Name	Name of brand that own by
I-MID	ID
Type	method type
From NICEPAY	Transaction calculation from side	If the type is
From NICEPAY.Transaction
Transaction.Number	Total done on each of
Transaction.Amount	Total nominal executed on each of
From NICEPAY.Fee	Fee that must pay to
Fee.Full Payment	MDR fee
Fee.Installment	MDR fee
Fee.NICEPAY	MDR fee
Fee.VAT	PPN	11%
Fee.Total	Total fee that must pay to
From NICEPAY.Settlement Amount(Scheduled)	Amount nominal that will through
Settlement Amount(Scheduled).Scheduled Amount	Amount nominal that will be received by after
Settlement Amount(Scheduled).Hold On	Unsettled settlement amount that pending from	Amount total is a minus originate from Fee from , so the hold fund as debt and can't to toward
Settlement Amount(Scheduled).Hold Off	Release pending settlement amount on next period (Hold On release) occur if total amount is sufficient	Hold Off will decrease total Amount (Scheduled)
Settlement Amount(Scheduled).Setoff	Adding or deducting Amount (Scheduled) according to resolution of certain issues	Special for
Settlement Amount(Scheduled).Refund	Amount nominal that going through refund
From NICEPAY.Settlement Amount(Scheduled)	Final amount nominal that will be received by
From Bank/Mitra	Transaction calculation from /	If the type is
From Bank/Mitra.Transaction	Information detail related to on-going
Transaction.Transaction	Total on-going s
Transaction.Amount	Total amount paid by
From Bank/Mitra.Fee	Fee that must paid to
Fee.Full Payment	MDR fee
Fee.Installment (Onus)	MDR fee
Fee.Installment (Offus)	MDR fee
From Bank/Mitra.Settlement Amount	Total final fee that will be received by from total

Header Name	Header Description	Remark
Date	Data collection on specific process
Date.Settlement	Transaction date through
Date.Approved	Transaction approval date
Date.Purchase	Goods purchase date
Date.Cancelled	Transaction cancelled date
Merchant Information	Collection of on a
Merchant Information.Brand Name	Name of {{th}} brand that own by
Merchant Information.I-MID	ID
Type	Collection of type on a
Type.Settlement	type
Type.Payment Method	method on a	MA - PG - /Direct
Type.Status	Transaction
Type.Month	To acknowledge the month of occur until is successful
From NICEPAY	Transaction calculation from side	If type is
From NICEPAY.Transaction	Transaction s by User from side
Transaction.Amount	Amount nominal paid by User from side on a detail	Amount that have been deducted with Fee and tax 11%
From NICEPAY.Fee	Fee that must paid to
Fee.Full Payment	channel fee on the
Fee.Installment	MDR fee
Fee.NICEPAY	MDR fee
Fee.VAT	PPN	11%
Fee.Total	Total fee that must paid to
From NICEPAY.Settlement	Amount that will going through
Settlement.Amount	Amount had been deduct with Fee and {{tax}} 11%
From Bank/Mitra	calculation from / side	If type is
From Bank/Mitra.Transaction	Transaction s by user from side
Transaction.Amount	Amount nominal that must User paid from side on a detail
From Bank/MitraFee	Fee that must paid to
Fee.Full Payment	fee
Fee.Installment (Onus)	fee
Fee.Installment (Offus)	{ fee
From Bank/Mitra.Settlement	Amount that will going through
Settlement.Amount	Amount nominal that will received
Bank/Mitra Type	/ type used on the
Bank/Mitra Type.Acquire	Name of / used on the
Bank/Mitra Type.Issuer	Name of / used on the	Specific for
Approval Code/Account No	Account number/approval code from an on-going detail
Order Number	Number of on-going order
Buyer	User name that execute the
Product Name	Product name from data
TID	Transaction ID
Batch No	Batch number to identify that going through batch

Term List on Report File

MMS - File Fail Transaction Report

MMS - Settlement Report File

About MMS - Settlement Report FIle

MMS - Settlement Report File

Excel

Excel Detail

Welcome to NICEPAY DOCS