Home > Technical > Table Definitions > DYNAPOSPROFILE

DYNAPOSPROFILE

These records store basic configuration details for DynaPOSTouch tills. Multiple tills can share the same profile making configuration easier.

Column

Type

Description

CTRCODE

INT

A unique number assigned by the system.

STRDESCRIPTION

VARCHAR(50)

A description about the profile.

YSNKEEPFASTKEYVISIBLE

VARCHAR(1)

'T' if the fastkey panel should be kept visible after an item has been selected from it.

YSNPRINTRECEIPT

VARCHAR(1)

'T' if a receipt should be printed at this till.

YSNAUTOPAYMENTAMT

VARCHAR(1)

If 'T' then when the payment button is pressed, it will attempt to autopay the transaction using the tender assigned to INTAUTOPAYTENDER.

YSNSHOWHIGHLIGHT

VARCHAR(1)

No longer used.

YSNPASSWORDCASHDRAWER

VARCHAR(1)

No longer used.

YSNASKCUSTOMER

VARCHAR(1)

No longer used.

YSNRETURNSHOWSELLOPTIONS

VARCHAR(1)

There are up to five sell prices for each item. If 'T',  show these sell price options when an item is returned.

YSNRETURNASKPRICE

VARCHAR(1)

'T' if DynaPOSTouch should ask for the sell price when an item is returned.

YSNGETPRICEIFZERO

VARCHAR(1)

If 'T' then if the sell price is zero, DynaPOSTouch will ask for the user for a sell price.

YSNMODIFYITEMEXCHANGE

VARCHAR(1)

T' if the Exchange Item option should be displayed to the user.

YSNCHECKPASSWORDASUSER

VARCHAR(1)

If 'T' then when an operator code is entered and it is not a valid code, the system will check if this is the password of a user. If it is then use that user code.

YSNORDERSAVEDSALES

VARCHAR(1)

If 'T' then when a sale is saved, the system can ask the user if the item should be back ordered. Not longer used.

YSNTILLREADTORECEIPT

VARCHAR(1)

If 'T' then till reads are printed to attached receipt printers.

DBLMAXNUMBER

DECIMAL(19,4)

The maximum number that can be entered by a user.

STRTABLECAPTION

VARCHAR(15)

The word you want to display to the user instead of 'Table'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.

STRMEMBERCAPTION

VARCHAR(15)

The word you want to display to the user instead of 'Member'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.

STRAUTOSPLITDEPTS

VARCHAR(100)

No longer used

STRAVONBILLINGCREDITITEMS

VARCHAR(100)

No longer used

STRAVONBILLINGCHARGEITEMS

VARCHAR(100)

No longer used

INTBOOTH

INT

No currently used.

INTDEFAULTFASTKEY

INT

No longer used.

INTSECNOSALE

INT

No longer used. See POSSECURITY.

INTSECRETURN

INT

No longer used. See POSSECURITY.

INTSECREFUND

INT

No longer used. See POSSECURITY.

INTSECCASHONCARD

INT

No longer used. See POSSECURITY.

INTSECMEMBERPTS

INT

No longer used. See POSSECURITY.

INTSECCHGQTY

INT

No longer used. See POSSECURITY.

INTSECCHGPRICE

INT

No longer used. See POSSECURITY.

INTSECEXCHANGE

INT

No longer used. See POSSECURITY.

INTSECDISCOUNTS

INT

No longer used. See POSSECURITY.

YSNCHECKORDERCODEFIRST

VARCHAR(1)

If 'T' then DynaPOSTouch will check the 'APN' number against the order code first. If it is not found then it will try to match against the APN.

YSNSHOWKEYBOARD

VARCHAR(1)

If 'T' a popup touch keyboard will appear on appropriate forms in DynaPOS.

YSNAUTOHELPMEMBER

VARCHAR(1)

If 'T' then when the user presses the Member button it will go straight to the search form rather than just ask for the card number.

YSNPRINTA4RECEIPT

