Project invoice

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

Business Class: ProjectContractInvoice

List: ProjectContractInvoiceForIDMDoc

XML field Description FSM field
InvoiceNumber Project Contract Invoice Number DerivedInvoicePrintNumber
InvoiceDate Project Contract Invoice Date InvoiceDate
DueDate Receivable Invoice Due Date DerivedDueDate
ParallelReferenceLabel Parallel Reference Label DerivedParallelReferenceLabel
ParallelReference Parallel Reference Value DerivedParallelReference
CompanyName Receivable Company Name FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.Name
CompanyAddress1 Receivable Company Address Line 1 FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.DeliveryAddress.AddressLine1
CompanyAddress2 Receivable Company Address Line 2 FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.DeliveryAddress.AddressLine2
CompanyAddress3 Receivable Company Address Line 3 FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.DeliveryAddress.AddressLine3
CompanyAddressCity Receivable Company Municipality FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.Municipality
CompanyAddressState Receivable Company State Province FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.StateProvince
CompanyAddressPostal Receivable Company Postal Code FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.PostalCode
CompanyCountry Receivable Company Country FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.Country
CompanyCountryName Receivable Company Country Name FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.Country.Name
CustomerName Customer Bill To Name ProjectFundingSource.DerivedBillToName
CustomerAddress1 Customer Bill To Address Line 1 ProjectFundingSource.DerivedAddressLine1
CustomerAddress2 Customer Bill To Address Line 2 ProjectFundingSource.DerivedAddressLine2
CustomerAddress3 Customer Bill To Address Line 3 ProjectFundingSource.DerivedAddressLine3
CustomerAddressCity Customer Bill To Municipality ProjectFundingSource.DerivedCity
CustomerAddressState Customer Bill To State Province ProjectFundingSource.DerivedStateProvince
CustomerAddressPostal Customer Bill To Postal Code ProjectFundingSource.DerivedPostalCode
CustomerCountry Customer Bill To Country ProjectFundingSource.CompanyCustomerGroup.CustomerBillTo.PostalAddress.Country
CustomerCountryName Customer Bill To Country Name ProjectFundingSource.CompanyCustomerGroup.CustomerBillTo.PostalAddress.Country.Name
Contract Project Contract Name ProjectContract.DisplayContract
ContractDescription Project Contract Description ProjectContract.Project.Description
ContractCurrency Project Contract Currency ProjectContract.Currency
FundingSource Project Funding Source FinanceDimension2.DisplayDimension
FundingSourceDescription Project Funding Source Description FinanceDimension2.Description
FundedAmount Project Funding Source Funded Amount ProjectFundingSource.FundedAmount
PurchaseOrderNumber Customer Purchase Order Number DerivedCustomerPoNumber
LifeToDateInvoicedAmount Project Journalized Invoiced Amount ProjectFundingSource.TotalJournalizedBilledAmount
RemainingFundedAmount Project Remaining Funded Amount ProjectFundingSource.BilledRemaining
SubTotal Project Contract Invoice Total Invoice Amount InvoiceTotalAmount
TaxTotal Project Contract Invoice Total Invoice Tax Amount InvoiceTotalTaxAmount
TotalDue Project Contract Invoice Total Due InvoiceTotalAmountaAndTaxAmount
FromEmailAddress Project Contract Invoice From Email Address FinanceEnterpriseGroup.EnterpriseProjectStructure.ProjectInvoiceFromEmailAddress

Business Class: ProjectContractInvoiceLine

List: ProjectContractInvoiceLineForIDMDoc

Path: /ProjectContractInvoice/Lines/Line

XML field Description FSM field
Project Project Contract Invoice Line Project Name Project
InvoiceDescription Project Contract Invoice Line Invoice Description DerivedInvoiceDescription
InvoiceDate Project Contract Invoice Line Invoice Date DerivedInvoiceDate
Quantity Project Contract Invoice Line Quantity UnitsAmount
Rate Project Contract Invoice Line Rate BillableRate
Amount Project Contract Invoice Line Amount Amount
TaxAmount Project Contract Invoice Line Tax Amount TaxAmount
NetAmount Project Contract Invoice Line Total Amount InvoiceLineTotalAmount