---
title: "Table 5477 Purch. Inv. Entity Aggregate"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/5477-purch-inv-entity-aggregate/
type: table
id: 5477
name: "Purch. Inv. Entity Aggregate"
app: "Base Application"
namespace: Microsoft.Integration.Entity
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/5477-purch-inv-entity-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 5477 Purch. Inv. Entity Aggregate

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

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

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Document Type | Enum Purchase Document Type | 17-28 | - | - |
| 2 | Buy-from Vendor No. | Code[20] | 17-28 | - | - |
| 3 | No. | Code[20] | 17-28 | - | - |
| 4 | Pay-to Vendor No. | Code[20] | 17-28 | - | - |
| 5 | Pay-to Name | Text[100] | 17-28 | - | - |
| 7 | Pay-to Address | Text[100] | 17-28 | - | - |
| 8 | Pay-to Address 2 | Text[50] | 17-28 | - | - |
| 9 | Pay-to City | Text[30] | 17-28 | - | - |
| 10 | Pay-to Contact | Text[100] | 17-28 | - | - |
| 11 | Your Reference | Text[35] | 17-28 | - | - |
| 12 | Ship-to Code | Code[10] | 17-28 | - | - |
| 13 | Ship-to Name | Text[100] | 17-28 | - | - |
| 15 | Ship-to Address | Text[100] | 17-28 | - | - |
| 16 | Ship-to Address 2 | Text[50] | 17-28 | - | - |
| 17 | Ship-to City | Text[30] | 17-28 | - | - |
| 18 | Ship-to Contact | Text[100] | 17-28 | - | - |
| 20 | Posting Date | Date | 17-28 | - | - |
| 23 | Payment Terms Code | Code[10] | 17-28 | - | - |
| 24 | Due Date | Date | 17-28 | - | - |
| 27 | Shipment Method Code | Code[10] | 17-28 | - | - |
| 29 | Shortcut Dimension 1 Code | Code[20] | 19-28 | - | - |
| 30 | Shortcut Dimension 2 Code | Code[20] | 19-28 | - | - |
| 31 | Vendor Posting Group | Code[20] | 17-28 | - | - |
| 32 | Currency Code | Code[10] | 17-28 | - | - |
| 35 | Prices Including VAT | Boolean | 17-28 | - | - |
| 43 | Purchaser Code | Code[20] | 17-28 | - | - |
| 44 | Order No. | Code[20] | 17-28 | - | - |
| 56 | Recalculate Invoice Disc. | Boolean | 17-28 | - | - |
| 60 | Amount | Decimal | 17-28 | - | - |
| 61 | Amount Including VAT | Decimal | 17-28 | - | - |
| 68 | Vendor Invoice No. | Code[35] | 17-28 | - | - |
| 79 | Buy-from Vendor Name | Text[100] | 17-28 | - | - |
| 81 | Buy-from Address | Text[100] | 17-28 | - | - |
| 82 | Buy-from Address 2 | Text[50] | 17-28 | - | - |
| 83 | Buy-from City | Text[30] | 17-28 | - | - |
| 84 | Buy-from Contact | Text[100] | 17-28 | - | - |
| 85 | Pay-to Post Code | Code[20] | 17-28 | - | - |
| 86 | Pay-to County | Text[30] | 17-28 | - | - |
| 87 | Pay-to Country/Region Code | Code[10] | 17-28 | - | - |
| 88 | Buy-from Post Code | Code[20] | 17-28 | - | - |
| 89 | Buy-from County | Text[30] | 17-28 | - | - |
| 90 | Buy-from Country/Region Code | Code[10] | 17-28 | - | - |
| 91 | Ship-to Post Code | Code[20] | 17-28 | - | - |
| 92 | Ship-to County | Text[30] | 17-28 | - | - |
| 93 | Ship-to Country/Region Code | Code[10] | 17-28 | - | - |
| 99 | Document Date | Date | 17-28 | - | - |
| 210 | Ship-to Phone No. | Text[30] | 25-28 | - | - |
| 1304 | Vendor Ledger Entry No. | Integer | 17-28 | - | - |
| 1305 | Invoice Discount Amount | Decimal | 17-28 | - | - |
| 5052 | Buy-from Contact No. | Code[20] | 17-28 | - | - |
| 8000 | Id | Guid | 17-28 | - | - |
| 9600 | Total Tax Amount | Decimal | 17-28 | - | - |
| 9601 | Status | Enum Invoice Entity Aggregate Status | 17-28 | - | - |
| 9602 | Posted | Boolean | 17-28 | - | - |
| 9624 | Discount Applied Before Tax | Boolean | 17-28 | - | - |
| 9630 | Last Modified Date Time | DateTime | 17-28 | - | - |
| 9631 | Vendor Id | Guid | 17-28 | - | - |
| 9632 | Order Id | Guid | 17-28 | - | - |
| 9634 | Currency Id | Guid | 17-28 | - | - |
| 9638 | Pay-to Vendor Id | Guid | 17-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | No., Posted | 17-28 |
| Key2 | Id | 17-28 |
| Key3 | Vendor Ledger Entry No. | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| UpdateCurrencyId | () | - | public | 17-28 | - | - |
| UpdateReferencedRecordIds | () | - | public | 17-28 | - | - |
| GetIsRenameAllowed | () | Boolean | public | 17-28 | - | - |
| SetIsRenameAllowed | (Boolean) | - | 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.