stockrotationitems

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

itemnumber_id

INT

10

null

items.itemnumber

stockrotationitems_iifkC

Itemnumber to link to a stage & rota

stage_id

INT

10

null

stockrotationitems_sifkC

stage ID to link the item to

indemand

BIT

0

Should this item be skipped for rotation?

fresh

BIT

0

Flag showing item is only just added to rota

Showing 1 to 4 of 4 entries

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	itemnumber_id
stockrotationitems_sifk	Performance	Asc	stage_id

Showing 1 to 2 of 2 entries