Page Comparison

...

Include Page

	VEDI:References Acronymns
	VEDI:References Acronymns

Field Name

Field Type

type

Nulls

Required	Notes

Site Code

SiteCode

nvarchar

varchar(2)

Mandatory

Must be

one of the pre-agreed site codes

WarehouseLocation

nvarchar(20

RotationNo

nvarchar

the 2 character code we agreed at the configuration stage
RotationNo	varchar(10)	Mandatory

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

This needs to exist in the stock table already

RotationLine

int

Must exist if used in the stock table already

TotalConvertedSingles

Must exist
DateFrozen	date	Mandatory
Reason	varchar(50)	Mandatory	text description of the reason the stock is frozen
TotalConvertedSinglesFrozen	int	Mandatory

Do not include frozen quantity within this

TotalConvertedSinglesReceived

int

Do not include frozen quantity within this


AutoUnfreezeAfter	date
FrozenReasonCode	varchar(8)	We use “IMP” to indicate on import if you need something else then please discuss this with us.
FrozenBy	varchar(30)	text of the user, if you leave blank we will input “System Import”

Versions Compared