Bin Template

Diagrams

Table

Bin Template

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	Code (Code)	Code20		NotBlank: Yes
2	Description (Description)	Text50
4	Location Code (Location Code)	Code10	TableRelation: Location WHERE (Bin Mandatory=CONST(Yes))	NotBlank: Yes
5	Bin Description (Bin Description)	Text50
6	Zone Code (Zone Code)	Code10	TableRelation: Zone.Code WHERE (Location Code=FIELD(Location Code))
10	Bin Type Code (Bin Type Code)	Code10	TableRelation: "Bin Type"
11	Warehouse Class Code (Warehouse Class Code)	Code10	TableRelation: "Warehouse Class"
12	Block Movement (Block Movement)	Option	[ ,Inbound,Outbound,All]
20	Special Equipment Code (Special Equipment Code)	Code10	TableRelation: "Special Equipment"
21	Bin Ranking (Bin Ranking)	Integer
22	Maximum Cubage (Maximum Cubage)	Decimal (0:5)		BlankZero: Yes
23	Maximum Weight (Maximum Weight)	Decimal (0:5)		BlankZero: Yes
24	Dedicated (Dedicated)	Boolean

Keys

#	Fields
0	Code (Code)		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
Bin Type Code (Bin Type Code)	Bin Type	Code (Code)	TableRelation: "Bin Type"	1..n
Location Code (Location Code)	Location	()	TableRelation: Location WHERE (Bin Mandatory=CONST(Yes))	1..n
Special Equipment Code (Special Equipment Code)	Special Equipment	Code (Code)	TableRelation: "Special Equipment"	1..n
Warehouse Class Code (Warehouse Class Code)	Warehouse Class	Code (Code)	TableRelation: "Warehouse Class"	1..n
Zone Code (Zone Code)	Zone	Code (Code)	TableRelation: Zone.Code WHERE (Location Code=FIELD(Location Code))	1..n

Table Relations From Other Tables

From Table	From Field