Table 7. Default PDQs for eConsumer Goods
Business Object
|
PDQ Name
|
PDQ Value
|
Account
|
PDADef_All Accounts
|
'Account'.Search = ""'Account'.Sort = "Name, Location"
|
Action
|
PDADef_All Calendar Activities
|
'Action'.Search = ""'Action'.Sort = "Due (DESCENDING)"
|
CPG Routes
|
PDADef_Active Routes
|
'CPG Routes'.Search = "[Active] = ""Y"""'CPG Routes'.Sort = "Route Name"
|
Contact
|
PDADef_All Contacts
|
'Contact'.Search = ""
|
Cycle Counting
|
PDADef_Today Open Cycle Counts
|
'Cycle Counting'.Search = "[Status] = LookupValue(""FS_CYC_CNT_STATUS"", ""Open"") OR [Status] = LookupValue(""FS_CYC_CNT_STATUS"", ""Assigned"") AND [Due Date] = Today()" 'Cycle Counting'.Sort = "Due Date"
|
In Store Visit
|
PDADef_*Today Not Started Visits
|
'In Store Visit'.Search = "[Start Date] = Today() AND [Status] = LookupValue ( ""EVENT_STATUS"", ""Not Started"" )"
|
Internal Product
|
PDADef_Orderable Products
|
'Internal Product'.Search = "[Orderable] = ""Y"""'Internal Product'.Sort = ""
|
Order Entry (Sales)
|
PDADef_Open Orders
|
'Order Entry - Orders'.Search = "[Status] <> LookupValue(""FS_ORDER_STATUS"",""Closed"") AND [Status] <> LookupValue(""FS_ORDER_STATUS"",""Cancelled"")"
|
SIS HH FS Invoice - CE
|
PDADef_Open Billings
|
'FS Invoice'.Search = "[Status] = LookupValue ( ""PS_SUBCONTRACTOR_STATUS"", ""Open"" ) or [Status] = LookupValue (""PS_SUBCONTRACTOR_STATUS"", ""Partially Paid"" )"
|
Price List
|
PDADef_Current Price Lists
|
'Price List'.Search = "[End Date] > Today()"'Price List'.Sort = "Name"
|