Home > Technical > Table Definitions > 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. |
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. |
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. |
Primary Key: CTRCODE + STRTRADECODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |