Home > Technical > Table Definitions > ACCOUNTTENDER

ACCOUNTTENDER

This table is used as part of the Accounts Interface. It is used as a cross-reference table so that transactions involving certain tenders types in our system can be placed into specific accounts within the third party accounting system. The strTradeCode should be a specific store location not a group. The account codes are based on the format of the account codes within the accounting system.

Column Type Description

INTTENDERCODE

INT

The tender type that this cross reference record is for.

TENDER.intTenderCode

STRTRADECODE

VARCHAR(10)

The location that this cross reference record is for.

TRADUNIT.strTradeCode

STRGLACCOUNT VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for transactions of this tender type. This will usually be the main bank account.

STRROUNDACCOUNT VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for rounding of this tender type.

 

Primary Key: INTTENDERCODE+STRTRADECODE

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