Table: Digita_Vat_Period | |||
Digita VAT reporting periods used to associate with VAT Ledger entries. | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
digita_vat_period_KEY | int | NOT NULL | |
start_date | datetime | NOT NULL | The start date for the VAT period. |
end_date | datetime | NOT NULL | The end date for the VAT period. |
is_cash_basis | bit | NOT NULL | Indicate whether the VAT period is reported using a cach or accrual basis. |
is_closed | bit | NOT NULL | Indicates whether the period is open or closed. |
standard_vat_rate | decimal (4, 2) | The standard vat rate to use for this period |
Primary key | |||
Name | Columns | Description | |
PK_Digita_Vat_Period$digita_vat_period_KEY | digita_vat_period_KEY | CLUSTERED |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Ledger_Entry__Digita_Vat_Period__digita_vat_period_KEY | digita_vat_period_KEY | Ledger_Entry |