Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Use

This defines where the stock is located within the warehouse, a product has one or more stock records and each stock record can have one or more location stock records

Limitations

It is important to ensure the total provided here agrees to the stock

Notes

This import originated from an older system so some of the fields are not relevant but remain as part of the standard import tables.        

Fields

Field Type

Explanantion

int

integer fields

bit

Yes or No fields

1 for Yes and 0 for No

date

format dd/mm/yy or dd/mm/yyyy

nvarchar (11)

text field with maximum length 11

decimal (8,2)

Decimal field must include the decimal and 00
(8,2) the total number of digits before and after the decimal point.

e.g 42.00 17.00 18.43 26.40

Field Name

Field Type

Nulls

Notes

WarehouseLocation

nvarchar(20)

Mandatory

This is the location name and must exist already on the system

RotationNo

nvarchar(10)

Mandatory

This needs to exist in the stock table already

RotationLine

int

Must exist if used in the stock table already

NoOfCases

int

Do not include frozen quantity within this

NoOfBottles

int

Do not include frozen quantity within this

FrozenCases

int

 

FrozenBottles

int

 

FrozenReason

nvarchar(50)

As you can not split this at data take on use a common reason to identify it afterwards. 

SiteCode

nvarchar(2)

Mandatory

Must be one of the pre-agreed site codes

  • No labels