sf到客户

1.cstguid导客户信息

SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_141 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_142 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_143 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_144 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_145 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_146 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_147 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_148 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_149 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_150 a where CstGUID in 
(SELECT `code` FROM `21xian`);
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_151 a where CstGUID in 
(SELECT `code` FROM `21xian`);

2.mapping

SELECT * from cst_CstGUIDMapping_0 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_1 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_2 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_3 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_4 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_5 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_6 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_7 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_8 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_9 where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_A where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_B where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_C where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_D where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_E where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);
SELECT * from cst_CstGUIDMapping_F where CstGUID in  (SELECT DISTINCT wcode FROM `21xian`);







SELECT * from prm_Agent_Cst_Recommed_150 where CstGUID='150308164'