Home > Technical > Table Definitions > TENDER

TENDER

Contains a record for each of the tender types a user can pay for goods with. Tender types can also be used to identify no-sales and spillages. Any sales with these special tender types bypass the normal sales mechanism and have special action taken on them. These special tender types are identified in System Settings.

Column

Type

Description

INTTENDERCODE

INT

A unique number assigned by the user to identify the tender type.

STRTENDERDESCRIPTION

VARCHAR(20)

A description about the tender type.

YSNDYNAPOSTENDER

VARCHAR(1)

‘T’ if the tender can be used on the DynaPOS.

STRIMAGENAME

VARCHAR(20)

The image to be displayed on a DynaPOS for this tender. Do not include path information.

INTDYNAPOSORDER

INT

The order in which this tender type will be displayed on the DynaPOS.

STRDYNAPOSDESCRIPTION

VARCHAR(15)

The description to be displayed on the DynaPOS.

YSNALLOWOVERTENDER

VARCHAR(1)

'T' if tender can be overtendered by the customer in the expectation that change will be given, for example cash.

YSNUSEFORREFUND

VARCHAR(1)

'T' if the tender can be used to give a refund back to the customer.

DBLCHARGEPER

DECIMAL(19,4)

The percentage charge that is applied to the value of a sale for credit card transactions. Usually zero. Not currently used. Should be in 5.11.

YSNCHARGEMEMBERSONLY

VARCHAR(1)

'T' if only members are charged the dblChargePer fee. If 'F' everybody will be charged the fee. Not currently used. Should be in 5.11.

YSNROUND

VARCHAR(1)

'T' if rounding of the sale should occur with this type of payment. For example, cash is normally rounded but EFTPOS is not.

CURMINSALEVALUE

DECIMAL(19,4)

The sale value must be at least this amount before this tender code can be used.

CURMAXTENDERVALUE

DECIMAL(19,4)

This is the maximum amount that will be accepted for this tender type.

INTCOPIES

INT

The number of copies of the receipt which should be printed. Usually 1.

YSNBANKABLE

VARCHAR(1)

Not currently used. Set to 'T'

YSNUSEFORACCOUNTPAYMENT

VARCHAR(1)

Indicates whether this payment type can be used to make account payments. If allowed to be used, set to 'T'. If not allowed, set to 'F'.

YSNASKDETAILS

VARCHAR(1)

If 'T' then DynaPOSTouch will ask for further details, for example cheque number.

STRCARDPREFIXES

VARCHAR(255)

Not currently used

YSNDECLARE

VARCHAR(1)

If 'T' then the tender will be shown on the Till Declaration. There are some special tenders which are used to trigger events and these should have this flag set to 'F' so that they don't appear on the Till Declaration.

YSNAUTOPAY

VARCHAR(1)

Not currently used.

YSNOPENCASHDRAWER

VARCHAR(1)

'T' if cash drawer should be opened for this tender type.

STRCOMMENT

VARCHAR(255)

Not currently used.

YSNINTERFACETOEFT

VARCHAR(1)

'T' if this tender should start an interface to a connected EFTPOS solution. Defaults to 'F'.

YSNASKFORCASHOUT

VARCHAR(1)

If this tender interfaces to EFTPOS, this flag will determine if DynaPOSTouch should also ask for cashout. Defaults to 'F'.

YSNPRINTSIGNATURE

VARCHAR(1)

'T' if the receipt should print space for a signature to be put on the receipt. Defaults to 'F'

STRTENDERCOMMENTMSG

VARCHAR(60)

If YSNASKDETAILS='T', POS will display this message when asking for the details.

YSNPRINTTENDERCOMMENT

VARCHAR(1)

If 'T', any comment entered for the tender will be printed on the receipt.

YSNTAXCHARGE

VARCHAR(1)

If 'T' the tender is considered to be taxable. For Taiwan use only.

YSNUSECHANGERULES

VARCHAR(1)

If 'T' the system will use change rules (as defined in the following fields to determine how change should be given).

CURCNCHANGELIMIT

DECIMAL(19,4)

When a payment is made with this tender and change needs to be given, the amount of change is compared to this value. If the change is less than this value the POS will use either INTCHANGELESSTENDER or INTCHANGELESSITEM otherwise it will use INTCHANGEMORETENDER or INTCHANGEMOREITEM.

INTCHANGELESSTENDER

INT

