TransactionID	TransactionType	Date		Remarks	CustomerID	POSID	EmployeeID	PayModeID	TaxID	TotalTax	TotalDiscount	TotalAmount	AmountPaid	ReferenceDocumentNumber	commission	Royalty		TaxExempt	DiscountReasonID	DiscountAmount	TransactionNumber	RefundReasonID	comments	Savings	ExchangeTransaction	loyalty_method	point

18		2		1534351241	Refund	\N		31	2		1		\N	-1.43		0		-16.43		0		2018/1/31/41		0		0		0		\N			0		2018/2/31/18		\N		\N		0	\N			\N		\N

19		2		1534351469	Refund	\N		31	2		1		\N	-0.14		0		1.63		0		0			0		0				\N			0		2018/2/31/19		\N		\N		0	\N			\N		\N



ItemID	Quantity	Rate	DiscountID	TaxID	Remarks		TransactionNumber	Discount	Tax	ItemSrl		CoupanID	CoupanAmt	UnitCost	Savings		TaxRate1	TaxRate2	MSIB

0	1		15	0		1	Refund		2018/2/31/18		0		-1.43	1		\N		0		0		0		-1.43		0		0

1010	1		1.49	0		1	Refund		2018/2/31/19		0		-0.14	1		\N		0		0.75		0		-0.14		0		0



PaymodeID	Amount		ReferenceNumber	AuthCode	CardNumber	TransactionNumber	CheckValidated	cardtype	srlnumber

1		-16.43						2018/2/31/18	1			0

1		-1.63						2018/2/31/19	1			0