Home > Technical > Table Definitions > ACCOUNTTAX

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.

TRADUNIT.strTradeCode

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)