VARCHAR(1)

If 'T' then DynaPOSTouch will print an A4 receipt if the sale value is greater than curMinReceiptAmt.

YSNAUTOLOGOFF

VARCHAR(1)

If 'T' then DynaPOSTouch will automatically log off after completion of a transaction.

YSNASKSALENOTE

VARCHAR(1)

If 'T' then DynaPOSTouch will ask for a comment about the transaction when it is completed.

YSNALLOWUNKNOWNMEMBER

VARCHAR(1)

No longer used.

CURMINRECEIPTAMT

DECIMAL(19,4)

No longer used.

YSNPOINTSONRECEIPT

VARCHAR(1)

If 'T' then customer's points will be printed on the receipt.

YSNBALANCEONRECEIPT

VARCHAR(1)

If' T' then customer's account balances will be printed on the receipt.

YSNASKSELLPRICE

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will force the user to select the sell price to use.

YSNASKDELIVERY

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will ask for delivery address details at the end of a transaction.

YSNORDERCODEONRECEIPT

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will print the item's order code on the receipt.

YSNASKRECEIPT

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will ask whether it should print a receipt or an invoice.

YSNPRINTTICKETS

VARCHAR(1)

If 'T' then a 'ticket' will be printed for each item in the transaction. Used in nightclubs. Not currently used.

YSNASKSAVEID

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will ask for the save id when the transaction starts.

YSNASKCOVER

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will ask for the number of covers (people)  when the transaction starts.

YSNASKFORTIP

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will ask for a tip on the sale. Not currently used.

YSNASKFORCUSTOMERONRETURN

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will ask for customer details on a return transaction.

YSNASKFORCUSTOMERONPOSCREDIT

VARCHAR(1)

If 'T' then DynaPOSTouch.exe will ask for customer details whenever a credit note is sold.

YSNPRINTMISCTORECEIPT

VARCHAR(1)

Used by DynaPOSTouch.exe. If 'T' then miscellaneous transactions like account payments, till adjustments will print to the receipt printer. If 'F' will print on A4 invoice.

YSNSHOWBUTTONHELP

VARCHAR(1)

If 'T' then the keys required to 'press' a button in DynaPOSTouch will be printed just underneath the button's main caption, for example Ctrl+F1. This is useful if using the system without a Touchscreen. Usually 'F'.

INTSECTAX

INT

No longer used. See POSSECURITY.

YSNPRINTAPNONRECEIPT

VARCHAR(1)

If 'T' then the EAN/UPC/PLU used to scan the item will be printed on the receipt.

YSNWARNIFNOMEMBER

VARCHAR(1)

No longer used.

YSNRECORDDATETIMEPERITEM

VARCHAR(1)

If 'T' then the actual time that an item was added to a transaction will be recorded. If 'F' (default), the date time the sale was completed or first held will be recorded against the entire transaction. This is useful in a restaurant situation where you might want to see the length a transaction took.

YSNASKFOROPERATOR

VARCHAR(1)

If 'T', DynaPOSTouch will ask for the operator who actually sold the item. It will do this each time an item is added to a sale. 'F' is default. 

YSNCHECKSAVEID

VARCHAR(1)

If 'T' the system will check to see if a held sale with the same save ID already exists. If it does, that transaction will be automatically retrieved. This is useful in a restaurant where the save ID is the table number.

CURCUSTOMERREQAMT

DECIMAL(19,4)

If a DynaPOSTouch sale is more than this amount, a customer must be entered for the transaction.

CURLAYBYMINDOLLAR

DECIMAL(19,4)

The minimum deposit required for a layby, expressed in dollars.

CURLAYBYMINPER

DECIMAL(19,4)

The minimum deposit required for a layby, expressed as a percentage of the total sale.

CURORDERMINDOLLAR

DECIMAL(19,4)

The minimum deposit required for an order, expressed in dollars.

CURORDERMINPER

DECIMAL(19,4)

The minimum deposit required for an order, expressed as a percentage of the total sale.

