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 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 |