QuickCode Lookup Types (Oracle Sales and Marketing Help)


	Previous	Next		Contents	Index	Navigation		Library

QuickCode Lookup Types

This section includes all Oracle Sales and Marketing QuickCode lookup types and any default value furnished with the product. A No or Yes in the User Maintained column indicates whether the value is updatable and viewable at the user level.

Your Setup menu also includes a separate category called Receivables QuickCodes. These QuickCodes are differentiated because they are set within Oracle Accounts Receivable. Though, it is necessary to set the Accounts Receivable QuickCodes, the values and settings are not discussed here.

Lookup Type Lookup Value Comments User Maintained?

Access Privilege Territory or Full A user has access to a Territory or access to all territories. Provides LOV for Access Privilege profile option No

Access Type Account
Account and Lead
Lead LOV for access when defining territory types. No

Advertisement Status User created list of values Suggested values include: Yes

C Cancelled

P Planned

S Scheduled

U Unscheduled

Amount Scaling In Thousands
Millions LOV for Amount Scaling profile option No

Astata_Run_Mode New
Restart
Total LOV for Territory concurrent program No

ASXCSPMR Navigation Fields Address ID
Contact Last Name
Contact Number
Contact Name
Customer Number These values are options for the Process Mail Response window. No

Blitz_Status Cancelled
Complete
Scheduled Not configurable. The application expects one of these values. No

Blitz_Type Call Blitz
Mail Blitz Not configurable. The application expects one of these values. No

Close_Reason User created list of values Enter a list of values that are meaningful to your site, such as:
C Competition
F Functionality
P Price Yes

Collateral Fulfillment Method FH Fulfillment House
N Neither
OE Order Entry LOV for Collateral Fulfillment Method profile option. No

Collateral Request Status B Backordered
C Completed
CA Cancelled
E Error
I In Process
P Pending
PS Partial Shipment
R Ready
RJ Rejected
S Shipped Set at site level in System Profile. No

Collateral Status B Backordered
I In Stock
K Collateral Kit
O Obsolete
Personal_Kit
Public_Kit
U Unknown Set at site level in System Profile. No

Competitor User-maintained list of values Enter a list of competing companies for opportunities Yes

Contact Degree User-maintained list of values Enter a list of possible educational degrees a contact may have earned. Yes

Contact Education Type User-maintained list of values Enter a list of possible educational types that describe a contact. Yes

Contact Family Event User-maintained list of values Enter a list of contact family events such as birthdays or anniversaries, that you may want to remember. Yes

Contact Military Branch User-maintained list of values Enter contact's military service, if any. Yes

Contact Relations User-maintained list of values Enter all possible family relationships important to your contact knowledge. Yes

Contact Sport User-maintained list of values Enter a list of sports enjoyed by your contacts Yes

Contact Trait User-maintained list of values Enter a list of traits that are important for others to observe when dealing with contact. Examples:
Humor
No Humor
Sharp
Soft Spoken Yes

Date Format dd mon yyyy
day month year
month day year Not configurable. The application expects one of these values. No

Delivery Method E Email
F Fax
FH Fulfillment House
M Manual Shipment
OE Order Entry Not configurable. No

Department Code User-maintained list of values Enter a list of department codes. Example:
Physics
Purchasing
Textiles
Chemistry
IS Yes

Environment Application User-maintained list of values Enter a list of possible applications contacts may be using. Example:
ASK-MANMAN
Excel
Lotus
OE-SAP Yes

Environment Category User-maintained list of values Enter a list of possible categories of applications contacts may be using. Example:
Email
Finapps
Other Yes

Environment Database User-maintained list of values Enter a list of possible databases your contacts are working with. Example:
Oracle
ASK
Informix
Ingres
Sybase Yes

Environment Hardware User-maintained list of values Enter a list of possible machines your contacts are working on. Example:
HP-9000
IBM6000
VAX-6000 Yes

Event Enrollment Status Attended
Cancelled
Confirmed
Enrolled
No Show
Waitlisted
Walk In Not configurable. The application expects one of these values. No

Event Facility Type User-maintained list of values Enter a list of event facilities. Example:
Convention Center
Hotel
Inhouse
University Yes

