MISC SQL Parameter
The following information lists the EIM tables that can be used with the MISC SQL parameter, as well as the values that can be set. The table lists the values of the MISC SQL parameter when you want to set a field explicitly. If you want to set the field implicitly, replace the letters EXPR (EXplicit PRimary) with IMPR (IMplicit PRimary). Note that all separators for values are underscores.
| Table and Primary Child Foreign Key | MISC SQL Parameter Value for Explicit Primary | Corresponding EIM Table | Comments |
|---|---|---|---|
S_PROJ.PR_OU_ADDR_ID |
EXPR_S_PROJ_PR_OU_ADDR_ID |
EIM_PROJECT |
No implicit primary |
S_OPTY.PR_OU_ADDR_ID |
EXPR_S_OPTY_PR_OU_ADDR_ID |
EIM_OPTY |
No implicit primary |
S_OPTY.PR_OU_INDUST_ID |
EXPR_S_OPTY_PR_OU_INDUST_ID |
EIM_OPTY |
None |
S_CONTACT.PR_HELD_POSTN_ID |
EXPR_S_CONTACT_PR_HELD_ POSTN_ID |
EIM_EMPLOYEE |
None |
S_CONTACT.PR_USERROLE_ID |
EXPR_S_CONTACT_PR_ USERROLE_ID |
EIM_USER |
None |
S_CONTACT.PR_OU_ADDR_ID |
EXPR_S_CONTACT_PR_OU_ ADDR_ID |
EIM_CONTACT |
None |
S_POSTN.PR_POSTN_ADDR_ID |
EXPR_S_POSTN_PR_POSTN_ ADDR_ID |
EIM_POSITION |
None |
S_POSTN.PR_EMP_ID |
EXPR_S_POSTN_PR_EMP_ID |
EIM_POSITION |
None |
S_ORG_EXT.PR_BL_PER_ID |
EXPR_S_ORG_EXT_PR_BL_PER_ID |
EIM_ACCOUNT |
None |
S_ORG_EXT.PR_SHIP_PER_ID |
EXPR_S_ORG_EXT_PR_ SHIP_PER_ID |
EIM_ACCOUNT |
None |
S_CONTACT.PR_AFFL_ID |
EXPR_S_CONTACT_PR_AFFL_ID |
EIM_CONTACT |
None |
S_ORG_EXT.PR_BL_PER_ID |
EXPR_SIS_S_ORG_EXT_PR_BL_ PER_ID |
EIM_ACCNT_CUT |
None |
S_ORG_EXT.PR_SHIP_PER_ID |
EXPR_SIS_S_ORG_EXT_PR_SHIP_ PER_ID |
EIM_ACCNT_CUT |
None |
S_ORG_EXT.PR_CON_ID |
EXPR_S_ORG_EXT_PR_CON_ID |
EIM_ACCNT_CUT |
None |
S_POSTN_CON.PR_ADDR_ID |
EXPR_S_POSTN_CON_PR_ ADDR_ID |
EIM_CONTACT1 |
None |
S_ORG_EXT.PR_BL_PER_ID |
EXPR_FINS_S_ORG_EXT_PR_BL_ PER_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_SHIP_PER_ID |
EXPR_FINS_S_ORG_EXT_PR_ SHIP_PER_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_CON_ID |
EXPR_FINS_S_ORG_EXT_PR_ CON_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_BL_OU_ID |
EXPR_S_ORG_EXT_PR_BL_OU_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_SHIP_OU_ID |
EXPR_S_ORG_EXT_PR_SHIP_ OU_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_PAY_OU_ID |
EXPR_S_ORG_EXT_PR_PAY_ OU_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_COMPETITOR_ID |
EXPR_S_ORG_EXT_PR_ COMPETITOR_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_PRTNR_OU_ID |
EXPR_S_ORG_EXT_PR_PRTNR_OU_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_EXT.PR_EMP_REL_ID |
EXPR_FINS_S_ORG_EXT_PR_EMP_REL_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_BU.PR_BL_PER_ID |
EXPR_S_ORG_BU_PR_BL_PER_ID |
EIM_FN_ACCNT1 |
None |
S_ORG_BU.PR_SHIP_PER_ID |
EXPR_S_ORG_BU_PR_SHIP_PER_ID |
EIM_FN_ACCNT1 |
None |
S_CONTACT.PR_HELD_POSTN_ID |
EXPR_FINS_S_CONTACT_PR_HELD_POSTN_ID |
EIM_FN_CONTACT1 |
None |
S_ASSET.PR_ASSET_ID |
EXPR_S_ASSET_PR_ASSET_ID |
EIM_FN_ASSET1 |
None |
S_ORG_GROUP.PR_ADDR_PER_ID |
EXPR_S_ORG_GROUP_PR_ADDR_PER_ID |
EIM_FN_ORGGRP |
None |
S_PROD_INT_TNTX.PR_CATEGORY_ID |
EXPR_S_PROD_INT_TNTX_PR_CATEGORY_ID |
EIM_PRDINT_TNT |
None |
S_QUOTE_TNTX.PR_ORDER_ID |
EXPR_S_QUOTE_TNTX_PR_ORDER_ID |
EIM_QUOTE_TNT |
None |
If you always want to use explicit primaries, follow this syntax:
MISC SQL = EXPR_S_CONTACT_PR_OU_ADDR_ID
If you always want to use implicit primaries, follow this syntax:
MISC SQL = IMPR_S_CONTACT_PR_OU_ADDR_ID
The most flexible method is to use explicit primaries on the records for which you have specified a primary, and to automatically use implicit primaries on the records where you have not specified a primary. The following example shows this syntax:
MISC SQL = EXPR_S_CONTACT_PR_OU_ADDR_ID, IMPR_S_CONTACT_PR_OU_ADDR_ID
For more information on how to use the MISC SQL parameter, see
the sample default.ifb file located in the Siebel Server/admin directory.