Home > Technical > Table Definitions > TRADUNITACCOUNT

TRADUNITACCOUNT

This table tells the system how different types of accounts should be shared between locations. Locations can each have their own set of accounts for customers/suppliers or they can share accounts with other locations.

Column

Type

Description

STRTRADECODE

VARCHAR(10)

The location to which this rule belongs.
TRADUNIT.strTradeCode 

STRLEDGERCODE

VARCHAR(10)

The account type to which this rule belongs.

ACLEDGER.strLedgerCode 

STRACTRADECODE

VARCHAR(10)

The location for which the account is set up.

TRADUNIT.strTradeCode 

If you wanted each store have separate accounts, this would be the same as strTradeCode. If you wanted stores to share an account, you would set this code to the same location code, for example 'ALL' for each store.

 

Primary Key: STRTRADECODE + STRLEDGERCODE + STRACTRADECODE

Example

These stores have separate accounts for customers but share supplier accounts:

strTradeCode

strLedgerCode

strAcTradeCode

SHOP1  

MEMCR  

SHOP1

SHOP2  

MEMCR  

SHOP2

SHOP3  

MEMCR  

SHOP3

SHOP1  

SUPPCR  

ALL

SHOP2  

SUPPCR  

ALL

SHOP3  

SUPPCR  

ALL


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