Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide > EIM Configuration File > Sample SQL Scripts > DB2 Sample SQL Scriptinsert into Siebel.EIM_ACCOUNT (ROW_ID, IF_ROW_BATCH_NUM,IF_ROW_STAT, PARTY_UID, PARTY_TYPE_CD, ROOT_PARTY_FLG,PARTY_NAME, NAME, MAIN_PH_NUM, LOC, ACCNT_BU, ACTIVE_FLG, DISA_CLEANSE_FLG, EVT_LOC_FLG, FCST_ORG_FLG, INT_ORG_FLG, PROSPECT_FLG, PRTNR_FLG, PRTNR_PUBLISH_FLG, RPLCD_WTH_CMPT_FLG, SKIP_PO_CRDCHK_FLG) ('100', '100','FOR_IMPORT', 'AUID1', 'ACD1', 'Y', 'Party1', 'Account1', '6505511784','HQ', 'Default Organization', 'Y', 'Y','Y','Y','Y','Y', 'Y','Y','Y','Y'); insert into Siebel.EIM_CONTACT (ROW_ID, IF_ROW_BATCH_NUM, IF_ROW_STAT, PARTY_UID, PARTY_TYPE_CD, ROOT_PARTY_FLG, ADDR_NAME, DEPT_ACCNT_BU, DEPT_ACCNT_LOC, DEPT_ACCNT_NAME, CON_PERSON_UID, CON_BU, CON_ACTIVE_FLG, CON_DISACLEANSEFLG, CON_DISPIMGAUTHFLG, CON_EMAILSRUPD_FLG, CON_EMP_FLG, CON_FST_NAME, CON_LAST_NAME, CON_PO_PAY_FLG, CON_PRIV_FLG, CON_PROSPECT_FLG, CON_PTSHPCONTACTFL, CON_PTSHPKEYCONFLG, CON_SUPPRESSEMAILF, CON_SUPPRESSFAXFLG, CLINT_ACCNT_BU, CLINT_ACCNT_LOC, CLINT_ACCNT_NAME, PP_PARTY_TYPE_CD, PP_PARTY_UID, PP_REF_FLG, PP_START_DT) ('200', '200', 'FOR_IMPORT', 'CUID1', 'CCD1', 'Y', 'Address1', 'Default Organization', 'HQ', 'Account1', 'CONUID1', 'Default Organization', 'Y','Y','Y','Y','Y','Tom','Hanks', 'Y','Y','Y','Y','Y','Y','Y','Default Organization', 'CrossRoads', 'Account2', 'ACD1', 'AUID1', 'Y', '2000-05-17-15.40.55.000000'); |
![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |