Home > Technical > Table Definitions > 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.
|
||||||
|
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. |
||||||
|
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. |
||||||
|
INTAUTHORISEUSER |
INT |
The user who authorised any tender specific actions that were secured against normal use. |
Primary Key: INTORDERCODE + CTRCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |