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

Sage100 - Order

ERP to SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
ARDivisionNo	GUMU__ARDivisionNo__c	string	ARDivisionNo
Batch Fax No	GUMU__Batch_Fax_No__c	CheckBox	BatchFax
Billing City	BillingCity	string	BillToCity
Billing Country	BillingCountry	string	BillToCountryCode
Billing State/Province	BillingState	string	BillToState
Billing Street	BillingStreet	string	BillToAddress1
Billing Zip/Postal Code	BillingPostalCode	string	BillToZipCode
CustomerNo	GUMU__CustomerNo__c	string	CustomerNo
FOB	GUMU__FOB__c	string	FOB
DiscountAmt	GUMU__DiscountAmt__c	Number	DiscountAmt
FreightAmt	GUMU__FreightAmt__c	Number	FreightAmt
Non taxable Amount	GUMU__Non_taxable_Amount__c	Number	NonTaxableAmt
DiscountPC	GUMU__DiscountPC__c	Number	DiscountRate
Document Type	GUMU__Document_Type__c	string		Order
ERP Order Number	GUMU__ERP_Order_Number__c	string	SalesOrderNo
Taxable Amount	GUMU__Taxable_Amount__c	Number	TaxableAmt
Shipping Zip/Postal Code	ShippingPostalCode	string	ShipToZipCode
ShipToCode	GUMU__ShipToCode__c	string	ShipToCode
ShipToName	GUMU__ShipToName__c	string	ShipToName
ShipVia	GUMU__ShipVia__c	string	ShipVia
Status	Status	string		Draft
Tax Schedule	GUMU__Tax_Schedule__c	string	TaxSchedule
TaxGroup	GUMU__TaxGroup__c	string	TaxClass
TermsCode	GUMU__TermsCode__c	string	TermsCode
Warehouse	GUMU__Warehouse__c	string	WarehouseCode
DiscountType	GUMU__DiscountType__c	string		Percentage
Order Start Date	EffectiveDate	Date	OrderDate
SalesTaxAmt	GUMU__SalesTaxAmt__c	Number	SalesTaxAmt
Order Type	Type	string	OrderType
Shipping Street	ShippingStreet	string	ShipToAddress1
Payment Type	GUMU__Payment_Type__c	string	PaymentType
Print Order	GUMU__Print_Order__c	CheckBox	PrintSalesOrders
Print Picking Sheets	GUMU__Print_Picking_Sheets__c	CheckBox	PrintPickingSheets
Sales Person	GUMU__Sales_Person__c	string	SalespersonNo
Ship Expire Date	GUMU__Ship_Expire_Date__c	Date	ShipExpireDate
Shipping City	ShippingCity	string	ShipToCity
Shipping Country	ShippingCountry	string	ShipToCountryCode
Shipping State/Province	ShippingState	string	ShipToState