Home > Technical > Table Definitions > REBATECLAIMED

REBATECLAIMED

Stores details about which rebates have been claimed.

Column Type Description

STRSOURCE

VARCHAR(5)

The source of the document that the claim was for. Usually 'INV' for invoice.

LINTREFERENCE

INT(4)

The transaction number of the source document that the claim was generated for, for example the invoice number.

LINTLINENUMBER

INT(4)

The line number within the source document that the claim was generated for, for example invoice line number.

STRREBATECODE

VARCHAR(20)

The code of the rebate claimed

REBATETYPE.strRebateCode

STRSUPPLIERCODE

VARCHAR(10)

The supplier who is paying the rebate

SUPPLIER.strSupplierCode

LINTLINKCODE

INT(4)

 

DTMREBATEDATE

DATETIME(8)

The date that the rebate claim was generated.

 

Primary Key: STRSOURCE + LINTREFERENCE + LINTLINENUMBER + STRREBATECODE + STRSUPPLIERCODE + LINTLINKCODE

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