Crm.Invoicing.InvoiceLines Entity

Detail records (lines) of the invoices. Entity: Crm_Invoice_Lines

Default Visualization

Default Display Text Format:
{LineNo}. {Invoice.DocumentNo} {Invoice.DocumentType.TypeName:T}
Default Search Members:
Invoice.DocumentNo
Category: Definitions
Show in UI: ShownByDefault

Track Changes

Min level: 0 - Do not track changes
Max level: 4 - Track object attribute and blob changes

Aggregate

An aggregate is a cluster of domain objects that can be treated as a single unit.

Aggregate Parent:
Crm.Invoicing.Invoices
Aggregate Root:
Crm.Invoicing.Invoices

Attributes

Name	Type	Description
BusinessReason	InvoicingBusinessReason	Business reason for invoicing of this product or service. S=Shipment, P=Payment. `Required` `Default("S")`
CurrentBalanceBase	Quantity	The current balance of the product in the selected store and enterprise company. If lot, serial number or product variant are specified the quantity is calculated accordingly.
DeliveryTermsCode	DeliveryTerms nullable	Mode of delivery, like CIF, FOB, etc. Used also in Intrastat reporting.
DisplayText	string	Uses the repository DisplayTextFormat to build the display text from the attributes and references of current object.
Id	guid
IntrastatApplyDate	datetime nullable	Specifies in which period for Intrastat declaration must be included the current operation. Used only when the invoice is issued in different period than the one, that the operation must be included. If not set the document date is used. `Filter(ge;le)` `Introduced in version 21.1.3.83`
IntrastatTransaction NatureCode	TransactionNature nullable	Transaction nature; used for Intrastat reporting.
IntrastatTransportModeCode	TransportMode nullable	Transport mode; used for Intrastat reporting.
LineAmount	Amount (14, 2)	Amount for the line in the currency of the parent document. Usually equals Quantity * Unit_Price. When Quantity = 0, Unit Price is undefined and this contains the total line amount. `Currency: Invoice.DocumentCurrency` `Required` `Default(0)`
LineCustomDiscountPercent	decimal (7, 6)	User-defined discount for the line. `Required` `Default(0)` `Filter(ge;le)`
LineNo	int32	Consecutive line number, unique within the invoice. Usually is increasing in steps of 10, like in 10, 20, 30, etc. `Required` `Filter(eq)`
LineStandardDiscount Percent	decimal (7, 6)	Standard discount for the line. This is automatically computed according to discount conditions. `Required` `Default(0)`
Notes	string (254) nullable	Notes for this InvoiceLine.
ObjectVersion	int32	The latest version of the extensible data object for the aggregate root for the time the object is loaded from the database. Can be used for optimistic locking.
ParentLineNo	int32 nullable	The number of the line within the parent document, which the current line executes. null when the current line does not execute line. `Introduced in version 18.2`
ProductDescription	MultilanguageString (254)	The description of the invoiced product. Initially copied from the name of the invoiced Product or from the generating document. `Required`
Quantity	Quantity (12, 3)	The quantity of the invoiced product. `Unit: QuantityUnit` `Required` `Default(1)` `Filter(ge;le)`
QuantityBase	Quantity (12, 3)	The equivalent of Quantity in the base measurement unit of the Product. `Unit: Product.BaseMeasurementCategory.BaseUnit` `Required`
SalesOrderAmount	decimal (14, 2) nullable	Specifies what portion of the amount of the sales order is invoiced with this line. The amount is calculated with respect to the trade conditions (prices, discounts, etc.) from the sales order. Can be different from the total amount of the line when the trade conditions from the sales order have changed before invoicing.
StandardQuantityBase	Quantity (12, 3)	The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution. `Unit: Product.BaseMeasurementCategory.BaseUnit` `Required` `ReadOnly` `Introduced in version 18.2`
UnitPrice	Amount (14, 5)	The unit selling price of Quantity. `Currency: Invoice.DocumentCurrency` `Required` `Default(0)`

References

Name	Type	Description
Document	Invoices	The to which this InvoiceLine belongs. `Required` `Filter(multi eq)`
IntrastatTransportCountry	Countries (nullable)	Country of origin of the transport company; used for Intrastat reporting. `Filter(multi eq)`
Invoice	Invoices	The to which this InvoiceLine belongs. `Required` `Filter(multi eq)` `Owner`
InvoiceOrderLine	InvoiceOrderLines (nullable)	Invoice order line which is invoiced by this line. `Filter(multi eq)`
LineDealType	DealTypes (nullable)	Deal type for this line. If deal type in the line is different from deal type in the header another VAT entry is created. `Filter(multi eq)`
LineDiscount	LineDiscounts (nullable)	The line discount type used to form the Line_Standard_ Discount_Percent. `Filter(multi eq)`
ParentDocument	Documents (nullable)	The document, which the current line executes. null when the current line does not execute another line. `Filter(multi eq)` `Introduced in version 18.2`
ParentSalesOrderLine	SalesOrderLines (nullable)	When not null specifies the Sales Order line that is invoiced by this invoice line. `Filter(multi eq)`
PaymentTransaction	PaymentTransactions (nullable)	The payment transaction, which is invoiced by this line, when Business Reason = P. Used to reconcile the invoice with the payments in the case of advance payment. `Filter(multi eq)`
Product	Products (nullable)	The invoiced product. When null, although rarely used, the invoice line is still valid and the Product Description contains the invoiced item. `Filter(multi eq)`
QuantityUnit	MeasurementUnits	The measurement unit of Quantity. `Required` `Filter(multi eq)`
SalesOrder	SalesOrders (nullable)	When not null specifies the Sales Order that is invoiced by this line. `Filter(multi eq;like)`
SerialNumber	SerialNumbers (nullable)	Which serial number to receive/issue. null means that serial number is unknown or not applicable. `Filter(multi eq)`
TransactionLine	StoreTransactionLines (nullable)	The store transaction line that is invoiced by this line, for Business Reason = S. `Filter(multi eq)`

Attribute Details

BusinessReason

Business reason for invoicing of this product or service. S=Shipment, P=Payment. Required Default("S")

Type: InvoicingBusinessReason
Category: System
Generic enum type for InvoicingBusinessReason properties
Allowed Values (Crm.Invoicing.InvoicingBusinessReason Enum Members)

Value	Description
Payment	Payment value. Stored as 'P'. Database Value: 'P' Model Value: 0 Domain API Value: 'Payment'
Shipment	Shipment value. Stored as 'S'. Database Value: 'S' Model Value: 1 Domain API Value: 'Shipment'

Supported Filters: NotFilterable
Supports Order By: False
Default Value: Shipment
Show in UI: HiddenByDefault

CurrentBalanceBase

The current balance of the product in the selected store and enterprise company. If lot, serial number or product variant are specified the quantity is calculated accordingly.

Type: Quantity
Category: Calculated Attributes
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault

DeliveryTermsCode

Mode of delivery, like CIF, FOB, etc. Used also in Intrastat reporting.

Type: DeliveryTerms nullable
Category: System
Generic enum type for DeliveryTerms properties
Allowed Values (Finance.Intrastat.DeliveryTerms Enum Members)

Value	Description
ExWorks	ExWorks value. Stored as 'EXW'. Database Value: 'EXW' Model Value: 0 Domain API Value: 'ExWorks'
FrancoCarrier	FrancoCarrier value. Stored as 'FCA'. Database Value: 'FCA' Model Value: 1 Domain API Value: 'FrancoCarrier'
FreeAlongsideShip	FreeAlongsideShip value. Stored as 'FAS'. Database Value: 'FAS' Model Value: 2 Domain API Value: 'FreeAlongsideShip'
FreeOnBoard	FreeOnBoard value. Stored as 'FOB'. Database Value: 'FOB' Model Value: 3 Domain API Value: 'FreeOnBoard'
CostAndFreightCF	CostAndFreightCF value. Stored as 'CFR'. Database Value: 'CFR' Model Value: 4 Domain API Value: 'CostAndFreightCF'
CostInsuranceAndFreight	CostInsuranceAndFreight value. Stored as 'CIF'. Database Value: 'CIF' Model Value: 5 Domain API Value: 'CostInsuranceAndFreight'
CarriagePaidTo	CarriagePaidTo value. Stored as 'CPT'. Database Value: 'CPT' Model Value: 6 Domain API Value: 'CarriagePaidTo'
CarriageAndInsurancePaidTo	CarriageAndInsurancePaidTo value. Stored as 'CIP'. Database Value: 'CIP' Model Value: 7 Domain API Value: 'CarriageAndInsurancePaidTo'
DeliveredAtPlace	DeliveredAtPlace value. Stored as 'DAP'. Database Value: 'DAP' Model Value: 8 Domain API Value: 'DeliveredAtPlace'
DeliveredAtTerminal	DeliveredAtTerminal value. Stored as 'DAT'. Database Value: 'DAT' Model Value: 9 Domain API Value: 'DeliveredAtTerminal'
DeliveredDutyPaid	DeliveredDutyPaid value. Stored as 'DDP'. Database Value: 'DDP' Model Value: 10 Domain API Value: 'DeliveredDutyPaid'
DeliveredAtPlaceUnloaded	DeliveredAtPlaceUnloaded value. Stored as 'DPU'. Database Value: 'DPU' Model Value: 11 Domain API Value: 'DeliveredAtPlaceUnloaded'

Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Back-End Default Expression:
obj.Invoice.DeliveryTermsCode

