Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

ProductCode

Unique SKU identifier code. This is the reference that is used to identify the SKU in other services

nvarchar(100)

Mandatory

Dispatch Note, Commercial Inv

ProductDescription

Short description of SKU

nvarchar(200)

Mandatory

Dispatch Note, Commercial Inv

ProductLongDescription

Open reference field

nvarchar(500)

EAN

SKU International Article Number/Barcode. Must be unique to the SKU.

nvarchar(50)

Conditional: if requiredby DC

HTSCode

Commodity code used to classify and define internationally traded goods. Must be numeric.

nvarchar(100)

Must be numeric

Conditional: if required for shipping

Commercial Inv

Hazardous

If set to TRUE, the SKU will be marked as Hazardous in SupplyStream

boolean

true, false

Conditional: if the Product List contains Hazardous SKU's

GrossWeight

Gross weight of SKU. Accepts up to 4 decimal places.

decimal(18, 4)

Mandatory

GrossWeightUOM

The Unit of Measure of the GrossWeight

char(2)

KG

Mandatory

LotControlled

Placeholder (Cannot be updated). If the product has no history, it is possible to update this directly from the SS interface. 

boolean

DateControlled

Placeholder (Cannot be updated). If the product has no history, it is possible to update this directly from the SS interface. 

boolean

CountryOfOrigin

Specifies which country the goods were manufactured

nvarchar(2)

ISO-2

Conditional: if required for shipping

Commercial Inv

 25

Brand

Product Brand

nvarchar(100)

Colour

Colour of SKU i.e. Blue

nvarchar(100)

Size

Size of SKU I.e Small

nvarchar(100)

QCControlled

Placeholder (Cannot be updated)

boolean

QCPercentage

Placeholder

int

SerialNumberControlled

Placeholder (Cannot be updated)

boolean

InwardProcessing

Inward Processing flag

boolean

WetBond

Wet Bond flag

boolean

UnitPrice

Unit price of SKU.

decimal(18, 4)

 25

LeadTime

Lead time in days to deliveries

int

 25

Category1

Category 1

nvarchar(50)

 25

Category2

Category 2

nvarchar(50)

 25

MOQ

Minimum Order Quantity

int

 25

Currency

Currency of unit price. No ISO-3 validation.

nchar(3)

 25

ProductUse

Product Use. Open text field.

nvarchar(50)

 25

ClientProductStatus

Product Status. Open text field. Does not show on SupplyStream

nvarchar(50)

 25

Business

Business open text field

nvarchar(50)

 25

Bonded

Bonded flag

boolean

SecondaryCurrencyCode

Secondary currency, for example, the purchase currency. No ISO-3 validation

nchar(3)

SecondaryPrice

Secondary price, for example, the purchase price

decimal(18, 4)

StyleCode

Style code coper text field

nvarchar(100)

SupplierMapping

Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

SupplierCode

Supplier code of the supplier to be assigned to the SKU. Supplier code created in Load Companies using CompanyCode. SupplierCode can also be created 'on the fly', but no Supplier address details will be recorded.

nvarchar(100)

Conditional: if required by DC

SupplierDescription

Name of supplier. If the SupplierCode specified already exists, the existing Supplier Description will be used rather than the one specified in this field.

nvarchar(200)

Conditional: if 'SupplierMapping → SupplierCode' provided

UOM

Placeholder

int