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 |