Table: Digita_Vat_Period
Digita VAT reporting periods used to associate with VAT Ledger entries.
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
digita_vat_period_KEYintNOT NULL
start_datedatetimeNOT NULLThe start date for the VAT period.
end_datedatetimeNOT NULLThe end date for the VAT period.
is_cash_basisbitNOT NULLIndicate whether the VAT period is reported using a cach or accrual basis.
is_closedbitNOT NULLIndicates whether the period is open or closed.
standard_vat_ratedecimal (4, 2)The standard vat rate to use for this period
Primary key
NameColumnsDescription
PK_Digita_Vat_Period$digita_vat_period_KEYdigita_vat_period_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ledger_Entry__Digita_Vat_Period__digita_vat_period_KEYdigita_vat_period_KEYLedger_Entry

Schema diagram