GRD_PRODDET Grid Component

Purpose

The application administrator uses the GRD_PRODDET grid component to maintain the details of a product listing. It is accessible from the GRD_HISTQUAN grid component, which is a list of cumulative unit product sales.

The GRD_PRODDET grid component [Picture]

Description

The GRD_PRODDET component is an editable columnar grid based on a view which incorporates fields from the product, product_category, and vendor tables. Vendor and category are filled by their lookups and are not editable.

Containers

ASWPRODONE.A5W

Notable Grid Control Property Settings

Control	Property	Description
Vendor	Lookup > Lookup	"True"
	Lookup > Lookup definition	Lookup Window > Grid name = "grd_lkven" Field Mapping > Field map = "Vendor<Vendor_id,Vendname<Name"
	Row Properties > Freeform layout	"True"
	Row Properties > Freeform template	Vendor is from the product table. Vendname is from the vendor table. {Vendname} {Vendor}
Vendname	Row Properties > Hide row	"True"
Cat_Id	Lookup > Lookup	"True"
	Lookup > Lookup definition	Lookup Window > Grid name = "grd_lkcats" Field Mapping > Field map = "Cat_id<Cat_id,Category<Category"
	Row Properties > Freeform layout	"True"
	Row Properties > Freeform template	Category is from the product_category table. Cat_Id is from the product table. {Category} {Cat_Id}
Category	Row Properties > Hide row	"True"
Ship_Avail	Display Settings > Control type	"DropDownBox"
Ship_Avail	DropDownBox Properties > Choices	Page code redefines the contents of the list box. Define Choices > List Type = "Static" Define Choices > Choices = "1 to 2"
Thumb	Image Properties > Image path	"[PathAlias.ADB_Path]"