Advanced dunning letter
These tables contain the field mapping to build your advanced dunning letter IDM template.
Business Class: DunningLetterHeader
List: DunningLetterHeaderListforIDMDoc
| XML field | Description | FSM field |
|---|---|---|
| Date | Current Date | TodaysDate |
| Company | Company | Company |
| CompanyName | Company Name | Company.Name |
| CompanyAddress1 | Company PostalAddress AddressLine1 | Company.PostalAddress.DeliveryAddress.AddressLine1 |
| CompanyAddress2 | Company PostalAddress AddressLine2 | Company.PostalAddress.DeliveryAddress.AddressLine2 |
| CompanyAddress3 | Company PostalAddress AddressLine3 | Company.PostalAddress.DeliveryAddress.AddressLine3 |
| CompanyAddress4 | Company PostalAddress AddressLine4 | Company.PostalAddress.DeliveryAddress.AddressLine4 |
| CompanyAddressCity | Company PostalAddress Municipality | Company.PostalAddress.Municipality |
| CompanyAddressState | Company PostalAddress StateProvince | Company.PostalAddress.StateProvince |
| CompanyAddressPostal | Company PostalAddress PostalCode | Company.PostalAddress.PostalCode |
| CompanyAddressCounty | Company PostalAddress County | Company.PostalAddress.County |
| CompanyAddressRegion | Company PostalAddress Region | Company.PostalAddress.Region |
| CompanyCountry | Company PostalAddress Country | Company.PostalAddress.Country |
| CreditAnalystNumber | Credit Analyst Number | CreditAnalyst |
| CreditAnalystName | Credit Analyst Name | CreditAnalyst.Name |
| CreditAnalystPhoneNumber | Credit Analyst Phone Number | DerivedCreditAnalystPhoneNumber |
| CreditAgencyName | Company Customer Credit Agency Name | CompanyCustomerRel.CreditAgencyName |
| CreditAgencyAddress1 | Company Customer CreditAgencyPostalAddress DeliveryAddress AddressLine1 | CompanyCustomerRel.CreditAgencyPostalAddress.DeliveryAddress.AddressLine1 |
| CreditAgencyAddress2 | Company Customer CreditAgencyPostalAddress DeliveryAddress AddressLine2 | CompanyCustomerRel.CreditAgencyPostalAddress.DeliveryAddress.AddressLine2 |
| CreditAgencyAddress3 | Company Customer CreditAgencyPostalAddress DeliveryAddress AddressLine3 | CompanyCustomerRel.CreditAgencyPostalAddress.DeliveryAddress.AddressLine3 |
| CreditAgencyAddress4 | Company Customer CreditAgencyPostalAddress DeliveryAddress AddressLine4 | CompanyCustomerRel.CreditAgencyPostalAddress.DeliveryAddress.AddressLine4 |
| CreditAgencyAddressCity | Company Customer CreditAgencyPostalAddress DeliveryAddress Municipality | CompanyCustomerRel.CreditAgencyPostalAddress.Municipality |
| CreditAgencyState | Company Customer CreditAgencyPostalAddress DeliveryAddress State Province | CompanyCustomerRel.CreditAgencyPostalAddress.StateProvince |
| CreditAgencyPostal | Company Customer CreditAgencyPostalAddress DeliveryAddress Postal Code | CompanyCustomerRel.CreditAgencyPostalAddress.PostalCode |
| CreditAgencyCounty | Company Customer CreditAgencyPostalAddress DeliveryAddress County | CompanyCustomerRel.CreditAgencyPostalAddress.County |
| CreditAgencyCountry | Company Customer CreditAgencyPostalAddress DeliveryAddress Country | CompanyCustomerRel.CreditAgencyPostalAddress.Country |
| CreditAgencyCountryName | Company Customer CreditAgencyPostalAddress DeliveryAddress Country Name | CompanyCustomerRel.CreditAgencyPostalAddress.Country.Name |
| CustomerNumber | Customer Number | Customer |
| CustomerName | Customer Name | Customer.Name |
| CustomerAddress1 | Customer PostalAddress AddressLine1 | Customer.PostalAddress.DeliveryAddress.AddressLine1 |
| CustomerAddress2 | Customer PostalAddress AddressLine2 | Customer.PostalAddress.DeliveryAddress.AddressLine2 |
| CustomerAddress3 | Customer PostalAddress AddressLine3 | Customer.PostalAddress.DeliveryAddress.AddressLine3 |
| CustomerAddress4 | Customer PostalAddress AddressLine4 | Customer.PostalAddress.DeliveryAddress.AddressLine4 |
| CustomerAddressCity | Customer PostalAddress Municipality | Customer.PostalAddress.Municipality |
| CustomerAddressState | Customer PostalAddress StateProvince | Customer.PostalAddress.StateProvince |
| CustomerAddressPostal | Customer PostalAddress PostalCode | Customer.PostalAddress.PostalCode |
| CustomerAddressCounty | Customer PostalAddress County | Customer.PostalAddress.County |
| CustomerAddressRegion | Customer PostalAddress Region | Customer.PostalAddress.Region |
| CustomerCountry | Customer PostalAddress Country | Customer.PostalAddress.Country |
| DunningText | Dunning Letter Text | DunningText |
| Currency | Total Open Amount Currency | DerivedCurrency |
| TotalDue | Total Open Amount in Company Currency | TotalDunned |
| CurrentBalance | Current Balance | CurrentBalance |
| FeeAmount | Fee Amount | FeeAmount |
| CustomerContact | Customer Contact | Customer.Contact |
| CustomerContactTitle | Customer Contact Title | Customer.ContactTitle |
| CustomerCustomerReference | Customer Reference | Customer.CustomerReference |
| CustomerCustomerReference2 | Customer Reference2 | Customer.CustomerReference2 |
| CustomerElectronicGovernmentID | Customer Electronic Government ID | Customer.ElectronicGovernmentID |
| CustomerLegalName | Customer Legal Name | Customer.LegalName |
| CustomerSocialNetworkID2 | Customer Social Network ID2 | Customer.SocialNetworkID2 |
| CustomerSocialNetworkID3 | Customer Social Network ID3 | Customer.SocialNetworkID3 |
| CustomerSocialNetworkID4 | Customer Social Network ID4 | Customer.SocialNetworkID4 |
| CustomerSocialNetworkID5 | Customer Social Network ID5 | Customer.SocialNetworkID5 |
| CustomerTaxID | Customer Tax ID | Customer.TaxID |
| CustomerTaxIdentificationType | Customer TaxIdentification Type | Customer.TaxIdentificationType |
| CustomerTaxRegistrationType | Customer Tax Registration Type | Customer.TaxRegistrationType |
| CustomerTwitterID | Customer Twitter ID | Customer.TwitterID |
| CustomerURLAddress | Customer URL Address | Customer.URLAddress |
| CustomerVATRegistrationCountry | Customer VAT Registration Country | Customer.VATRegistrationCountry |
| CustomerVATRegistrationNumber | Customer VAT Registration Number | Customer.VATRegistrationNumber |
| CompanyCustomerAlternateEDINumber | Company Customer Alternate EDI Number | CompanyCustomerRel.AlternateEDINumber |
| CompanyCustomerAlternateEDIType | Company Customer Alternate EDI Type | CompanyCustomerRel.AlternateEDIType |
| CompanyCustomerContact | Company Customer Contact | CompanyCustomerRel.Contact |
| CompanyCustomerCreditAnalyst | Company Customer Credit Analyst | CompanyCustomerRel.CreditAnalyst |
| CompanyCustomerCustomerMajorClass | Company Customer Major Class | CompanyCustomerRel.CustomerMajorClass |
| CompanyCustomerCustomerMinorClass | Company Customer Minor Class | CompanyCustomerRel.CustomerMinorClass |
| CompanyCustomerEDINumber | Company Customer EDI Number | CompanyCustomerRel.EDINumber |
| CompanyCustomerStartDate | Company Customer Start Date | CompanyCustomerRel.StartDate |
| CompanyCustomerVATRegistrationCountry | Company Customer VAT Registration Country | CompanyCustomerRel.VATRegistrationCountry |
| CompanyCustomerVATRegistrationNumber | Company Customer VAT Registration Number | CompanyCustomerRel.VATRegistrationNumber |
Business Class: DunningLetterDetail
List: DunningLetterDetailListforIDMDoc
Path: /AdvancedDunningLetter/Lines/Line
| XML field | Description | FSM field |
|---|---|---|
| TransNumber | Transaction Number | DerivedReceivableInvoice |
| TransType | Transaction Type / Invoice Detail Type | DunningLetterDetail.DunningLetterGroup.ReceivableInvoiceDetailType |
| TransDate | Transaction Date | DerivedTransactionDate |
| DueDate | Transaction Due Date | DueDate |
| DueDays | Transaction Due Days | DueDays |
| TransCurrency | Transaction Currency / Invoice Currency | Currency |
| TransAmount | Transaction Amount | TransactionAmount |
| DueAmount | Transaction Open Amount | PastDueAmount |
| FunctionalAmount | Functional Amount | ReceivableInvoiceDetailRel.SignedBaseAmount |
| FunctionalDueAmount | Base Open Amount / Functional Open Amount | DerivedBaseOpenAmount |
| ReceivableInvoiceCustomerBillTo | Receivable Invoice Customer Bill To | ReceivableInvoiceRel.CustomerBillTo |
| ReceivableInvoiceCertificationDate | Receivable Invoice Certification Date | ReceivableInvoiceRel.CertificationDate |
| ReceivableInvoiceCertificationNumber | Receivable Invoice Certification Number | ReceivableInvoiceRel.CertificationNumber |
| ReceivableInvoiceCustomerOrder | Receivable Invoice Customer Order | ReceivableInvoiceRel.CustomerOrder |
| ReceivableInvoiceDescription | Receivable Invoice Description | ReceivableInvoiceRel.Description |
| ReceivableInvoiceEWayBillNumber | Receivable Invoice E Way Bill Number | ReceivableInvoiceRel.EWayBillNumber |
| ReceivableInvoiceForeignEconomicRegulatoryCode | Receivable Invoice Foreign Economic Regulatory Code | ReceivableInvoiceRel.ForeignEconomicRegulatoryCode |
| ReceivableInvoiceInvoiceTypeCode | Receivable Invoice Invoice Type Code | ReceivableInvoiceRel.InvoiceTypeCode |
| ReceivableInvoiceParallelReference | Receivable Invoice Parallel Reference | ReceivableInvoiceRel.ParallelReference |
| ReceivableInvoiceReceivableProcessLevel | Receivable Invoice Process Level | ReceivableInvoiceRel.ReceivableProcessLevel |
| ReceivableInvoiceRegimeCode | Receivable Invoice Regime Code | ReceivableInvoiceRel.RegimeCode |
| ReceivableInvoiceTaxExempt | Receivable Invoice Tax Exempt | ReceivableInvoiceRel.TaxExempt |
| ReceivableInvoiceTransactionUserField1 | Receivable Invoice Transaction User Field 1 | ReceivableInvoiceRel.TransactionUserField1 |
| ReceivableInvoiceTransactionUserField2 | Receivable Invoice Transaction User Field 2 | ReceivableInvoiceRel.TransactionUserField2 |
| ReceivableInvoiceTransactionUserField3 | Receivable Invoice Transaction User Field 3 | ReceivableInvoiceRel.TransactionUserField3 |
| ReceivableInvoiceTransactionUserField4 | Receivable Invoice Transaction User Field 4 | ReceivableInvoiceRel.TransactionUserField4 |
| ReceivableInvoiceTransactionUserField5 | Receivable Invoice Transaction User Field 5 | ReceivableInvoiceRel.TransactionUserField5 |
| ReceivableInvoiceVoucherReferenceNumber | Receivable Invoice Voucher Reference Number | ReceivableInvoiceRel.VoucherReferenceNumber |
| ReceivableInvoiceDetailDescription | Receivable Invoice Detail Description | ReceivableInvoiceDetailRel.Description |
| ReceivableInvoiceDetailDiscountAmount | Receivable Invoice Detail Discount Amount | ReceivableInvoiceDetailRel.DerivedDiscount1Amount |
| ReceivableInvoiceDetailDiscountDate | Receivable Invoice Detail Discount Date | ReceivableInvoiceDetailRel.DiscountDate.DiscDate[1] |
| ReceivableInvoiceDetailDiscount2Amount | Receivable Invoice Detail Discount2 Amount | ReceivableInvoiceDetailRel.DerivedDiscount2Amount |
| ReceivableInvoiceDetailDiscount2Date | Receivable Invoice Detail Discount2 Date | ReceivableInvoiceDetailRel.DiscountDate.DiscDate[2] |
| ReceivableInvoiceDetailDiscount3Amount | Receivable Invoice Detail Discount3 Amount | ReceivableInvoiceDetailRel.DerivedDiscount3Amount |
| ReceivableInvoiceDetailDiscount3Date | Receivable Invoice Detail Discount3 Date | ReceivableInvoiceDetailRel.DiscountDate.DiscDate[3] |
| CalculatedDiscount | Receivable Invoice Detail Calculated Discount | ReceivableInvoiceDetailRel.DerivedDiscountAmount |
| ReceivableInvoiceDetailHSNSACCode | Receivable Invoice Detail HSNSAC Code | ReceivableInvoiceDetailRel.HSNSACCode |
| ReceivableInvoiceDetailItemReference | Receivable Invoice Detail Item Reference | ReceivableInvoiceDetailRel.ItemReference |
| ReceivableInvoiceDetailItemUser1 | Receivable Invoice Detail Item User1 | ReceivableInvoiceDetailRel.ItemUser1 |
| ReceivableInvoiceDetailLastStatementDate | Receivable Invoice Detail Last Statement Date | ReceivableInvoiceDetailRel.LastStatementDate |
| ReceivableInvoiceDetailSort1 | Receivable Invoice Detail Sort1 | ReceivableInvoiceDetailRel.Sort1 |
| ReceivableInvoiceDetailSort2 | Receivable Invoice Detail Sort2 | ReceivableInvoiceDetailRel.Sort2 |
| ReceivableInvoiceDetailSort3 | Receivable Invoice Detail Sort3 | ReceivableInvoiceDetailRel.Sort3 |
| ReceivableInvoiceDetailSort4 | Receivable Invoice Detail Sort4 | ReceivableInvoiceDetailRel.Sort4 |
Business Class: DunningLetterTotals
List: DunningLetterTotalsListForIDMDoc
Path: /AdvancedDunningLetter/Totals/Total
| XML field | Description | FSM field |
|---|---|---|
| TotalsCurrency | Transaction Currency | Currency |
| TotalDue | Total Due per Transaction Currency | TotalDunned |