AX Table	Fieldname	Data Type	Length	Applicability	Remarks
CUSTTABLE	EXTERNALID	Text	20	Customer integration	This will be used to store the SFDC account id.
SALESLINE	SOEXTERNALID	Text	20	Sales order integration	This will be used to store the sales order id that was transferred into SFDC.
CUSTINVOICETRANS	INVEXTERNALID	Text	20	Sales history integration	This will be used to store the invoice id that was transferred into SFDC.

SFDC Object	Fieldname	Data Type	Length	External ID?	Applicability	Remarks
Account	AXID__c	Text	15	Yes	Customer Integration	Field to contain RECID from MS Dynamics AX
Account	Legal_Entity__c	Picklist	N/A	No		Field that contain a list of abbreviation for the AX company name. Used to specify which AX company this Account belongs to. Only required if you have more than one company in AX.
Account	Transferred__c	DateTime	N/A	No	Customer Integration	Datetime field to contain a timestamp that can be used as filter to not transfer the same Account twice and as information of when this Account was transferred from SDFC to AX.

SFDC Object	Fieldname	Data Type	Length	External ID?	Applicability	Remarks
Contact	Transferred__c	DateTime	15	Yes	Contact Integration	Datetime field to contain a timestamp that can be used as filter to not transfer the same contact twice and as information of when this contact was transfered from SDFC to AX.
Contact	Contact_Person_ID__c	Text	20		Contact Integration	Datetime field to contain a timestamp that can be used as filter to not transfer the same contact twice and as information of when this contact was transferred from SDFC to AX.
Opportunity	OrderNumber__c	Text	20	Yes	Opportunity Integration	Field to hold the AX Sales Order number (automatically assigned in AX and written back to the Opportunity in SF).

Salesforce.com - MS Dynamics AX