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 |