Front-End Recalc Expressions:
obj.Invoice.DeliveryTermsCode

DisplayText

Uses the repository DisplayTextFormat to build the display text from the attributes and references of current object.

Type: string
Category: Calculated Attributes
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault

Id

Type: guid
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: CannotBeShown

IntrastatApplyDate

Specifies in which period for Intrastat declaration must be included the current operation. Used only when the invoice is issued in different period than the one, that the operation must be included. If not set the document date is used. Filter(ge;le) Introduced in version 21.1.3.83

Type: datetime nullable
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: HiddenByDefault

IntrastatTransactionNatureCode

Transaction nature; used for Intrastat reporting.

Type: TransactionNature nullable
Category: System
Generic enum type for TransactionNature properties
Allowed Values (Finance.Intrastat.TransactionNature Enum Members)

Value	Description
OutrightPurchaseOrSale	OutrightPurchaseOrSale value. Stored as '11'. Database Value: '11' Model Value: 0 Domain API Value: 'OutrightPurchaseOrSale'
SupplyForSale	SupplyForSale value. Stored as '12'. Database Value: '12' Model Value: 1 Domain API Value: 'SupplyForSale'
BarterTrade	BarterTrade value. Stored as '13'. Database Value: '13' Model Value: 2 Domain API Value: 'BarterTrade'
FinancialLeasing	FinancialLeasing value. Stored as '14'. Database Value: '14' Model Value: 3 Domain API Value: 'FinancialLeasing'
OtherTransactions	OtherTransactions value. Stored as '19'. Database Value: '19' Model Value: 4 Domain API Value: 'OtherTransactions'
ReturnStokilizing	ReturnStokilizing value. Stored as '21'. Database Value: '21' Model Value: 5 Domain API Value: 'ReturnStokilizing'
ReplacementFor ReturnedGoods	ReplacementFor ReturnedGoods value. Stored as '22'. Database Value: '22' Model Value: 6 Domain API Value: 'ReplacementFor ReturnedGoods'
ReplacementOfGoods NotBeingReturned	ReplacementOfGoods NotBeingReturned value. Stored as '23'. Database Value: '23' Model Value: 7 Domain API Value: 'ReplacementOfGoods NotBeingReturned'
ReturnOrExchange OfOtherGoods	ReturnOrExchange OfOtherGoods value. Stored as '29'. Database Value: '29' Model Value: 8 Domain API Value: 'ReturnOrExchange OfOtherGoods'
SpecificTransactions	SpecificTransactions value. Stored as '60'. Database Value: '60' Model Value: 9 Domain API Value: 'SpecificTransactions'
OperationsOnJointProjects	OperationsOnJointProjects value. Stored as '70'. Database Value: '70' Model Value: 10 Domain API Value: 'OperationsOnJointProjects'
TransactionsOf ConstructionMaterials AndEquipment	TransactionsOf ConstructionMaterials AndEquipment value. Stored as '80'. Database Value: '80' Model Value: 11 Domain API Value: 'TransactionsOf ConstructionMaterials AndEquipment'
OtherTransactionsLeasing	OtherTransactionsLeasing value. Stored as '91'. Database Value: '91' Model Value: 12 Domain API Value: 'OtherTransactionsLeasing'
OtherTransactionsOther	OtherTransactionsOther value. Stored as '99'. Database Value: '99' Model Value: 13 Domain API Value: 'OtherTransactionsOther'
DealsThatInclude PropertyTransfers WithoutFinancial CompensationOr CompensationIn Kind	DealsThatInclude PropertyTransfers WithoutFinancial CompensationOr CompensationIn Kind value. Stored as '30'. Database Value: '30' Model Value: 14 Domain API Value: 'DealsThatInclude PropertyTransfers WithoutFinancial CompensationOr CompensationIn Kind'
GoodsThatAreExpected ToBeReturnedTo Sender	GoodsThatAreExpected ToBeReturnedTo Sender value. Stored as '41'. Database Value: '41' Model Value: 15 Domain API Value: 'GoodsThatAreExpected ToBeReturnedTo Sender'
GoodsThatAreNot ExpectedToBeReturned ToSender	GoodsThatAreNot ExpectedToBeReturned ToSender value. Stored as '42'. Database Value: '42' Model Value: 16 Domain API Value: 'GoodsThatAreNot ExpectedToBeReturned ToSender'
GoodsThatAreReturned ToSender	GoodsThatAreReturned ToSender value. Stored as '51'. Database Value: '51' Model Value: 17 Domain API Value: 'GoodsThatAreReturned ToSender'
GoodsThatAreNot ReturnedToSender	GoodsThatAreNot ReturnedToSender value. Stored as '52'. Database Value: '52' Model Value: 18 Domain API Value: 'GoodsThatAreNot ReturnedToSender'

Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Back-End Default Expression:
obj.Invoice.IntrastatTransactionNatureCode

