Home > Technical > Table Definitions > 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. |
STRLEDGERCODE |
VARCHAR(10) |
The account type to which this rule belongs. |
VARCHAR(10) |
The location for which the account is set up. 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) |