If this is entered and the change is less than CURCNCHANGELIMIT, the POS will give change back by adding a tender using this tender code.

INTCHANGELESSITEM

INT

If this is entered (and INTCHANGELESSTENDER is not) and the change is less than CURCNCHANGELIMIT, the POS will add this item number to the transaction with the value of the change to bring the transaction value back to zero.

INTCHANGEMORETENDER

INT

If this is entered and the change is more than CURCNCHANGELIMIT, the POS will give change back by adding a tender using this tender code.

INTCHANGEMOREITEM

INT

If this is entered (and INTCHANGEMORETENDER is not) and the change is more than CURCNCHANGELIMIT, the POS will add this item number to the transaction with the value of the change to bring the transaction value back to zero.

YSNDEFAULTDECLARED

VARCHAR(1)

If 'T' then when doing till declarations, the declared amount will default to the expected amount.

YSNCHGDECLARE

VARCHAR(1)

If 'T' the user will be allowed to change the value for this tender in till declarations.

INTCHANGEMETHOD

INT

Determines the set of rules the system will use when calculating change.

0  

Standard Rules

1  

Korean Rules

CURCHANGETENDERLIMIT

DECIMAL(19,4)

This is a limit used when setting Korean change rules.

DBLCHANGEMOREPER

DECIMAL(19,4)

If the tendered amount is less than CURCHANGETENDERLIMIT and the percentage amount of the tender actual used to complete transaction is more than this then this value, POS will use either INTCHANGELESSTENDER or INTCHANGELESSITEM otherwise it will use INTCHANGEMORETENDER or INTCHANGEMOREITEM.

DBLCHANGELESSPER

DECIMAL(19,4)

If the tendered amount is more than CURCHANGETENDERLIMIT and the percentage amount of the tender actual used to complete transaction is more than this then this value, POS will use either INTCHANGELESSTENDER or INTCHANGELESSITEM otherwise it will use INTCHANGEMORETENDER or INTCHANGEMOREITEM.

YSNCASHTYPETENDER

VARCHAR(1)

If 'T' the tender is considered as part of cash receipts. For Korea only.

YSNHOTELINTERFACE

VARCHAR(1)

'T' if this tender is used to put a sale on to a hotel account.

CURMINSERVICECHARGE

DECIMAL(19,4)  

The minimum amount before a service charge is applied. If this tendered amount is greater than this amount, a service charge will be applied.

CURSERVICECHARGE

DECIMAL(19,4)  

The service charge value.

STRSERVICECHARGETYPE 

VARCHAR(1) 

$ indicates that CURSERVICECHARGE is a dollar value. % indicates that CURSERVICECHARGE is a percentage rate.

CURMINDETAILS

DECIMAL(19,4)

The minimum amount to be tendered for this tender code before the system will ask for extra details, for example cheque number. This is used in conjunction with YSNASKDETAILS. If YSNASKDETAILS is 'F', this value is ignored.

YSNCUSTNOTPRESENT

VARCHAR(1)

If 'T', indicates an EFTPOS trans is being made while the customer is not present. Currently used for the YesPOS interface only.

CURDEFAULTAMT

DECIMAL(19,4)

If this is non-zero, when the tender is selected at POS, it will pay out this amount automatically. You could use this for a $50 voucher.

YSNSHOWCONFIRMATION

VARCHAR(1)

If 'T' POS will show the confirmation message to the user.  The user can either proceed with the payment or exit and choose another payment method.

STRCONFIRMATIONMSG

VARCHAR(100)

A confirmation message which will tell the user to check for various things, for example driver's licence, or tell the user something, for example you won't get any change from this gift cert.

YSNFORFEITLESSWARNING

VARCHAR(1)

If 'T' and the 'less' change rule is to be applied, the system will show a forfeit message showing that the change is about to be forfeited. This is a system defined message. The user can either proceed with the payment or exit and choose another payment method. This is useful where the user pays with a voucher and they haven't used the full value.

YSNFORFEITMOREWARNING

VARCHAR(1)

If 'T' and the 'more' change rule is to be applied, the system will show a forfeit message showing that the change is about to be forfeited. This is a system defined message. The user can either proceed with the payment or exit and choose another payment method. This is useful where the user pays with a voucher and they haven't used the full value.

YSNALWAYSINREFUND

VARCHAR(1)

 

YSNREFUNDOVERRIDE

VARCHAR(1)

 

 

Primary Key: INTTENDERCODE

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