Micros 3700 how to get gift cards from dsvc_def database table?

[Harry_]

Hello,

Does anyone know how to get Gift Cards (gift card sales) from dsvc_def (Discount/Service Charge) table?

In Micros 3700 it's common when users create gift cards in that table, but what is the right way to differentiate gift cards from service charges when getting data?

There is a field called TYPE - which has D for discount and S for service charge. Also it has a filed called ob_svc04_add_to_tip_svc_chg which shows if a service charge is autograt or not. But nothing that can help to see what are the actual gift cards when looking from the database.

Thanks

 

[CathalMF]

Sales data are stored in _dtl tables.
The _def tables are for configuration.

The table you want is dsvc_dtl

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website

http://www.microspostools.com/

 

[Harry_]

Hey CathalMF,

Thanks a lot for your fast response.

You are correct, but what is the flag that indicates if the item is a service charge of a gift card?

 

[CathalMF]

There is no "gift card" type. It's just a service charge.

Your gift card system will have configuration for which service charge is used for gift cards.

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website

http://www.microspostools.com/

 

[Wildbar]

Gift cards should be sold as menu items. Not put thru as discounts.
Sales should credit an accounting account "gift card liability"
Gift cards that are redeemed should be redeemed to a tender that is then debited to the "gift card liability' account.
If there is a service charge or grat you would pick that up from the over payment of the amount due to the tender, which you would link to grats payable.

 

[POSKitchen]

Hi Harry,

They must use different ServiceCharges then you can query the Number of the Service Charge.

select * from micros.dsvc_def and query/join through the micros.trans_dtl micros.chk_dtl to find the line of the transaction and the service charge obj_number.



Micros use a Service Charge to sell and Cash in the amount from the Customer because of the handling of the taxes. In Europe is this the normal use, sell a gift card with 100.- and pay with credit card.
The Gift cards are normally from a third part system where the number and amount is stored, because Micros has no comfortable Gift Card System, ok u can use gss but......

In this table you find never ever all Gift Card Details because of the Purging of the 3700. Tracking Totals max. 999 and other details like Discounts, Check Details 14 Days.
If they not put any Number of the GiftCard in the selling process you will never have the number of the gift card.
If they enter the gift card as a Reference then it is better to query the Journal txt files for the Numbers.


but other story
What you would like to achieve with ?

Best Regard
Andi