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

SF to ERP

Source Field Label	Source Field	Target Field Label
ARDivisionNo	GUMU__ARDivisionNo__c	ARDivisionNo
OrderStartDate	EffectiveDate	OrderDate
ShipExpireDate	GUMU__Ship_Expire_Date__c	ShipExpireDate
CustomerNo	GUMU__CustomerNo__c	CustomerNo
FOB	GUMU__FOB__c	FOB
OrderType	Type	OrderType
DiscountAmt	GUMU__DiscountAmt__c	DiscountAmt
FreightAmt	GUMU__FreightAmt__c	FreightAmt
PrintPickingSheets	GUMU__Print_Picking_Sheets__c	PrintPickingSheets
PrintOrders	GUMU__Print_Order__c	PrintSalesOrders
TermsCode	GUMU__TermsCode__c	TermsCode
Sales Person	GUMU__Sales_Person__c	SalespersonNo
PaymentType	GUMU__Payment_Type__c	PaymentType
TaxSchedule	GUMU__Tax_Schedule__c	TaxSchedule
Warehouse	GUMU__Warehouse__c	WarehouseCode
ShipVia	GUMU__ShipVia__c	ShipVia
ShippingCountry	ShippingCountry	ShippingToCountryCode
Shipping Zip/Postal Code	ShippingPostalCode	ShipToZipCode
ShippingState/Province	ShippingState	ShipToState
Shipping City	ShippingCity	ShipToCity
Shipping Street	ShippingStreet	ShipToAddress1
Shipping Street	ShippingStreet	ShipToAddress2
Shipping Street	ShippingStreet	ShipToAddress3
Ship ToCode	GUMU__ShipToCode__c	ShipToCode
Ship ToName	GUMU__ShipToName__c	ShipToName
Billing Country	BillingCountry	BillingToCountryCode
Billing Zip/PostalCode	BillingPostalCode	BillToZipCode
Billing State/Province	BillingState	BillingToState
Billing City	BillingCity	BillingToCity
Billing Street	BillingStreet	BillToAddress1
Billing Street	BillingStreet	BillToAddress2
Billing Street	BillingStreet	BillToAddress3
Batch Fax No	GUMU__Batch_Fax_No__c	BatchFax
Order Reference Number	OrderReferenceNumber	CustomerPONo
DepositAmt	GUMU__DepositAmt__c	DepositAmt
Check Number	GUMU__Check_Number_ext__c	CheckNoForDeposit

Relationship

Target Field	Source Field	Default Value	Parent Object
Account	ARDivisionNo		Account
Account	CustomerNo		Account
Pricebook2			Pricebook2

Real-time Fields

Sections	Data Page Field Label	Data Page Field API Name	Data Type
Order Header	Order No	SalesOrderNo	Text
	Order Date	OrderDate	Date
	Order Type	OrderType	Text
	Master / Repeating Order No.	MasterRepeatingOrderNo	Text
	Division	ARDivisionNo	Text
	Customer No	CustomerNo	Text
	Customer PO No.	CustomerPoNo	Text
	Ship Expire Date	ShipExpiredate	Date
	Terms Code	TermsCode	Text
	Confirm To	ConfirmTo	Text
	Tax Schedule	TaxSchedule	Text
	Warehouse Code	WarehouseCode	Text
	Ship Via	ShipVia	Text
	FOB	FOB	Text
	Sales Person	SalespersonNo	Text
	Comment	Comment	Text
	Bill To Name	BillToName	Text
	Ship To Name	ShipToName	Text
	Split Commissions	SplitCommissions	Checkbox
Line Items	Item Code	ItemCode	Text
	Description	ItemCodeDesc	Text
	Warehouse Code	WarehouseCode	Text
	Unit of Measure	UnitOfMeasure	Text
	Quantity Ordered	QuantityOrdered	Decimal
	Quantity Shipped	QuantityShipped	Decimal
	Back Ordered	QuantityBackordered	Decimal
	Unit Price	UnitPrice	Decimal
Order Totals	Taxable Subject To Discount	TaxableSubjectToDiscount	Decimal
	Non Taxable Subject To Discount	NonTaxableSubjectToDiscount	Decimal
	Discount Rate (%)	DiscountRate	Decimal
	Discount Amount	DiscountAmt	Decimal
	Taxable Amount(Discount Included)	TaxableAmt	Decimal
	Non-Taxable Amount(Discount Included)	NonTaxableAmt	Decimal
	Ship Zone	ShipZone	Text
	Ship Weight	ShipWeight	Text
	Freight Amount	FreightAmt	Decimal
	Sales Tax Amount	SalesTaxAmt	Decimal

