Receivables statement

These tables show the field mapping information of the fields that you can use to build your receivables statement IDM template.

Path: /StatementPrintHeader

XML field Description FSM field
Date As Of Date AsOfDate
Company Company Company
CompanyName Company Name Company.Name
Customer Customer Customer
CustomerName Customer Name Customer.Name
PostalAddress1 Customer Address Line 1 Customer.PostalAddress.DeliveryAddress.AddressLine1
PostalAddress2 Customer Address Line 2 Customer.PostalAddress.DeliveryAddress.AddressLine2
PostalAddress3 Customer Address Line 3 Customer.PostalAddress.DeliveryAddress.AddressLine3
PostalAddress4 Customer Address Line 4 Customer.PostalAddress.DeliveryAddress.AddressLine4
PostalAddressCity Customer Address City Customer.PostalAddress.Municipality
PostalAddressState Cutomer Address State Customer.PostalAddress.StateProvince
PostalAddressPostal Customer Address Postal Code Customer.PostalAddress.PostalCode
PostalAddressCountry Customer Address Country Code Customer.PostalAddress.Country
PostalAddressCountryName Customer Address Country Customer.PostalAddress.Country.Name
RemitToAddressName Remit To Name DerivedRemitToAddressName
RemitToAddress1 Remit to Address Line 1 DerivedRemitToAddressLine1
RemitToAddress2 Remit to Address Line 2 DerivedRemitToAddressLine2
RemitToAddress3 Remit to Address Line 3 DerivedRemitToAddressLine3
RemitToAddress4 Remit to Address Line 4 DerivedRemitToAddressLine4
RemitToAddressCity Remit to Address City DerivedRemitToAddressMunicipality
RemitToAddressState Remit to Address State DerivedRemitToAddressState
RemitToAddressPostal Remit to Address Postal Code DerivedRemitToAddressPostalCode
RemitToAddressCountry Remit to Address Country DerivedRemitToAddressCountry
StatementText Receivables Statement Text Code DerivedStatementText
AgingPeriod1Label Aging period 1 label AgingPeriod1Title
AgingPeriod2Label Aging period 2 label AgingPeriod2Title
AgingPeriod3Label Aging period 3 label AgingPeriod3Title
AgePeriod1Total Aging period 1 Total DerivedAgePeriod1Total
AgePeriod2Total Aging period 2 Total DerivedAgePeriod2Total
AgePeriod3Total Aging period 3 Total DerivedAgePeriod3Total
CurrentBalance Current Statement Balance DerivedCurrentBalance
LastStatementBalance Last Statement Balance DerivedLastStatementBalance
TotalOpenAmount Total Open Amount DerivedTotalOpenAmount
TotalOpenAmountInWords Total Open Amount in Wordings TotalOpenAmountInWords
StatementCurrency Statement Currency DerivedReportCurrency
EmailFrom Email From Address CompanyCustomerRel.ReceivablesStatementFromAndReplyToEmail
CurrentAmountTotal Current Amount Total DerivedCurrentAmountTotal

Path: /StatementPrintHeader/Details/Detail

XML field Description FSM field
TransactionNumber Transaction Number TransactionNumber
TransactionDate Transaction Date TransactionDate
DueDate Transaction Due Date DueDate
CustomerPurchaseOrder Customer Purchase Order CustomerPurchaseOrder
OriginalCurrency Transaction Currency OriginalCurrency
TransactionAmount Transaction Amount TransactionAmount
OpenAmount Transaction Open Amount OpenAmount

Path: /Applications/Application

XML field Description
PaymentNumber Payment Number
TransactionDate Payment Transaction Date
PaymentAmount Payment Amount

Path: /Adjustments/Adjustment

XML field Description
AdjustmentAmount Cash Application Adjustment Amount