Home > Technical > Table Definitions > REBATEBUCKET

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.

SUPPLIER.strSupplierCode

DTMTRANS

DATETIME(8)

The date the item was invoiced and therefore rebatable.

STRPERIOD

VARCHAR(7)

The period for the corresponding date.

STATSPER.strYearWeek

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.

INVOICEDETAIL.lintLineNumber

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.

ITEM.lintItemNumber

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

REBATETYPE.strRebateCode

LINTLINKCODE

INT(4)

 

STRREPORTTRADECODE

VARCHAR(10)

 

STRORDERCODE

VARCHAR(20)

 

 

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