Front-End Recalc Expressions:
obj.Invoice.IntrastatTransactionNatureCode

IntrastatTransportModeCode

Transport mode; used for Intrastat reporting.

Type: TransportMode nullable
Category: System
Generic enum type for TransportMode properties
Allowed Values (Finance.Intrastat.TransportMode Enum Members)

Value	Description
Shipping	Shipping value. Stored as '1'. Database Value: '1' Model Value: 0 Domain API Value: 'Shipping'
RailwayTransport	RailwayTransport value. Stored as '2'. Database Value: '2' Model Value: 1 Domain API Value: 'RailwayTransport'
RoadTransport	RoadTransport value. Stored as '3'. Database Value: '3' Model Value: 2 Domain API Value: 'RoadTransport'
AirTransport	AirTransport value. Stored as '4'. Database Value: '4' Model Value: 3 Domain API Value: 'AirTransport'
Mail	Mail value. Stored as '5'. Database Value: '5' Model Value: 4 Domain API Value: 'Mail'
FixedTransport Installations	FixedTransport Installations value. Stored as '7'. Database Value: '7' Model Value: 5 Domain API Value: 'FixedTransport Installations'
RiverTransport	RiverTransport value. Stored as '8'. Database Value: '8' Model Value: 6 Domain API Value: 'RiverTransport'
SelfPropelled	SelfPropelled value. Stored as '9'. Database Value: '9' Model Value: 7 Domain API Value: 'SelfPropelled'

Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Back-End Default Expression:
obj.Invoice.IntrastatTransportModeCode

Front-End Recalc Expressions:
obj.Invoice.IntrastatTransportModeCode

LineAmount

Amount for the line in the currency of the parent document. Usually equals Quantity * Unit_Price. When Quantity = 0, Unit Price is undefined and this contains the total line amount. Currency: Invoice.DocumentCurrency Required Default(0)