Event Letter Type Specified Date
Status Change Not configurable. The application expects one of these values. No

Event Status Cancelled
Complete
Planned
Scheduled Not configurable. The application expects one of these values. No

Field Validation Free Text
Validate Let users enter free text or limit to LOV. No

Flag Y Flags set
N No flags set Set at Site level through System Profile. No

Freight Carrier User-maintained list of values such as:
DHL
Fedex
UPS Enter the list of freight carriers used at your site. Yes

Freight Carrier Source OE Oracle Order Entry
OSM Oracle Sales and Marketing Not configurable. The application expects one of these values. No

Generate Keys Mode Address
Contact
Customer Argument for Generate Customer Keys concurrent program No

Interaction Type Collateral
Event
Inbound
Mail In Response
Mail Blitz
Outbound
Visit Not configurable. The application expects one of these values. No

Interest Status User-maintained list of values Status for interest type. Example:
Downsizing
Evaluating
Installed
Rejected
Upgrading
Obsolete Yes

Interest Use Company
Classification
Contact Interest
Lead Classification Not configurable. The application expects one of these values. No

Issue User-maintained list of values Issue related to a lead or opportunity. Example:
Performance
Price
Size
Support Yes

Language User-maintained list of values-a full list of languages is provided and can be enabled or disabled Language of the contact. Yes

Lead Channel User-maintained list of values Sales channel for a lead or opportunity. Yes

Lead Status Dealer
Expired
Forecasted
Lost
No Opportunity
Preliminary
Upside
Won Not configurable. The application expects one of these values. No

Letter Template Event
Generic Not configurable. The application expects one of these values. No

List Type Account
Contact
Lead
One Time Not configurable. The application expects one of these values. No

Media Type User-maintained list of values such as:
EDI Electronic Data
I Interchange
F Fax
NP Newspaper
R Radio
TV Television Types of advertisement media. Yes

Month 01 = January
ascending to
12 = December Numerical values assigned to months No

Note Source Account Comment
Company Comment
System Generated
User Entered Note Not configurable. The application expects one of these values. No

Notification Type F Fulfillment Request
L Lead Not configurable. The application expects one of these values. No

Opportunity Probability Link Error
Warning Not configurable. The application expects one of these values. No

Pre-Defined Action Types CL Create Lead
EE Enroll for Event
PI Contact Interest
SC Send Collateral Not configurable. The application expects one of these values. No

Processing Status CA Cancelled
CO Complete
I In Process
R Ready Not configurable. The application expects one of these values. No

Promotion Status User maintained list of values such as:
Completed
Expecting
Planning Enter a list of promotional status. Yes

Promotion Type A Advertisement
B Blitz
C Collateral
E Event
L Letter
P Program
S Script Not configurable. The application expects one of these values. No

Publication Type Example:
Financial
Home
Technical Enter a list of publications in which your advertisements appear, or a source of opportunity. Yes

Qualifier Format C Character
M Money
N Number Not configurable. The application expects one of these values. No

Qualifier Type D Discrete
M Template
R Range Not configurable. The application expects one of these values. No

Rank (Level of importance) 1 Very High
2 High
3 Moderate
4 Low
5 Very Low Not configurable. The application expects one of these values. No

Salesforce Relationship None specified Enter internal codes or descriptions of business unit relationships your salesforce is likely to have with customers. No

Salesforce Role Account Manager Enter a list of possible responsibilities an employee is likely to have with respect to a given sale. No

Salesforce Type Employee
Partner Not configurable. The application expects one of these values. No

Script Type C Call
M Mail Not configurable. The application expects one of these values. No

Time Format 24HR format
AM/PM format Not configurable. The application expects one of these values. No

Word Replacement Type Address
Customer
First Name
Key
Last Name
Name Not configurable. Choose a first key field for the Customer Key Word replacement program. The application expects one of these values. No

Worksheet Region Account
Collateral
Contact
Enter Forecast
Note
Opportunity
To Do
View Forecast This quickcode fills a list of values for the profile option OSM: Initial Worksheet Region. That profile determines which worksheet appears on top when file tab windows are arranged in the Telemarketing Workbench window. No

