Invoice register

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

Business Class: BillingCompany

List: BillingCompanyDetailsForIDM

XML field Description FSM field
ParameterFromInvoiceDate Invoice Date From TransientFromInvoiceDate
ParameterToInvoiceDate Invoice Date To TransientToInvoiceDate
ParameterFromPostingDate Posting Date From TransientFromGLDate
ParameterToPostingDate Posting Date To TransientToGLDate
ParameterProcessLevel Process Level TransientProcessLevel
ParameterProcessLevelName Process Level Name TransientProcessLevel.Name
ParameterCustomer Customer Number TransientCustomer
ParameterCustomerName Customer Name TransientCustomer.Name
ParameterFromInvoiceDateAddSub Invoice Date From Add or Subtract TransientFrInvAddSub
ParameterFromInvoiceDays From Invoice Days TransientFrInvDays
ParameterToInvoiceDateAddSub To Invoice Date Add or Subtract TransientToInvAddSub
ParameterToInvoiceDays To Invoice Days TransientToInvDays
ParameterFromPostingDateAddSub From Posting Date Add or Subtract TransientFrGlAddSub
ParameterFromPostingDays From Posting Days TransientFrGlDays
ParameterToPostingAddSub To Posting Date Add or Subtract TransientToGlAddSub
ParameterToPostingDays To Posting Days TransientToGlDays
Company Billing Company Company
CompanyName Billing Company Name Name
Currency Billing Company Currency Currency
Date Run Date DerivedCurrentDateForIDM
Time Run Time DerivedCurrentTimeForIDM
ReportTotalFreightCharge Total Freight Charge DerivedCompanyLevelTotalFreight
ReportTotalTaxAmount Total Tax Amount DerivedCompanyLevelTotalTax
ReportTotalInvoiceNetAmount Total Invoice Net Amount DerivedCompanyLevelTotalInvoiceNet
EmailFrom From Email / Reply to Email TransientEmailFrom
SummarizeInvoicesByCustomer Summarize Invoices By Customer Toggle TransientSummarizeInvoicesByCustomer

Business Class: BillingProcessLevelRel

List: BillingProcessLevelForIDMList

Path: /InvoiceRegister/Lines/Line

XML field Description FSM field
ProcessLevel Billing Process Level BillingProcessLevel
ProcessLevelName Billing Process Level Name Name
TotalFreightCharge Billing Process Level Total Freight Charge DerivedProcessLevelTotalFreight
TotalTaxAmount Billing Process Level Total Tax Amount DerivedProcessLevelTotalTax
TotalInvoiceNetAmount Billing Process Level Total Invoice Net Amount DerivedProcessLevelTotalInvoiceNet

Business Class: BillingInvoice

List: BillingInvoiceListForIDM

Path: /InvoiceRegister/Lines/Line/LineInvoice/Invoice

XML field Description FSM field
InvoicePrefix Invoice Prefix BillingInvoice.InvoicePrefix
InvoiceNo Invoice Number ConditionalInvoiceNumber
InvoiceType Invoice Type BillingInvoiceType
InvoiceDate Invoice Date InvoiceDate
GlobalLedgerPostingDate Global Ledger Posting Date GeneralLedgerDate
ParallelReference Parallel Reference ParallelReference
CustomerOrder Customer Order DerivedCustomerOrder
CustomerNo Customer Number Customer
CustomerName Customer Name DerivedCustomerName
ShipTo Customer Ship To DerivedCustomerShipTo
FreightCharge Invoice Freight Charge FreightCharge.BaseAmount.EnteredCurrencyAmount
TaxAmount Invoice Tax Amount TaxTotal.BaseAmount.EnteredCurrencyAmount
InvoiceNetAmount Invoice Net Amount DerivedInvoiceNetAmountForIDM
HasEDI Has Customer EDI DerivedHasCustomerEDINumber