I'm adding a series of records to the Activity table and only some of them are getting assigned the correct CustomerRecordID. The others are getting a CustomerRecordID that doesn't have any matches in the Customer table. Example data below. Is there somethiing wrong with the data I'm passing or are there other fields I should be including to make sure these records are assigned to the correct customer?
This is the list of fields I’m inserting into the [Activity] table: ActivityType,Comments,WorkOrderInstructions,Contacts,ActivityStatus,Entity,DueDateStart,DueDateEnd,ActualStartDate,AssignedTo,ActivityPriority
The correct CustomerRecordID is 53434. Only 4 of 11 records inserted got assigned that value, the others got a value of either 43755 or 14475. List of values inserted are included below. The [Contacts] and [Entity] field values are bolded, those are the only fields I’m passing that map the activity to a customer and they’re the same for all.
1. 03/14/2013
Method RecordID: 274264
ValueList: Work Order,Barrier Spray,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,03/14/2013 01:30 PM,14-Mar-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 43755
2. 04/04/2013
Method RecordID: 274265
ValueList: Work Order,Barrier Spray & Ticks,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,04/04/2013 01:30 PM,04-Apr-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 43755
3. 04/25/2013
Method RecordID: 274266
ValueList: Work Order,Barrier Spray,Date specific note: Marc's birthday party, don't miss this spray!!! Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,04/25/2013 01:30 PM,25-Apr-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 53434
4. 05/16/2013
Method RecordID: 274267
ValueList: Work Order,Barrier Spray & Ticks,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,05/16/2013 01:30 PM,16-May-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 53434
5. 06/06/2013
Method RecordID: 274268
ValueList: Work Order,Barrier Spray,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,06/06/2013 01:30 PM,06-Jun-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 53434
6. 06/27/2013
Method RecordID: 274269
ValueList: Work Order,Barrier Spray & Ticks,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,06/27/2013 01:30 PM,27-Jun-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 14475
7. 07/18/2013
Method RecordID: 274270
ValueList: Work Order,Barrier Spray,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,07/18/2013 01:30 PM,18-Jul-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 43755
8. 08/08/2013
Method RecordID: 274271
ValueList: Work Order,Barrier Spray & Ticks,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,08/08/2013 01:30 PM,08-Aug-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 14475
9. 08/29/2013
Method RecordID: 274272
ValueList: Work Order,Barrier Spray,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,08/29/2013 01:30 PM,29-Aug-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 14475
10. 09/19/2013
Method RecordID: 274273
ValueList: Work Order,Barrier Spray & Ticks,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,09/19/2013 01:30 PM,19-Sep-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium
Method [CustomerRecordID]: 43755
11. 10/10/2013
Method RecordID: 274274
ValueList: Work Order,Barrier Spray,Date specific note: Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,10/10/2013 01:30 PM,10-Oct-13 09:00 PM,03/01/2013 07:46 PM,Phillip,2-Medium
Method [CustomerRecordID]: 53434