Home > Technical > Table Definitions > TAXCHANGE

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)