Table Exc_Excise_Administrative_Document_Lines

Entity

Entity: Finance.Excise.ExciseAdministrativeDocumentLines

The details of the movement of each excise product for each excise document. Entity: Exc_Excise_Administrative_Document_Lines (Introduced in version 21.1.3.54)

Owner Tables Hierarchy

• Exc_Excise_Administrative_Documents
• Gen_Documents

Summary

Name	Type	Description
Excise_Administrative_Document_Id	uniqueidentifier
Excise_Administrative_Document_Line_Id	uniqueidentifier PK
Excise_Alcoholic_Strength	decimal(5, 2)	The alcoholic strength, which will be used for Excise reporting purposes. NULL if the product is not subject to alcoholic Excise reporting.
Excise_Amount	decimal(14, 2)	The excise amount
Excise_Amount_Base	decimal(14, 4)	The excise amount in base currency
Excise_Duty_Rate_Id	uniqueidentifier	The Duty rate specified by the taxation and customs authorities.
Excise_Duty_Rate_Value	decimal(10, 6)	The rate which should be applied for the specified product and purpose. NULL means not assigned yet.
Excise_Product_Id	uniqueidentifier	The Excise product code defined by the taxation and customs authorities.
Excise_Purpose_Code_Id	uniqueidentifier	The Purpose codes specify the different purposes recognized by the authorities for determining the excise rate.
Excise_Quantity	decimal(12, 3)	The quantity, converted, for reporting purposes, in the measurement unit of the excise product type.
Excise_Quantity_Unit_Id	uniqueidentifier	The measurement unit of Excise Quantity. Copied from the excise product type.
Line_No	int	Consecutive line number within the document.
Lot_Id	uniqueidentifier	Warehouse lot
Measuring_Transaction_Id	uniqueidentifier	Transaction of product input or output, measured with specialized measuring device for excise purposes.
Notes	nvarchar(max)
Parent_Document_Id	uniqueidentifier	The document, which the current line executes. Null when the current line does not execute another line.
Parent_Line_No	int	The number of the line within the parent document, which the current line executes. Null when the current line does not execute line.
Product_Id	uniqueidentifier	The product being sold.
Quantity	decimal(12, 3)	The quantity being sold, in the measurement unit, specified in Quantity Unit.
Quantity_Base	decimal(12, 3)	The quantity in base measurement category for the product.
Quantity_Unit_Id	uniqueidentifier	The measurement unit of Quantity.
Row_Version	timestamp

Columns

Excise_Administrative_Document_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	5
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Exc_Excise_Administrative_Documents
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

Excise_Administrative_Document_Id - Supported Filters

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

Excise_Administrative_Document_Line_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	4
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_Administrative_Document_Line_Id - Supported Filters

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

Excise_Alcoholic_Strength

The alcoholic strength, which will be used for Excise reporting purposes. NULL if the product is not subject to alcoholic Excise reporting.

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	15
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(5, 2) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Excise_Amount

The excise amount

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	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	decimal(14, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Excise_Amount - Supported Filters

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

Excise_Amount_Base

The excise amount in base currency

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	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	decimal(14, 4)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Excise_Amount_Base - Supported Filters

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

Excise_Duty_Rate_Id

The Duty rate specified by the taxation and customs authorities.

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	13
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Exc_Excise_Duty_Rates
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	no

Excise_Duty_Rate_Id - Supported Filters

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

Excise_Duty_Rate_Value

The rate which should be applied for the specified product and purpose. NULL means not assigned yet.

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	14
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(10, 6) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Excise_Product_Id

The Excise product code defined by the taxation and customs authorities.

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	11
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Exc_Excise_Products
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	no

Excise_Product_Id - Supported Filters

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

Excise_Purpose_Code_Id

The Purpose codes specify the different purposes recognized by the authorities for determining the excise rate.

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	12
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Exc_Excise_Purpose_Codes
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	no

Excise_Purpose_Code_Id - Supported Filters

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

Excise_Quantity

The quantity, converted, for reporting purposes, in the measurement unit of the excise product 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	-1
Order	18
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Excise_Quantity_Unit_Id

The measurement unit of Excise Quantity. Copied from the excise product 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	-1
Order	19
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Measurement_Units
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_Quantity_Unit_Id - Supported Filters

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

Line_No

Consecutive line number within the document.

Property	Value
Auto Complete	no
Autoincrement	1
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	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	int
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Line_No - Supported Filters

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

Lot_Id

Warehouse lot

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Depends On	Product_Id
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	20
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Lots
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

Lot_Id - Supported Filters

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

Measuring_Transaction_Id

Transaction of product input or output, measured with specialized measuring device for excise purposes.

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_Measuring_Transactions
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	no

Measuring_Transaction_Id - Supported Filters

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

Notes

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

Parent_Document_Id

The document, which the current line executes. Null when the current line does not execute another line.

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	16
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Documents
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	no

Parent_Document_Id - Supported Filters

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

Parent_Line_No

The number of the line within the parent document, which the current line executes. Null when the current line does not execute line.

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

Parent_Line_No - Supported Filters

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

Product_Id

The product being sold.

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	1
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Products
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

Product_Id - Supported Filters

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

Quantity

The quantity being sold, in the measurement unit, specified in Quantity Unit.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
Enter Stop	yes
Format	N3
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	decimal(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Quantity_Base

The quantity in base measurement category for the product.

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

Quantity_Unit_Id

The measurement unit of Quantity.

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	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Measurement_Units
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

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