Home > Technical > Table Definitions > SUPPXREF
This is a cross-reference table used to translate the wholesaler’s supplier codes to our supplier codes when performing an electronic host update. Pay special attention to the fields. The first field is not that of the wholesaler but the supplier which the wholesaler is referring to. To set up the data using the Supplier form, you retrieve the supplier being referred to and enter the wholesaler and the wholesaler's supplier code.
Column |
Type |
Description |
STRSUPPLIERCODE |
VARCHAR(10) |
The supplier code this cross-reference is for. |
STRXREFCODE |
VARCHAR(10) |
The wholesaler’s supplier code. |
STRXREFTYPE |
VARCHAR(10) |
The supplier code we use identify the wholesaler. |
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |