7.6.1.2 Default Mapping BA

As of version 2.126, the Mapping BA is now hard coded and the custom settings Mapping BA will only be used to overwrite the default Mapping BA where needed by customers. Below is the default Mapping BA as set in the code. Users can overwrite this by configuring their custom settings Mapping BA.

Source:

Name

Source

Accounting Date

 

AdDayOfWeek

Item.AdDayOfWeek__c

AdHourOfDay

Item.AdHourOfDay__c

Ad Key Values

Item.AdKeyValues__c

AdOperatingSystems

Item.AdOperatingSystems__c

Ad Type External

Item.Ad_Price__r.Ad_Spec__r.Ad_Type__r.External_Name__c

Ad Type

Item.Ad_Price__r.Ad_Spec__r.Ad_Type__r.Name

Ad Spec Description On PDF

Item.Ad_Price__r.Ad_Spec__r.DescriptionOnPDF__c

Ad Spec Distribution

Item.Ad_Price__r.Ad_Spec__r.Distribution__c

Ad Spec External Name

Item.Ad_Price__r.Ad_Spec__r.External_Name__c

Ad Spec Name

Item.Ad_Price__r.Ad_Spec__r.Name

Placement External

Item.Ad_Price__r.Ad_Spec__r.Placement__r.External_Name__c

Placement

Item.Ad_Price__r.Ad_Spec__r.Placement__r.Name

Site External

Item.Ad_Price__r.Ad_Spec__r.Placement__r.Site__r.External_Name__c

Site

Item.Ad_Price__r.Ad_Spec__r.Placement__r.Site__r.Name

Ad Spec Use External Name on PDF

Item.Ad_Price__r.Ad_Spec__r.UseExternalNameOnPDF__c

AdWebBrowsers

Item.AdWebBrowsers__c

Advertised Brand Name

AdvertisedBrand__r.Name

Advertiser Billing City

Account__r.BillingCity

Advertiser Billing Country

Account__r.BillingCountry

Advertiser Billing Postal Code

Account__r.BillingPostalCode

Advertiser Billing State

Account__r.BillingState

Advertiser Billing Street

Account__r.BillingStreet

Advertiser Contact Email

 

Advertiser Contact Fax

 

Advertiser Contact Phone

 

Advertiser Contact Name

 

Advertiser Debitor Id

Account__r.AccountNumber

Advertiser Lookup

Account__c

Advertiser Name

Account__r.Name

Advertiser Number

Account__r.AccountNumber

Advertiser VAT Id

Account__r.VATID__c

Agency Billing City

Agency__r.BillingCity

Agency Billing Country

Agency__r.BillingCountry

Agency Billing Postal Code

Agency__r.BillingPostalCode

Agency Billing State

Agency__r.BillingState

Agency Billing Street

Agency__r.BillingStreet

Agency Commission

Item.EffectiveAgencyCommission__c

Agency Contact Email

 

Agency Contact Fax

 

Agency Contact Phone

 

Agency Contact Name

 

Agency Debitor Id

Agency__r.AccountNumber

Agency Lookup

Agency__c

Agency Name

Agency__r.Name

Agency Number

Agency__r.AccountNumber

Agency VAT Id

Agency__r.VATID__c

Beneficiary Billing City

Principal__r.BillingCity

Beneficiary Billing Country

Principal__r.BillingCountry

Beneficiary Billing Postal Code

Principal__r.BillingPostalCode

Beneficiary Billing State

Principal__r.BillingState

Beneficiary Billing Street

Principal__r.BillingStreet

Beneficiary Contact Email

 

Beneficiary Contact Phone

 

Beneficiary Contact Fax

 

Beneficiary Contact Name

 

Beneficiary Debitor Id

Principal__r.AccountNumber

Beneficiary Lookup

Principal__c

Beneficiary Name

Principal__r.Name

Beneficiary Number

Principal__r.AccountNumber

Beneficiary VAT Id

Principal__r.VATID__c

Bill Record (Item)

Item.BillMe__c

Bill Record

BillMe__c

Billing Category

Item.Billing_category__c

Billing Status

Item.BillingStatus__c

Booked Quantity

Item.Quantity__c

Campaign End

Campaign_End_Date__c

Campaign Name

Name

Campaign Start

Campaign_Start_Date__c

Connected Item Id

Item.ConnectedItemID__c

Contact Email

Contact.Contact__r.Email

Contact Fax

Contact.Contact__r.Fax

Contact First Name

Contact.Contact__r.FirstName

Contact Last Name

Contact.Contact__r.LastName

Contact Mailing City

Contact.Contact__r.MailingCity

Contact Mailing Country

Contact.Contact__r.MailingCountry

Contact Mailing Postal Code

Contact.Contact__r.MailingPostalCode

Contact Mailing State

Contact.Contact__r.MailingState

Contact Mailing Street

Contact.Contact__r.MailingStreet

Contact Name

Contact.Contact__r.Name

Contact Phone

Contact.Contact__r.Phone

Contact Role

Contact.Campaign_Contact_Role__c

Contact Salutation Letter

Contact.Contact__r.Salutation_Letter__c

Contact

Contact.Contact__c

Currency (Item)

Item.CurrencyIsoCode

Currency

CurrencyIsoCode

Day Time Targeting

Item.DayTimeTargeting__c

Days Early Payment Discount

TermsOfPayment__r.DaysEarlyPaymentDiscount__c

Delivery AutoImport

 

Description

Description__c

Invoice Dispatch Type

Dispatch__c

Distribution (Period)

Item.DistributionPeriod__c

Distribution (Unit)

Item.DistributionUnit__c

Early Payment Discount

TermsOfPayment__r.EarlyPaymentDiscount__c

End Date

Item.until_Date__c

External Media Campaign Name

external_Media_Campaign_Name__c

Frequency Capping

Item.FrequencyCapping__c

Frequency

Item.Frequency__c

Guaranteed AI

Item.Guaranteed_AI__c

Hide Brands/Products On PDF

Item.HideBrandsProductsOnPdf__c

Hide components of adhoc packages on PDF

HideComponentsOfAdhocPackagesOnPdf__c

Hide Content Targeting On PDF

Item.HideContentTargetingOnQuote__c

Hide FC On PDF

Item.HideFCOnQuote__c

Hide Geo/Device Targeting on PDF

Item.HideGeoDeviceTargetingOnPDF__c

Hide Geo Targeting On PDF

Item.HideGeoTargetingOnQuote__c

Hide Key Value Targeting On PDF

Item.HideKeyValueTargetingOnQuote__c

Hide Package Header Details on PDF

Item.HidePackageHeaderDetailsOnPDF__c

Hide Publication Date Targeting On PDF

Item.HidePublicationDateTargetingOnQuote__c

Hide Technical Targeting On PDF

Item.HideTechnicalTargetingOnQuote__c

Hide Time Targeting On PDF

Item.HideTimeTargetingOnQuote__c

Intermediary Billing City

Intermediary__r.BillingCity

Intermediary Billing Country

Intermediary__r.BillingCountry

Intermediary Billing Postal Code

Intermediary__r.BillingPostalCode

Intermediary Billing State

Intermediary__r.BillingState

Intermediary Billing Street

Intermediary__r.BillingStreet

Intermediary Debitor Id

Intermediary__r.AccountNumber

Intermediary Lookup

Intermediary__c

Intermediary Name

Intermediary__r.Name

Intermediary Number

Intermediary__r.AccountNumber

Intermediary VAT Id

Intermediary__r.VATID__c

Invoice by Delivery

Item.LinearDistribution__c

Invoice Date

 

Invoice Recipient Contact Email

invoice_recipient__r.InvoiceEmail__c

Invoiced Quantity

 

IsCPMPrice

Item.IsCPMPrice__c

Description (Item)

Item.LineDescription__c

Item Master

Item.Media_Campaign__c

Item Name

Item.Name

Item Object

Campaign_Item__c

Quantity Discount (Item)

Item.Rate_Discount_1__c

Customer Discount (Item)

Item.Rate_Discount_2__c

Agency Discount (Item)

Item.Rate_Discount_3__c

Item Record Type

Item.RecordType.DeveloperName

Third Party Commission (Item)

Item.Third_party_commission__c

Item Uniquekey

 

VAT-Exempt (Item)

Item.VATExempt__c

Language

Quote_Language__c

Legal Entity Country

SellerCountry__c

Locale

Quote_Locale__c

Master Object

MediaCampaign__c

MediaCampaign

 

Non-Media

Item.NonMedia__c

Ext. Order No.

 

Order No.

MediaCampaignFullNumber__c

Package

Item.Package__c

Packet Item Id

Item.PacketItem__c

Packet Item Package

Item.PacketItem__r.Package__c

Payment Due Date

PaymentDueDate__c

Payment Interval

PaymentInterval__c

Payment Start

PaymentStart__c

PaymentTerms

PaymentTermsLong__c

Position Number Appendix

Item.PositionNumberAppendix__c

Position Number

Item.PositionNumber__c

Postal-Recipient Billing City

PostalRecipient__r.BillingCity

Postal-Recipient Billing Country

PostalRecipient__r.BillingCountry

Postal-Recipient Billing Postal Code

PostalRecipient__r.BillingPostalCode

Postal-Recipient Billing State

PostalRecipient__r.BillingState

Postal-Recipient Billing Street

PostalRecipient__r.BillingStreet

Postal-Recipient Debitor Id

PostalRecipient__r.AccountNumber

Postal-Recipient Lookup

PostalRecipient__c

Postal-Recipient Name

PostalRecipient__r.Name

Postal-Recipient Number

PostalRecipient__r.AccountNumber

Postal-Recipient VAT Id

PostalRecipient__r.VATID__c

Probability

 

Prorated

Item.Prorated__c

Rate Criterion

Item.Ad_Price__r.RateCriterion__c

Quantity Discount Abs. Custom

Item.RateDiscount1AbsCustom__c

Quantity Discount

Rate_Discount_1__c

Customer Discount Abs. Custom

Item.RateDiscount2AbsCustom__c

Rate Discount 2 Name

Item.RateDiscount2Name__c

Customer Discount

Rate_Discount_2__c

Agency Discount Abs. Custom

Item.RateDiscount3AbsCustom__c

Agency Discount

Rate_Discount_3__c

Special Discount Abs. Custom

Item.RateDiscount4AbsCustom__c

Rate Discount 4 Name

Item.Rate_Discount_4_Name__c

Special Discount

Item.Rate_Discount_4__c

Debtor Billing City

invoice_recipient__r.BillingCity

Debtor Billing Country

invoice_recipient__r.BillingCountry

Debtor Billing Postal Code

invoice_recipient__r.BillingPostalCode

Debtor Billing State

invoice_recipient__r.BillingState

Debtor Billing Street

invoice_recipient__r.BillingStreet

Debtor Contact Email

 

Debtor Contact Fax

 

Debtor Contact Phone

 

Debtor Contact

 

Debtor Debtor Id

invoice_recipient__r.AccountNumber

Debtor Lookup

invoice_recipient__c

Debtor Name

invoice_recipient__r.Name

Debtor Number

invoice_recipient__r.AccountNumber

Debtor VAT Id

invoice_recipient__r.VATID__c

Reverse-Charge Mechanism

ReverseChargeMechanism__c

Sales Representative

OwnerId

Sales Tax Id

 

Selected AdServer ID Information

Item.SelectedAdServerIdInformation__c

Selected Brands/Products Information

Item.SelectedBrandProductInformation__c

Selected City Information

Item.SelectedCityInformation__c

Selected Content Information

Item.SelectedContentInformation__c

Selected Country Information

Item.SelectedCountryInformation__c

Selected Publication Date Information

Item.SelectedPublicationDateInformation__c

Selected Region Information

Item.SelectedRegionInformation__c

Show on Invoice PDF

 

Show Packet Component On PDF

Item.PacketItem__r.ShowPacketComponentsOnQuote__c

Show Third Party Commission

Show_Third_Party_Commission__c

Sort Order

Item.SortOrder__c

Start Date

Item.from_Date__c

Status

 

Surcharge (B2) Abs

Item.SurchargeB2Abs__c

Surcharge (B2)

Item.SurchargeB2__c

Surcharge (B3) Abs

Item.SurchargeB3Abs__c

Surcharge (B3)

Item.SurchargeB3__c

Surcharge Sales Price %

Item.SurchargeSalespricePct__c

SurchargeSalesPrice

Item.SurchargeSalesPrice__c

Terms Of Payment Days Net

TermsOfPayment__r.DaysNet__c

Terms Of Payment Text

TermsOfPayment__r.Name

Third Party Commission

Third_party_commission__c

Transaction Type

TransactionType__c

Unitprice

Item.Sales_Price__c

Use Item Name On PDF

Item.UseItemNameOnPdf__c

VAT Exempt

VATExempt__c

VAT Total

 

VAT Type

Item.Ad_Price__r.Ad_Spec__r.VATType__c

Reference Number

your_reference_number2__c

 

 

 

Target

Name

Target

Accounting Date

 

AdDayOfWeek

Item.AdDayOfWeek__c

AdHourOfDay

Item.AdHourOfDay__c

Ad Key Values

Item.AdKeyValues__c

AdOperatingSystems

Item.AdOperatingSystems__c

Ad Type External

Item.AdSpecAdTypeExternalName__c

Ad Type

Item.AdSpecAdTypeName__c

Ad Spec Description On PDF

Item.AdSpecDescriptionOnPDF__c

Ad Spec Distribution

Item.AdSpecDistribution__c

Ad Spec External Name

Item.AdSpecExternalName__c

Ad Spec Name

Item.AdSpecName__c

Placement External

Item.AdSpecPlacementExternalName__c

Placement

Item.AdSpecPlacementName__c

Site External

Item.AdSpecSiteExternalName__c

Site

Item.AdSpecSiteName__c

Ad Spec Use External Name on PDF

Item.AdSpecUseExternalNameOnPDF__c

AdWebBrowsers

Item.AdWebBrowsers__c

Advertised Brand Name

AdvertisedBrandName__c

Advertiser Billing City

AdvertiserBillingCity__c

Advertiser Billing Country

AdvertiserBillingCountry__c

Advertiser Billing Postal Code

AdvertiserBillingPostalCode__c

Advertiser Billing State

AdvertiserBillingState__c

Advertiser Billing Street

AdvertiserBillingStreets__c

Advertiser Contact Email

AdvertiserContactEmail__c

Advertiser Contact Fax

AdvertiserContactFax__c

Advertiser Contact Phone

AdvertiserContactPhone__c

Advertiser Contact Name

AdvertiserContact__c

Advertiser Debitor Id

AdvertiserDebitorId__c

Advertiser Lookup

AdvertiserId__c

Advertiser Name

AdvertiserName__c

Advertiser Number

AdvertiserNumber__c

Advertiser VAT Id

AdvertiserVATId__c

Agency Billing City

AgencyBillingCity__c

Agency Billing Country

AgencyBillingCountry__c

Agency Billing Postal Code

AgencyBillingPostalCode__c

Agency Billing State

AgencyBillingState__c

Agency Billing Street

AgencyBillingStreets__c

Agency Commission

Item.AgencyCommission__c

Agency Contact Email

AgencyContactEmail__c

Agency Contact Fax

AgencyContactFax__c

Agency Contact Phone

AgencyContactPhone__c

Agency Contact Name

AgencyContact__c

Agency Debitor Id

AgencyDebitorId__c

Agency Lookup

AgencyId__c

Agency Name

AgencyName__c

Agency Number

AgencyNumber__c

Agency VAT Id

AgencyVATId__c

Beneficiary Billing City

BeneficiaryBillingCity__c

Beneficiary Billing Country

BeneficiaryBillingCountry__c

Beneficiary Billing Postal Code

BeneficiaryBillingPostalCode__c

Beneficiary Billing State

BeneficiaryBillingState__c

Beneficiary Billing Street

BeneficiaryBillingStreets__c

Beneficiary Contact Email

 

Beneficiary Contact Phone

 

Beneficiary Contact Fax

 

Beneficiary Contact Name

 

Beneficiary Debitor Id

BeneficiaryDebitorId__c

Beneficiary Lookup

BeneficiaryId__c

Beneficiary Name

BeneficiaryName__c

Beneficiary Number

BeneficiaryNumber__c

Beneficiary VAT Id

BeneficiaryVATId__c

Bill Record (Item)

 

Bill Record

 

Billing Category

Item.BillingCategory__c

Billing Status

 

Booked Quantity

Item.BookedQuantity__c

Campaign End

BillingPeriodEndDate__c

Campaign Name

CampaignName__c

Campaign Start

BillingPeriodStartDate__c

Connected Item Id

 

Contact Email

Contact.Email__c

Contact Fax

Contact.Fax__c

Contact First Name

Contact.FirstName__c

Contact Last Name

Contact.LastName__c

Contact Mailing City

Contact.MailingCity__c

Contact Mailing Country

Contact.MailingCountry__c

Contact Mailing Postal Code

Contact.MailingPostalCode__c

Contact Mailing State

Contact.MailingState__c

Contact Mailing Street

Contact.MailingStreet__c

Contact Name

Contact.Name__c

Contact Phone

Contact.Phone__c

Contact Role

Contact.Role__c

Contact Salutation Letter

Contact.SalutationLetter__c

Contact

Contact.Contact__c

Currency (Item)

Item.CurrencyIsoCode

Currency

CurrencyIsoCode

Day Time Targeting

Item.DayTimeTargeting__c

Days Early Payment Discount

DaysEarlyPaymentDiscount__c

Delivery AutoImport

Item.DeliveryAutoImport__c

Description

Description__c

Invoice Dispatch Type

Dispatch__c

Distribution (Period)

Item.DistributionPeriod__c

Distribution (Unit)

Item.DistributionUnit__c

Early Payment Discount

Early_Payment_Discount__c

End Date

Item.UntilDate__c

External Media Campaign Name

ExternalMediaCampaignName__c

Frequency Capping

Item.FrequencyCapping__c

Frequency

Item.Frequency__c

Guaranteed AI

Item.GuaranteedAI__c

Hide Brands/Products On PDF

Item.HideBrandsProductsOnPdf__c

Hide components of adhoc packages on PDF

HideComponentsOfAdhocPackagesOnPdf__c

Hide Content Targeting On PDF

Item.HideContentTargetingOnPDF__c

Hide FC On PDF

Item.HideFCOnPDF__c

Hide Geo/Device Targeting on PDF

Item.HideGeoDeviceTargetingOnPDF__c

Hide Geo Targeting On PDF

Item.HideGeoTargetingOnPDF__c

Hide Key Value Targeting On PDF

Item.HideKeyValueTargetingOnPDF__c

Hide Package Header Details on PDF

Item.HidePackageHeaderDetailsOnPDF__c

Hide Publication Date Targeting On PDF

Item.HidePublicationDateTargetingOnPDF__c

Hide Technical Targeting On PDF

Item.HideTechnicalTargetingOnPDF__c

Hide Time Targeting On PDF

Item.HideTimeTargetingOnPDF__c

Intermediary Billing City

IntermediaryBillingCity__c

Intermediary Billing Country

IntermediaryBillingCountry__c

Intermediary Billing Postal Code

IntermediaryBillingPostalCode__c

Intermediary Billing State

IntermediaryBillingState__c

Intermediary Billing Street

IntermediaryBillingStreets__c

Intermediary Debitor Id

IntermediaryDebitorId__c

Intermediary Lookup

IntermediaryId__c

Intermediary Name

IntermediaryName__c

Intermediary Number

IntermediaryNumber__c

Intermediary VAT Id

IntermediaryVATId__c

Invoice by Delivery

Item.LinearDistribution__c

Invoice Date

 

Invoice Recipient Contact Email

InvoiceEmailAddress__c

Invoiced Quantity

Item.InvoicedQuantity__c

IsCPMPrice

Item.IsCPMPrice__c

Description (Item)

Item.LineDescription__c

Item Master

 

Item Name

Item.Name

Item Object

InvoiceItem__c

Quantity Discount (Item)

Item.RateDiscount1__c

Customer Discount (Item)

Item.RateDiscount2__c

Agency Discount (Item)

Item.RateDiscount3__c

Item Record Type

Item.ItemRecordType__c

Third Party Commission (Item)

Item.ThirdPartyCommission__c

Item Uniquekey

 

VAT-Exempt (Item)

Item.VATExempt__c

Language

QuoteLanguage__c

Legal Entity Country

LegalEntityCountry__c

Locale

QuoteLocale__c

Master Object

Invoice__c

MediaCampaign

MediaCampaign__c

Non-Media

Item.NonMedia__c

Ext. Order No.

OrderExtNumber__c

Order No.

OrderNumber__c

Package

Item.Package__c

Packet Item Id

Item.PacketItemId__c

Packet Item Package

Item.PacketItemPackage__c

