Table Cash_Invoice_Reconciliation_Lines

Note

OBSOLETE! Do not use!

Entity

Entity: Finance.Payments.InvoiceReconciliationLines

Obsolete. Not used. Entity: Cash_Invoice_Reconciliation_Lines (Obsoleted in version 20.1.0.0)

Owner Tables Hierarchy

Summary

Name	Type	Description
Covered_Invoice_Amount	`decimal(14, 2)`	Amount from the invoice that is covered by the payment. The amount is in the currency of the invoice.
Invoice_Document_Id	`uniqueidentifier`	Obsolete. Not used.
Invoice_Reconciliation_Id	`uniqueidentifier`
Invoice_Reconciliation_Line_Id	`uniqueidentifier` `PK`
Payment_Transaction_Document_Id	`uniqueidentifier`	Obsolete. Not used.
Row_Version	`timestamp`

Columns

Covered_Invoice_Amount

Amount from the invoice that is covered by the payment. The amount is in the currency of the invoice.

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

Invoice_Document_Id

Obsolete. Not used.

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

Invoice_Document_Id - Supported Filters

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

Invoice_Reconciliation_Id

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	2147483647
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Cash_Invoice_Reconciliations
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

Invoice_Reconciliation_Id - Supported Filters

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

Invoice_Reconciliation_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	2147483647
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

Invoice_Reconciliation_Line_Id - Supported Filters

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

Payment_Transaction_Document_Id