Home > Technical > Table Definitions > ACCOUNTTAX
This table is used as part of the Accounts Interface. It is used as a cross-reference table so that tax details are 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 |
STRTRADECODE | VARCHAR(10) |
The location that this cross reference record is for. |
STRTAXDEBITACCOUNT | VARCHAR(20) |
The account code within the 3rd party accounts system that should be adjusted for tax debit transactions. |
STRTAXCREDITACCOUNT | VARCHAR(20) |
The account code within the 3rd party accounts system that should be adjusted for tax credit transactions. |
STRDEPOSITACCOUNT |
VARCHAR(20) |
|
STRINVVARACCOUNT |
VARCHAR(20) |
|
STRRECEIPTSACCOUNT |
VARCHAR(20) |
|
STRCONTRAWHSEFEEACCOUNT |
VARCHAR(20) |
|
STRINTRALOCATIONACCOUNT |
VARCHAR(20) |
|
STRCONTRASTOCKACCOUNT |
VARCHAR(20) |
|
STRBANKINGVARIANCEACCOUNT |
VARCHAR(20) |
The Account GL code to be mapped to Banking Variance for the Account Interface report. |
Primary Key: STRTRADECODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |