# AccountsByFiscalYear: General Ledger Accounts by Fiscal Year - Name: `AccountsByFiscalYear` - Catalog: `VismaEAccounting` - Schema: `V2` - Label: General Ledger Accounts by Fiscal Year ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `fiscalYearId` | `guid` | ☑ | | | ## Table Columns The columns of the table `AccountsByFiscalYear` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `FiscalYearId` | `string` | Fiscal Year ID | ☑ | | | `IsActive` | `boolean` | Is Active | ☑ | | | `IsBlockedForManualBooking` | `boolean` | Is Blocked for Manual Booking | ☑ | | | `IsCostCenterAllowed` | `boolean` | Is Cost Centre Allowed | ☑ | | | `IsProjectAllowed` | `boolean` | Is Project Allowed | ☑ | | | `ModifiedUtc` | `string` | Modified (UTC) | ☑ | | | `Name` | `string` | Name | ☑ | | | `Number` | `string` | Number | ☑ | | | `ReferenceCode` | `string` | Reference Code | ☐ | | | `Type` | `int32` | Type | ☑ | | | `TypeDescription` | `string` | Type Description | ☑ | | | `VatCodeDescription` | `string` | VAT Code Description | ☐ | | | `VatCodeId` | `string` | VAT Code ID | ☐ | |