Type: Amount (14, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: ShownByDefault

Front-End Recalc Expressions:
obj.CalculateLineAmount( obj.Quantity, obj.UnitPrice, Convert( obj.LineStandardDiscountPercent, Nullable1), Convert( obj.LineCustomDiscountPercent, Nullable1), obj.Invoice.DocumentCurrency)

LineCustomDiscountPercent

User-defined discount for the line. Required Default(0) Filter(ge;le)

Type: decimal (7, 6)
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Default Value: 0
Show in UI: ShownByDefault

LineNo

Consecutive line number, unique within the invoice. Usually is increasing in steps of 10, like in 10, 20, 30, etc. Required Filter(eq)

Type: int32
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault

Back-End Default Expression:
( obj.Invoice.Lines.Select( c => c.LineNo).DefaultIfEmpty( 0).Max( ) + 10)

Front-End Recalc Expressions:
( obj.Invoice.Lines.Select( c => c.LineNo).DefaultIfEmpty( 0).Max( ) + 10)

LineStandardDiscountPercent

Standard discount for the line. This is automatically computed according to discount conditions. Required Default(0)

Type: decimal (7, 6)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: 0
Show in UI: HiddenByDefault

Front-End Recalc Expressions:
IIF( ( obj.LineDiscount != null), obj.LineDiscount.DiscountPercent, 0)

Notes

Notes for this InvoiceLine.

Type: string (254) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 254
Show in UI: HiddenByDefault

ObjectVersion

The latest version of the extensible data object for the aggregate root for the time the object is loaded from the database. Can be used for optimistic locking.

Type: int32
Category: Extensible Data Object
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault

ParentLineNo

The number of the line within the parent document, which the current line executes. null when the current line does not execute line. Introduced in version 18.2

Type: int32 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

ProductDescription

The description of the invoiced product. Initially copied from the name of the invoiced Product or from the generating document. Required

Type: MultilanguageString (254)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Front-End Recalc Expressions:
obj.Product.Name

Quantity

The quantity of the invoiced product. Unit: QuantityUnit Required Default(1) Filter(ge;le)

Type: Quantity (12, 3)
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Default Value: Constant
Show in UI: ShownByDefault

QuantityBase

The equivalent of Quantity in the base measurement unit of the Product. Unit: Product.BaseMeasurementCategory.BaseUnit Required

Type: Quantity (12, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Back-End Default Expression:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.QuantityBase, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product))

Front-End Recalc Expressions:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.QuantityBase, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product))

SalesOrderAmount

Specifies what portion of the amount of the sales order is invoiced with this line. The amount is calculated with respect to the trade conditions (prices, discounts, etc.) from the sales order. Can be different from the total amount of the line when the trade conditions from the sales order have changed before invoicing.

Type: decimal (14, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

StandardQuantityBase

The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution. Unit: Product.BaseMeasurementCategory.BaseUnit Required ReadOnly Introduced in version 18.2

Type: Quantity (12, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Back-End Default Expression:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.StandardQuantityBase, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product))

Front-End Recalc Expressions:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.StandardQuantityBase, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product))

UnitPrice

The unit selling price of Quantity. Currency: Invoice.DocumentCurrency Required Default(0)

Type: Amount (14, 5)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: ShownByDefault

Reference Details

Document

The to which this InvoiceLine belongs. Required Filter(multi eq)

Type: Invoices
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

IntrastatTransportCountry

Country of origin of the transport company; used for Intrastat reporting. Filter(multi eq)

