Home > Technical > Table Definitions > REBATEBUCKET
Used as a temporary holding area when generating rebates. The Rebate Claims will generate the data based on rebates which can be claimed. This data will be stored in this table. If the user is happy with the data, it can be accepted and it will be moved into the ACDETAIL table.
Column | Type | Description |
STRSUPPLIERCODE |
VARCHAR(10) |
The supplier this rebate will be paid by. |
DTMTRANS |
DATETIME(8) |
The date the item was invoiced and therefore rebatable. |
STRPERIOD |
VARCHAR(7) |
The period for the corresponding date. |
CURVALUE |
DECIMAL9(19,4) |
The value of the rebate. |
STRREFERENCE |
VARCHAR(30) |
A description/reference for this rebate. |
DTMENDDATE |
DATETIME(8) |
The last date that was examined for rebates. This is simply the 'To Date' specified when running the report. |
STRSOURCE |
VARCHAR(10) |
Indicates where the rebate came from, for example 'IM-C' indicates an invoice. |
LINTREFERENCE |
INT(4) |
The code of the source record. If the source was an invoice then this would be the invoice number. |
YSNCLAIMSUPPLIER |
VARCHAR(1) |
'T' if this is a rebate claim on a supplier, 'F' otherwise. |
YSNCLAIMMANUFACTURER |
VARCHAR(1) |
'T' if this is a rebate claim on a manufacturer, 'F' otherwise. |
YSNCLAIMHEADOFFICE |
VARCHAR(1) |
'T' if this is a rebate claim on a head office, 'F' otherwise. |
LINTLINENUMBER |
INT(4) |
The line number within the invoice that this rebate is for. |
STRPAYMENTREF1 |
VARCHAR(20) |
Contains a reference for the rebate. This will be written to the ACDETAIL.strPaymentRef1 field when the claims are posted to the accounts. |
STRCOMMENT |
VARCHAR(1000) |
Full details about the rebate, the item it was for and the amount claimed. This will be written to ACDETAIL.strComment. |
CTRCODE |
INT(4) |
A unique number assigned by the system. |
LINTITEMNUMBER |
INT(4) |
The item number that this rebate has been claimed for. |
STRTRADECODE |
VARCHAR(10) |
The location that this rebate has been claimed for. |
CURTAXAMT |
DECIMAL9(19,4) |
The amount of tax in the rebate amount. |
YSNPOSTTOACCOUNT |
VARCHAR(1) |
'T' if this detail should be posted to the SUPPDR accounts ledger, 'F' otherwise. |
STRREBATECODE |
VARCHAR(20) |
The rebate code which this rebate is for |
LINTLINKCODE |
INT(4) |
|
STRREPORTTRADECODE |
VARCHAR(10) |
|
STRORDERCODE |
VARCHAR(20) |
|
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |