Default Mappings
Sage100 - ARDivision
ERP to SF
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
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
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
string
EmailAddress
TRUE
SF to ERP
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
EmailAddress
Mobile
MobilePone
TelephoneNo2
Relationship
AccountId
ARDivisionNo (ARDivisionNo)
Account
AccountId
CustomerNo (CustomerNo)
Account
Sage100 - Customer
ERP to SF
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
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
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
Default ShipTo
GUMU__Default_ShipTo__c
string
Yes
Ship to Address
GUMU__isShipTo__c
string
Yes
Relationship
GUMU__Account_Id__c
ARDivisionNo
Account
CustomerNo
Account
Sage100 - Order
ERP to SF
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
Last updated
Was this helpful?