MEMINVOICEMESSAGE

TEXT

The message to be printed at the bottom of a DynaPOSTouch Invoice.

MEMORDERMESSAGE

TEXT

The message to be printed at the bottom of a DynaPOSTouch Order.

MEMLAYBYMESSAGE

TEXT

The message to be printed at the bottom of a DynaPOSTouch Layby.

MEMJOBSHEETMESSAGE

TEXT

The message to be printed at the bottom of a DynaPOSTouch Service Jobsheet.

MEMQUOTEMESSAGE

TEXT

The message to be printed at the bottom of a DynaPOSTouch Quote.

INTSECCLOCKIN

INT

No longer used. See POSSECURITY.

INTSECTRANSFER

INT

No longer used. See POSSECURITY.

INTSECSTOCKADJ

INT

No longer used. See POSSECURITY.

YSNPRINTCANCELLEDSALES

VARCHAR(1)

If 'T' then a receipt will be printed for cancelled sales. Set to 'F' for no receipt.

YSNASKCUSTOMERATSTART

VARCHAR(1)

If 'T' then DynaPOSTouch will ask for customer number at the start of the sale.

YSNASKOPERATORATSTART

VARCHAR(1)

If 'T' then DynaPOSTouch will ask for the salesperson (the operator who sold the actual items) at the start of the sale.

INTSURVEYTYPE

INT

The code of the survey to be asked at the POS.
SURVEYHDR.ctrCode

INTRECEIPTFORMAT

INT

Controls the format of the items printed on the receipt.

1  

Basic

2  

Basic + Unit Sell Price

3  

Nett Price

4  

Basic + Discounts

5  

Basic + Discounts + Unit Sell Price

6  

Taiwan Basic

7  

China Basic

INTDATASOURCEITEMS INT No longer used. Should be 0
INTDATASOURCECUSTS INT

Indicates where POS will get customer data from. 0= POS BE. 4=Genting Casinos (via their DLL)

