Home > Technical > Table Definitions > SUPPXREF

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.
SUPPLIER.strSupplierCode

STRXREFCODE

VARCHAR(10)

The wholesaler’s supplier code.

STRXREFTYPE

VARCHAR(10)

The supplier code we use identify the wholesaler.
SUPPLIER.strSupplierCode

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