Table VAT_Declarations
Entity
Entity: Finance.Vat.Declarations
Contains the VAT declarations, issued by the enterprise company, according to the eligible legislation. Entity: VAT_Declarations (Introduced in version 22.1.4.21)
Owner Tables Hierarchy
Summary
Name
Type
Description
Base_Currency_Id
uniqueidentifier
The base currency for summary reporting for Enterprise Company at the moment of VAT Declaration creation.
Declaration_Id
uniqueidentifier
PK
Document_Id
uniqueidentifier
From_Date
date
Start date of the period fot which the VAT declaration is made.
Reporting_Person_Id
uniqueidentifier
This is the person submitting the declaration.
Row_Version
timestamp
To_Date
date
End date of the period fot which the VAT declaration is made.
Columns
Base_Currency_Id
The base currency for summary reporting for Enterprise Company at the moment of VAT Declaration creation.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Gen_Currencies
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Base_Currency_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Declaration_Id
Property
Value
Auto Complete
no
Data Filter
no
Default Value
NewGuid
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
0
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
yes (order: 1)
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Declaration_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Document_Id
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
1
Ownership Reference
yes
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Gen_Documents
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Document_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
From_Date
Start date of the period fot which the VAT declaration is made.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
date
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
From_Date - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
GreaterThanOrLessThan
None
no
no
Reporting_Person_Id
This is the person submitting the declaration.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
4
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Cm_Persons
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Reporting_Person_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Row_Version
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
timestamp
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
To_Date
End date of the period fot which the VAT declaration is made.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
3
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
date
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
To_Date - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
GreaterThanOrLessThan
None
no
no