Home > Technical > Table Definitions > REBATEEXTRADTL

REBATEEXTRADTL

Stores details about the exact amounts and items to receive the rebate stored in REBATEEXTRAHDR. When a rebate is first created, the system will copy the details from STOCKDETAIL for the item. The user then simply fills in the curAdditionalRebate field.

Column Type Description

INTREBATECODE

INT(4)

The number of the rebate header.

REBATEEXTRAHDR.ctrCode

CTRCODE

INT(4)

A unique number assigned by the system.

LINTSTOCKDETAILCODE

INT(4)

Link to the specific STOCKDETAIL record.

STOCKDETAIL.ctrCode

DTMWHEN

DATETIME(8)

The date copied from the STOCKDETAIL record.

CURCOST

DECIMAL9(19,4)

The cost of the item, copied from the STOCKDETAIL record.

CURCURRENTREBATE

DECIMAL9(19,4)

The current rebate, copied from the STOCKDETAIL record.

CURADDITIONALREBATE

DECIMAL9(19,4)

The additional rebate paid by the supplier (as a dollar amount).

DBLREBATEPER

DECIMAL9(19,4)

The additional rebate paid by the supplier (as a percentage of curCost).

 

Primary Key: INTREBATECODE + CTRCODE

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