Sage100 - OrdersLines

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Comments	GUMU__Comments__c	string	CommentText
Discount	GUMU__Discount__c	Number	LineDiscountPercent
Drop Ship	GUMU__Drop_Ship__c	string	DropShip
Extension Amount	GUMU__ExtensionAmt__c	Number	ExtensionAmt
Line Description	Description	string	ItemCodeDesc
Quantity	Quantity	Number	QuantityOrdered
Tax Class	GUMU__TaxClass__c	string	TaxClass
Unit Price	UnitPrice	Number	UnitPrice
UOM	GUMU__UOM__c	string	UnitOfMeasure
Warehouse Code	GUMU__Warehouse_Code__c	string	WarehouseCode
Commissionable	GUMU__Commissionable__c	string	Commissionable
Item Type	GUMU__ItemType__c	string	ItemType

SF to ERP

Source Field Label	Source Field	Target Field Label
Comments	GUMU__Comments__c	CommentText
Discount	GUMU__Discount__c	LineDiscountPercent
Drop Ship	GUMU__Drop_Ship__c	DropShip
Extension Amount	GUMU__ExtensionAmt__c	ExtensionAmt
Quantity	Quantity	QuantityOrdered
Tax Class	GUMU__TaxClass__c	TaxClass
Unit Price	UnitPrice	UnitPrice
UOM	GUMU__UOM__c	UnitOfMeasure
Warehouse Code	GUMU__Warehouse_Code__c	WarehouseCode
Commissionable	GUMU__Commissionable__c	Commissionable

Relationship

Target Field	Source Field	Default Value	Parent Object
OrderId	SalesOrderNo		Order
PricebookEntryId	ItemCode		PricebookEntry

Sage100 - PaymentType

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Payment Method	GUMU__Payment_Method__c	string	PaymentType
Payment Type Code	GUMU__Payment_Type_Code__c	string	PaymentType
Payment Type Description	GUMU__Payment_Type_Description__c	string	PaymentDesc

Sage100 - PricebookEntry

ERP to SF

Target Field Label	Target Field	Data Type
List Price	UnitPrice	Number
Category	GUMU__Category__c	string

Relationship

Target Field	Source Field	Default Value	Parent Object
Product2Id	ItemCode		Product
Pricebook2Id			Price Book

Sage100 - PricebookEntrySTD

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
List Price	UnitPrice	Number	StandardUnitPrice
Category	GUMU__Category__c	string	Category1

Relationship

Target Field	Source Field	Default Value	Parent Object
Product2Id	ItemCode		Product
Pricebook2Id			Price Book

Sage100 - ProductFamily

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
ERP Product Family Code	GUMU__ERP_Product_Family_Code__c	string	ProductLine
ERP Product Family Description	GUMU__ERP_Product_Family_Description__c	string	ProductLineDesc

Relationship

Target Field	Source Field	Default Value	Parent Object
Product2Id	ItemCode		Product
Pricebook2Id			Price Book

Sage100 - Products

ERP to SF

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

Relationship

Target Field	Source Field	Default Value	Parent Object
GUMU__ERP_Product_family_Id__C	ProductLine

Sage100 - SalesPerson

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
AR Division Code	GUMU__AR_Division_Code__c	string	SalespersonDivisionNo
Salesperson Code	GUMU__Salesperson_Code__c	string	SalespersonNo
Salesperson Description	GUMU__Salesperson_Description__c	string	SalespersonName
Email	GUMU__Email__c	string	EmailAddress

Sage100 - ShipMethod

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Ship Code	GUMU__Ship_Code__c	string	ShippingCode
Ship Code Description	GUMU__Ship_Code_Description__c	string	ShippingCodeDesc

Sage100 - ShipTo

ERP to SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Address1	GUMU__Ship_To_Address1__c	string	ShipToAddress1
Address2	GUMU__Ship_to_Address2__c	string	ShipToAddress2
Address3	GUMU__Ship_to_Address3__c	string	ShipToAddress3
City	GUMU__Ship_to_City__c	string	ShipToCity
Country Code	GUMU__Ship_to_Country_Code__c	string	ShipToCountryCode
Email Address	GUMU__Email_Address__c	string	EmailAddress
Fax No	GUMU__Fax_No__c	string	FaxNo
Salesperson No	GUMU__Salesperson_No__c	string	SalespersonNo
Ship To Addresses Name	Name	string	ShipToCode
Ship To Code	GUMU__Ship_To_Code__c	string	ShipToCode
Ship To Name	GUMU__Ship_To_Name__c	string	ShipToName
State	GUMU__Ship_To_State__c	string	ShipToState
Tax Schedule	GUMU__Tax_Schedule__c	string	TaxSchedule
Telephone Ext	GUMU__Telephone_Ext__c	string	TelephoneExt
Telephone No	GUMU__Telephone_No__c	string	TelephoneNo
Warehouse Code	GUMU__Warehouse_Code__c	string	WarehouseCode
Zip Code	GUMU__Ship_To_Zip_Code__c	string	ShipToZipCode
Default ShipTo	GUMU__Default_ShipTo__c	string		No
Ship to Address	GUMU__isShipTo__c	string		Yes
Primary Address	GUMU__IsPrimary__c	string		No
Not Promoted?	GUMU__Not_Promoted__c	CheckBox		FALSE

