Table Acc_Voucher_Lines

Entity

Entity: Finance.Accounting.AccountingVoucherLines

Contains one debit or credit posting within an accounting voucher. Entity: Acc_Voucher_Lines

Owner Tables Hierarchy

• Acc_Vouchers
• Gen_Documents

Summary

Name	Type	Description
Account_Id	uniqueidentifier	The account being debited or credited
Correspondance_No	int	The number of the correspondance group within the accounting voucher. For each correspondance group, the debits are equal to the credits
Correspondant_Amount	decimal(18, 2) Readonly	The amount (in the currency of the correspondant line) to which the amount in this line is corresponding. This field has value only when the current line is corresponding to only one line (e.g. NULL means that the current line is corresponding to many lines).
Cost_Center_Id	uniqueidentifier	The cost center to which this cost is related
Credit	decimal(18, 2)	The amount of the credit in the currency of the account. 0 means that the account is not credited
Credit_Base	decimal(18, 2)	The amount of credit in base currency
Currency_Id	uniqueidentifier	The currency of the movement in this line. If there is defined currency for the account in the line that it should be equal to the value in this field.
Debit	decimal(18, 2)	The amount of the debit in the currency of the account. 0 means that the account is not debited
Debit_Base	decimal(18, 2)	The amount of debit in base currency
Item_Key	nvarchar(64)	The item (grouping) key for the account in the line. Account_Id + Item_Key - the smallest unit of calculation for account balance.
Line_No	int	Consecutive number of the line within the voucher
Profit_Center_Id	uniqueidentifier	The profit center to which this revenue is related
Rate_Divisor	decimal(18, 6)	The divisor for conversion from Debit/Credit to base currency
Rate_Multiplier	decimal(18, 6)	The multiplier for conversion from Debit/Credit to base currency
Referenced_Document_Id	uniqueidentifier	The document which is referenced by the line. By default, this is the document of the voucher
Row_Version	timestamp
Voucher_Id	uniqueidentifier	The voucher to which this line is attached
Voucher_Line_Id	uniqueidentifier PK

Columns

Account_Id

The account being debited or credited

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	Acc_Accounts
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Account_Id - Supported Filters

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

Correspondance_No

The number of the correspondance group within the accounting voucher. For each correspondance group, the debits are equal to the credits

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

Correspondant_Amount

The amount (in the currency of the correspondant line) to which the amount in this line is corresponding. This field has value only when the current line is corresponding to only one line (e.g. NULL means that the current line is corresponding to many lines).

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Format	N2
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	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(18, 2) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Cost_Center_Id

The cost center to which this cost is related

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	Acc_Cost_Centers
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Cost_Center_Id - Supported Filters

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

Credit

The amount of the credit in the currency of the account. 0 means that the account is not credited

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	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	Sum
Supports EQUALS_IN	no
Type	decimal(18, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Credit_Base

The amount of credit in base currency

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	no
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	Sum
Supports EQUALS_IN	no
Type	decimal(18, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Currency_Id

The currency of the movement in this line. If there is defined currency for the account in the line that it should be equal to the value in this field.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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_Currencies
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	50
User Login	no
Visible	yes

Currency_Id - Supported Filters

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

Debit

The amount of the debit in the currency of the account. 0 means that the account is not debited

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	4
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	Sum
Supports EQUALS_IN	no
Type	decimal(18, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Debit_Base

The amount of debit in base currency

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	Sum
Supports EQUALS_IN	no
Type	decimal(18, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Item_Key

The item (grouping) key for the account in the line. Account_Id + Item_Key - the smallest unit of calculation for account balance.

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

Item_Key - Supported Filters

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

Line_No

Consecutive number of the line within the voucher

Property	Value
Auto Complete	no
Autoincrement	10
Data Filter	no
Default Value	None
Enter Stop	no
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	no
Type	int
UI Memo Editor	no
UI Width	25
User Login	no
Visible	yes

Profit_Center_Id

The profit center to which this revenue is related

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	Acc_Profit_Centers
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Profit_Center_Id - Supported Filters

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

Rate_Divisor

The divisor for conversion from Debit/Credit to base currency

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
Enter Stop	no
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(18, 6)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Rate_Multiplier

The multiplier for conversion from Debit/Credit to base currency

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
Enter Stop	no
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(18, 6)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Referenced_Document_Id

The document which is referenced by the line. By default, this is the document of the voucher

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	Gen_Documents
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Referenced_Document_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

Voucher_Id

The voucher to which this line is attached

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	16
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Acc_Vouchers
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Voucher_Id - Supported Filters

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

Voucher_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	15
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

Voucher_Line_Id - Supported Filters

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