Table of Contents

Table Saft_Declaration_Export_Sales_Invoices

Entity

Entity: Regulatory.Saft.DeclarationExportSalesInvoices

Contains Sales Invoices for SAF-T export section SalesInvoices. Entity: Saft_Declaration_Export_Sales_Invoices (Introduced in version 27.1.0.86)

Summary

Name Type Description
Account_Id nvarchar(5) Account Id
Customer_City nvarchar(35) Customer City
Customer_Country nvarchar(2) Customer Country
Customer_Id nvarchar(35) Customer Id
Customer_Name nvarchar(70) Customer Name
Declaration_Export_Sales_Invoice_Id uniqueidentifier PK
Export_Sequence int Monotonc sequence within Declaration Export
Invoice_Date date Invoice Date
Invoice_No nvarchar(70) Invoice No
Invoice_Type nvarchar(9) Invoice Type
Row_Version timestamp
Saft_Declaration_Export_Id uniqueidentifier Saft Declaration Export
Self_Billing_Indicator char(1) Self Billing Indicator
Transaction_Id uniqueidentifier Transaction Id

Columns

Account_Id

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

Customer_City

Customer City

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

Customer_Country

Customer Country

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

Customer_Id

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

Customer_Name

Customer 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 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

Declaration_Export_Sales_Invoice_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 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_Sales_Invoice_Id - Supported Filters

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

Export_Sequence

Monotonc sequence within Declaration 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 -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable yes
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Export_Sequence - Supported Filters

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

Invoice_Date

Invoice Date

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

Invoice_Date - Supported Filters

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

Invoice_No

Invoice No

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

Invoice_Type

Invoice Type

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

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_Export_Id

Saft Declaration 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 -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Saft_Declaration_Exports
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_Export_Id - Supported Filters

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

Self_Billing_Indicator

Self Billing Indicator

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

Transaction_Id

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

Transaction_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Suggest improvement to this page