Home > Technical > Table Definitions > DYNAPOSPROFILE
These records store basic configuration details for DynaPOSTouch tills. Multiple tills can share the same profile making configuration easier.
Column |
Type |
Description |
||||||||||||||
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. |
||||||||||||||
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. |
||||||||||||||
INTRECEIPTFORMAT |
INT |
Controls the format of the items printed on the receipt.
|
||||||||||||||
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.![]() |
||||||||||||||
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.
|
||||||||||||||
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.
|
||||||||||||||
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.
|
||||||||||||||
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.
|
||||||||||||||
INTMENUCODE | INT | The menu definition that should be used when displaying the menu at POS. | ||||||||||||||
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. | ||||||||||||||
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.
|
||||||||||||||
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. | ||||||||||||||
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. |
||||||||||||||
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.
|
||||||||||||||
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.
|
||||||||||||||
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.
|
||||||||||||||
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) |