Relationship

Target Field	Source Field	Default Value	Parent Object
GUMU__Account_Id__c	ARDivisionNo		Account
GUMU__Account_Id__c	CustomerNo		Account

Sage100 - ShipVia

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Ship via Name	Name	string	ShippingCode
Ship Via Code	GUMU__Ship_Via_Code__c	string	ShippingCode
Ship Via Description	GUMU__Ship_Via_Description__c	string	ShippingCodeDesc

Sage100 - TaxClass

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Tax Class Code	GUMU__Tax_Class_Code__c	string	TaxClass
Tax Class Description	GUMU__Tax_Class_Description__c	string	TaxClassDesc

Sage100 - TaxSchedule

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Tax Schedule Code	GUMU__Tax_Schedule_Code__c	string	TaxSchedule
Tax Schedule Description	GUMU__Tax_Schedule_Description__c	string	TaxScheduleDesc

Sage100 - TermsCode

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Terms Code	GUMU__Terms_Code__c	string	TaxCode
Terms Code Description	GUMU__Terms_Code_Description__c	string	TaxCodeDesc

Sage100 - UOM

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Unit Of Measure Name	Name	string	UnitOfMeasure
UOM Code	GUMU__UOM_Code__c	string	UnitOfMeasure
Conversion Factor	GUMU__Conversion_Factor__c	Number	ConversionFactor1

Sage100 - Warehouse

ERP to SF

Target Field Label	Target Field	Data Type	Source Field
Warehouse Code	GUMU__Warehouse_Code__c	string	WarehouseCode
Warehouse Description	GUMU__Warehouse_Description__c	string	WarehouseDesc

Sage100 - Sales Invoice

Data Page Field Label	Data Page Field API Name	Data Type
Invoice Number	InvoiceNo	Text
Customer PO No.	CustomerPONo	Text
Invoice Type	InvoiceType	Text
Source	ModuleCode	Text
Division Number	ARDivisionNo	Text
Customer Number	CustomerNo	Text
Invoice Date	InvoiceDate	Date
Due Date	InvoiceDueDate	Date
Terms Code	TermsCode	Text
Ship Via	ShipVia	Text
Sales Person No.	SalespersonNo	Text
Tax Schedule	TaxSchedule	Text
Comment	Comment	Text
Sales Order No	SalesOrderNo	Text
Item Code	ItemCode	Text
Description	ItemCodeDesc	Text
Amount	ExtensionAmt	Decimal
Sales Tax Class	TaxClass	Text
Quantity	QuantityShipped	Decimal
Price	UnitPrice	Decimal
Cost	UnitCost	Decimal
Freight	FreightAmt	Decimal
Deposit Amount	DepositAmt	Decimal
Discount Amount	DiscountAmt	Decimal
Discount Rate	DiscountRate	Decimal
Taxable Sales Amount	TaxableSalesAmt	Decimal
Sales Tax Amount	SalesTaxAmt	Decimal
Non Taxable Amount	NonTaxableSalesAmt	Decimal

Sage100 - Shipments

Data Page Field Label	Data Page Field API Name	Data Type
Invoice No	InvoiceNo	Text
Customer No	CustomerNo	Text
SalesOrder No	SalesOrderNo	Text
ARDivision No	ARDivisionNo	Text
Multiple SO Applied	MultipleSalesOrdersApplied	Text
Multiple PO Nos	MultipleCustomerPONos	Text
Ship Date	ShipDate	Text
Ship Via	ShipVia	Text
Shipper ID	ShipperID	Text
Freight Amt	FreightAmt	Text
Invoice Total	InvoiceTotal	Text
Date Updated	DateUpdated	Text

Sage100 - AR Open Invoice

Data Page Field Label	Data Page Field API Name	Data Type
Invoice Number	InvoiceNo	Text
Invoice Type	InvoiceType	Text
Customer PO No.	CustomerPONo	Text
Source	ModuleCode	Text
Division Number	ARDivisionNo	Text
Customer Number	CustomerNo	Text
Invoice Date	InvoiceDate	Date
Due Date	InvoiceDueDate	Date
Terms Code	TermsCode	Number
Ship Via	ShipVia	Text
Sales Person No.	SalespersonNo	Text
Tax Schedule	TaxSchedule	Text
Comment	Comment	Text
Sales Order No	salesOrderNo	Text
Item Code	ItemCode	Text
Description	ItemCodeDesc	Text
Amount	ExtensionAmt	Decimal
Sales Tax Class	TaxClass	Text
Quantity	QuantityOrdered	Decimal
Price	UnitPrice	Decimal
Cost	UnitCost	Decimal
Freight	FreightAmt	Decimal
Discount Amount	DiscountAmt	Decimal
Sales Tax Amount	SalesTaxAmt	Decimal
Non Taxable Amount	NonTaxableAmt	Decimal