Home > Technical > Table Definitions > INVOICEREBATE

INVOICEREBATE

When an invoice is received, the system can calculated the expected rebates for the invoice. If you are using FIFO for COGS sold, this rebate is stored separately in STOCKDETAIL. If you are using Average Cost, you can (optionally) have the system modify the average cost for the invoiced items by the invoice cost AND the expected rebate. This table records the details of those expected rebates as an audit trail.

Column

Type

Description

CTRCODE

INT(4)

A unique number assigned by the system.

STRTRADECODE

VARCHAR(10)

'T' if the stock will be increased as a result of this adjustment, 'F' if stock will be decreased.

TRADUNIT.strTradeCode

STRSOURCE

VARCHAR(5)

'IM' to indicate the rebate came from an invoice.

LINTREFERENCE

INT(4)

The code of the invoice which generated the invoice.

STRREBATETYPE

VARCHAR(20)

The type of rebate.

 REBATETYPE.strRebateCode

DTMWHEN

DATETIME(8)

When the rebate was generated (date only).

CURAMOUNT

DECIMAL(9)19,4

The amount of the rebate.

CURCOSTVALUE

DECIMAL(9)19,4

The cost value on which the rebate was calculated.

DBLQTYSOLD

DECIMAL(9)19,4

The quantity of item the rebate was calculated on.

LINTITEMNUMBER

INT(4)

The number of the item, the rebate was for.

ITEM.lintItemNumber

 

Primary Key: CTRCODE + STRTRADECODE

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