Table of Contents

Table Saft_Declaration_Exports

Entity

Entity: Regulatory.Saft.DeclarationExports

Each record in the table represents a distinct SAF-T declaration export operation. Entity: Saft_Declaration_Exports (Introduced in version 27.1.0.81)

Owner Tables Hierarchy

Summary

Name Type Description
Application_Version nvarchar(18) ERP.net Version Used to Generate the Export
Audit_File_Date_Created datetime Creation date of odit file (value of AuditFileDateCreated)
Beneficial_Owner_Country_Code nvarchar(2) Country Code of the Beneficial Owner
Beneficial_Owner_EGN nvarchar(35) Personal Identification Number of the Bulgarian Beneficial Owne
Beneficial_Owner_Name_Cyrillic_BG nvarchar(70) Name of the Bulgarian Beneficial Owner
Beneficial_Owner_Name_Latin_Foreign nvarchar(70) Name of the Foreign Beneficial Owner
Company_City nvarchar(35) City or Other Locality
Company_Country_Code nvarchar(2) Country Code
Company_Name nvarchar(70) Official Name of the Taxable Person
Company_Registration_Number nvarchar(35) Company Registration Number or Other Registration Number of the Taxable Person
Company_Street_Name nvarchar(70) Registered Address of the Taxable Person
Contact_Person_Email nvarchar(70) Email Address of the Contact Person
Contact_Person_Job_Title nvarchar(35) Position or Role of the Contact Person
Contact_Person_Name nvarchar(127) Contact Person Name
Contact_Person_Phone nvarchar(18) Contact Person Phone Number
Created_On datetime Date and time of record creation
Declaration_Export_Id uniqueidentifier PK Unique export identifier
Default_Currency_Code nvarchar(3) Primary currency code of the SAF-T file.
Error_Message nvarchar(max) Information about the error that occurred during failed generation.
Export_Type char(1) Allowed: M, Y, D Export type: monthly(M), annual(Y) or on-demand(D).
File_Name nvarchar(254) Name of generated SAF-T file
Generated_By_User_Id uniqueidentifier User who started generation
Generated_On datetime Date and Time of successful generation of report(data preparation).
Is_Part_Of_Group int Indicates whether the company belongs to a group of enterprises.
Released_End_Time datetime The end of the Released Time range used to select data.
Released_Start_Time datetime The beginning of the Released Time range used to select data.
Row_Version timestamp
Saft_Declaration_Id uniqueidentifier SAF-T declaration
Schema_Version nvarchar(9) The version of the SAF-T schema used to generate the file.
Selection_End_Date date End Date of the Export Period
Selection_Start_Date date Start Date of the Export Period
Status char(1) Allowed: P, G, C, F, N Current status: Pending(P), Generating(G), Completed(C), Failed(F), Cancelled(N)
Tax_Accounting_Basis nvarchar(18) Accounting Basis Used in the SAF-T File
Ultimate_Owner_Country_Code nvarchar(2) Country Code of the Ultimate Owner
Ultimate_Owner_Name_Cyrillic_BG nvarchar(70) Name of the Bulgarian Ultimate Owner
Ultimate_Owner_Name_Cyrillic_Foreign nvarchar(70) Name of the Foreign Ultimate Owner in Cyrillic
Ultimate_Owner_Name_Latin_Foreign nvarchar(70) Name of the Foreign Ultimate Owner in Latin Script
Ultimate_Owner_UIC_BG nvarchar(35) UIC of the Bulgarian Ultimate Owner

Columns

Application_Version

ERP.net Version Used to Generate the Export

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

Audit_File_Date_Created

Creation date of odit file (value of AuditFileDateCreated)

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 datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Audit_File_Date_Created - Supported Filters

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

Beneficial_Owner_Country_Code

Country Code of the Beneficial Owner

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

Beneficial_Owner_EGN

Personal Identification Number of the Bulgarian Beneficial Owne

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

Beneficial_Owner_Name_Cyrillic_BG

Name of the Bulgarian Beneficial Owner

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

Beneficial_Owner_Name_Latin_Foreign

Name of the Foreign Beneficial Owner

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

Company_City

City or Other Locality

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

Company_Country_Code

Country Code

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

Company_Name

Official Name of the Taxable Person

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

Company_Registration_Number

Company Registration Number or Other Registration Number of the Taxable Person

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

Company_Street_Name

Registered Address of the Taxable Person

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

Contact_Person_Email

Email Address of the Contact Person

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

Contact_Person_Job_Title

Position or Role of the Contact Person

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

Contact_Person_Name

Contact Person Name

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

Contact_Person_Phone

Contact Person Phone Number

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

Created_On

Date and time of record creation

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTime
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 datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Created_On - Supported Filters

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

Declaration_Export_Id

Unique export identifier

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 2147483647
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_Export_Id - Supported Filters

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

Default_Currency_Code

Primary currency code of the SAF-T file.

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

Error_Message

Information about the error that occurred during failed generation.

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

Export_Type

Export type: monthly(M), annual(Y) or on-demand(D).

Property Value
Allowed Values M, Y, D
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 yes
Type char(1)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Export_Type - Supported Filters

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

File_Name

Name of generated SAF-T file

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

File_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

Generated_By_User_Id

User who started generation

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

Generated_By_User_Id - Supported Filters

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

Generated_On

Date and Time of successful generation of report(data preparation).

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

Generated_On - Supported Filters

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

Is_Part_Of_Group

Indicates whether the company belongs to a group of enterprises.

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

Released_End_Time

The end of the Released Time range used to select data.

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 datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Released_End_Time - Supported Filters

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

Released_Start_Time

The beginning of the Released Time range used to select data.

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 datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Released_Start_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None 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

Saft_Declaration_Id

SAF-T 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 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Saft_Declarations
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

Saft_Declaration_Id - Supported Filters

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

Schema_Version

The version of the SAF-T schema used to generate the file.

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

Selection_End_Date

End Date of the Export Period

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 date
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Selection_End_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
GreaterThanOrLessThan None no no

Selection_Start_Date

Start Date of the Export Period

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 date
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Selection_Start_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
GreaterThanOrLessThan None no no

Status

Current status: Pending(P), Generating(G), Completed(C), Failed(F), Cancelled(N)

Property Value
Allowed Values P, G, C, F, N
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 yes
Type char(1)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Status - Supported Filters

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

Tax_Accounting_Basis

Accounting Basis Used in the SAF-T File

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

Tax_Accounting_Basis - Supported Filters

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

Ultimate_Owner_Country_Code

Country Code of the Ultimate Owner

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

Ultimate_Owner_Name_Cyrillic_BG

Name of the Bulgarian Ultimate Owner

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

Ultimate_Owner_Name_Cyrillic_Foreign

Name of the Foreign Ultimate Owner in Cyrillic

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

Ultimate_Owner_Name_Latin_Foreign

Name of the Foreign Ultimate Owner in Latin Script

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

Ultimate_Owner_UIC_BG

UIC of the Bulgarian Ultimate Owner

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 35
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(35) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes
Suggest improvement to this page