Blank User-Maintained
QuickCode Screen Undetermined Not set Yes

Table A - 10. QuickCode Lookup Types (Page 9 of 9)

Lookup Type	Lookup Value	Comments	User Maintained?

Access Privilege	Territory or Full	A user has access to a Territory or access to all territories. Provides LOV for Access Privilege profile option	No
Access Type	Account Account and Lead Lead	LOV for access when defining territory types.	No
Advertisement Status	User created list of values	Suggested values include:	Yes
		C Cancelled
		P Planned
		S Scheduled
		U Unscheduled
Amount Scaling In	Thousands Millions	LOV for Amount Scaling profile option	No
Astata_Run_Mode	New Restart Total	LOV for Territory concurrent program	No
ASXCSPMR Navigation Fields	Address ID Contact Last Name Contact Number Contact Name Customer Number	These values are options for the Process Mail Response window.	No
Blitz_Status	Cancelled Complete Scheduled	Not configurable. The application expects one of these values.	No
Blitz_Type	Call Blitz Mail Blitz	Not configurable. The application expects one of these values.	No
Close_Reason	User created list of values	Enter a list of values that are meaningful to your site, such as: C Competition F Functionality P Price	Yes
Collateral Fulfillment Method	FH Fulfillment House N Neither OE Order Entry	LOV for Collateral Fulfillment Method profile option.	No
Collateral Request Status	B Backordered C Completed CA Cancelled E Error I In Process P Pending PS Partial Shipment R Ready RJ Rejected S Shipped	Set at site level in System Profile.	No
Collateral Status	B Backordered I In Stock K Collateral Kit O Obsolete Personal_Kit Public_Kit U Unknown	Set at site level in System Profile.	No
Competitor	User-maintained list of values	Enter a list of competing companies for opportunities	Yes
Contact Degree	User-maintained list of values	Enter a list of possible educational degrees a contact may have earned.	Yes
Contact Education Type	User-maintained list of values	Enter a list of possible educational types that describe a contact.	Yes
Contact Family Event	User-maintained list of values	Enter a list of contact family events such as birthdays or anniversaries, that you may want to remember.	Yes
Contact Military Branch	User-maintained list of values	Enter contact's military service, if any.	Yes
Contact Relations	User-maintained list of values	Enter all possible family relationships important to your contact knowledge.	Yes
Contact Sport	User-maintained list of values	Enter a list of sports enjoyed by your contacts	Yes
Contact Trait	User-maintained list of values	Enter a list of traits that are important for others to observe when dealing with contact. Examples: Humor No Humor Sharp Soft Spoken	Yes
Date Format	dd mon yyyy day month year month day year	Not configurable. The application expects one of these values.	No
Delivery Method	E Email F Fax FH Fulfillment House M Manual Shipment OE Order Entry	Not configurable.	No
Department Code	User-maintained list of values	Enter a list of department codes. Example: Physics Purchasing Textiles Chemistry IS	Yes
Environment Application	User-maintained list of values	Enter a list of possible applications contacts may be using. Example: ASK-MANMAN Excel Lotus OE-SAP	Yes
Environment Category	User-maintained list of values	Enter a list of possible categories of applications contacts may be using. Example: Email Finapps Other	Yes
Environment Database	User-maintained list of values	Enter a list of possible databases your contacts are working with. Example: Oracle ASK Informix Ingres Sybase	Yes
Environment Hardware	User-maintained list of values	Enter a list of possible machines your contacts are working on. Example: HP-9000 IBM6000 VAX-6000	Yes
Event Enrollment Status	Attended Cancelled Confirmed Enrolled No Show Waitlisted Walk In	Not configurable. The application expects one of these values.	No
Event Facility Type	User-maintained list of values	Enter a list of event facilities. Example: Convention Center Hotel Inhouse University	Yes
Event Letter Type	Specified Date Status Change	Not configurable. The application expects one of these values.	No
Event Status	Cancelled Complete Planned Scheduled	Not configurable. The application expects one of these values.	No
Field Validation	Free Text Validate	Let users enter free text or limit to LOV.	No
Flag	Y Flags set N No flags set	Set at Site level through System Profile.	No
Freight Carrier	User-maintained list of values such as: DHL Fedex UPS	Enter the list of freight carriers used at your site.	Yes
Freight Carrier Source	OE Oracle Order Entry OSM Oracle Sales and Marketing	Not configurable. The application expects one of these values.	No
Generate Keys Mode	Address Contact Customer	Argument for Generate Customer Keys concurrent program	No
Interaction Type	Collateral Event Inbound Mail In Response Mail Blitz Outbound Visit	Not configurable. The application expects one of these values.	No
Interest Status	User-maintained list of values	Status for interest type. Example: Downsizing Evaluating Installed Rejected Upgrading Obsolete	Yes
Interest Use	Company Classification Contact Interest Lead Classification	Not configurable. The application expects one of these values.	No
Issue	User-maintained list of values	Issue related to a lead or opportunity. Example: Performance Price Size Support	Yes
Language	User-maintained list of values-a full list of languages is provided and can be enabled or disabled	Language of the contact.	Yes
Lead Channel	User-maintained list of values	Sales channel for a lead or opportunity.	Yes
Lead Status	Dealer Expired Forecasted Lost No Opportunity Preliminary Upside Won	Not configurable. The application expects one of these values.	No
Letter Template	Event Generic	Not configurable. The application expects one of these values.	No
List Type	Account Contact Lead One Time	Not configurable. The application expects one of these values.	No
Media Type	User-maintained list of values such as: EDI Electronic Data I Interchange F Fax NP Newspaper R Radio TV Television	Types of advertisement media.	Yes
Month	01 = January ascending to 12 = December	Numerical values assigned to months	No
Note Source	Account Comment Company Comment System Generated User Entered Note	Not configurable. The application expects one of these values.	No
Notification Type	F Fulfillment Request L Lead	Not configurable. The application expects one of these values.	No
Opportunity Probability Link	Error Warning	Not configurable. The application expects one of these values.	No
Pre-Defined Action Types	CL Create Lead EE Enroll for Event PI Contact Interest SC Send Collateral	Not configurable. The application expects one of these values.	No
Processing Status	CA Cancelled CO Complete I In Process R Ready	Not configurable. The application expects one of these values.	No
Promotion Status	User maintained list of values such as: Completed Expecting Planning	Enter a list of promotional status.	Yes
Promotion Type	A Advertisement B Blitz C Collateral E Event L Letter P Program S Script	Not configurable. The application expects one of these values.	No
Publication Type	Example: Financial Home Technical	Enter a list of publications in which your advertisements appear, or a source of opportunity.	Yes
Qualifier Format	C Character M Money N Number	Not configurable. The application expects one of these values.	No
Qualifier Type	D Discrete M Template R Range	Not configurable. The application expects one of these values.	No
Rank (Level of importance)	1 Very High 2 High 3 Moderate 4 Low 5 Very Low	Not configurable. The application expects one of these values.	No
Salesforce Relationship	None specified	Enter internal codes or descriptions of business unit relationships your salesforce is likely to have with customers.	No
Salesforce Role	Account Manager	Enter a list of possible responsibilities an employee is likely to have with respect to a given sale.	No
Salesforce Type	Employee Partner	Not configurable. The application expects one of these values.	No
Script Type	C Call M Mail	Not configurable. The application expects one of these values.	No
Time Format	24HR format AM/PM format	Not configurable. The application expects one of these values.	No
Word Replacement Type	Address Customer First Name Key Last Name Name	Not configurable. Choose a first key field for the Customer Key Word replacement program. The application expects one of these values.	No
Worksheet Region	Account Collateral Contact Enter Forecast Note Opportunity To Do View Forecast	This quickcode fills a list of values for the profile option OSM: Initial Worksheet Region. That profile determines which worksheet appears on top when file tab windows are arranged in the Telemarketing Workbench window.	No
Blank User-Maintained QuickCode Screen	Undetermined	Not set	Yes
Table A - 10. QuickCode Lookup Types (Page 9 of 9)

Contents

Index

Navigation

Library