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

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)

Last updated

Was this helpful?