Standard refunds
Sales are split into two tables in MantikiFeed.
dbo.refund
id | store_code | sales_order_group_number | sales_order_number | credit_reference_number | customer_number | refund_created_on | entry_created_on | order_type | goods_net_inc_tax | goods_tax | goods_net_ex_tax | delivery_net_inc_tax | delivery_tax | delivery_net_ex_tax | User_Field_1 | User_Field_2 | User_Field_3 | Description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | vwshop | V0010968 | V0010968AA | V0010968AA-C001 | 84000500 | 12/07/17 12:00 AM | 12/07/17 04:27 PM | standard-cp | 107.88 | 17.98 | 89.9 | 0 | 0 | 0 | 84000500 | NULL | V0010968 | V0010968AA |
24 | vwshop | V0010967 | V0010967AA | V0010967AA-C001 | 84000500 | 12/07/17 12:00 AM | 12/07/17 04:27 PM | standard-cp | 95.88 | 15.98 | 79.9 | 0 | 0 | 0 | 84000500 | NULL | V0010967 | V0010967AA |
23 | vwshop | V0010957 | V0010957AA | V0010957AA-C001 | 84000500 | 12/06/17 12:00 AM | 12/07/17 10:56 AM | standard-cp | 125.88 | 20.99 | 104.89 | 0 | 0 | 0 | 84000500 | NULL | V0010957 | V0010957AA |
22 | vwshop | V0010940 | V0010940AA | V0010940AA-C001 | 84000500 | 12/06/17 12:00 AM | 12/07/17 10:56 AM | standard-cp | 95.88 | 15.96 | 79.92 | 0 | 0 | 0 | 84000500 | NULL | V0010940 | V0010940AA |
21 | vwshop | V0010948 | V0010948AA | V0010948AA-C001 | 84000500 | 12/06/17 12:00 AM | 12/06/17 05:58 PM | standard-cp | 95.88 | 16 | 79.88 | 0 | 0 | 0 | 84000500 | NULL | V0010948 | V0010948AA |
dbo.refund_payment
Insert example here
Payment table has these specific rules to follow.
- If the payment method is any of these: "exchange", "wine_bank_interest", "promotional_credit" we do not want to show the payment in the payment table.