---
title: "Table 112 Sales Invoice Header"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/112-sales-invoice-header/
type: table
id: 112
name: "Sales Invoice Header"
app: "Base Application"
namespace: Microsoft.Sales.History
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/112-sales-invoice-header/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 112 Sales Invoice Header

Jonas Paprotka, https://jonas-paprotka.de/ref/table/112-sales-invoice-header/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Sales.History |
| Versions | 17-28 |
| Source file | Sales/History/SalesInvoiceHeader.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 2 | Sell-to Customer No. | Code[20] | 17-28 | - | - |
| 3 | No. | Code[20] | 17-28 | - | - |
| 4 | Bill-to Customer No. | Code[20] | 17-28 | - | - |
| 5 | Bill-to Name | Text[100] | 17-28 | - | - |
| 6 | Bill-to Name 2 | Text[50] | 17-28 | - | - |
| 7 | Bill-to Address | Text[100] | 17-28 | - | - |
| 8 | Bill-to Address 2 | Text[50] | 17-28 | - | - |
| 9 | Bill-to City | Text[30] | 17-28 | - | - |
| 10 | Bill-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 | - | - |
| 14 | Ship-to Name 2 | Text[50] | 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 | - | - |
| 19 | Order Date | Date | 17-28 | - | - |
| 20 | Posting Date | Date | 17-28 | - | - |
| 21 | Shipment Date | Date | 17-28 | - | - |
| 22 | Posting Description | Text[100] | 17-28 | - | - |
| 23 | Payment Terms Code | Code[10] | 17-28 | - | - |
| 24 | Due Date | Date | 17-28 | - | - |
| 25 | Payment Discount % | Decimal | 17-28 | - | - |
| 26 | Pmt. Discount Date | Date | 17-28 | - | - |
| 27 | Shipment Method Code | Code[10] | 17-28 | - | - |
| 28 | Location Code | Code[10] | 17-28 | - | - |
| 29 | Shortcut Dimension 1 Code | Code[20] | 17-28 | - | - |
| 30 | Shortcut Dimension 2 Code | Code[20] | 17-28 | - | - |
| 31 | Customer Posting Group | Code[20] | 17-28 | - | - |
| 32 | Currency Code | Code[10] | 17-28 | - | - |
| 33 | Currency Factor | Decimal | 17-28 | - | - |
| 34 | Customer Price Group | Code[10] | 17-28 | - | - |
| 35 | Prices Including VAT | Boolean | 17-28 | - | - |
| 37 | Invoice Disc. Code | Code[20] | 17-28 | - | - |
| 40 | Customer Disc. Group | Code[20] | 17-28 | - | - |
| 41 | Language Code | Code[10] | 17-28 | - | - |
| 42 | Format Region | Text[80] | 23-28 | - | - |
| 43 | Salesperson Code | Code[20] | 17-28 | - | - |
| 44 | Order No. | Code[20] | 17-28 | - | - |
| 46 | Comment | Boolean | 17-28 | - | - |
| 47 | No. Printed | Integer | 17-28 | - | - |
| 51 | On Hold | Code[3] | 17-28 | - | - |
| 52 | Applies-to Doc. Type | Enum Gen. Journal Document Type | 17-28 | - | - |
| 53 | Applies-to Doc. No. | Code[20] | 17-28 | - | - |
| 55 | Bal. Account No. | Code[20] | 17-28 | - | - |
| 60 | Amount | Decimal | 17-28 | - | - |
| 61 | Amount Including VAT | Decimal | 17-28 | - | - |
| 70 | VAT Registration No. | Text[20] | 17-28 | - | - |
| 72 | Registration Number | Text[50] | 24-28 | - | - |
| 73 | Reason Code | Code[10] | 17-28 | - | - |
| 74 | Gen. Bus. Posting Group | Code[20] | 17-28 | - | - |
| 75 | EU 3-Party Trade | Boolean | 17-28 | - | - |
| 76 | Transaction Type | Code[10] | 17-28 | - | - |
| 77 | Transport Method | Code[10] | 17-28 | - | - |
| 78 | VAT Country/Region Code | Code[10] | 17-28 | - | - |
| 79 | Sell-to Customer Name | Text[100] | 17-28 | - | - |
| 80 | Sell-to Customer Name 2 | Text[50] | 17-28 | - | - |
| 81 | Sell-to Address | Text[100] | 17-28 | - | - |
| 82 | Sell-to Address 2 | Text[50] | 17-28 | - | - |
| 83 | Sell-to City | Text[30] | 17-28 | - | - |
| 84 | Sell-to Contact | Text[100] | 17-28 | - | - |
| 85 | Bill-to Post Code | Code[20] | 17-28 | - | - |
| 86 | Bill-to County | Text[30] | 17-28 | - | - |
| 87 | Bill-to Country/Region Code | Code[10] | 17-28 | - | - |
| 88 | Sell-to Post Code | Code[20] | 17-28 | - | - |
| 89 | Sell-to County | Text[30] | 17-28 | - | - |
| 90 | Sell-to 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 | - | - |
| 94 | Bal. Account Type | Enum Payment Balance Account Type | 17-28 | - | - |
| 97 | Exit Point | Code[10] | 17-28 | - | - |
| 98 | Correction | Boolean | 17-28 | - | - |
| 99 | Document Date | Date | 17-28 | - | - |
| 100 | External Document No. | Code[35] | 17-28 | - | - |
| 101 | Area | Code[10] | 17-28 | - | - |
| 102 | Transaction Specification | Code[10] | 17-28 | - | - |
| 104 | Payment Method Code | Code[10] | 17-28 | - | - |
| 105 | Shipping Agent Code | Code[10] | 17-28 | - | - |
| 106 | Package Tracking No. | Text[50] | 17-28 | - | - |
| 107 | Pre-Assigned No. Series | Code[20] | 17-28 | - | - |
| 108 | No. Series | Code[20] | 17-28 | - | - |
| 110 | Order No. Series | Code[20] | 17-28 | - | - |
| 111 | Pre-Assigned No. | Code[20] | 17-28 | - | - |
| 112 | User ID | Code[50] | 17-28 | - | - |
| 113 | Source Code | Code[10] | 17-28 | - | - |
| 114 | Tax Area Code | Code[20] | 17-28 | - | - |
| 115 | Tax Liable | Boolean | 17-28 | - | - |
| 116 | VAT Bus. Posting Group | Code[20] | 17-28 | - | - |
| 119 | VAT Base Discount % | Decimal | 17-28 | - | - |
| 121 | Invoice Discount Calculation | Option | 17-28 | - | - |
| 122 | Invoice Discount Value | Decimal | 17-28 | - | - |
| 131 | Prepayment No. Series | Code[20] | 17-28 | - | - |
| 136 | Prepayment Invoice | Boolean | 17-28 | - | - |
| 137 | Prepayment Order No. | Code[20] | 17-28 | - | - |
| 151 | Quote No. | Code[20] | 17-28 | - | - |
| 163 | Company Bank Account Code | Code[20] | 20-28 | - | - |
| 166 | Alt. VAT Registration No. | Boolean | 17-23, 25-28 | - | - |
| 167 | Alt. Gen. Bus Posting Group | Boolean | 17-23, 25-28 | - | - |
| 168 | Alt. VAT Bus Posting Group | Boolean | 17-23, 25-28 | - | - |
| 169 | Last Email Notif Cleared | Boolean | 17-23 | Pending 21.0 | Microsoft Invoicing has been discontinued. |
| 171 | Sell-to Phone No. | Text[30] | 17-28 | - | - |
| 172 | Sell-to E-Mail | Text[80] | 17-28 | - | - |
| 176 | Payment Instructions | Blob | 17-25 | Removed 22.0 | Microsoft Invoicing is not supported in Business Central |
| 177 | Payment Instructions Name | Text[20] | 17-25 | Removed 22.0 | Microsoft Invoicing is not supported in Business Central |
| 179 | VAT Reporting Date | Date | 21-28 | - | - |
| 180 | Payment Reference | Code[50] | 17-28 | - | - |
| 185 | Last Email Sent Time | DateTime | 25-28 | - | - |
| 186 | Last Email Sent Message Id | Guid | 25-28 | - | - |
| 200 | Work Description | Blob | 17-28 | - | - |
| 210 | Ship-to Phone No. | Text[30] | 25-28 | - | - |
| 480 | Dimension Set ID | Integer | 17-28 | - | - |
| 600 | Payment Service Set ID | Integer | 17-28 | - | - |
| 710 | Document Exchange Identifier | Text[50] | 17-28 | - | - |
| 711 | Document Exchange Status | Enum Sales Document Exchange Status | 17-28 | - | - |
| 712 | Doc. Exch. Original Identifier | Text[50] | 17-28 | - | - |
| 720 | Coupled to CRM | Boolean | 17-28 | Removed 26.0 | Replaced by flow field Coupled to Dataverse |
| 721 | Coupled to Dataverse | Boolean | 22-28 | - | - |
| 1200 | Direct Debit Mandate ID | Code[35] | 17-28 | - | - |
| 1302 | Closed | Boolean | 17-28 | - | - |
| 1303 | Remaining Amount | Decimal | 17-28 | - | - |
| 1304 | Cust. Ledger Entry No. | Integer | 17-28 | - | - |
| 1305 | Invoice Discount Amount | Decimal | 17-28 | - | - |
| 1310 | Cancelled | Boolean | 17-28 | - | - |
| 1311 | Corrective | Boolean | 17-28 | - | - |
| 1312 | Reversed | Boolean | 17-28 | - | - |
| 1340 | Dispute Status | Code[10] | 24-28 | - | - |
| 1341 | Promised Pay Date | Date | 24-28 | - | - |
| 5050 | Campaign No. | Code[20] | 17-28 | - | - |
| 5052 | Sell-to Contact No. | Code[20] | 17-28 | - | - |
| 5053 | Bill-to Contact No. | Code[20] | 17-28 | - | - |
| 5055 | Opportunity No. | Code[20] | 17-28 | - | - |
| 5700 | Responsibility Center | Code[10] | 17-28 | - | - |
| 5794 | Shipping Agent Service Code | Code[10] | 25-28 | - | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | 17-28 | - | - |
| 7001 | Allow Line Disc. | Boolean | 17-28 | - | - |
| 7200 | Get Shipment Used | Boolean | 17-28 | - | - |
| 8000 | Id | Guid | 17-25 | Removed 22.0 | This functionality will be replaced by the systemID field |
| 8001 | Draft Invoice SystemId | Guid | 17-28 | - | - |
| 8010 | Dispute Status Id | Guid | 24-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | No. | 17-28 |
| Key2 | Order No. | 17-28 |
| Key3 | Pre-Assigned No. | 17-28 |
| Key4 | Sell-to Customer No., External Document No. | 17-28 |
| Key5 | Sell-to Customer No., Order Date | 17-28 |
| Key6 | Sell-to Customer No. | 17-28 |
| Key7 | Prepayment Order No., Prepayment Invoice | 17-28 |
| Key8 | Bill-to Customer No. | 17-28 |
| Key9 | Posting Date | 17-28 |
| Key10 | Document Exchange Status | 17-28 |
| Key11 | Due Date | 17-28 |
| Key12 | Salesperson Code | 17-28 |
| Key13 | SystemModifiedAt | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| IsFullyOpen | () | Boolean | public | 17-28 | - | - |
| SendRecords | () | - | public | 17-28 | - | - |
| SendProfile | (var Record Document Sending Profile) | - | public | 17-28 | - | - |
| PrintRecords | (Boolean) | - | public | 17-28 | - | - |
| PrintToDocumentAttachment | (var Record Sales Invoice Header) | - | public | 17-28 | - | - |
| EmailRecords | (Boolean) | - | public | 17-28 | - | - |
| GetDocTypeTxt | () | Text[50] | public | 17-28 | - | - |
| Navigate | () | - | public | 17-28 | - | - |
| LookupAdjmtValueEntries | () | - | public | 17-28 | - | - |
| GetCustomerVATRegistrationNumber | () | Text | public | 17-28 | - | - |
| GetCustomerVATRegistrationNumberLbl | () | Text | public | 17-28 | - | - |
| GetCustomerGlobalLocationNumber | () | Text | public | 17-28 | - | - |
| GetCustomerGlobalLocationNumberLbl | () | Text | public | 17-28 | - | - |
| GetSellToCustomerFaxNo | () | Text | public | 17-28 | - | - |
| GetPaymentReference | () | Text | public | 17-28 | - | - |
| GetPaymentReferenceLbl | () | Text | public | 17-28 | - | - |
| GetLegalStatement | () | Text | public | 17-28 | - | - |
| GetRemainingAmount | () | Decimal | public | 17-28 | - | - |
| ShowDimensions | () | - | public | 17-28 | - | - |
| SetSecurityFilterOnRespCenter | () | - | public | 17-28 | - | - |
| GetDocExchStatusStyle | () | Text | public | 17-28 | - | - |
| ShowActivityLog | () | - | public | 17-28 | - | - |
| StartTrackingSite | () | - | public | 17-28 | - | - |
| GetSelectedPaymentsText | () | Text | public | 17-28 | - | - |
| GetWorkDescription | () | Text | public | 17-28 | - | - |
| GetCurrencySymbol | () | Text[10] | public | 17-28 | - | - |
| DocExchangeStatusIsSent | () | Boolean | public | 17-28 | - | - |
| ShowCanceledOrCorrCrMemo | () | - | public | 17-28 | - | - |
| ShowCorrectiveCreditMemo | () | - | public | 17-28 | - | - |
| ShowCancelledCreditMemo | () | - | public | 17-28 | - | - |
| GetDefaultEmailDocumentName | () | Text[150] | public | 17-28 | - | - |
| CheckNoPrinted | () | - | public | 21-28 | - | - |
| UpdateDisputeStatus | () | - | public | 24-28 | - | - |
| UpdateDisputeStatusId | () | - | public | 24-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnBeforeEmailRecords | (var Record Report Selections, var Record Sales Invoice Header, Text, Boolean, var Boolean) | 17-21 | - | - |
| Integration event | OnBeforePrintRecords | (var Record Report Selections, var Record Sales Invoice Header, Boolean, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeSendProfile | (var Record Report Selections, var Record Sales Invoice Header, Text, var Boolean, var Record Document Sending Profile) | 17-28 | - | - |
| Integration event | OnBeforeSendRecords | (var Record Report Selections, var Record Sales Invoice Header, Text, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeShowCanceledOrCorrCrMemo | (var Record Sales Invoice Header, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeShowCorrectiveCreditMemo | (var Record Sales Invoice Header, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeShowCancelledCreditMemo | (var Record Sales Invoice Header, var Boolean) | 17-28 | - | - |
| Integration event | OnGetPaymentReference | (var Text) | 17-28 | - | - |
| Integration event | OnGetPaymentReferenceLbl | (var Text) | 17-28 | - | - |
| Integration event | OnLookupAppliesToDocNoOnAfterSetFilters | (var Record Cust. Ledger Entry, Record Sales Invoice Header) | 17-28 | - | - |
| Integration event | OnBeforeDoPrintToDocumentAttachment | (var Record Sales Invoice Header, var Boolean, var Boolean) | 19-28 | - | - |
| Integration event | OnBeforeSetSecurityFilterOnRespCenter | (var Record Sales Invoice Header, var Boolean) | 19-28 | - | - |
| Integration event | OnBeforeCheckNoPrinted | (var Record Sales Invoice Header, var Boolean) | 21-28 | - | - |
| Integration event | OnBeforeEmailRecords | (var Record Report Selections, var Record Sales Invoice Header, Text, var Boolean, var Boolean) | 22-28 | - | - |
| Integration event | OnPostedSalesInvoiceFullyOpen | (var Record Sales Invoice Header, var Boolean, var Boolean) | 22-28 | - | - |
| Integration event | OnBeforeGetWorkDescription | (var Record Sales Invoice Header) | 23-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.