Federal financial report
These tables show the field mapping information of the fields that you can use to build your federal financial report IDM template.
Business Class: GrantReportingSettings
List: GrantReportingSettingsForIDM
| XML field | Description | FSM field |
|---|---|---|
| Customer Name | Federal Agency and Organization Name | FinanceDimension2.CompanyCustomerGroup.Customer.Name |
| CompanyName | Receivable Company Name | FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.Name |
| GrantID | Federal Grand Identifying Number | FinanceDimension2.GrantID |
| 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 |
| CompanyAddress4 | Receivable Company Address Line 4 | FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.DeliveryAddress.AddressLine4 |
| CompanyAddressCity | Receivable Company Municipality | FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.Municipality |
| CompanyAddressRegion | Receivable Company Region | FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.PostalAddress.Region |
| 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 |
| CreditAgencyReportingNumber | DUNS Number | FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.CreditAgencyReportingNumber |
| EmployerIdentificationNumber | Employer Identification Number(EIN) | FinanceDimension2.CompanyCustomerGroup.ReceivableCompany.EmployerIdentificationNumber |
| ContractID | Recipient Account/Identifying Number | ProjectContract.ContractID |
| ReportType | Federal Financial Report Type | ReportType |
| Basis | Basis of Accounting | Basis |
| ProjectOrGrantPeriod | Period Date Range | FinanceDimension2.DateRange |
| ReportingPeriodEndDate | Federal Financial Report End Date | ReportingThruDate |
| CashReceipts | Federal Cash Receipts | DerivedCashReceipts |
| ProjectFundingDisbursements | Federal Cash Disbursements/Share of Expenditures | ProjectFundingDisbursements |
| CashOnHand | Federal Cash On Hand | DerivedCashOnHand |
| TotalFederalFundsAuthorized | Total Federal Funds Authorized | FinanceDimension2.Amount |
| ProjectFundingEncumbrance | Federal Share of Unliquidated Obligations | ProjectFundingEncumbrance |
| TotalFederalShare | Total Federal Share | DerivedTotalFederalShare |
| UnobligatedBalance | Unobligated Balance of Federal Funds | DerivedUnobligatedBalance |
| TotalRecipientShareRequired | Total Recipient Share Required | FinanceDimension2.RequiredRecipientShare |
| RecipientShareOfExpenditures | Recipient Share of Expenditures | FinanceDimension2.RecipientShareOfExpenditures |
| RemainingRecipientShare | Remaining Recipient Share to be provided | FinanceDimension2.DerivedRemainingRecipientShare |
| ProgramIncome | Total Federal Program Income | FinanceDimension2.FederalProgramIncome |
| ProgramIncomeDeduction | Program Income expended in accordance with the deduction alternative | FinanceDimension2.ProgramIncomeExpendedDeductionAlternative |
| ProgramIncomeAddition | Program Income expended in accordance with the addition alternative | FinanceDimension2.ProgramIncomeExpendedAdditionAlternative |
| UnexpendedProgramIncome | Unexpended Program Income | FinanceDimension2.DerivedUnexpendedProgramIncome |
| IndirectExpenseType | Indirect Expense Type | FinanceDimension2.IndirectExpenseType |
| IndirectExpenseRate | Indirect Expense Rate | FinanceDimension2.IndirectExpenseRate |
| IndirectExpenseBase | Indirect Expense Base Amount | FinanceDimension2.IndirectExpenseBaseAmount |
| IndirectExpenseAmountCharged | Indirect Expense Amount Charged | FinanceDimension2.IndirectExpenseAmountCharged |
| IndirectExpense | Indirect Expense Federal Share | FinanceDimension2.IndirectExpenseFederalShare |
| Description | Federal Financial Report Description | Description |
| FromEmailAddress | From Email Address | FromEmailAddress |