Home > Technical > Table Definitions > TAXCHANGE
This is a temporary table used for the conversion to GST in Australia.
| Column | Type | Description |
|
STRSTORECODE |
VARCHAR(10) |
|
|
LINTITEMNUMBER |
INT(4) |
|
|
DBLOLDSTOCKCOUNT |
DECIMAL(19,4) |
|
|
CUROLDAVGCOST |
DECIMAL(19,4) |
|
|
CUROLDLASTINVOICECOST |
DECIMAL(19,4) |
|
|
INTCOUNTFIFO |
INT(4) |
|
|
STRTAXCODE |
VARCHAR(10) |
|
|
STRLIQUORTAXCODE |
VARCHAR(10) |
|
|
STRGSTTAXCODE |
VARCHAR(10) |
|
|
STRWETTAXCODE |
VARCHAR(10) |
|
|
CURADJUSTMENTVALUE |
DECIMAL(19,4) |
|
|
CURNEWAVGCOST |
DECIMAL(19,4) |
|
|
CURNEWLASTINVOICECOST |
DECIMAL(19,4) |
|
|
STRORDERCODE |
VARCHAR(20) |
|
|
CURFIFOAVGCOST |
DECIMAL(19,4) |
|
|
CURFIFOAVGREBATE |
DECIMAL(19,4) |
|
|
STRCOMPETITION |
VARCHAR(10) |
|
|
DBLREBATERATE |
DECIMAL(19,4) |
|
Primary Key: STRSTORECODE + LINTITEMNUMBER
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |