Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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

idstore_codesales_order_group_numbersales_order_numbershipment_reference_numbercustomer_numberorder_created_onorder_shipped_onsales_channelorder_typegoods_gross_inc_taxgoods_discount_inc_taxgoods_discount_taxwinebank_interest_inc_taxwinebank_interest_taxgoods_net_inc_taxgoods_taxgoods_net_ex_taxdelivery_gross_inc_taxdelivery_discount_inc_taxdelivery_discount_taxdelivery_net_inc_taxdelivery_taxdelivery_net_ex_taxUser_Field_1User_Field_2User_Field_3Descriptionpromotion_goods_discountagent_goods_discount_taxpayment_promotional_creditpayment_promotional_credit_taxpromotion_shipping_discountpromotion_shipping_discount_taxagent_shipping_discountagent_shipping_discount_taxentry_created_onpromotion_goods_discount_taxagent_goods_discount
31896vwshopV0017798V0017798AAV0017798AA-D0018400206011/10/17 12:00 AM11/13/17 12:00 AMSubscriptionstandard101.880000101.8816.9884.97.99007.991.336.6684002060[NULL]V0017798V0017798AA0000000011/13/17 03:22 PM00

dbo.sales_payment

idpayment_gatewayauthorisation_transaction_idsettlement_transaction_idgateway_authorisation_transaction_idgateway_settlement_transaction_idpayment_methodcard_typecard_numberamountsales_idUser_Field_1User_Field_2User_Field_3Descriptionentry_created_on
31960WorldPay-HCV0017798-P001V0017798-P001-S00120026161802004506280CardVisa Credit Card********1111109.8731896[NULL]2004506280[NULL][NULL]11/13/17 03:22 PM


Preorders

Preorders have some specific rules to follow.

  1. The dbo.sales_payment table must include both the initial payment of the deposit as an entry for eg £12 and upon redemption of the balance, there must be a second entry for the deposit as it is used as part payment for the balance.
  2. Where multiple items are preordered, the deposit should be credited all against the first item alphabetically, not spread evenly over the balance items:- ie the order with the suffix AA has all of the deposit credited against it.  Where the deposit paid is greater than the value of the balance of the first item, only the value of the first item is used from the pool of the deposit and the remainder is credited against the next alphabetical item and so on.


  • No labels