YSNASKCUSTOMERREFERENCE VARCHAR(1) If 'T' DynaPOSTouch will ask for a customer reference, for example PO number at the start of every sale.
INTSECCANCELSALE INT No longer used. See POSSECURITY.
INTSECLAYBY INT No longer used. See POSSECURITY.
INTSECCOD INT No longer used. See POSSECURITY.
INTSECORDER INT No longer used. See POSSECURITY.
INTSECQUOTE INT No longer used. See POSSECURITY.
INTSECLOSTSALE INT No longer used. See POSSECURITY.
INTSECSERVICE INT No longer used. See POSSECURITY.
YSNAUTOGENGIFT VARCHAR(1) 'T' if DynaPOSTouch should automatically generate a number for a gift certificate. If 'F', user will need to enter a gift certificate number.
YSNAUTOGENCN VARCHAR(1) 'T' if DynaPOSTouch should automatically generate a number for a credit note. If 'F', user will need to enter a credit note number.
YSNASKFORCUSTOMERONGIFTCERT VARCHAR(1) If 'T' then DynaPOSTouch.exe will ask for customer details whenever a gift certificate is sold.
STRRECALLTRADECODE VARCHAR(10) The location that a till can recall transactions for. If left empty, can see all held transactions. Can be a location group in which case till can see any held transaction within the group.
TRADUNIT.strTradeCode
INTSECCUSTNEW INT No longer used. See POSSECURITY.
INTSECCUSTCHG INT No longer used. See POSSECURITY.
INTSECCUSTVIEW INT No longer used. See POSSECURITY.
STRBRANDCAPTION VARCHAR(20) The word you want to display to the user instead of 'Brand'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.
STRPRODUCTCAPTION VARCHAR(20) The word you want to display to the user instead of 'Description'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.
STRVARIETYCAPTION VARCHAR(20) The word you want to display to the user instead of 'Variety'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.
STRSIZECAPTION VARCHAR(20) The word you want to display to the user instead of 'Size'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.
YSNFIRECASHDRAWERTILLREAD VARCHAR(1) Not currently used.
YSNASKORDERREQUIREDBYDATE VARCHAR(1) 'T' if a required by date should be entered for an order. Default to 'T'
YSNGIFTCERTCHGASCN VARCHAR(1) Not currently used
YSNSAMECUSTASUSER VARCHAR(1) 'T' if a user is allowed to use a customer which is the same card number as their user number (potentially a customer set up for them to do discounts for themselves). Defaults to 'T' 
YSNASKSIGSALE VARCHAR(1) 'T' if a signature should be asked for on sale transactions, 'F' otherwise. Defaults to 'F'
YSNASKSIGRETURN VARCHAR(1) 'T' if a signature should be asked for on return transactions, 'F' otherwise. Defaults to 'F'
YSNASKSIGEXCHANGE VARCHAR(1) 'T' if a signature should be asked for on exchange transactions, 'F' otherwise. Defaults to 'F'
YSNASKSIGACPAY VARCHAR(1) 'T' if a signature should be asked for on account payments, 'F' otherwise. Defaults to 'F'
STRSIGNATURE VARCHAR(200) The message to be displayed on the receipt when a signature is required
INTEXTRASIGRECEIPTS INT The number of extra receipts to be printed when signature is required on a receipt.
STRORDERCAPTION VARCHAR(20) The word you want to display to the user instead of 'Order'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.
INTSECCOGS INT No longer used. See POSSECURITY.
INTTIMEOUT INT No longer used.
INTDATASOURCEGIFTCERTS INT Not currently used.
INTSECCOSTINPOS INT No longer used. See POSSECURITY.
INTSECABUSEDSTOCK INT No longer used. See POSSECURITY.
YSNHIDECUSTADDRESSDETAILS VARCHAR(1) If 'T' you will not see customer details in the customer search results. If 'F' you will see the details.
YSNPAIDORDERTAXINVOICE VARCHAR(1) If 'T' you will get a tax invoice as soon as a customer order has been paid in full. If 'F' the tax invoice will be produced when the goods are released.
YSNPROMOONRECEIPT VARCHAR(1) If 'T' and the item being sold is on promotion, the word 'Promotion' will be printed under the item on the receipt.  ???
INTSECCUSTACCOUNT INT No longer used. See POSSECURITY.
YSNAUTOTABLETICKET VARCHAR(1) If 'T' then the system will generate a table number which can be printed on a receipt.
STRSUPPLIERCAPTION VARCHAR(20) The word you want to display to the user instead of 'Supplier'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.
STRMANUFACTURERCAPTION VARCHAR(20) The word you want to display to the user instead of 'Manufacturer'. Although the field is still used, it cannot be entered via the Till maintenance screen. You can (and should) use the standard language facilities to do translations.
INTAUTOLOGOFFTIMEOUT INT The number of seconds of inactivity allowed before the user will be logged off POS. If set to zero, no timeout occurs.
YSNASKFORORDERMETHOD VARCHAR(1) If 'T' and a customer order is taken, POS will ask the user how the goods will be obtained.
INTSECORDERMETHODTFR INT No longer used. See POSSECURITY.
INTSECORDERMETHODPO INT No longer used. See POSSECURITY.
INTSECORDERMETHODHO INT No longer used. See POSSECURITY.
YSNASKSIGORDER VARCHAR(1) If 'T' the POS will ask for a signature on the receipt for a customer order.
YSNASKSIGCOD VARCHAR(1) If 'T' the POS will ask for a signature on the receipt for a COD
YSNASKSIGLAYBY VARCHAR(1) If 'T' the POS will ask for a signature on the receipt for a layby.
YSNASKSIGQUOTE VARCHAR(1) If 'T' the POS will ask for a signature on the receipt for a quote.
YSNPRINTGIFTCERT VARCHAR(1) If 'T' the POS will print a gift certificate on the receipt printer for each gift certificate sold in the transaction.
YSNPRINTCREDITNOTE VARCHAR(1) If 'T' the POS will print a credit note on the receipt printer for each credit note sold in the transaction.
INTDATASOURCESOH INT Not currently used.
YSNACCEPTEXPIREDCUSTS VARCHAR(1) No longer used.
INTDATASOURCESALES INT Not currently used.
INTSECVOID INT No longer used. See POSSECURITY.
YSNPRINTMODIFIERSONRECEIPT VARCHAR(1) If 'T' item modifiers will be printed on the receipt.
INTLINESPERPAGE INT The number of lines per page. Used for Taiwan receipts.
INTFIRSTLINE INT The first line we should start printing on. Used for Taiwan receipts.
INTLASTLINE INT The last line we should print on. Used for Taiwan receipts.
INTPAGESPERROLL INT The number of pages on one receipt roll. Used for Taiwan receipts.
INTSECCUSTTAXNUM INT No longer used. See POSSECURITY.
INTDATASOURCEGIFTCERTSVALID INT Not currently used.
YSNPRINTTESTRECEIPT VARCHAR(1) If 'T' POS will print a test receipt when it is started to indicate the receipt printer is working.
YSNKITCHENPRINTMULTIITEM VARCHAR(1) If 'T' multiple items can be printed to a single kitchen receipt. If 'F', each item will be printed on its own kitchen receipt.
YSNPRINTNOSALE VARCHAR(1) If 'T' POS will print a receipt for No Sale transactions.
INTSECREPRINT INT No longer used. See POSSECURITY.
YSNMANDATORYTABLE VARCHAR(1) If 'T' the table number must be entered for a transaction.
intSecChgPriceSel INT No longer used. See POSSECURITY.
intSecChgPriceReturn INT No longer used. See POSSECURITY.
intSecChgPriceReturnSel INT No longer used. See POSSECURITY.
intSecTraining INT No longer used. See POSSECURITY.
INTCUSTDISPLAYDATA INT Indicates which POS description to use on the customer display.
0   POS 20
1   POS 12
YSNASKPASSWORD VARCHAR(1) If 'T' the POS will ask for a password when the operator logs on.
INTCOUNTRYCODE INT Indicates the country the POS is running in which in turn controls some of the functionality of POS.
0   Any country
1   Taiwan
2   China
3   South Korea
YSNPRINTTRAININGREC VARCHAR(1) If 'T' POS will print receipts when in training mode.
YSNUSECHANGERULES VARCHAR(1) No longer used. See TENDER.YSNUSECHANGERULES.
INTPOSITIONKEYPAD INT Position of the keypad on the POS screen.
0   Centre
1   Right
YSNHIDEINACTIVEKEYS VARCHAR(1) If 'T' POS will hide any keys that are not being used. If 'F' the keys will simply be disabled.
YSNASKFLOATATSTART VARCHAR(1) If 'T', POS will ask for a float at the start of shift.
YSNVALIDATEPOSTCODE VARCHAR(1) If 'T' POS will attempt to validate the postcode entered for delivery addresses.
YSNDELIVERYTIMEVALIDTIME VARCHAR(1) If 'T' the delivery time must be entered as a valid time. If 'F' it ca be entered as a free format text.
YSNCHANGERETURN VARCHAR(1) If 'T' you can change the items on a return transaction.
YSNVALIDATEGIFTCERT VARCHAR(1) If 'T', POS will validate the gift certificate number has not been used.
YSNALLOWSALESOHZERO VARCHAR(1) If 'T' POS will allow sale of an item, even if its SOH is zero.
INTSOHCHECKMETHOD INT When POS needs to check the current stock on hand of an item, this tells the system how the check should be done.
0   Standard check against Merchant Central Server.
1   WMS Interface (a third party warehousing system).
INTMENUCODE INT The menu definition that should be used when displaying the menu at POS.

