ZBS_BU_PROFILE_OPTION

Details

Schema: FUSION
Object owner: ZBS
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
ZBS_BU_PROFILE_OPTION_VAL_PK	BU_ORG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BU_ORG_ID	NUMBER			Yes	BU_ORG_ID
PROFILE_OPTION_NUMBER	VARCHAR2	64		Yes	Alternate Key
FUNCTION_ID	NUMBER				FUNCTION_ID
MOO_CLOSE_COMP_REQD	VARCHAR2	20			Specify whether a primary competitor is required on an opportunity when closing it and whether a competitor is required on a revenue line when saving it in a closed status.
MOO_CLOSE_WINLOSS_REQD	VARCHAR2	20			Specify whether a win/loss reason is required on an opportunity when closing it and whether a win/loss reason is required on a revenue line when closing it.
MOO_DEFAULT_SALES_METHOD	VARCHAR2	64			Specify the default sales method for the business unit. The value specified will be used when creating a new opportunity.
MOO_DEFAULT_SALES_METHOD_EXPAN	VARCHAR2	64			The default sales method that will be selected for expansion.
MOO_DEFAULT_SALES_METHOD_RENEW	VARCHAR2	64			The default sales method that will be selected for renewal.
MOO_ENABLE_CLOSE_OPTY_FLOW	VARCHAR2	20			Indicator for the enable close opportunity flow field on the Sales business unit functions page.
MOO_OPTY_RESOURCE_TBA_STYLE	VARCHAR2	20			Specify if all members of the territory should be added to an opportunity team or just the owner.
MOO_OPTY_SRCH_PANEL_COLLAPSED	VARCHAR2	20			Enable collapsed view of opportunity search panel by default. Set to No to have default view as expanded.
MKL_LEAD_ASSESSMENT_TEMPLATE	VARCHAR2	1000			MKL_LEAD_ASSESSMENT_TEMPLATE
MKL_LEAD_ASSIGNMENT_QUAL_RULE	VARCHAR2	1000			MKL_LEAD_ASSIGNMENT_QUAL_RULE
MKL_LEAD_ASSIGNMENT_RANK_RULE	VARCHAR2	1000			MKL_LEAD_ASSIGNMENT_RANK_RULE
MKL_LEAD_ASSIGNMENT_SCORE_RULE	VARCHAR2	1000			MKL_LEAD_ASSIGNMENT_SCORE_RULE
MKL_LEAD_DEAL_REGN_EXPIRATION	VARCHAR2	20			MKL_LEAD_DEAL_REGISTRATION_EXPIRATION
MKL_LEAD_QUAL_TEMPL_PROFILE	VARCHAR2	1000			MKL_LEAD_QUALIFICATION_TEMPLATE_PROFILE
MKL_LEAD_QUERY_IN_N_DAYS	VARCHAR2	20			MKL_LEAD_QUERY_IN_N_DAYS
MKL_LEAD_REGN_APR_ADM_PROFILE	VARCHAR2	1000			MKL_LEAD_REGISTRATION_APPROVAL_ADMIN_PROFILE
MKL_LEAD_SRCH_CRN_RNG_DEFAULT	VARCHAR2	20			MKL_LEAD_SEARCH_CREATION_RANGE_DEFAULT
MKL_LEAD_SRCH_CRN_RNG_RECMD	VARCHAR2	20			MKL_LEAD_SEARCH_CREATION_RANGE_RECOMMENDED
MKL_LEAD_TO_OPPTY_MAPPING	VARCHAR2	1000			MKL_LEAD_TO_OPPTY_MAPPING
MKL_PRM_LEAD_TO_OPPTY_MAPPING	VARCHAR2	1000			MKL_PRM_LEAD_TO_OPPTY_MAPPING
CONFLICT_ID	NUMBER		18	Yes	Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
USER_LAST_UPDATE_DATE	TIMESTAMP				Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).

Indexes

Index	Uniqueness	Tablespace	Columns
ZBS_BU_PROFILE_OPTION_VAL_U1	Unique	Default	BU_ORG_ID