Temporary Tables In Mantiki (process_extract tables)
Sales are split into two temporary tables in Mantiki.
process_extract_dream_shipment
process_extract_dream_shipment_payment
MantikiFeed
Standard sales
Sales are split into two tables in MantikiFeed.
dbo.sales
id | store_code | sales_order_group_number | sales_order_number | shipment_reference_number | customer_number | order_created_on | order_shipped_on | sales_channel | order_type | goods_gross_inc_tax | goods_discount_inc_tax | goods_discount_tax | winebank_interest_inc_tax | winebank_interest_tax | goods_net_inc_tax | goods_tax | goods_net_ex_tax | delivery_gross_inc_tax | delivery_discount_inc_tax | delivery_discount_tax | delivery_net_inc_tax | delivery_tax | delivery_net_ex_tax | User_Field_1 | User_Field_2 | User_Field_3 | Description | promotion_goods_discount | agent_goods_discount_tax | payment_promotional_credit | payment_promotional_credit_tax | promotion_shipping_discount | promotion_shipping_discount_tax | agent_shipping_discount | agent_shipping_discount_tax | entry_created_on | promotion_goods_discount_tax | agent_goods_discount |
31896 | vwshop | V0017798 | V0017798AA | V0017798AA-D001 | 84002060 | 11/10/17 12:00 AM | 11/13/17 12:00 AM | Subscription | standard | 101.88 | 0 | 0 | 0 | 0 | 101.88 | 16.98 | 84.9 | 7.99 | 0 | 0 | 7.99 | 1.33 | 6.66 | 84002060 | [NULL] | V0017798 | V0017798AA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/13/17 03:22 PM | 0 | 0 |
dbo.sales_payment
id | payment_gateway | authorisation_transaction_id | settlement_transaction_id | gateway_authorisation_transaction_id | gateway_settlement_transaction_id | payment_method | card_type | card_number | amount | sales_id | User_Field_1 | User_Field_2 | User_Field_3 | Description | entry_created_on |
31960 | WorldPay-HC | V0017798-P001 | V0017798-P001-S001 | 2002616180 | 2004506280 | Card | Visa Credit Card | ********1111 | 109.87 | 31896 | [NULL] | 2004506280 | [NULL] | [NULL] | 11/13/17 03:22 PM |
...