...
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 |
...
Stage 1, place preorder
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 |
|
---|
31927 | vwshop | V0017980 | V0017980AA | V0017980AA-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Telesales | presell | 90 | 0 | 0 | 0 | 0 | 90 | 0 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 84002270 | [NULL] | V0017980 | V0017980AA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 09:45 AM | 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 |
---|
31999 | WorldPay-HC | V0017980-P001 | V0017980-P001-S001 | 2005472820 | 2005489340 | Card | Visa Credit Card | ********1111 | 90 | 31927 | [NULL] | 2005489340 | [NULL] | [NULL] | 11/15/17 09:45 AM |
Stage 2, charge for balance
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 |
---|
31942 | vwshop | V0017988 | V0017988AI | V0017988AI-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 10:00 AM | 0 | 0 |
31941 | vwshop | V0017988 | V0017988AH | V0017988AH-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 10:00 AM | 0 | 0 |
31940 | vwshop | V0017988 | V0017988AG | V0017988AG-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 10:00 AM | 0 | 0 |
31939 | vwshop | V0017988 | V0017988AF | V0017988AF-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 10:00 AM | 0 | 0 |
31938 | vwshop | V0017988 | V0017988AE | V0017988AE-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 10:00 AM | 0 | 0 |
31937 | vwshop | V0017988 | V0017988AD | V0017988AD-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 09:57 AM | 0 | 0 |
31936 | vwshop | V0017988 | V0017988AC | V0017988AC-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 09:57 AM | 0 | 0 |
31935 | vwshop | V0017988 | V0017988AB | V0017988AB-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 09:57 AM | 0 | 0 |
31934 | vwshop | V0017988 | V0017988AA | V0017988AA-D001 | 84002270 | 11/15/17 12:00 AM | 11/15/17 12:00 AM | Subscription | gift | 79.99 | 0 | 0 | 0 | 0 | 79.99 | 13.33 | 66.66 | 7.99 | 7.99 | 1.33 | 0 | 0 | 0 | 84002270 | [NULL] | V0017988 | V0017988AA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/15/17 09:57 AM | 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 |
---|
32019 | WorldPay-HC | V0017980-P002 | V0017980-P002-S008 | 2005499270 | 2005501670 | Card | Visa Credit Card | ********1111 | 79.99 | 31942 | [NULL] | 2005501670 | [NULL] | [NULL] | 11/15/17 10:00 AM |
32018 | WorldPay-HC | V0017980-P002 | V0017980-P002-S007 | 2005499270 | 2005501660 | Card | Visa Credit Card | ********1111 | 79.99 | 31941 | [NULL] | 2005501660 | [NULL] | [NULL] | 11/15/17 10:00 AM |
32017 | WorldPay-HC | V0017980-P002 | V0017980-P002-S006 | 2005499270 | 2005501650 | Card | Visa Credit Card | ********1111 | 79.99 | 31940 | [NULL] | 2005501650 | [NULL] | [NULL] | 11/15/17 10:00 AM |
32016 | WorldPay-HC | V0017980-P002 | V0017980-P002-S005 | 2005499270 | 2005501640 | Card | Visa Credit Card | ********1111 | 79.99 | 31939 | [NULL] | 2005501640 | [NULL] | [NULL] | 11/15/17 10:00 AM |
32015 | WorldPay-HC | V0017980-P002 | V0017980-P002-S004 | 2005499270 | 2005501630 | Card | Visa Credit Card | ********1111 | 79.99 | 31938 | [NULL] | 2005501630 | [NULL] | [NULL] | 11/15/17 10:00 AM |
32014 | WorldPay-HC | V0017980-P002 | V0017980-P002-S003 | 2005499270 | 2005501620 | Card | Visa Credit Card | ********1111 | 79.99 | 31937 | [NULL] | 2005501620 | [NULL] | [NULL] | 11/15/17 09:57 AM |
32013 | WorldPay-HC | V0017980-P002 | V0017980-P002-S002 | 2005499270 | 2005501610 | Card | Visa Credit Card | ********1111 | 79.99 | 31936 | [NULL] | 2005501610 | [NULL] | [NULL] | 11/15/17 09:57 AM |
32012 | Presell | V0017980AA-PO-1 | V0017980AA-PO-1 | [NULL] | [NULL] | Presell | [NULL] | [NULL] | 10.01 | 31935 | [NULL] | [NULL] | [NULL] | [NULL] | 11/15/17 09:57 AM |
32011 | WorldPay-HC | V0017980-P002 | V0017980-P002-S001 | 2005499270 | 2005501600 | Card | Visa Credit Card | ********1111 | 69.98 | 31935 | [NULL] | 2005501600 | [NULL] | [NULL] | 11/15/17 09:57 AM |
32010 | Presell | V0017980AA-PO-1 | V0017980AA-PO-1 | [NULL] | [NULL] | Presell | [NULL] | [NULL] | 79.99 | 31934 | [NULL] | [NULL] | [NULL] | [NULL] | 11/15/17 09:57 AM |
...