Home > Technical > Table Definitions > CUSTOMERINVOICE

CUSTOMERINVOICE

This table controls whether or not an invoice is required for certain customer types at a specific location. The invoice will be printed using the Invoice Printer service.

Column Type Description

STRTRADECODE

VARCHAR(10)

The location this rule applies to.

TRADUNIT.strTradeCode

STRCUSTTYPE

VARCHAR(10)

The customer type that this invoice type will be required for. This links to the CUSTOMERCATEGORY table where the intType=1.

CUSTOMERCATEGORY.strCode

STRINVOICETYPE

VACHAR(5)

The type of invoice that will be printed. This will usually be 'STD'.

 

Primary Key: STRTRADECODE + STRCUSTTYPE + STRINVOICETYPE

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