Home > Technical > Table Definitions > ACCOUNTDEPT

ACCOUNTDEPT

This table is used as part of the Accounts Interface. It is used as a cross-reference table so that sales from our department/category/groups 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
STRDEPTCODE VARCHAR(10)

The department that this crossreference record is for.

DEPT.strDeptCode

STRCATCODE VARCHAR(10)

The category that this crossreference record is for.

CATEGORY.strCatCode

STRGROUPCODE VARCHAR(10)

The department that this crossreference record is for.

GROUPS.strGroupCode

STRSUBGROUPCODE

VARCHAR(10)

 

STRTRADECODE

VARCHAR(10)

The location that this crossreference record is for.

TRADUNIT.strTradeCode

STRSALESACCOUNT

VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for sales. If strDiscountAccount is left empty and ACCOUNDISCOUNT is empty, this amount should be the net sales value. If discount accounts are available, this will be the gross sales value with the discount value going to the discount account.

STRCOGSACCOUNT

VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for cost of goods sold.

STRSTOCKACCOUNT

VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for stock.

STRSTOCKADJACCOUNT

VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for stock adjustments.

STRTRANSFERACCOUNT

VARCHAR(20)

 

STRRETURNACCOUNT

VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for returns. If this is left empty the strSalesAccount will be used.

STREXCHANGEACCOUNT

VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for exchanges. If this is left empty the strSalesAccount will be used.

STRDISCOUNTACCOUNT

VARCHAR(20)

The account code within the 3rd party accounts system that should be adjusted for discounts. If this is left empty the strSalesAccount will be used. The system will use details in ACCOUNTDISCOUNT before using this value.

STRINTTRANSITACCOUNT

VARCHAR(20)

 

STRCONSIGNMENTACCOUNT

VARCHAR(20)

 

STRWHSEFEEINCOMEACCOUNT

VARCHAR(20)

 

STRWHSEFEEACCOUNT

VARCHAR(20)

 

STRCOSTADJUSTACCOUNT

VARCHAR(20)

 

 

Primary Key: STRDEPTCODE+STRCATCODE+STRGROUPCODE+STRSUBGROUPCODE+STRTRADECODE

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