GRD_HISTCUST Grid Component

Purpose

Application administrators use the GRD_HISTCUST grid component to review customer sales.

Description

The GRD_HISTCUST component is a read-only tabular grid based on a view that combines the sales_summary_cust and customer tables. The GRD_HISTCUST component is a child grid in the TGRDL_HIST tabbed gridlinker, which is located on the ASWSALESHIST.A5W page.

The entries in the Last Sale and Customer columns are links to the ASWINVDET.A5W and AWSCUSTDET.A5W tables.

The GRD_HISTCUST component has two calculated fields. The TGRDL_HIST tabbed gridlinker uses the link field to link the GRD_CUSTLIST grid to GRD_HISTCUST.

link = "1"

cname = alltrim(Customer->Lastname) + ", " + alltrim(Customer->Firstname)

Containers

ASWSALESHIST.A5W, TGRDL_HIST

Notable Grid Control Property Settings

Control	Property	Description
Link	Column Properties > Hide column	"True"
Last_Invoice_Number	Column Properties > Hide column	"True"
Last_Date	Display Settings > Control type	"Link"
	Display Settings > Link address type	"Computed from fields in the Grid"
	Display Settings > Link address	Opens the ASWINVDET.A5W page with the record that matches the record's last_invoice_number. aswinvdet.a5w?inv={Last_Invoice_Number}
Cname	Display Settings > Control type	"Link"
	Display Settings > Link address type	"Computed from fields in the Grid"
	Display Settings > Link address	Opens the AWSCUSTDET.A5W page with the record that matches the record's customer_id. aswcustdet.a5w?cid={Customer_Id}
Last_Invoice_Number	Column Properties > Hide column	"True"
Customer_Id	Column Properties > Hide column	"True"