FWDataSetNesting

The table is used to specify the table and attributes used to define and extract a specific problem set. It provides the ability to define up to six different attributes in a nested format that can be used to filter different attributes within attributes.

For example: If you specify Territory at level one and Driver at level two, then the problem is restricted to that driver within that territory, instead of the whole territory.

Attribute Name	Type	Field Size	Description	Required
DataSetNestingID	int	4	Unique internal DB of the DataSetNesting record.	Required
DataSetNestingKey	nvarchar	50	Business key to identify the activity this DataSetNesting refers to.	Required
TableName	nvarchar	50	The value must be a valid Descartes Route Planner table name. All tables with a FW prefix are valid. The table name is validated against the FWCode table of type NestedTable.	Required
Level1Attribute	nvarchar	50	Level one is always required, whereas the other Level Attributes are optional. The concept here is to start at level one and work deeper into the table by being more specific with each level using a different attribute. It is possible to use the same attribute at different levels. The actual attribute name is provided by the user and must be on the table specified in the TableName attribute. If an attribute is used that does not exist, then it is ignored. The attributes must exist on the FWCode table of type NestedTableAttribute.	Required
Level2Attribute	nvarchar	50	If Level two is specified, then level one must also be specified. If level two is empty, then levels three, four, five, and six must also be empty. See Level1Attribute for more details.
Level3Attribute	nvarchar	50	If Level three is specified, then levels one and two must also be specified. If level three is empty, then levels four, five, and six must also be empty. See Level1Attribute for more details.
Level4Attribute	nvarchar	50	If Level four is specified, then levels one, two, and three must also be specified. If level four is empty, then levels five and six must also be empty. See Level1Attribute for more details.
Level5Attribute	nvarchar	50	If Level five is specified, then levels one, two, three, and four must also be specified. If level five is empty, then level six must also be empty. See Level1Attribute for more details.
Level6Attribute	nvarchar	50	If Level six is specified, then levels one, two, three, four, and five must also be specified. See Level1Attribute for more details.
Comment	nvarchar	255	See Comment.
CreatedBy	int	4	See CreatedBy.
CreatedDate	datetime	8	See CreatedDate.
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.
Company	nvarchar	50	See Company.