Payment Due Date

PaymentDueDate__c

Payment Interval

PaymentInterval__c

Payment Start

PaymentStart__c

PaymentTerms

PaymentTerms__c

Position Number Appendix

Item.PositionNumberAppendix__c

Position Number

Item.PositionNumber__c

Postal-Recipient Billing City

PostalRecipientBillingCity__c

Postal-Recipient Billing Country

PostalRecipientBillingCountry__c

Postal-Recipient Billing Postal Code

PostalRecipientBillingPostalCode__c

Postal-Recipient Billing State

PostalRecipientBillingState__c

Postal-Recipient Billing Street

PostalRecipientBillingStreets__c

Postal-Recipient Debitor Id

PostalRecipientDebitorId__c

Postal-Recipient Lookup

PostalRecipientId__c

Postal-Recipient Name

PostalRecipientName__c

Postal-Recipient Number

PostalRecipientNumber__c

Postal-Recipient VAT Id

PostalRecipientVATId__c

Probability

 

Prorated

Item.Prorated__c

Rate Criterion

Item.RateCriterion__c

Quantity Discount Abs. Custom

Item.CiRateDiscount1AbsCustom__c

Quantity Discount

RateDiscount1__c

Customer Discount Abs. Custom

Item.CiRateDiscount2AbsCustom__c

Rate Discount 2 Name

Item.RateDiscount2Name__c

Customer Discount

RateDiscount2__c

Agency Discount Abs. Custom

Item.CiRateDiscount3AbsCustom__c

Agency Discount

RateDiscount3__c

Special Discount Abs. Custom

Item.CiRateDiscount4AbsCustom__c

Rate Discount 4 Name

Item.RateDiscount4Name__c

Special Discount

Item.RateDiscount4__c

Debtor Billing City

RecipientBillingCity__c

Debtor Billing Country

RecipientBillingCountry__c

Debtor Billing Postal Code

RecipientBillingPostalCode__c

Debtor Billing State

RecipientBillingState__c

Debtor Billing Street

RecipientBillingStreets__c

Debtor Contact Email

RecipientContactEmail__c

Debtor Contact Fax

RecipientContactFax__c

Debtor Contact Phone

RecipientContactPhone__c

Debtor Contact

RecipientContact__c

Debtor Debtor Id

RecipientDebitorId__c

Debtor Lookup

RecipientId__c

Debtor Name

RecipientName__c

Debtor Number

RecipientNumber__c

Debtor VAT Id

RecipientVATId__c

Reverse-Charge Mechanism

ReverseChargeMechanism__c

Sales Representative

SalesRep__c

Sales Tax Id

SalesTaxIdNr__c

Selected AdServer ID Information

Item.SelectedAdServerIdInformation__c

Selected Brands/Products Information

Item.SelectedBrandProductInformation__c

Selected City Information

Item.SelectedCityInformation__c

Selected Content Information

Item.SelectedContentInformation__c

Selected Country Information

Item.SelectedCountryInformation__c

Selected Publication Date Information

Item.SelectedPublicationDateInformation__c

Selected Region Information

Item.SelectedRegionInformation__c

Show on Invoice PDF

 

Show Packet Component On PDF

Item.ShowPacketComponentOnPDF__c

Show Third Party Commission

ShowThirdPartyCommission__c

Sort Order

Item.SortOrder__c

Start Date

Item.FromDate__c

Status

Status__c

Surcharge (B2) Abs

Item.SurchargeB2Abs__c

Surcharge (B2)

Item.SurchargeB2__c

Surcharge (B3) Abs

Item.SurchargeB3Abs__c

Surcharge (B3)

Item.SurchargeB3__c

Surcharge Sales Price %

Item.SurchargeSalespricePct__c

SurchargeSalesPrice

Item.SurchargeSalesPrice__c

Terms Of Payment Days Net

TermsOfPaymentDaysNet__c

Terms Of Payment Text

TermsOfPaymentText__c

Third Party Commission

ThirdPartyCommission__c

Transaction Type

TransactionType__c

Unitprice

Item.Salesprice__c

Use Item Name On PDF

Item.UseItemNameOnPdf__c

VAT Exempt

VATExempt__c

VAT Total

 

VAT Type

Item.VATType__c

Reference Number

YourReferenceNumber__c