# AllocationPeriods: Allocation Periods - Name: `AllocationPeriods` - Catalog: `VismaEAccounting` - Schema: `V2` - Label: Allocation Periods ## Table Columns The columns of the table `AllocationPeriods` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AllocationPeriodSourceType` | `int32` | Allocation Period Source Type | ☑ | 0: SupplierInvoice, 1: ManualVoucher. | | `Amount` | `decimal` | Amount | ☐ | | | `BookkeepingDate` | `string` | Bookkeeping Date | ☐ | | | `CostCenterItemId1` | `string` | Cost Centre Item ID 1 | ☐ | | | `CostCenterItemId2` | `string` | Cost Centre Item ID 2 | ☐ | | | `CostCenterItemId3` | `string` | Cost Centre Item ID 3 | ☐ | | | `CreatedUtc` | `string` | Created (UTC) | ☐ | | | `CreditAccountNumber` | `int32` | Credit GL Account Number | ☐ | | | `DebitAccountNumber` | `int32` | Debit GL Account Number | ☐ | | | `Id` | `string` | ID | ☑ | | | `ManualVoucherId` | `string` | Manual Voucher ID | ☐ | | | `ManualVoucherRow` | `int32` | Manual Voucher Row | ☐ | | | `ProjectId` | `string` | Project ID | ☐ | | | `Status` | `int32` | Status | ☑ | 0: Pending, 1: Revoked, 2: Booked. | | `SupplierInvoiceId` | `string` | Supplier Invoice ID | ☐ | | | `SupplierInvoiceRow` | `int32` | Supplier Invoice Row | ☐ | |