Table "Sales Invoice Line Aggregate"
ID 5476
Namespace: Microsoft.Integration.Entity
Properties
| Name | Value |
|---|---|
| Caption | Sales Invoice Line Aggregate |
| TableType | Temporary |
| ReplicateData | False |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Line No." | Integer | |
| Type | Enum Microsoft.Sales.Document."Sales Line Type" | |
| "No." | Code[20] | |
| "Location Code" | Code[10] | |
| "Shipment Date" | Date | |
| Description | Text[100] | |
| "Description 2" | Text[50] | |
| Quantity | Decimal | |
| "Qty. to Invoice" | Decimal | |
| "Qty. to Ship" | Decimal | |
| "Unit Price" | Decimal | |
| "VAT %" | Decimal | |
| "Line Discount %" | Decimal | |
| "Line Discount Amount" | Decimal | |
| Amount | Decimal | |
| "Amount Including VAT" | Decimal | |
| "Quantity Shipped" | Decimal | |
| "Quantity Invoiced" | Decimal | |
| "Inv. Discount Amount" | Decimal | |
| "Tax Group Code" | Code[20] | |
| "VAT Prod. Posting Group" | Code[20] | |
| "Currency Code" | Code[10] | |
| "VAT Base Amount" | Decimal | |
| "Line Amount" | Decimal | |
| "Line Discount Calculation" | Option | |
| "Variant Code" | Code[10] | |
| "Unit of Measure Code" | Code[10] | |
| "Document Id" | Guid | |
| Id | Text[50] | |
| "Variant Id" | Guid | |
| "Tax Code" | Code[50] | |
| "Tax Amount" | Decimal | |
| "Discount Applied Before Tax" | Boolean | |
| "API Type" | Enum Microsoft.Integration.Entity."Invoice Line Agg. Line Type" | |
| "Item Id" | Guid | |
| "Account Id" | Guid | |
| "Unit of Measure Id" | Guid | |
| "Line Tax Amount" | Decimal | |
| "Line Amount Including Tax" | Decimal | |
| "Line Amount Excluding Tax" | Decimal | |
| "Prices Including Tax" | Boolean | |
| "Inv. Discount Amount Excl. VAT" | Decimal | |
| "Tax Id" | Guid | |
| "Line Discount Value" | Decimal | |
| "Location Id" | Guid | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |
Methods
UpdateItemId
procedure UpdateItemId()UpdateAccountId
procedure UpdateAccountId()UpdateNo
procedure UpdateNo()UpdateReferencedRecordIds
procedure UpdateReferencedRecordIds()UpdateLineDiscounts
procedure UpdateLineDiscounts()SetDiscountValue
procedure SetDiscountValue()