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 |