Home > Technical > Table Definitions > CUSTORDERTENDER

CUSTORDERTENDER

Column Type Description
INTORDERCODE BIGINT The transaction number to which the tender belongs.
CUSTORDERHDR.CTRCODE
CTRCODE INT A unique number assigned by the system.
STRTYPE VARCHAR(1) Indicates the type of tender.
T   New payment added to the transaction.
b   Previous payment recorded on the transaction.
K Records the rounding amount (if a sale was rounded to nearest five cents for example).

STRCOMMENT

VARCHAR(20)

Not used.

STRTENDERCODE

VARCHAR(5)

The code of the tender used, for example 1= Cash.  No padding 1 will be stores as '1'.

CURTENDERAMT

DECIMAL(19,4)

The amount tendered, in the local currency.

YSNNEWTENDER

VARCHAR(1)

'T' if this is a new tender. If we have a customer order with multiple payments on it, previous payments would have this set as 'F'.

DTMTENDERED

DATETIME

The date the tender was made. Date/time?

STRCREDITCARD

VARCHAR(16)

Not used

STREXPIRY

VARCHAR(5)

Not used

STRCARDNAME

VARCHAR(100)

Not used

STRCARDTYPE

VARCHAR(10)

Not used.

LINTGIFTNUM

VARCHAR(10)

The gift certificate number used to pay the tender.

STRLEDGERCODE

VARCHAR(10)

If paid on account, this is the type of account. Link

STRCURRENCYCODE

VARCHAR(5)

The currency code used for the tender.

DBLEXCHANGERATE

DECIMAL(19,4)

The exchange rate used for the tender.

CURFOREIGNAMT

DECIMAL(19,4)

The actual amount tendered. Thi is used for foreign tender payments. If the local currency was GBP and the currency used to pay was USD, this value will be the original USD tendered amount.

STRTENDERCOMMENT

VARCHAR(100)

A comment about the tender, for example the cheque number.

DBLMEMBERID

DECIMAL(19,4)

Not used.

INTOPERATORID

INT

The code of the user who entered the payment.

USERCODE.INTUSERCODE

LINTCUSTOMERNUM

INT

The number of the customer who made the payment.

DTMSALESDATETIME

DATETIME

The date/time the tender was added to the transaction.

STRCARDNUM

VARCHAR(16)

The card number of the customer who made the payment. Not required if the customer number was provided.

STRREPLTRADECODE

VARCHAR(10)

Not used in standard system. Some sites may use it to add replication in which case it would be set by a trigger.

STRTRADECODE

VARCHAR(10)

The location where the payment was made.

TRADUNIT.strTradeCode

INTAUTHORISEUSER

INT

The user who authorised any tender specific actions that were secured against normal use.

USERCODE.INTUSERCODE

 

Primary Key: INTORDERCODE + CTRCODE

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