Query "Fixed Assets Analysis"
The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'.
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| DataAccessIntent | ReadOnly |
| UsageCategory | ReportsAndAnalysis |
| Caption | Fixed Assets Ad-hoc Analysis |
| AboutTitle | About Fixed Assets Ad-hoc Analysis |
| AboutText | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| No | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| FAPostingDate | FALedgerEntry | Date | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| PostingDate | FALedgerEntry | Date | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| DocumentType | FALedgerEntry | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| DocumentDate | FALedgerEntry | Date | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| DocumentNo | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| Description | FALedgerEntry | Text[100] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| PostingCategory | FALedgerEntry | Enum Microsoft.FixedAssets.Ledger."FA Ledger Posting Category" | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| FAPostingType | FALedgerEntry | Enum Microsoft.FixedAssets.Ledger."FA Ledger Entry FA Posting Type" | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| Amount | FALedgerEntry | Decimal | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ReclassificationEntry | FALedgerEntry | Boolean | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| FApostingGroup | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| Depreciation_Method | FALedgerEntry | Enum Microsoft.FixedAssets.Depreciation."FA Depreciation Method" | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| DepreciationStartingDate | FALedgerEntry | Date | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| DepreciationEndingDate | FALedgerEntry | Date | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| GlobalDimension1Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| GlobalDimension2Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ShortcutDimension3Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ShortcutDimension4Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ShortcutDimension5Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ShortcutDimension6Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ShortcutDimension7Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ShortcutDimension8Code | FALedgerEntry | Code[20] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| FADescription | FixedAsset | Text[100] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ClassCode | FAClass | Code[10] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| ClassName | FAClass | Text[50] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| SubClassCode | FASubClass | Code[10] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| FASubClassName | FASubClass | Text[50] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| FALocationCode | FALocation | Code[10] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| FALocationName | FALocation | Text[50] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| DepBookCode | DepreciationBook | Code[10] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |
| DepBookDescription | DepreciationBook | Text[100] | The Fixed Assets Analysis is a query that joins data from FA ledger entries with Fixed asset master data. Use it to reconcile at month end as an alternative to using the report 'Book Value 01'. |