---
title: "Table 5478 Purch. Inv. Line Aggregate"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/5478-purch-inv-line-aggregate/
type: table
id: 5478
name: "Purch. Inv. Line Aggregate"
app: "Base Application"
namespace: Microsoft.Integration.Entity
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/5478-purch-inv-line-aggregate/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 5478 Purch. Inv. Line Aggregate

Jonas Paprotka, https://jonas-paprotka.de/ref/table/5478-purch-inv-line-aggregate/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Integration.Entity |
| Versions | 17-28 |
| Source file | Integration/Entity/PurchInvLineAggregate.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 4 | Line No. | Integer | 17-28 | - | - |
| 5 | Type | Enum Purchase Line Type | 17-28 | - | - |
| 6 | No. | Code[20] | 17-28 | - | - |
| 7 | Location Code | Code[10] | 18-28 | - | - |
| 10 | Expected Receipt Date | Date | 17-28 | - | - |
| 11 | Description | Text[100] | 17-28 | - | - |
| 12 | Description 2 | Text[50] | 17-28 | - | - |
| 15 | Quantity | Decimal | 17-28 | - | - |
| 17 | Qty. to Invoice | Decimal | 17-28 | - | - |
| 18 | Qty. to Receive | Decimal | 17-28 | - | - |
| 22 | Direct Unit Cost | Decimal | 17-28 | - | - |
| 25 | VAT % | Decimal | 17-28 | - | - |
| 27 | Line Discount % | Decimal | 17-28 | - | - |
| 28 | Line Discount Amount | Decimal | 17-28 | - | - |
| 29 | Amount | Decimal | 17-28 | - | - |
| 30 | Amount Including VAT | Decimal | 17-28 | - | - |
| 60 | Quantity Received | Decimal | 17-28 | - | - |
| 61 | Quantity Invoiced | Decimal | 17-28 | - | - |
| 69 | Inv. Discount Amount | Decimal | 17-28 | - | - |
| 87 | Tax Group Code | Code[20] | 17-28 | - | - |
| 90 | VAT Prod. Posting Group | Code[20] | 17-28 | - | - |
| 91 | Currency Code | Code[10] | 17-28 | - | - |
| 99 | VAT Base Amount | Decimal | 17-28 | - | - |
| 103 | Line Amount | Decimal | 17-28 | - | - |
| 5402 | Variant Code | Code[10] | 17-28 | - | - |
| 5407 | Unit of Measure Code | Code[10] | 17-28 | - | - |
| 8000 | Document Id | Guid | 17-28 | - | - |
| 8001 | Id | Text[50] | 17-28 | - | - |
| 8002 | Variant Id | Guid | 17-28 | - | - |
| 9020 | Tax Code | Code[50] | 17-28 | - | - |
| 9021 | Tax Amount | Decimal | 17-28 | - | - |
| 9022 | Discount Applied Before Tax | Boolean | 17-28 | - | - |
| 9029 | API Type | Enum Invoice Line Agg. Line Type | 17-28 | - | - |
| 9030 | Item Id | Guid | 17-28 | - | - |
| 9031 | Account Id | Guid | 17-28 | - | - |
| 9032 | Unit of Measure Id | Guid | 17-28 | - | - |
| 9039 | Line Tax Amount | Decimal | 17-28 | - | - |
| 9040 | Line Amount Including Tax | Decimal | 17-28 | - | - |
| 9041 | Line Amount Excluding Tax | Decimal | 17-28 | - | - |
| 9042 | Prices Including Tax | Boolean | 17-28 | - | - |
| 9043 | Inv. Discount Amount Excl. VAT | Decimal | 17-28 | - | - |
| 9044 | Tax Id | Guid | 17-28 | - | - |
| 9070 | Location Id | Guid | 18-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | Document Id, Line No. | 17-28 |
| Key2 | Id | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| UpdateItemId | () | - | public | 17-28 | - | - |
| UpdateAccountId | () | - | public | 17-28 | - | - |
| UpdateNo | () | - | public | 17-28 | - | - |
| UpdateReferencedRecordIds | () | - | public | 17-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.