Merchant Back Office
Term List on Report File

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
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)
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
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
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 the brand that own by 



Merchant Information.I-MID

 ID



Type

Collection of type on a 



Type.Settlement

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