MENUHDR.intMenuCode

YSNASKPARTIALRETURN VARCHAR(1) If 'T', POS will ask if a return is actually a partial return.
YSNINCRETURNDISC VARCHAR(1) If 'T', discounts on returns will be included in the tillread in the discounts row. If 'F' only discounts given on sales will be included.
INTSERVERMSGCHECK INT How regularly, in seconds, the POS should check the server for messages.
YSNCHECKLOCALSERVER VARCHAR(1) If 'T' the POS will record held transactions on Merchant Local Server, not Merchant Central Server.
YSNUSERTILLREAD VARCHAR(1) No longer used.
INTZREADHELDTRANS INT No longer used. See TRADINGUNITTILL.intZReadHeldTrans.
YSNRELOADITEMTAX VARCHAR(1) If 'T' ITEMTAXGROUP details will be reloaded. This is a Stena specific setting to minimise reload times for their multiple crossings.
YSNCHECKINTERRUPTSALES VARCHAR(1) If 'T' POS will check for possible interrupted sales each time the operator logs in.
YSNPRINTBOTHPOSTOKITCHEN VARCHAR(1) Not currently used.
YSNTRACKLOGON VARCHAR(1) If 'T' POS will record the logon/logoff activity so its visible in Electronic Audit.
YSNLOCALSALEID VARCHAR(1) If 'T' the POS will record the next sale number to use in the local DYNAMIC.INI. If 'F' POS will get the number from Merchant Central Server.
YSNPRINTSALECOMMENT VARCHAR(1) If 'T' the sale comment will be printed on the receipt.
YSNOKBUTTONCHGQTY VARCHAR(1) If 'T' the POS button will treat a press of the OK button as an 'increment quantity' request. If 'F' the OK button will be ignored.
STRCUSTDISPLAYCODE VARCHAR(10) The code of the multimedia customer display definition that should be used to display information to a second screen.

