Home > Technical > Table Definitions > HOTELACCOUNT
This table is used to interface with hotel systems such as Maxial. As an account payment is made, its details are recorded here, ready to be passed through to the hotel system.
|
Column |
Type |
Description |
|
CTRCODE |
INT(4) |
A unique number assigned by the system. |
|
STRTRADECODE |
VARCHAR(10) |
The location that the transaction was made in. |
|
LINTROOMNUM |
INT(4) |
The room number that the charge is to go to. |
|
STRLEDGERCODE |
VARCHAR(10) |
The ledger which the account payment was made into. |
|
INTORDERCODE |
INT(4) |
The code which identifies the transaction this record came from. |
|
DTMTRANS |
DATETIME(8) |
The date the transaction was created. |
|
CURAMOUNT |
DECIMAL(9)19,4 |
The amount of the transaction. |
|
STRDESCRIPTION |
VARCHAR(50) |
A general description about the transaction. |
|
DTMPOSTED |
DATETIME(8) |
The date the transaction was successfully posted to the hotel system. |
Primary Key: CTRCODE + STRTRADECODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |
