Default Mapping

AccountSets

ERP TO SF

Target Field Label	Target Field	Data Type	Source Field
Account Set Description	GUMU__Account_Set_Description__c	string	Description (Description)
Account Set Code	GUMU__Account_Set_Code__c	string	AccountSetKey(AccountSetKey)
Account Set Name	Name	string	AccountSetKey(AccountSetKey)

ARDistributionCode

ERP TO SF

Target Field Label	Target Field	Data Type	Source Field
Distribution Code Name	Name	string	DistributionCodeKey
Description	GUMU__Description__c	string	Description
Status	GUMU__Status__c	string	Description

ARItems

ERP TO SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Item Type	GUMU__Item_Type__c	string		ARItem
Product Name	Name	string	ItemNumber(ItemNumber)
Product Description	Description	string	Description(Description)
Product Code	Product Code	string	ItemNumber(ItemNumber)
Active	IsActive	CheckBox		TRUE

ARPricebookEntry

ERP TO SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
List Price	UnitPrice	Number		0

Relationship

Target Field	Source Field	Default Value	Parent Object
Product2Id	ItemNumber(ItemNumber)		Product
Pricebook2id			PriceBook

ARPricebookEntrySTD

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
List Price	UnitPrice	Number		0

Relationship

Target Field	Source Field	Default Value	Parent Object
Product2Id	ItemNumber(ItemNumber)		Product

ARUOM

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
UOM Code	GUMU__UOM_Code__c	string	UnitesOfMeasureKey(UnitesOfMeasureKey)
Unit Of Measure Name	Name	string	UnitesOfMeasureKey(UnitesOfMeasureKey)

Contact

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Is Primary Contact	GUMU__Sage300_Contact__c	CheckBox		TRUE
Email	Email	string	ContactsEmail(ContactsEmail)
Business Fax	Fax	string	ContactsFax(ContactsFax)
Business Phone	Phone	string	ContactsPhone(ContactsPhone)
Last Name	LastName	string	ContactName(ContactName)

SF To ERP

Source Field Label	Source Field	Target Field Label
Name	Name	ContactName(ContactName)
Phone	Phone	ContactsPhone(ContactPhone)
Fax	Fax	ContactsFax(ContactFax)
Email	Email	ContactsEmail(ContactEmail)

Category

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Category description	GUMU__Category_description__c	string	Description(Description)
Category	GUMU__CategoryCode__c	string	GroupCode(GroupCode)

Currency

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Currency Description	GUMU__Currency_Description__c	string	Description(Description)
Currency Code	GUMU__Currency_Code__c	string	Currency CodeKey(Currency CodeKey)

Customer

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
ERP Customer Type	GUMU__ERP_Customer_Type__c	string	CustomerDiscountType(CustomerDiscountType)
Customer Number	GUMU__ERP_Customer_Number__c	string	CustomerNumber(CustomerNumber)
Currency	GUMU__Currency__c	string	CurrencyCode(CurrencyCode)
Account Type	Type	string		Customer
Account Name	Name	string	CustomerName(CustomerName)

SF To ERP

Source Field Label	Source Field	Target Field Label
Customer Number	GUMU__ERP_Customer_Number__c	Customer Number(Customer Number)
Account Name	Name	CustomerName(CustomerName)
Billing Address	BillingStreet	AddressLine1(AddressLine1)
Billing Address	BillingStreet	AddressLine2(AddressLine2)
Billing Address	BillingStreet	AddressLine3(AddressLine3)
Billing City	BillingCity	City (City)
Billing State/Province	BillingState	StateProvince(StateProvince)
Billing Zip/Postal Code	BillingPostalCode	ZipPostalCode(ZipPostalCode)
Billing Country	BillingCountry	Country (Country)
Account Phone	Phone	PhoneNumber (PhoneNumber)
Account Fax	Fax	FaxNumber (FaxNumber)
Website	Website	Website(Website)

Location

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Warehouse Description	GUMU__Warehouse_Description__c	string	Name (Name)
Warehouse Code	GUMU__Warehouse_Code__c	string	LocationKey(LocationKey)

PricebookEntry

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Active	IsActive	CheckBox		TRUE
UOM	GUMU__UOM__c	string	StockingUnitOfMeasure(StockingUnitOfMeasure)
List Price	UnitPrice	Number		0
Category	GUMU__Category__c	string	Category (Category )

Relationship

Target Field	Source Field	Default Value	Parent Object
Product2Id	UnformattedItemNumber(UnformattedItemNumber)		Product
Pricebook2id			PriceBook

PricebookEntrySTD

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Active	IsActive	CheckBox		TRUE
UOM	GUMU__UOM__c	string	StockingUnitOfMeasure(StockingUnitOfMeasure)
List Price	UnitPrice	Number		0
Category	GUMU__Category__c	string	Category (Category)

ItemPricelist

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Price_List Name	Name	string	PriceListCodeKey(PriceListCodeKey)
Price List Description	GUMU__Price_List_Description__c	string	Description(Description)
Price List Code	GUMU__Price_List_Code__c	string	PriceListCodeKey(PriceListCodeKey)

ProductCode

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Product Family	Family	string	Category(Category)
Active	IsActive	CheckBox		TRUE
Product Description	Description	string	Description(Description)
Product Code	ProductCode	string	ItemNumber(ItemNumber)
Product Name	Name	string	ItemNumber(ItemNumber)

ProductFamily

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
ERP Product Family Description	GUMU__ERP_Product_Family_Description__c	string	Description(Description)
ERP Product Family Code	GUMU__ERP_Product_Family_Code__c	string	CategoryCode(CategoryCode)

SalesOrder

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
AccountSet	GUMU__AccountSet__c	string	CustomerAccountSet(CustomerAccountSet)
Billing City	BillingCity	string	BillToCity(BillToCity)
Billing Country	BillingCountry	string	BillToCountry(BillToCountry)
Billing State/Province	BillingState	string	BillToStateProvince(BillToStateProvince)
Billing Street	BillingStreet	string
CustomerNo	GUMU__CustomerNo__c	string	CustomerNumber(CustomerNumber)
Description	Description	string	OrderDescription(OrderDescription)
DiscountAmt	GUMU__DiscountAmt__c	Number	OrderDiscountAmount(OrderDiscountAmount)
DiscountPC	GUMU__DiscountPC__c	Number	OrderDiscountPercentage(OrderDiscountPercentage)
DiscountType	GUMU__DiscountType__c	string		Percentage
Document Type	GUMU__Document_Type__c	string		Order
ERP Order Number	GUMU__ERP_Order_Number__c	string	Order Number(Order Number)
ERP Order Total	GUMU__ERP_Order_Total__c	Number	OrderTotal(OrderTotal)
Order Reference Number	Order Reference Number	string	PurchaseOrderNumber(PurchaseOrderNumber)
Order Start Date	EffectiveDate	Date	Orderdate(Orderdate)
Order Type	Type	string	OrderType(OrderType)
Sales Person	GUMU__Sales_Person__c	string	Salesperson1(Salesperson1)
SalesTaxAmt	GUMU__SalesTaxAmt__c	Number	TotalTaxAmount(TotalTaxAmount)
Shipping City	ShippingCity	string	ShipToCity(ShipToCity)
Shipping State/Province	ShippingState	string	ShipToStateProvince(ShipToStateProvince)
Shipping Zip/Postal Code	ShippingPostalCode	string	ShipToZipPostalCode(ShipToZipPostalCode)
ShipToCode	GUMU__ShipToCode__c	string	ShipToLocationCode(ShipToLocationCode)
ShipVia	GUMU__ShipVia__c	string	ShipViaCode(ShipViaCode)
Status	Status	string		Draft
TaxGroup	GUMU__TaxGroup__c	string	TaxGroup(TaxGroup)
TermsCode	GUMU__TermsCode__c	string	TermsCode(TermsCode)
Warehouse	GUMU__Warehouse__c	string	Location(Location)

SF To ERP

Source Field Label	Source Field	Target Field Label
Order Start Date	EffectiveDate	OrderDate(OrderDate)
Ship To Code	GUMU__ShipToCode__c	ShipToLocationCode(ShipToLocationCode)
Terms Code	GUMU__TermsCode__c	TermsCode(TermsCode)
Tax Group	GUMU__TaxGroup__c	TaxGroup(TaxGroup)
Account Set	GUMU__AccountSet__c	CustomerAccountSet(CustomerAccountSet)
Ship Via	GUMU__ShipVia__c	ShipViaCode(ShipViaCode)
Warehouse	GUMU__Warehouse__c	DefaultLocationCode(DefaultLocationCode)
Description	Description	OrderDescription(OrderDescription)
Order Reference Number	OrderReferenceNumber	OrderReference(OrderReference)
Billing Address	BillingStreet	BillToAddressLine1(BillToAddressLine1)
Billing Address	BillingStreet	BillToAddressLine2(BillToAddressLine2)
Billing Address	BillingStreet	BillToAddressLine3(BillToAddressLine3)
Billing City	BillingCity	BillToCity(BillToCity)
Billing State/Province	BillingState	BillToStateProvince(BillToStateProvince)
Billing Zip/Postal Code	BillingPostalCode	BillToZipPostalCode(BillToZipPostalCode)
Billing Country	BillingCountry	BillToCountry(BillToCountry)
Shipping Address	ShippingStreet	ShipTo AddressLine1(ShipTo AddressLine1)
Shipping Address	ShippingStreet	ShipTo AddressLine2(ShipTo AddressLine2)
Shipping Address	ShippingStreet	ShipTo AddressLine3(ShipTo AddressLine3)
Shipping City	ShippingCity	ShipToCity(ShipToCity)
Shipping State/Province	ShippingState	ShipToStateProvince(ShipToStateProvince)
Shipping Zip/Postal Code	ShippingPostalCode	ShipToZipPostalCode(ShipToZipPostalCode)
Shipping Country	ShippingCountry	ShipToCountry(ShipToCountry)

Relationship

Target Field	Source Field	Parent Object
AccountId	CustomerNumber(CustomerNumber)	Account
Pricebook2Id		Price Book

SalesOrderDetails

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Discount	GUMU__Discount__c	Number	DiscountPercent(DiscountPercent)
Extension Amount	GUMU__ExtensionAmt__c	Number	ExtendedAmount(ExtendedAmount)
Item Type	GUMU__ItemType__c	string	Category(Category)
Line Description	Description	string
Net Detail Discount	GUMU__Net_Detail_Discount__c	Number	ExtendedDiscountPrice(ExtendedDiscountPrice)
Price_List	GUMU__Price_List__c	string	DefaultPriceListCode(DefaultPriceListCode)
Quantity	Quantity	Number	QuantityOrdered(QuantityOrdered)
Quantity Committed	Quantity_Committed__c	string	QuantityCommitted(QuantityCommitted)
Unit Price	UnitPrice	Number	PricingUnitPrice(PricingUnitPrice)
UOM	GUMU__UOM__c	string	OrderUnitOfMeasure(OrderUnitOfMeasure)
Warehouse Code	GUMU__Warehouse_Code__c	string	Location(Location)

SF To ERP

Source Field Label	Source Field	Target Field Label
Line Description	Description
Warehouse Code	GUMU__Warehouse_Code__c	Location(Location)
Price_List	GUMU__Price_List__c	PriceList(PriceList)
UOM	GUMU__UOM__c	OrderUnitOfMeasure(OrderUnitOfMeasure)
Quantity	Quantity	QuantityOrdered(QuantityOrdered)
Unit Price	UnitPrice	OrderUnitPrice(OrderUnitPrice)
Net Detail Discount	GUMU__Net_Detail_Discount__c	OrderDiscountAmount(OrderDiscountAmount)
Extension Amount	GUMU__ExtensionAmt__c	ExtensionAmount(ExtensionAmount)
Item Type Code	GUMU__ItemTypeCode__c	Category(Category)
Quantity Committed	Quantity_Committed__c	QuantityCommitted(QuantityCommitted)

Relationship

Target Field	Source Field	Default Value	Parent Object
OrderId	OrderUniquifier(OrderUniquifier)		Order
PrcebookEntryId	UnformattedItemNumber(UnformattedItemNumber)		Price Book Entry

Salespersons

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Salesperson Name	Name	string	Name(Name)
Salesperson Code	GUMU__Salesperson_Code__c	string	SalespersonKey(SalespersonKey)
Salesperson Description	GUMU__Salesperson_Description__c	string	Name(Name)

ShipToLocation

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Zip Code	GUMU__Ship_To_Zip_Code__c	string	ZipPostalCode(ZipPostalCode)
Address1	GUMU__Ship_To_Address1__c	string	AddressLine1(AddressLine1)
Territory	GUMU__Territory__c	string	TerritoryCode(TerritoryCode)
State	GUMU__Ship_To_State__c	string	StateProvince(StateProvince)
Ship To Name	GUMU__Ship_To_Name__c	string	Description(Description)
Ship To Code	GUMU__Ship_To_Code__c	string	ShipToLocationKey(ShipToLocationKey)
Ship To Address Name	Name	string	ShipToLocationKey(ShipToLocationKey)
Ship to Address	GUMU__isShipTo__c	string		yes
Country Code	GUMU__Ship_to_Country_Code__c	string	Country(Country)
City	GUMU__Ship_to_City__c	string	City(City)
Address3	GUMU__Ship_to_Address3__c	string	AddressLine3(AddressLine3)
Address2	GUMU__Ship_to_Address2__c	string	AddressLine2(AddressLine2)

ShipVia

ERP To SF

Target Field Label	Target Field	Data Type	Source Field	Default Value
Ship Via Description	GUMU__Ship_Via_Description__c	string	Name(Name)
Ship Via Code	GUMU__Ship_Via_Code__c	string	Code(Code)
Name	Name	string	Name(Name)

TaxGroup

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Tax Group Code	GUMU__Tax_Group_code__c	string	TaxGroupKey(TaxGroupKey)
Tax Group Description	GUMU__Tax_Group_Description__c	string	Description(Description)
Tax Group Name	Name	string	TaxGroupKey(TaxGroupKey)

TermsCode

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Terms Code	GUMU__Terms_Code__c	string	TermsCode(TermsCode)
Terms Code Description	GUMU__Terms_Code_Description__c	string	Description(Description)

UOM

ERP To SF

Target Field Label	Target Field	Data Type	Source Field
Conversion Factor	GUMU__Conversion_Factor__c	Number	DefaultConversionFactor(DefaultConversionFactor)
UOM Code	GUMU__UOM_Code__c	string	UnitsOfMeasureKey(UnitsOfMeasureKey)
Unit Of Measure Name	Name	string	UnitsOfMeasureKey(UnitsOfMeasureKey)