Type: Countries (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

Back-End Default Expression:
obj.Invoice.IntrastatTransportCountry

Front-End Recalc Expressions:
obj.Invoice.IntrastatTransportCountry

Invoice

The to which this InvoiceLine belongs. Required Filter(multi eq) Owner

Type: Invoices
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Filterable Reference: True
Show in UI: ShownByDefault

InvoiceOrderLine

Invoice order line which is invoiced by this line. Filter(multi eq)

Type: InvoiceOrderLines (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

LineDealType

Deal type for this line. If deal type in the line is different from deal type in the header another VAT entry is created. Filter(multi eq)

Type: DealTypes (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

Back-End Default Expression:
obj.Invoice.DealType

Front-End Recalc Expressions:
obj.Invoice.DealType

LineDiscount

The line discount type used to form the Line_Standard_Discount_Percent. Filter(multi eq)

Type: LineDiscounts (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

Front-End Recalc Expressions:
obj.DetermineLineDiscount( Convert( ( obj.Invoice.DeliveryDate ?? obj.Invoice.DocumentDate), Nullable1), obj.Invoice.Customer, obj.Product, obj.Quantity, obj.Invoice.EnterpriseCompany, obj.Invoice.EnterpriseCompanyLocation, IIF( ( obj.SalesOrder == null), null, obj.SalesOrder.DistributionChannel), IIF( ( obj.SalesOrder == null), null, obj.SalesOrder.PriceList))`

ParentDocument

The document, which the current line executes. null when the current line does not execute another line. Filter(multi eq) Introduced in version 18.2

Type: Documents (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

ParentSalesOrderLine

When not null specifies the Sales Order line that is invoiced by this invoice line. Filter(multi eq)

Type: SalesOrderLines (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

PaymentTransaction

The payment transaction, which is invoiced by this line, when Business Reason = P. Used to reconcile the invoice with the payments in the case of advance payment. Filter(multi eq)

Type: PaymentTransactions (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

Product

The invoiced product. When null, although rarely used, the invoice line is still valid and the Product Description contains the invoiced item. Filter(multi eq)

Type: Products (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

QuantityUnit

The measurement unit of Quantity. Required Filter(multi eq)

Type: MeasurementUnits
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

Front-End Recalc Expressions:
obj.Product.MeasurementUnit

SalesOrder

When not null specifies the Sales Order that is invoiced by this line. Filter(multi eq;like)

Type: SalesOrders (nullable)
Indexed: True
Category: System
Supported Filters: Equals, Like, EqualsIn
Show in UI: HiddenByDefault

Front-End Recalc Expressions:
IIF( ( obj.ParentSalesOrderLine != null), obj.ParentSalesOrderLine.SalesOrder, null)

SerialNumber

Which serial number to receive/issue. null means that serial number is unknown or not applicable. Filter(multi eq)

Type: SerialNumbers (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

TransactionLine

The store transaction line that is invoiced by this line, for Business Reason = S. Filter(multi eq)

Type: StoreTransactionLines (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

API Methods

Methods that can be invoked in public APIs.

GetAllowedCustomPropertyValues

Gets the allowed values for the specified custom property for this entity object. If supported the result is ordered by property value. Some property value sources do not support ordering - in that case the result is not ordered.
Return Type: Collection Of CustomPropertyValue
Declaring Type: EntityObject
Domain API Request: GET

Parameters

customPropertyCode
The code of the custom property
Type: string
search
The search text - searches by value or description. Can contain wildcard character %.
Type: string
Optional: True
Default Value: null
exactMatch
If true the search text should be equal to the property value
Type: boolean
Optional: True
Default Value: False
orderByDescription
If true the result is ordered by Description instead of Value. Note that ordering is not always possible.
Type: boolean
Optional: True
Default Value: False
top
The top clause - default is 10
Type: int32
Optional: True
Default Value: 10
skip
The skip clause - default is 0
Type: int32
Optional: True
Default Value: 0

CreateNotification

Create a notification immediately in a separate transaction, and send a real-time event to the user.
Return Type: void
Declaring Type: EntityObject
Domain API Request: POST

Parameters

user
The user.
Type: Users
notificationClass
The notification class.
Type: string
subject
The notification subject.
Type: string

CreateCopy

Duplicates the object and its child objects belonging to the same aggregate. The duplicated objects are not saved to the data source but remain in the same transaction as the original object.
Return Type: EntityObject
Declaring Type: EntityObject
Domain API Request: POST

Business Rules

None

Front-End Business Rules

API

Domain API Query: https://demodb.my.erp.net/api/domain/odata/Crm_Invoicing_InvoiceLines?$top=10

Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Crm_Invoicing_InvoiceLines?$top=10

Table of Contents

Crm.Invoicing.InvoiceLines Entity

Default Visualization

Track Changes

Aggregate

Attributes

References

Attribute Details

BusinessReason

CurrentBalanceBase

DeliveryTermsCode

DisplayText

Id

IntrastatApplyDate

IntrastatTransactionNatureCode

IntrastatTransportModeCode

LineAmount

LineCustomDiscountPercent

LineNo

LineStandardDiscountPercent

Notes

ObjectVersion

ParentLineNo

ProductDescription

Quantity

QuantityBase

SalesOrderAmount

StandardQuantityBase

UnitPrice

Reference Details

Document

IntrastatTransportCountry

Invoice

InvoiceOrderLine

LineDealType

LineDiscount

ParentDocument

ParentSalesOrderLine

PaymentTransaction

Product

QuantityUnit

SalesOrder

SerialNumber

TransactionLine

API Methods

GetAllowedCustomPropertyValues

CreateNotification

CreateCopy

Business Rules

Front-End Business Rules

API