Home > Technical > Table Definitions > INVOICEHEADER

INVOICEHEADER

Details for invoices are stored in INVOICEHEADER and . Each invoice will have one record in INVOICEHEADER and one or more in INVOICEDETAIL (for each item invoiced).

Column

Type

Description

LINTINVOICENUMBER

INT(4)

A unique number identifying the invoice. Assigned by the system.

STRSUPPLIERCODE

VARCHAR(10)

The supplier the invoice belongs to.

SUPPLIER.strSupplierCode

STRSUPPLIERINVOICENUMBER

VARCHAR(50)

The supplier’s invoice number.

STRTRADECODE

VARCHAR(10)

The location that received the items that the invoice is for.

TRADUNIT.strTradeCode

DTMINVOICEDATE

DATETIME(8)

The date of the invoice.

STRWHO

VARCHAR(20)

The code of the user who created the record.

DTMENTERREDDATE

DATETIME(8)

The date that the record was created.

STRSTATUS

VARCHAR(10)

The status of the invoice:New Printed Accepted

STRPONUMBERS

VARCHAR(50)

A comma-delimited list of our purchase order numbers that were included on this invoice.

CURTOTALEXPECTEDSERVICEFEE

DECIMAL(9)19,4

The total expected service fee.

CURTOTALEXPECTEDULLAGEFEE

DECIMAL(9)19,4

The total expected ullage fee.

CURTOTALEXPECTEDSALESTAX

DECIMAL(9)19,4

The total expected sales tax.

CURTOTALEXPECTEDLIQUORTAX

DECIMAL(9)19,4

The total expected liquor tax. Not used in GST or US Tax Systems.

CURTOTALEXPECTEDFREIGHT

DECIMAL(9)19,4

The total expected freight. This is ex GST.

CURTOTALEXPECTEDLINECOST

DECIMAL(9)19,4

The total expected line cost. The line cost is the expected cost * quantity for each item.

CURTOTALINVOICESERVICEFEE

DECIMAL(9)19,4

The total invoiced service fee.

CURTOTALINVOICEULLAGEFEE

DECIMAL(9)19,4

The total invoiced ullage fee.

CURTOTALINVOICESALESTAX

DECIMAL(9)19,4

The total invoiced sales tax.

CURTOTALINVOICELIQUORTAX

DECIMAL(9)19,4

The total invoiced liquor tax.  Not used in GST or US Tax Systems.

CURTOTALINVOICEFREIGHT

DECIMAL(9)19,4

The total invoiced freight. This is ex-GST.

CURTOTALINVOICELINECOST

DECIMAL(9)19,4

The total invoiced line cost. The line cost is the expected cost * quantity for each item.

MEMCOMMENTS

VARCHAR(2000)

Any comment about the invoiced goods.

CURBATCHTOTAL

DECIMAL(9)19,4

The total of the supplier's invoice. This will be used as a control total to ensure that the user enters the invoice correctly.

CURTOTALINVOICEDISCOUNT

DECIMAL(9)19,4

The total discount applied to the invoice.

LINTACCOUNTCREDITORSCODE

INT(4)

A unique, incrementing number assigned by the system. This is used by the system to keep track of transactions which have been exported to a third party accounting system.

DTMINVOICEDUE

DATETIME(8)

The date the invoice is due.

DTMSTATUS

DATETIME(8)

The date the strStatus field was changed to a new value.

MEMPOCOMMENTS

VARCHAR(2000)

The comments associated with the purchase orders which have been added to this invoice. Copied from POHEADER.memComments. If more than one purchase order has been added to the invoice, the comments will be appended.

DTMTAXINVOICE

DATETIME(8)

 

CURTOTALINVOICEFREIGHTINCTAX

DECIMAL(9)19,4

The total amount of freight (including GST) on this invoice.

CURTOTALINVOICEWETAMT

DECIMAL(9)19,4

The total invoiced WET amount (Wine Equalisation Tax).

CURTOTALEXPECTEDWETAMT

DECIMAL(9)19,4

The total expected WET amount (Wine Equalisation Tax).

YSNCOSTINCLUDESSERVICEFEE

VARCHAR(1)

'T' indicates that the invoice cost does include service fee otherwise 'F'. Copied from SUPPLIER when the invoice is created.

YSNCOSTINCLUDESULLAGEFEE

VARCHAR(1)

'T' indicates that the invoice cost does include ullage fee  otherwise 'F'. Copied from SUPPLIER when the invoice is created.

YSNCOSTINCLUDESTAX

VARCHAR(1)

'T' indicates that the invoice cost does include tax (GST) otherwise 'F'. Copied from SUPPLIER when the invoice is created.

YSNCOSTINCLUDESWET

VARCHAR(1)

'T' indicates that the invoice cost does include WET (Wine Equalisation Tax) otherwise 'F'. Copied from SUPPLIER when the invoice is created.

DTMTAXCLAIMED

DATETIME(8)

The date the transaction was actually claimed for taxation purposes.

STRTYPE

VARCHAR(10)

Can be INVOICE or RETURN. If invoice amount < 0 then should be RETURN.

LINTRETURNINVOICENUMBER

INT(4)

If this is a return or a claim, then this field will contain the lintInvoiceNumber of the original invoice the return came from, otherwise it will be zero.

MEMSPECIINSTRUCT

VARCHAR(2000)

Special instructions to use when returning items.

STRAUTHORISATIONCODE

VARCHAR(50)

The authorisation number provided by the supplier for the return of the items.

DTMSTATUSCHANGED

DATETIME(8)

 

STRAUTHORISEDBY

VARCHAR(20)

 

INTCHANGEFLAG

INT(4)

 

INTNEWFLAG

INT(4)

 

INTACCEPTED

INT(4)

 

STRSUPPDELIVERYNUM

VARCHAR(20)

 

STRORIGSUPPINVNUMBER

VARCHAR(50)

 

STRCURRENCYCODE

VARCHAR(5)

 

DBLEXCHANGERATE

DECIMAL(9)10,6

 

STRAGENTCODE

VARCHAR(10)

 

 

Primary Key: LINTINVOICENUMBER

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