Home > Technical > Table Definitions > REBATEEXTRAHDR

REBATEEXTRAHDR

This table is used to store details about additional rebates which may be paid by a supplier. It can only be used if the COGS method is FIFO. The specific items that the rebate will be paid on are listed in REBATEEXTRADET. When the rebates are accepted they will modify the STOCKDETAIL.curRebate amount and be marked for printing on the Rebate Claims.

Column Type Description

CTRCODE

INT(4)

A unique number assigned by the system.

STRSUPPLIERCODE

VARCHAR(10)

The supplier this rebate will be paid by.

SUPPLIER.strSupplierCode

LINTITEMNUMBER

INT(4)

The item number this rebate is for.

ITEM.lintItemNumber

STRDESCRIPTION

VARCHAR(50)

A description about the rebate.

STRTRADECODE

VARCHAR(10)

The location to receive the rebate.

TRADUNIT.strTradeCode

STRSTATUS

VARCHAR(10)

The status of the rebate, for example 'New' or 'Accepted'.

DTMSTATUS

DATETIME(8)

The date that strStatus was last changed.

STRWHO

VARCHAR(20)

The user who entered the rebate.

DTMWHEN

DATETIME(8)

The date the rebate was entered into the computer.

DTMTAXINVOICE

DATETIME(8)

The date a tax invoice was received for this transaction.

 

Primary Key: CTRCODE

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