Table Pos_Fiscal_Receipt_Templates

Entity

Templates for customizing the printouts of fiscal receipts. Entity: Pos_Fiscal_Receipt_Templates (Introduced in version 24.1.1.50)

Summary

Name	Type	Description
Custom_Footer	`nvarchar(256)`	User-defined footer printed at the end of the document (interpolated string).
Custom_Header	`nvarchar(256)`	User-defined header printed at the beginning of the document (interpolated string).
Custom_Row_Footer	`nvarchar(256)`	User-defined footer printed after each row (interpolated string).
Custom_Row_Header	`nvarchar(256)`	User-defined header printed before each row (interpolated string).
Pos_Fiscal_Receipt_Template_Id	`uniqueidentifier` `PK`
Print_System_Header	`bit`	Denotes whether to print the system-defined header for the document.
Print_System_Row_Header	`bit`	Denotes whether to print the system-defined header for each row.
Row_Version	`timestamp`
Template_Kind	`nvarchar(1)` Allowed: `S`, `I`, `P`	Specifies the entity type, for which the template can be used. Template strings can refer to the attributes of the specified entity type.
Template_Name	`nvarchar(64)`	The unique name of the printing template.

Columns

Custom_Footer

User-defined footer printed at the end of the document (interpolated string).

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	256
Order	7
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(256) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Custom_Header

User-defined header printed at the beginning of the document (interpolated string).

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	256
Order	4
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(256) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Custom_Row_Footer

User-defined footer printed after each row (interpolated string).

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	256
Order	6
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(256) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Custom_Row_Header

User-defined header printed before each row (interpolated string).

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	256
Order	5
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(256) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

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

Pos_Fiscal_Receipt_Template_Id - Supported Filters

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

Print_System_Header

Denotes whether to print the system-defined header for the document.

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

Print_System_Header - Supported Filters

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

Print_System_Row_Header

Denotes whether to print the system-defined header for each row.

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

Print_System_Row_Header - 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	8
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

Template_Kind

Specifies the entity type, for which the template can be used. Template strings can refer to the attributes of the specified entity type.

Property	Value
Allowed Values	`S`, `I`, `P`
Auto Complete	no
Data Filter	no
Default Value	S
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1
Order	9
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	nvarchar(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Template_Kind - Supported Filters

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

Template_Name

The unique name of the printing template.

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	1
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(64)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Template_Name - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
Like	None	no	no

Table of Contents