MMS - Settlement Report File

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 docid\ qwf7ijf4rnamk4spifoy1 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 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 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 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 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