I'm trying to mass create order objects with some opportunities data. I have no trouble to create those orders with the Dataloader or the developer workbench, but for some reason, the field "OpportunityId" which makes the lookup between an opportunity and an order is not available in neither data loading tool...even if I can see it in the interface, and edit it. I also tried to query the order object and check the schema on workbench, and I cannot see the field. However, in Developer Console, I'm able to query successfully : SELECT Id, OpportunityId FROM Order but not in Dataloader or Workbench, where the same query gives me the following error :
"INVALID_FIELD: SELECT Id, OpportunityId FROM Order ^ ERROR at Row:1:Column:12 No such column 'OpportunityId' on entity 'Order'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names."
I'm an admin. I checked "Field Security Level" and Layouts. I think it might have to do with the lookup, but I don't understand. The fields are standard fields. Could it be a bug ? I'm trying to see how I can make sure that those new orders are linked to the right opportunities. Thanks in advance for any help.