CUSTDISPLAYHDR.strCode

MEMCASHINOUTMSG TEXT Message that should be displayed at the end of cash in/out receipts.
INTCASHINOUTEXTRARECEIPTS INT The number of extra receipts that should be printed for cash in/out transactions.
INTFOREIGNCHANGERULE INT Indicates how the POS should calculate change for transactions involving foreign tenders.
0   User To Select Currency
1   Auto Determine Currency
2   Always Primary Currency
YSNUSERMSGS VARCHAR(1) If 'T' POS is allowed to use POS BE messaging.
YSNSTATUSMSGS VARCHAR(1) Not currently used.
YSNSHOWNEWSFRONT VARCHAR(1) Not currently used.
YSNASKTABLENAME VARCHAR(1) If 'T' POS will ask for a table name (different to the save id)
YSNASKTRANSNUMFORRETURN VARCHAR(1) If 'T' POS will ask for the transaction number of the original sale when doing a return.
YSNALLOWMULTIEFTPOS VARCHAR(1) If 'T' POS will accept multiple EFTPOS payments for one transaction.
STRAUTOLOGONUSER VARCHAR(20) If POS should log in automatically (as for a kiosk), this is the operator code to log in as.
STRSUPERVISORENTRYCODE VARCHAR(20) If POS is running in a kiosk mode, this is the special code that can be entered to enter supervisor mode. You could have a swipe card with this code on it to easily enter supervisor mode.
YSNSHOWTABLEBUTTONS VARCHAR(1) If 'T' and their are tables defined for the location in which the POS belongs, each table will be shown on a fastkey button to make it quick for the operator to select.
INTAUTOPAYTENDER INT The tender code that should be used for autopayment of transactions.

TENDER.intTenderCode

YSNSHOWAUTOPAYBUTTON VARCHAR(1) If 'T' the POS will show split the Payment button into two. One will be the normal payment button (which works as per the standard payment button) and the other will be an auto payment button. When the auto-payment button is pressed, the POS will use the tender assigned to INTAUTOPAYTENDER to complete the transaction.
YSNRETURNDISCOUNTVALUE VARCHAR(1) If 'T' then when a return is done by matching against an original sale, the value of the returned items will include any discounts that were given on the item.

