Financials: Financial Cap Amort Export
User roles: ✔ Project Access ✔ Financial Access ✔ Financial Administrator
The Financial Cap Amort Export file contains the complete list of financial capitalization and amortization forecast and actuals records for the project and its subprojects posted in the selected date range.
You can export data for the current financial month, current, previous or next financial or calendar year, or choose a completely custom time span.
The report also includes the reportable custom properties for the project, the resources and the community plan.
The Financial Cap Amort Export file rolls up financial data from all sub projects too. It therefore lists the capitalization and amortization records of the projects and its sub projects.
The Financial Cap Amort Export file aggregates capitalization and amortization records that apply to the same project and have the same expense category/type, capitalization percentage, capitalization month and amortization period.
The Financial Cap Amort Export file share the same format as the other financial reports in order to ensure consistency across the different reports. However, as this report aggregates financial records in order to reduce the size of the file, quite a few columns are not applicable.
Field Description
Column & Title | Description |
LineType | Indicates whether the financial record is a Amortized or Capitalized record. |
LineSubType | Indicates whether the financial record represents a Forecast or Actuals amount. |
Year | The financial year the financial record is posted to. |
FullYearForecast | Indicates if the financial record is included in the project full year forecast. |
Month | The month the financial record is posted to. |
Date | The date the financial record is posted to. |
Project | The project name. |
ProjectId | Fluid project unique ID. |
ProjectRef | Project external reference. |
Alternate Reference | The alternate unique identifier of the project (different to the project external reference). |
Phase | N/A |
ProjectType | The project type. |
PrimaryPM | The primary manager responsible for the project. |
PrimaryPMId | Fluid unique identifier for the project primary manager. |
PrimaryPMRef | The primary manager's username. |
Owner | The owner of the project. |
OwnerId | Fluid unique identifier for the project owner. |
OwnerRef | The project owner's username. |
BusinessOwner | The project business owner. |
BusinessOwnerId | Fluid unique identifier for the project business owner. |
BusinessOwnerRef | The project business owner's username. |
ProjectStatus | The project status. |
Resource | N/A |
ResourceId | N/A |
ResourceRef | N/A |
Approver | N/A |
ApproverId | N/A |
ApproverRef | N/A |
Parent | The Top Parent project of the project in the Project Hierarchy. |
ParentId | The unique ID of the Top Parent project. |
ParentRef | The Top Parent project external reference. |
Engagement | N/A |
Task | N/A |
Hours | N/A |
Allocation | N/A |
Value | The amount value of the financial record in the default currency. |
Rate | N/A |
Detail | This value indicates whether the capitalized amount is derived from a Forecast or Actuals record. |
ExpenseCategory | The expense category of the financial record. |
ExpenseType | The expense type of the financial record. |
Note | N/A |
ProviderCostCentre | N/A |
ReceiverCostCentre | The project cost centre. |
ResourceRegion | N/A |
ResourceUnit | N/A |
TimesheetStatus | N/A |
Classification | The value indicates whether the amount value was calculated from forecast and actuals records. |
RecordId | The Capitalization Fluid record ID. |
EntryId | The Capitalization Fluid record ID. |
MonthlyRate | N/A |
MonthlyHours | N/A |
Currency | The currency the financial record was entered in. |
LocalValue | The amount value in the currency the financial record was entered in. |
RestatedValue | The amount value in the restated currency. |
CappedProportion | N/A |
CapitalizationId | The capitalisation Fluid record ID. This is only applicable to Capitalized records. |
AmortizationPeriods | The financial record amortisation period. The value is set to 0 for Amortized financial records. |
AmortizationStart | This value indicates the month the amortization for the associated capitalization record started / will start. |
PercentageAmortized | N/A |
AmortizationId | The amortisation Fluid record ID. |
CapPercentage | The capitalisation percentage that was used to derive the amount of the capitalised record. This is only applicable to Capitalized records. |
DirectRate | N/A |
Placeholder | The value is always set to False. |
ProjectCategory | The project category. |
FundingSource | The project funding source. |
ResourceRole | N/A |
Modified | The date the financial record was last modified. |
ModifiedBy | N/A |
ModifiedById | N/A |
ModifiedByRef | N/A |
Editors | The project editors. |
EditorsId | The editor's username. |
Executive | The project executive. |
ExecutiveId | The executive's username. |
Portfolio | The project portfolio. |
SubPortfolio | The project sub-portfolio. |
BX onwards |
|