Project invoice summary
These tables show the field mapping information of the fields that you can use to build your project invoice summary IDM Template.
Business Class: ProjectContractInvoice
List: ProjectContractSummaryInvoiceForIDMDoc
| XML field | Description | FSM field |
|---|---|---|
| InvoiceNumber | Project Contract Summary Invoice Number | DerivedInvoicePrintNumber |
| InvoiceDate | Project Contract Summary 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 Remaining Funded Amount | ProjectFundingSource.BilledRemaining |
| RemainingFundedAmount | Project Journalized Invoiced Amount | ProjectFundingSource.TotalJournalizedBilledAmount |
| SubTotal | Project Contract Summary Invoice Total Invoice Amount | InvoiceTotalAmount |
| TaxTotal | Project Contract Summary Invoice Total Invoice Tax Amount | InvoiceTotalTaxAmount |
| TotalDue | Project Contract Summary Invoice Total Due | InvoiceTotalAmountaAndTaxAmount |
| FromEmailAddress | Project Contract Summary Invoice From Email Address | FinanceEnterpriseGroup.EnterpriseProjectStructure.ProjectInvoiceFromEmailAddress |
Business Class: ProjectContractInvoiceSummary
List: ProjectContractSummaryInvoiceLineForIDMDoc
Path: /ProjectContractSummaryInvoice/Lines/Line
| XML field | Description | FSM field |
|---|---|---|
| Project | Project Contract Summary Line Project Name | Project.DisplayProject |
| ProjectDescription | Project Contract Summary Line Project Description | Project.Description |
| Dimension | Project Contract Summary Line Dimension | DisplayDimension |
| DimensionDescription | Project Contract Summary Line Dimension Description | DimensionDescription |
| Resource | Project Contract Summary Line Resource | Resource |
| ResourceName | Project Contract Summary Line Resource Name | Resource.PresentationNameSnapshot |
| LTDAmount | Project Contract Summary Line Life to Date Amount | LTDAmount |
| Amount | Project Contract Summary Line Amount | Amount |