YSNPRINTDELIVERYTODAYONLY

VARCHAR(1)

If 'T' POS will print a delivery report only if the delivery date is for today.

INTDEFAULTSALESMETHOD

INTEGER

The default sales method used that the POS will use when making sales.

SALESMETHOD.intCode

YSNASKSALESMETHOD

VARCHAR(1)

If 'T' POS will ask for the sales method at the start of every transaction.

YSNASKTRADEDATE

VARCHAR(1)

If 'T' the POS will ask the user for the trading date at the start of a shift. If 'F', POS will calculate the trading date based on the current date/time and start hour of a trading day.

INTSETMEALRECEIPTFORMAT

INTEGER

The format used when printing set meals on receipts.

0  

Show Items/ No Prices

1  

Show Items/ Show Prices

2  

Do Not Show Items

YSNNONITEMISEDRECEIPT

VARCHAR(1)

If 'T', POS will print a receipt with no items on it, only totals.

INTTABLEUPDATEINTERVAL

INTEGER

The number of seconds between data refresh when the POS is displaying the table status for each table.

INTSORTRECEIPTFORMAT

INTEGER

The sequence in which data will print on the receipt.

0  

Entered Sequence

1  

D/C/G/SG/Description

2  

Description

CURMAXTIP

DECIMAL(19,4)

The maximum value for a tip.

YSNPRINTVALIDTABLEONLY

VARCHAR(1)

If 'T', a kitchen receipt will only print if the transactions table number is a valid table. If 'F' the kitchen receipt will print regardless of the table number.

YSNKPONDEMAND

VARCHAR(1)

If 'T' the POS will use Print On Demand for kitchen printing. If 'F' the kitchen receipts will print automatically.

INTTABLEINACTIVETIME INTEGER The interval (in seconds), that POS will poll the sever to check table status. If zero then table polling will not occur.

YSNASKCASHDRAWER

VARCHAR(1)

If 'T' POS will ask the user which cash drawer they want to use.

YSNASKMONEYBELT

VARCHAR(1)

If 'T' POS will ask the user if they want to use a money belt.

YSNRETURNRECEIPTNEG

VARCHAR(1)

If 'T' the values on a Return transaction will be printed as a negative number. If 'F' (default), the value will be shown as a positive value.

YSNALLOWRETURNWEIGHED

VARCHAR(1)

If 'T' you are allowed to add weighed items to a Return transaction.

YSNINCLUDEWEIGHDISC

VARCHAR(1)

If 'T' weighed items are allowed to be included in discounts.

YSNERRORMSGPOPUP

VARCHAR(1)

If 'T', error messages at POS will be displayed in a pop up window.

INTDEFAULTFASTKEYTAKEAWAY

INTEGER

The default fastkey panel to be displayed from a keyboard for takeaway sales.

YSNASKGCEXPIRYDATE

VARCHAR(1)

If 'T', POS will ask for expiry date when a gift certificate is sold.

YSNASKCNEXPIRYDATE

VARCHAR(1)

If 'T', POS will ask for expiry date when a credit note is sold.

STRRANDOMWEIGHT4PLU

VARCHAR(50)

A comma-delimited list of prefixes that identify a barcode as a random weight barcode with a four digit PLU.

STRRANDOMWEIGHT5PLU

VARCHAR(50)

A comma-delimited list of prefixes that identify a barcode as a random weight barcode with a five digit PLU.

YSNCHANGEPROMPT

VARCHAR(1)

If 'T' the POS will display the change to be given in a popup dialog box.

YSNPRINTIPNONRECEIPT

VARCHAR(1)

If 'T' the POS will print the IPN under the POS description on the receipt.

YSNGIFTCERTRANGE

VARCHAR(1)

If 'T' the POS will allow a range of gift certificate numbers to be entered, instead of a single number.

YSNPREGIFTCHECKS

VARCHAR(1)

If 'T' the POS will do checks to make sure the gift certificate number exists as a pre-sale gift certificate before it can be sold.

