Configuration Guide for Siebel Offline Client for Life Sciences > Configuration Files, Filter Definitions, and Calculated Expressions > Filter Definitions >
Filter Definition Files Available with the Offline Client for Life Sciences
This topic lists some of the filter definition files available with Siebel CRM and shows some of the important attributes. Filter Definition Files Available with Siebel CRM
See Table 10 for the filter definition files available with Siebel CRM and some of the filter attributes. See Table 11 and Table 12 for additional attributes of the filter definition files.
Table 10. Siebel CRM Filter Definition Files
|
|
Configured Search Specification? |
|
Account |
accountaddressfilter.xml |
No |
Sales |
Account |
accountfilter.xml |
No |
Sales |
Activity |
activitycontactfilter.xml |
No |
Sales |
Activity |
activityfilter.xml |
Yes |
Sales |
Address |
addressfilter.xml |
No |
Sales |
Allocation |
allocationfilter.xml |
Yes |
Sales |
Book |
bookfilter.xml |
No |
Asset Message Planner |
Contact Account |
conactaccountfilter.xml |
No |
Sales |
Contact Address |
contactaddressfilter.xml |
No |
Sales |
Contact Best Times |
contactbesttimesfilter.xml |
No |
Sales |
Contact |
contactfilter.xml |
No |
Sales |
Contact License |
contactlicensefilter.xml |
No |
Sales |
Message Plan Book |
messageplanbookfilter.xml |
No |
Asset Message Planner |
Message Plan |
messageplanfilter.xml |
Yes |
Sales |
Message Plan (AMP) |
messageplanfilter_AMP.xml |
No |
Asset Message Planner |
Message Plan Item |
messageplanitemfilter.xml |
Yes |
Sales, Asset Message Planner |
Message Plan Item Relation |
msgplanitemrelationfilter.xml |
Yes |
Sales |
Message Response |
messageresponsefilter.xml |
Yes |
Sales |
Product |
productfilter.xml |
No |
Sales, Asset Message Planner |
Production Indication |
productindicationfilter.xml |
No |
Sales |
Products Detailed |
productsdetailedfilter.xml |
Yes |
Sales |
Promotional Items Dropped |
pomotionalitemsdroppedfilter.xml |
Yes |
Sales |
PSR Account |
psraccountfilter.xml |
No |
Sales |
PSR Contact |
psrcontactfilter.xml |
No |
Sales |
Related Account |
relatedaccountfilter.xml |
No |
Sales |
Related Contact |
relatedcontactfilter.xml |
No |
Sales |
Related Solution |
relatedsolutionfilter.xml |
No |
Sales |
Retail Objective |
retailobjectivefilter.xml |
No |
Sales |
Revenue |
revenuefilter.xml |
No |
Sales |
Sample Disclaimer |
sampledisclaimerfilter.xml |
Yes |
Sales |
Sample Dropped |
sampledroppedfilter.xml |
Yes |
Sales |
Sample Inventory |
Sampleinventoryfilter.xml |
Yes |
Sales |
Sample Transaction |
sampletransactionfilter.xml |
Yes |
Sales |
Signature |
signaturefilter.xml |
Yes |
Sales |
Solution Book |
solutionbookfilter.xml |
No |
Sales |
Solution |
solutionfilter.xml |
Yes |
Sales |
Solution (AMP) |
solutionfilter_AMP.xml |
No |
Asset Message Planner |
Transaction Item |
transactionitemfilter.xml |
Yes |
Sales |
Table 11 describes additional attributes of the filter definitions available with Siebel CRM.
Table 11. Siebel CRM Filter Definition Files - Additional Attributes
|
|
|
Account |
LSSGOP_Account |
Account |
Account |
LSSGOP_AccountAddress |
AccountAddress |
Activity |
LSSGOP_Activity |
Activity |
Activity |
LSSGOP_ActivityContact |
ActivityContact |
Address |
LSSGOP_Address |
Address |
Allocation |
LSSGOP_PromotionalItemsDropped |
Allocation |
Allocation |
LSSGOP_SampleDropped |
Allocation |
Book |
LSSGOP_CatalogCategory |
Book |
Contact |
LSSGOP_Contact |
Contact |
Contact Account |
LSSGOP_ContactAccount |
ContactAccount |
Contact Address |
LSSGOP_ContactAddress |
ContactAddress |
Contact Best Times |
LSSGOP_ContactBestTimes |
ContactBestTimes |
Contact License |
LSSGOP_ContactLicense |
ContactLicense |
Message Plan |
LSSGOP_MessagePlan |
MessagePlan |
Message Plan (AMP) |
LSSGOP_MessagePlan |
MessagePlan |
Message Plan Item |
LSSGOP_MsgPlanItem |
MsgPlanItem |
Message Plan Item Relation |
LSSGOP_MsgPlanItemRelation |
MsgPlanItemRelation |
Message Response |
LSSGOP_MessageResponse |
MessageResponse |
Product |
LSSGOP_Product |
Product |
Product Indication |
LSSGOP_ProductIndication |
ProductIndication |
Products Detailed |
LSSGOP_ProductsDetailed |
ProductsDetailed |
Promotional Items Dropped |
LSSGOP_PromotionalItemsDropped |
PromotionalItemsDropped |
Related Account |
LSSGOP_RelatedAccount |
RelatedAccount |
Related Contact |
LSSGOP_RelatedContact |
RelatedContact |
Related Solution |
LSSGOP_RelatedLiterature |
RelatedLiterature |
Retail Objective |
LSSGOP_RetailObjective |
RetailObjective |
Revenue |
LSSGOP_Revenue |
Revenue |
Sample Disclaimer |
LSSGOP_SampleDisclaimer |
SampleDisclaimer |
Sample Dropped |
LSSGOP_SampleDropped |
SampleDropped |
Sample Inventory |
LSSGOP_SampleInventory |
SampleInventory |
Sample Transaction |
LSSGOP_SampleTransaction |
SampleTransaction |
Signature |
LSSGOP_Signature |
Signature |
Solution |
LSSGOP_Literature |
Solution |
Solution book |
LSSGOP_LiteratureCatalog |
SolutionCatalog |
Solution (AMP) |
LSSGOP_Literature |
Solution |
Transaction Item |
LSSGOP_TransactionItem |
TransactionItem |
Table 12 shows the search specifications of the filter definitions available with the Sales application for Siebel CRM.
Table 12. Siebel CRM Filter Definitions - Search Specifications
|
|
Activity |
([DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15)) |
Allocation (for Promotional Items Dropped and Sample Dropped) |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15))" |
Message Plan |
([Status]="Released" AND ([EndDate]>TODAY() OR [EndDate]="")) |
Message Plan Item |
([ParentMessagePlanStatus]="Released" AND ([EndDate]>TODAY() OR [EndDate]="")) |
Message Plan Item Relation |
([ParentMessagePlanStatus]="Released" AND ([EndDate]>TODAY() OR [EndDate]=""))"> |
Message Response |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15)) |
Products Detailed |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15)) |
Promotional Items Dropped |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15)) |
Sample Disclaimer |
([Status]="Active") |
Sample Dropped |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15)) |
Sample Inventory |
([ActiveFlag]=TRUE()) |
Sample Transaction |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15))> |
Signature |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15)) |
Solution |
([DistributionMethod]="N" AND [ReleaseDate]<TIMESTAMP() AND ([ExpirationDate]>TODAY() OR [ExpirationDate]="")) |
Transaction Item |
([OwnerId]=CURRENTUSERID() AND [DueDate]>=ADDDAY(TODAY(),-180) AND [DueDate]<=ADDDAY(TODAY(),15)) |
|