Default Mappings

Sage100 - ARDivision

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
AR Division Code	GUMU__AR_Division_Code__c	string	ARDivisionNo (ARDivisionNo)
AR Division Description	GUMU__AR_Division_Description__c	string	ARDivisionDesc (ARDivisionDesc)

Sage100 - ARItemProducts

ERP to SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Product Name	Name	string	ItemCode (ItemCode)
Product Code	ProductCode	string	ItemCode (ItemCode)
Product Description	Description	string	ItemCodeDesc (ItemCodeDesc)
Product Family	Family	string	ItemType (ItemType)
Active	Family	CheckBox		TRUE

Sage100 - Contact

ERP to SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
ERP Contact Code	GUMU__ERP_Contact_Code__c	string	ContactCode	TRUE
Last Name	LastName	string	ContactName	TRUE
Mailing City	MailingCity	string	City	TRUE
Mailing Country	MailingCountry	string	CountryCode	TRUE
Mailing State/Province	MailingState	string	State	TRUE
Mailing Street	MailingStreet	string	AddressLine1	TRUE
Mailing Zip/Postal Code	MailingPostalCode	string	ZipCode	TRUE
Salutation	Salutation	string	Salutation	TRUE
Title	Title	string	ContactTitle	TRUE
Business Phone	Phone	string	TelephoneNo1	TRUE
Business Fax	Fax	string	FaxNo	TRUE
Home Phone	HomePhone	string	TelephoneNo2	TRUE
Email	Email	string	EmailAddress	TRUE

SF to ERP

Source Field Label	Source Field	Target Field Label	Default Value
ERP Contact Code	GUMU__ERP_Contact_Code__c	ContactCode
Last Name	LastName	ContactName
Mailing City	MailingCity	City
Mailing Country	MailingCountry	CountryCode
Mailing State/Province	MailingState	State
Mailing Street	MailingStreet	AddressLine1
Mailing Street	MailingStreet	AddressLine2
Mailing Street	MailingStreet	AddressLine3
Mailing Zip/Postal Code	MailingPostalCode	ZipCode
Salutation	Salutation	Salutation
Title	Title	ContactTitle
Business Phone	Phone	TelephoneNo1
Business Fax	Fax	FaxNo
Email	Email	EmailAddress
Mobile	MobilePone	TelephoneNo2

Relationship

Target Field	Source Field	Default Value	Parent Object
AccountId	ARDivisionNo (ARDivisionNo)		Account
AccountId	CustomerNo (CustomerNo)		Account

Sage100 - Customer

ERP to SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Account Name	Name	string	CustomerName
Account Type	Type	string		Customer
AR DivisonNo	GUMU__AR_DivisonNo__c	string	AR DivisonNo
Billing City	BillingCity	string	City
Billing Country	BillingCountry	string	CountryCode
Billing State/Province	BillingState	string	State
Billing Street	BillingStreet	string	AddressLine1
Billing Zip/Postal Code	BillingPostalCode	string	ZipCode
Company Code	GUMU__ERP_Company_Code__c	string		ABC
Customer Number	GUMU__ERP_Customer_Number__c	string	CustomerNo
Account Phone	Phone	string	TelephoneNo
Account Fax	Fax	string	FaxNo
Website	Website	string	URLAddress

SF to ERP

Source Field Label	Source Field	Target Field Label	Default Value
Account Name	Name	CustomerName
AR DivisonNo	GUMU__AR_DivisonNo__c	ARDivisonNo
Billing City	BillingCity	City
Billing Country	BillingCountry	Country
Billing State/Province	BillingState	State
Billing Street	BillingStreet	AddressLine1
Billing Street	BillingStreet	AddressLine2
Billing Street	BillingStreet	AddressLine3
Billing Zip/Postal Code	BillingPostalCode	ZipCode
Customer Number	GUMU__ERP_Customer_Number__c	CustomerNo
Account Phone	Phone	TelephoneNo
Account Fax	Fax	FaxNo
Website	Website	URLAddress

Real-time Fields

Sections	Data Page Field Label	Data Page Field API Name	Data Type
Main	ShipMethod	Ship Method	Text
	CreditHold	Credit Hold	Checkbox
	TaxSchedule	Tax Schedule	Text
	ARDivisionNo	AR Division	Text
	CustomerNo	Customer Number	Text
	SalespersonNo	Sales person	Text
	CustomerName	Customer Name	Text
	TermsCode	Terms Code	Text
Additional	Customer Type	CustomerType	Text
	Finance Charge Rate(%)	ServiceChargeRate	Decimal
	Customer Status	CustomerStatus	Text
	Statement Cycle	StatementCycle	Text
	Open Item Customer	OpenItemCustomer	Checkbox
	Default Payment Type	DefaultPaymentType	Text
	Sort	SortField	Text
	Comment	Comment	Text
	Batch Fax	BatchFax	Checkbox
	Print Dun message	PrintDunningmessage	Text
	Price level	Pricelevel	Text
Statistics	Last Statement Date	DateLastStatement	Date
	Date Established	DateEstablished	Date
	Average Days to Pay	AvgDaysPaymentInvoice	Text
	Date Of Last Activity	DateLastActivity	Date
	Last Payment Amount	LastpaymentAmt	Decimal
	Highest Balance	HigheststmntBalance	Decimal
	Last Finance Charge Date	DateLastFinanceChrg	Date
	Average Days Overdue	AvgDaysOverDue	Text
	Unpaid Finance Charges	UnpaidServicechrg	Decimal
	Last Payment Date	DateLastPayment	Date
	Unpaid Finance Charges	UnpaidServicechrg	Decimal
	Last Payment Date	DateLastPayment	Date

Sage100 - DefaultShipTo

ERP to SF

Target Field Label	Target Field	Data Type	Default Value
Default ShipTo	GUMU__Default_ShipTo__c	string	Yes
Ship to Address	GUMU__isShipTo__c	string	Yes

Relationship

Target Field	Source Field	Parent Object
GUMU__Account_Id__c	ARDivisionNo	Account
	CustomerNo	Account