YSNASKENTERTAINMENT

VARCHAR(1)

If 'T' POS is allowed to print an entertainment receipt on a reprint.

YSNRETURNORIGTENDERS

VARCHAR(1)

If 'T' then on a return transaction the user must select the tender with which the POS was originally paid.

YSNOPENCASHDRAWERALWAYS

VARCHAR

 

YSNPRINTROLLUPMODIFIER

VARCHAR (1)

Used when printing the receipt. If 'T' the price of a modifier will be added to the main item rather than shown against the modifier item itself.

YSNPRINTLONGDESCA4

VARCHAR(1)

If 'T' the long description of the item will print on the A4 invoice.

YSNMENUITEMCOUNTDOWN

VARCHAR(1)

If 'T' the POS will be using the menu countdown feature.

INTDEFAULTTABLESECTION

INTEGER

The default table section to be displayed when the user goes to Table state.

YSNUSESCRIPTS

VARCHAR(1)

If 'T' the POS will be used for pharmacies and display script transactions.

YSNVALIDATEREWARDVOUCHER

VARCHAR(1)

If 'T' the POS will validate the reward voucher number when it is redeemed.

YSNREWARDVOUCHERRANGE

VARCHAR(1)

'T' if we are allowed to accept a range of voucher numbers.

YSNVALIDATETABLE

VARCHAR(1)

If 'T' the table number must be a valid table that has been defined against the location.

YSNPRINTSODFLOATRECEIPT

VARCHAR(1)

If 'T' a receipt will be printed for the start of shift float.

INTSODFLOATEXTRARECEIPTS

INTEGER

The number of extra receipts to print when we do the start of shift float.

YSNMARKTABLEDIRTYONPAYMENT

VARCHAR(1)

If 'T' then a table will be marked as dirty on payment.

INTTABLEDIRTYTOAVAILABLETIME

INTEGER

The amount of time (in minutes) that the POS will wait before changing a dirty table to an available table. This saves the user having to mark the table as available once it has been cleaned.

INTKITCHENPRINTLINESPACE

INTEGER

Indicates the number of lines to print between each item on the kitchen receipt. Defaults to zero so there is no spacing.

YSNFLEXIBLESPENDINGACCOUNT

INTEGER

 

YSNPRINTKITCHENOLDNEWCHG

INTEGER

 

YSNPRINTUOMFORITEMS

VARCHAR(1)

'T' indicates that the item unit of measure will be printed on the receipt for multiple quantities. Default behavior is false ('F').

YSNMULTIUSERSALE

VARCHAR(1)

'T'- indicates if the till will prompt for additional operators.

INTSCALEACCURACY

INTEGER

Used to store the accuracy of attached scale devices for the profile - for use with Weighed items. Default is to three decimal places.

2

Two Decimal Places

3

Three Decimal Places

4

Four Decimal Places

DBLSCALEDIVISION

DECIMAL(4,4)

Used to store the lowest decimal division attached scale devices for the profile is capable of - for use with weighed items. Default is 0.001

YSNPRINTPOINTSEXPIRY

VARCHAR(1)

Enables points expiry printing. Values: T - True, F - False (default).

YSNPRINTPOINTSEXPIRYBANDS

VARCHAR(1)

Enables points expiry band printing. Values: T - True, F - False (default).

INTPRINTPOINTSEXPIRYTYPE

INTEGER

The type of points expiry time scale. Values: 0 - Months (default), 1 - Years.

INTPRINTPOINTSEXPIRYDURATION

INTEGER

Numeric value used in conjunction with INTPRINTPOINTSEXPIRYTYPE.

CURGIFTMAXTOPUP

DECIMAL(19,4)

Maximum top up amount for gift cards and gift/point configuration.

YSNGIFTMONEY

VARCHAR(1)

Indicates if GiveX Gift Card functionality is on or off.

YSNGIFTPOINTS

VARCHAR(1)

Indicates if GiveX Points functionality is on or off.

 

Primary Key: CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)