ColumnName |
Domain |
Datatype |
NULL |
Definition |
COMPANY_ID |
|
VARCHAR2(10) |
NO |
|
DFLT_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
|
DFLT_UDT01_TYPE_CD |
|
VARCHAR2(10) |
NO |
|
DFLT_ROLE_CD |
|
VARCHAR2(20) |
NO |
|
S_DFLT_DATE_EDIT_CD |
|
VARCHAR2(1) |
NO |
|
S_LINK12_CD |
|
VARCHAR2(1) |
NO |
|
S_LINK17_CD |
|
VARCHAR2(1) |
NO |
|
S_LINK19_CD |
|
VARCHAR2(1) |
NO |
|
S_LINK27_CD |
|
VARCHAR2(1) |
NO |
|
S_LINK29_CD |
|
VARCHAR2(1) |
NO |
|
S_LINK93_CD |
|
VARCHAR2(1) |
NO |
|
SHOW_EMPL_ID_FL |
|
VARCHAR2(1) |
NO |
|
LOGO_NAME_DIR_S |
|
VARCHAR2(254) |
YES |
|
BRANDING_NAME_DIR_S |
|
VARCHAR2(254) |
YES |
|
SPLASH_NAME_DIR_S |
|
VARCHAR2(254) |
YES |
|
SYSTEM_MAIL_ADDRESS_S |
|
VARCHAR2(254) |
YES |
|
SMTP_SERVER_ADDRESS_S |
|
VARCHAR2(30) |
YES |
|
RETRY_ADD_UPDATE_FL |
|
VARCHAR2(1) |
NO |
|
ASCII_IMPORT_FL |
|
VARCHAR2(1) |
NO |
|
XML_IMPORT_FL |
|
VARCHAR2(1) |
NO |
|
TABLE_IMPORT_FL |
|
VARCHAR2(1) |
NO |
|
IMPORT_INTERVAL_HRS |
|
NUMBER(5, 0) |
NO |
|
IMPORT_INTERVAL_MINS |
|
NUMBER(5, 0) |
NO |
|
IMPORT_START_HRS |
|
NUMBER(5, 0) |
NO |
|
IMPORT_START_MINS |
|
NUMBER(5, 0) |
NO |
|
S_IMPORT_START_CD |
|
VARCHAR2(2) |
NO |
|
IMPORT_LOCATION_S |
|
VARCHAR2(254) |
YES |
|
TRASH_IMPORT_LOCATION_S |
|
VARCHAR2(254) |
YES |
|
S_IMPORT_STATUS_CD |
|
VARCHAR2(4) |
NO |
|
EXPORT_LOCATION_S |
|
VARCHAR2(254) |
YES |
|
CP_MULTI_COMPANY_FL |
|
VARCHAR2(1) |
NO |
|
UDT01_ABBRV_FL |
|
VARCHAR2(1) |
NO |
|
UDT02_ABBRV_FL |
|
VARCHAR2(1) |
NO |
|
UDT09_ABBRV_FL |
|
VARCHAR2(1) |
NO |
|
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
|
ROWVERSION |
|
NUMBER(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|
SMTP_USER_ID |
|
VARCHAR2(20) |
YES |
|
SMTP_PASSWORD |
|
VARCHAR2(20) |
YES |
|
DFLT_S_NOTIFY_METHOD_CD |
|
VARCHAR2(1) |
NO |
|
DISPLAY_ABBRV_FL |
|
VARCHAR2(1) |
NO |
|
SERVER_TIME_ZONE_CD |
|
VARCHAR2(35) |
NO |
|
RESTRICT_DELEGATION_FL |
|
VARCHAR2(1) |
NO |
|
TS_PRE_SAVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
TS_POST_SAVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
SMTP_PORT_NO |
|
NUMBER(10, 0) |
NO |
|
TS_PRE_SIGN_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
TS_POST_SIGN_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
TS_POST_APPROVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
ER_PRE_SIGN_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
ER_POST_SIGN_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
ER_EXP_PRE_SAVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
ER_EXP_POST_SAVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
TIME_MAIL_ADDRESS_S |
|
VARCHAR2(254) |
YES |
|
EXPENSE_MAIL_ADDRESS_S |
|
VARCHAR2(254) |
YES |
|
SELF_SERVICE_MAIL_ADDRESS_S |
|
VARCHAR2(254) |
YES |
|
SHOW_EMPL_ID_WORKFLOW_FL |
|
VARCHAR2(1) |
NO |
|
COSTPOINT_LINK_FL |
|
VARCHAR2(1) |
NO |
|
S_CHARGE_LOOKUP_SOURCE_CD |
|
VARCHAR2(10) |
NO |
|
S_PROJECT_LEVEL1_CD |
|
VARCHAR2(20) |
NO |
|
S_PROJECT_LEVEL2_CD |
|
VARCHAR2(20) |
NO |
|
S_PROJECT_LEVEL3_CD |
|
VARCHAR2(20) |
NO |
|
S_MO_LEVEL1_CD |
|
VARCHAR2(20) |
NO |
|
S_MO_LEVEL2_CD |
|
VARCHAR2(20) |
NO |
|
S_MO_LEVEL3_CD |
|
VARCHAR2(20) |
NO |
|
S_ACCT_LEVEL1_CD |
|
VARCHAR2(20) |
NO |
|
S_ACCT_LEVEL2_CD |
|
VARCHAR2(20) |
NO |
|
S_ACCT_LEVEL3_CD |
|
VARCHAR2(20) |
NO |
|
CP_PROJECT_STRUCTURE_FL |
|
VARCHAR2(1) |
NO |
|
CP_PROJECT_MIN_ID_FILTER_NO |
|
NUMBER(10, 0) |
NO |
|
CP_MO_MIN_ID_FILTER_NO |
|
NUMBER(10, 0) |
NO |
|
CP_ACCOUNT_MIN_ID_FILTER_NO |
|
NUMBER(10, 0) |
NO |
|
CP_PROJECT_MIN_DESC_FILTER_NO |
|
NUMBER(10, 0) |
NO |
|
CP_MO_MIN_DESC_FILTER_NO |
|
NUMBER(10, 0) |
NO |
|
CP_ACCOUNT_MIN_DESC_FILTER_NO |
|
NUMBER(10, 0) |
NO |
|
S_PROJECT_USER_CODE1_CD |
|
VARCHAR2(20) |
NO |
|
S_PROJECT_USER_CODE2_CD |
|
VARCHAR2(20) |
NO |
|
S_PROJECT_USER_CODE3_CD |
|
VARCHAR2(20) |
NO |
|
S_MO_USER_CODE1_CD |
|
VARCHAR2(20) |
NO |
|
S_MO_USER_CODE2_CD |
|
VARCHAR2(20) |
NO |
|
S_MO_USER_CODE3_CD |
|
VARCHAR2(20) |
NO |
|
S_ACCOUNT_USER_CODE1_CD |
|
VARCHAR2(20) |
NO |
|
S_ACCOUNT_USER_CODE2_CD |
|
VARCHAR2(20) |
NO |
|
S_ACCOUNT_USER_CODE3_CD |
|
VARCHAR2(20) |
NO |
|
CP_CREATE_PROJECT_ROLE_FL |
|
VARCHAR2(1) |
NO |
|
CP_CREATE_MO_ROLE_FL |
|
VARCHAR2(1) |
NO |
|
S_CP_PROJECT_DESC_CD |
|
VARCHAR2(1) |
NO |
|
S_CP_MO_DESC_CD |
|
VARCHAR2(1) |
NO |
|
TS_PRE_APPROVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
EA_PRE_SAVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
EA_POST_SAVE_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
EA_PRE_SIGN_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
EA_POST_SIGN_SP_NAME_S |
|
VARCHAR2(128) |
YES |
|
S_BLACKBERRY_MESSAGES_LOC |
|
VARCHAR2(254) |
YES |
|
MOBILE_MAX_ROW_NO |
|
NUMBER(10, 0) |
NO |
|
ALLOW_MOBILE_PIN_FL |
|
VARCHAR2(1) |
NO |
|
FAX_ATTACH_FL |
|
VARCHAR2(1) |
NO |
|
CUSTOM1_FL |
|
VARCHAR2(1) |
NO |
|
EMAIL_PASSWORD_FL |
|
VARCHAR2(1) |
NO |
|
IMPORT_SERVER_ID |
|
VARCHAR2(254) |
YES |
|
ATTACH_FILE_TYPES |
|
VARCHAR2(254) |
YES |
|
ALLOW_MOBILE_ACCESS_FL |
|
VARCHAR2(1) |
NO |
|
ALLOW_MOBILE_TIME_ACCESS_FL |
|
VARCHAR2(1) |
NO |
|
ALLOW_MOBILE_EXPENSE_ACCESS_FL |
|
VARCHAR2(1) |
NO |
|
ALLOW_AMEX_IMPORT_FL |
|
VARCHAR2(1) |
NO |
|
ALLOW_VISA_IMPORT_FL |
|
VARCHAR2(1) |
NO |
|