Igor, Please note that the scripting error occurs when I make the two changes in the user table....I am trying to change "State to UserState and Division to User Division.
SQL SELECT A_R_OK__c,
A_R_Specialist_Collections__c,
Account__c,
Actual_Delivery__c,
Actual_SAD__c,
Additional_Items_Not_main_body__c,
AE__c,
Approved_for_Booking__c,
Apps_Start_Date__c,
Billing_Date__c,
Booked_on_AS400__c,
Booked_on_Flash__c,
BR_Order__c,
Change_Order__c,
City__c,
Complete_Package_Received__c,
ConnectionReceivedId,
ConnectionSentId,
Contact__c,
CreatedById,
CreatedDate,
CSE__c,
Custom_Terms__c,
Customer_Acceptance__c,
Customer_Called__c,
Customer_RAD__c,
Days_to_Book__c,
Deposit__c,
Deposit_Amount__c,
Deposit_Received__c,
Description__c,
Discount__c,
Email_Address__c,
Forecasted_Amount__c,
IC_PM__c,
Id,
Install_Start_Date__c,
Inventory_Ordered__c,
Invoice__c,
IsDeleted,
ISPM__c,
LastActivityDate,
LastModifiedById,
LastModifiedDate,
Main_Body_Total__c,
Name,
Opportunity__c,
Order_Entered_by__c,
Order_Incomplete_Explain__c,
Order_Incomplete_from_Sales__c,
Order_Packet_sent_to_OTR__c,
Order_Received__c,
Order_Rejected_by_OTR__c,
Order_Rejected_by_OTR_Explain__c,
Order_Type__c,
OTR_Specialist_Assigned__c,
Phone_Number__c,
PM_for_Synapse_orders__c,
PM_Release_Date__c,
PO_Date__c,
PO_Number__c,
PO_received_to_Transfer_to_OTR__c,
Process_Alert__c,
Product__c,
Projected_Release__c,
RAD_vs_Actual_Delivery__c,
Reason__c,
Reason_SAD_Missed__c,
RecordTypeId,
Remarks__c,
Resubmitted_to_OTR__c,
Revenue_Recognized__c,
RID__c,
SAD_vs_Actual_Delivery__c,
Ship_Date__c,
Shipped_Amount_Main_Body__c,
SR_Order__c,
State__c,
Status__c,
Submitted_for_Approval__c,
SystemModstamp,
Terms__c,
Total_Back_Order_Amount__c,
Total_Days_PO_to_Delivery__c,
Total_Order_Amount2__c,
Total_Shipped_Amount__c,
Type_of_Contract__c,
Under_Over_250K__c,
Zone__c
FROM Order__c;
SQL SELECT Accepted_Date__c,
AccountId,
Actual_Booked__c,
Actual_Commercial_Booking__c,
Additional_Notes_Exist__c,
Adequacy_of_Current_Postion__c,
Admin_training_completed__c,
Amount,
Annual_Amount__c,
Annual_Service__c,
Approved_By__c,
Assigned_Dealer__c,
Associated_Opportunity__c,
CampaignId,
Capital__c,
Capital_Lease__c,
Capital_Purchase__c,
Close_Date_Rev_Rec__c,
CloseDate,
Common_View__c,
Communication_Module__c,
Competition__c,
Competition_Type__c,
Config_Due__c,
Config_Received__c,
ConnectionReceivedId,
ConnectionSentId,
Contract_Effective_Date__c,
Contract_given_to_Customer__c,
Contract_Negotiation_Comments__c,
Contract_Terms__c,
Contract_Type__c,
ContractEndDate__c,
CreatedById,
CreatedDate,
Credit_Approval__c,
Credit_Comments__c,
Credit_Info_Received__c,
Credit_Info_Requested__c,
Credit_Risk__c,
CRM_Dealer__c,
CRm_Total__c,
CSS__c,
CSS_Comments__c,
Current_Sales_Obstacles__c,
Current_Volume__c,
Customer_RAD__c,
CV_Modalities_Quoted__c,
Data_Migrated__c,
DealLostReason__c,
Delivery_Date__c,
Demo_Completed__c,
Demo_Date_1__c,
Demo_Date_2__c,
Description,
End_User__c,
EST__c,
Exec_Visit_Completed__c,
Exec_Visit_Date__c,
Final_Booked_Amount__c,
Finance_Opportunity__c,
Financial_Analyst_Assigned__c,
First_Synapse_Sale__c,
Fiscal,
FiscalQuarter,
FiscalYear,
ForecastCategory,
Forecasted_for_Revenue__c,
FPS_Lease__c,
FUJI_Financial__c,
Go_Live_Date__c,
Government__c,
Hardware_Installed__c,
HasOpportunityLineItem,
HL7_Fees__c,
HL7_Interface_List__c,
HL7_Interface_Loaded__c,
Hospital_Credit_Approved__c,
Hospital_Credit_Grade__c,
iCAD_Total__c,
Id,
Install_Base_Program__c,
Install_Date__c,
Interface_s_tested__c,
Invoice_or_Contract_Notes__c,
IsClosed,
IsDeleted,
IsWon,
Kickoff_Call_s_or_Meeting__c,
Last_Action__c,
Last_Updated_BlueSheet__c,
LastActivityDate,
LastModifiedById,
LastModifiedDate,
Latest_Customer_Contact__c,
LeadSource,
MainCompetitor__c,
Managed_Services_Options__c,
Managers_Notes__c,
Managers_Notes_Exist__c,
Managers_Review_Date__c,
Market_Segment__c,
Migration__c,
My_Position_vs_Compeition__c,
Name,
New_Replacement__c,
Next_On_site_Visit__c,
NextStep,
Open_Issues__c,
Operations_Notes__c,
Opportunity_Type__c,
Order_2__c,
Other_Fees__c,
Overage__c,
OwnerId,
Pass_Through__c,
Percent_Implementation_Complete__c,
Pipeline_Category__c,
PO_Received__c,
Presentation_Completed__c,
Presentation_Date__c,
Price_Study__c,
Pricebook2Id,
Probability,
Product_Demo_d__c,
Professional_Services__c,
Promotion__c,
PS_Record_Id__c,
Quote_Due__c,
Quote_given_to_Customer__c,
Quote_Received__c,
RecordTypeId,
Red_Flags__c,
Red_line_Contract_Received__c,
Red_line_given_to_FMSU_Contracts__c,
RFP_0_250K__c,
RFP_250K_1M__c,
RFP_Assigned_to__c,
RFP_Due__c,
RFP_Notes__c,
RFP_over_1M__c,
RFP_Recieved__c,
RFP_Status__c,
RFPForce__CurrentGenerators__c,
RFPForce__DeliveryInstallationStatus__c,
RFPForce__MainCompetitors__c,
RFPForce__OrderNumber__c,
RFPForce__TrackingNumber__c,
Service_Contract_Type__c,
Signed_Lease_Docs_Received__c,
Site_Visit_Completed__c,
Site_Visit_Date__c,
Software_Installed__c,
StageName,
Strengths__c,
Synapse_Amount__c,
Synapse_Cardiology__c,
Synapse_Disaster_Recovery__c,
Synapse_IS__c,
Synapse_Managed_Services__c,
Synapse_Radiology__c,
Synapse_Radiology_PACS__c,
Synapse_RIS__c,
SystemModstamp,
Tables_Loaded__c,
Term_years__c,
Timing_of_Priorities__c,
Total_Amount__c,
Total_NST_Amount__c,
Total_Potential_Volume__c,
Total_Service_Contract_Amount__c,
Type__c,
Upfront_Capital__c,
X2nd_Tier_PE_Approval__c,
X2nd_Tier_PE_Approval_Date__c,
X2nd_Tier_PE_Comments__c,
X3D__c
FROM Opportunity;
SQL SELECT Alias,
CallCenterId,
City,
CompanyName,
ContactId,
contracts_coordinator__c,
Country,
CreatedById,
CreatedDate,
DelegatedApproverId,
Department,
Division,
Email,
EmailEncodingKey,
EmployeeNumber,
Extension,
Fax,
FirstName,
ForecastEnabled,
Id,
IsActive,
LanguageLocaleKey,
LastLoginDate,
LastModifiedById,
LastModifiedDate,
LastName,
LocaleSidKey,
ManagerId,
MobilePhone,
Name,
OfflinePdaTrialExpirationDate,
OfflineTrialExpirationDate,
Phone,
PostalCode,
ProfileId,
quote_approver__c,
ReceivesAdminInfoEmails,
ReceivesInfoEmails,
State as UserState,
Street,
SystemModstamp,
Territory__c,
TimeZoneSidKey,
Title,
Username,
UserPermissionsAvantgoUser,
UserPermissionsCallCenterAutoLogin,
UserPermissionsMarketingUser,
UserPermissionsMobileUser,
UserPermissionsOfflineUser,
UserPreferencesActivityRemindersPopup,
UserPreferencesDisableAutoSubForFeeds,
UserPreferencesEventRemindersCheckboxDefault,
UserPreferencesReminderSoundOff,
UserPreferencesTaskRemindersCheckboxDefault,
UserRoleId,
UserType,
Zone__c as UserZone
FROM User;
