Home > Technical > Table Definitions > HOTELACCOUNT

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.

TRADUNIT.strTradeCode

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.

ACLEDGER.strLedgerCode

INTORDERCODE

INT(4)

The code which identifies the transaction this record came from.

DAILYSALES.intOrderCode

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)