Home > Technical > Table Definitions > INVEXTRAHDR

INVEXTRAHDR

This is the header record for Extra Invoice Cost transactions. The items are stored in INVEXTRADTL.

Extra Invoice Cost transactions record extra costs such as freight or customs duty. It is matched to a previous invoice. This allows us to distribute the costs over the items and update their average cost.

Column

Type

Description

LINTINVOICENUMBER

INT

Unique number assigned by the system.

STRSUPPLIERCODE

VARCHAR(10)

The supplier that has sent us the invoice.

SUPPLIER.strSupplierCode

STRSUPPLIERINVOICENUMBER

VARCHAR(50)

The supplier's invoice number.

STRTRADECODE

VARCHAR(10)

The code of the location to which the invoice belongs.
TRADUNIT.strTradeCode

DTMINVOICEDATE

DATETIME

The date of the invoice.

DTMTAXINVOICE

DATETIME

The date of any associated tax invoice.

DTMINVOICEDUE

DATETIME

The date the invoice is due for payment.

DTMTAXCLAIMED

DATETIME

The date the tax was claimed. Not currently used.

STRCURRENCYCODE

VARCHAR(5)

The code of the currency used on the invoice.
link.gif (858 bytes) CURRENCYCODE.strCurrencyCode

DBLEXCHANGERATE

DECIMAL(19,4)

The exchange rate of the currency.

LINTACCOUNTCREDITORSCODE

INT

A unique number assigned by the system when the invoice is accepted. This can be used by the accounts interface to determine records which need to be processed.

INTREASON

INT

The reason for the extra costs.
REASON.intCode

INTDISTRIBUTEMETHOD

INT

The method used to distribute the cost over the items.

1  

$/Carton

2  

$/KG

3  

% of Cost

CURINVOICEINCTAX DECIMAL(19,4)

The invoice cost including tax. The tax is determine from the tax code associated with the INTREASON.

CURINVOICEEXTAX DECIMAL(19,4)

The invoice cost excluding tax. The tax is determine from the tax code associated with the INTREASON.

CURINVOICEINCTAXLOCAL DECIMAL(19,4)

The invoice cost including tax converted to the local currency. The tax is determine from the tax code associated with the INTREASON.

CURINVOICEEXTAXLOCAL DECIMAL(19,4)

The invoice cost excluding tax converted to the local currency. The tax is determine from the tax code associated with the INTREASON.

STRWHO VARCHAR(20)

The code of the user who created the transaction.

USERCODE.strUserCode

DTMWHEN DATETIME

When the transaction was created.

STRSTATUS VARCHAR(10)

The current status of the invoice.

New

New transaction

Printed   

Transaction has been printed

Accepted  

Transaction has been accepted

DTMSTATUS DATETIME

The date the status was changed.

LINTORIGINVOICENUMBER INT

The original invoice to which this invoice is matched.

MEMCOMMENTS TEXT

General comments on the invoice.

STRAUTHORISEDBY VARCHAR(20)

The code of the user who authorised the acceptance of the invoice.

USERCODE.strUserCode

INTCHANGEFLAG INT

An incrementing number updated by the system for changes.

INTNEWFLAG INT

An incrementing number updated by the system for new records.

 

Primary Key: LINTINVOICENUMBER

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