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