Table of Contents

Table Nat_BG_VAT_Declarations

Entity

Entity: Finance.Vat.BGVATDeclarations

National data: Contains the VAT declarations, issued by the enterprise company, according to the Bulgarian legislation. Entity: Nat_BG_VAT_Declarations

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.
Coefficient_VATL_Article_73 decimal(3, 2) Field 01 - 33 from the declaration. Must be between 0.00 and 1.00.
Declaring_Person_Id uniqueidentifier Specific declaring person for this declaration. If the declaring person isn't specified then the default declaring person for the enterprise company is used
Deducted_VAT_Amount_Article_92_Paragraph_1 decimal(14, 2) Field 01 - 70 from the declaration. Amounts are in base currency. Must be greater than 0.00.
Deposited_VAT_Amount decimal(14, 2) Field 01 - 71 from the declaration. Amounts are in base currency. Must be greater than 0.00.
Document_Id uniqueidentifier
Is_Released bit Readonly True if the document is not void and its state is released or greater. Deprecated
Is_Single_Execution bit Readonly Specifies whether the document is a single execution of its order document.
Row_Version timestamp
VAT_Amount_To_Recoup_Article_92_Paragraph_1 decimal(14, 2) Field 01 - 80 from the declaration. Amounts are in base currency. Must be greater than 0.00.
VAT_Amount_To_Recoup_Article_92_Paragraph_3 decimal(14, 2) Field 01 - 81 from the declaration. Amounts are in base currency. Must be greater than 0.00.
VAT_Amount_To_Recoup_Article_92_Paragraph_4 decimal(14, 2) Field 01 - 82 from the declaration. Amounts are in base currency. Must be greater than 0.00.
VAT_Declaration_Id uniqueidentifier PK Unique identification of the VAT declaration.
VAT_Declaration_Representing_Person_Id uniqueidentifier Representing person for the purposes of submitting of VAT declarations.
VAT_Declaration_Representing_Person_Position nvarchar(64) Position of the representing person for the purposes of submitting of VAT declarations.
VAT_Period_End date End date of the period fot which the VAT declaration is made.
VAT_Period_Start date Start 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

Coefficient_VATL_Article_73

Field 01 - 33 from the declaration. Must be between 0.00 and 1.00.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
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 decimal(3, 2)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Declaring_Person_Id

Specific declaring person for this declaration. If the declaring person isn't specified then the default declaring person for the enterprise company is used

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
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 Nat_BG_VAT_Declaring_Persons
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Declaring_Person_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Deducted_VAT_Amount_Article_92_Paragraph_1

Field 01 - 70 from the declaration. Amounts are in base currency. Must be greater than 0.00.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
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 decimal(14, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Deposited_VAT_Amount

Field 01 - 71 from the declaration. Amounts are in base currency. Must be greater than 0.00.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
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 decimal(14, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

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 yes

Is_Released

True if the document is not void and its state is released or greater. Deprecated

Property Value
Auto Complete no
Data Filter no
Default Value False
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 yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Is_Released - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Is_Single_Execution

Specifies whether the document is a single execution of its order document.

Property Value
Auto Complete no
Data Filter no
Default Value False
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 yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Is_Single_Execution - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

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

VAT_Amount_To_Recoup_Article_92_Paragraph_1

Field 01 - 80 from the declaration. Amounts are in base currency. Must be greater than 0.00.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
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 decimal(14, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

VAT_Amount_To_Recoup_Article_92_Paragraph_3

Field 01 - 81 from the declaration. Amounts are in base currency. Must be greater than 0.00.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
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 decimal(14, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

VAT_Amount_To_Recoup_Article_92_Paragraph_4

Field 01 - 82 from the declaration. Amounts are in base currency. Must be greater than 0.00.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
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 decimal(14, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

VAT_Declaration_Id

Unique identification of the VAT declaration.

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

VAT_Declaration_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

VAT_Declaration_Representing_Person_Id

Representing person for the purposes of submitting of VAT declarations.

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 Cm_Persons
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

VAT_Declaration_Representing_Person_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

VAT_Declaration_Representing_Person_Position

Position of the representing person for the purposes of submitting of VAT declarations.

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 64
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 nvarchar(64) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

VAT_Period_End

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

VAT_Period_End - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None yes no

VAT_Period_Start

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

VAT_Period_Start - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None yes no
Suggest improvement to this page