Table Exc_Excise_Stamp_Lots

Entity

Entity: Finance.Excise.ExciseStampLots

Sequence of excise stamps with same production batch and type, received with one delivery. Entity: Exc_Excise_Stamp_Lots (Introduced in version 22.1.6.13)

Summary

Name	Type	Description
Batch_Number	nvarchar(30)	Production batch of the Excise Stamps.
End_Number	nvarchar(30)	End number of the lot.
Excise_Product_Type_Id	uniqueidentifier	Specifies the Excise Product Type of the Excise Stamps in the lot.
Excise_Stamp_Lot_Id	uniqueidentifier PK
Is_Active	bit	Is Active
Prefix	nvarchar(30)	Specifies the prefix that is used in forming the value of the "BatchNumber" field.
Purchase_Lot_Number	nvarchar(30)	Type and number of the document with which the excise stamps were received from the customs administration.
Quantity	int	Number of excise stamps in the lot.
Row_Version	timestamp
Start_Number	nvarchar(30)	Start number of the lot.

Columns

Batch_Number

Production batch of the Excise Stamps.

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

Batch_Number - Supported Filters

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

End_Number

End number of the lot.

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

Excise_Product_Type_Id

Specifies the Excise Product Type of the Excise Stamps in the lot.

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
Referenced Table	Exc_Excise_Product_Types
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

Excise_Product_Type_Id - Supported Filters

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

Excise_Stamp_Lot_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

Excise_Stamp_Lot_Id - Supported Filters

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

Is_Active

Is Active

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

Is_Active - Supported Filters

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

Prefix

Specifies the prefix that is used in forming the value of the "BatchNumber" field.

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

Prefix - Supported Filters

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

Purchase_Lot_Number

Type and number of the document with which the excise stamps were received from the customs administration.

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

Purchase_Lot_Number - Supported Filters

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

Quantity

Number of excise stamps in the lot.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
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	int
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	9
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

Start_Number

Start number of the lot.

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