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) |