BC Observatoryunofficial, made by waldo
tablePurchasing & Payablesofficial - Microsoftderived - from the source, no model text

Table 122 "Purch. Inv. Header"

Base Application · Microsoft.Purchases.History

Open in Claude122.mdSource on GitHub

Across versions

  1. BC23present
  2. BC241 fields changed
  3. BC251 fields added
  4. BC262 fields changed, 1 fields removed
  5. BC272 fields changed
  6. BC2869 fields changed, 2 fields added
  7. BC292 fields added
  8. BC30unchanged

Neighbourhood 81 connected objects and pages

Table 225 "Post Code" (relates to, 6 links)Post CodeTable 308 "No. Series" (relates to, 4 links)No. SeriesTable 9 "Country/Region" (relates to, 4 links)Table 123 "Purch. Inv. Line" (relates to, 3 links)Table 1900 "Cancelled Document" (relates to, 2 links)Cancelled DocumentTable 23 "Vendor" (relates to, 2 links)VendorTable 25 "Vendor Ledger Entry" (relates to, 2 links)Vendor Ledger EntryTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 5050 "Contact" (relates to, 2 links)Page 146 "Posted Purchase Invoices" (pages and codeunits on it, 3 links)Posted Purchase InvoicesCodeunit 1313 "Correct Posted Purch. Invoice" (pages and codeunits on it)Codeunit 1324 "Correct PstdPurchInv (Yes/No)" (pages and codeunits on it)Codeunit 1325 "Cancel PstdPurchInv (Yes/No)" (pages and codeunits on it)Codeunit 1405 "Purch. Inv. Header - Edit" (pages and codeunits on it)Codeunit 319 "Purch. Inv.-Printed" (pages and codeunits on it)Page 10001 "Overdue Purchase Invoices" (pages and codeunits on it)Page 1351 "Posted Purch. Invoice - Update" (pages and codeunits on it)Page 138 "Posted Purchase Invoice" (pages and codeunits on it)Page 400 "Purchase Invoice Statistics" (pages and codeunits on it)Page 9971 "Posted Purchase Invoice API" (pages and codeunits on it)Table extension 4883 "EU3 Purch. Inv. Header" (extended by)Table extension 5029 "Serv. Decl. Purch. Inv. Header" (extended by)Codeunit 5529 "Purch. Inv. Aggregator" (event subscribers, 4 links)Purch. Inv. AggregatorCodeunit 1173 "Document Attachment Mgmt" (event subscribers)Codeunit 8028 "Usage Based Contr. Subscribers" (event subscribers)Codeunit 364 "PostPurch-Delete" (calls, 2 links)PostPurch-DeletePage 140 "Posted Purchase Credit Memo" (calls, 2 links)Posted Purchase Credit MemoCodeunit 1535 "Approvals Mgmt." (calls)Codeunit 408 "DimensionManagement" (calls)Codeunit 5700 "User Setup Management" (calls)Table 1900 "Cancelled Document" (referenced by, 2 links)Cancelled DocumentTable 23 "Vendor" (referenced by, 2 links)VendorTable 38 "Purchase Header" (referenced by, 2 links)Purchase HeaderTable 6108 "E-Doc. Vendor Assign. History" (referenced by, 2 links)E-Doc. Vendor Assign. HistoryTable 9060 "SB Owner Cue" (referenced by, 2 links)Amend or cancel unpaid purchase invoices (Learn pages)Combine Receipts or PO Lines on a Single Invoice (Learn pages)Edit posted sales and purchase documents (Learn pages)Record purchases with purchase invoices (Learn pages)Record sustainability entries (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Purchases.History · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 138 “Posted Purchase Invoice” (4 Learn pages), Page 146 “Posted Purchase Invoices” (4).

Properties

Property Value
Caption Purch. Inv. Header
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
2 Buy-from Vendor No. Δ BC26 Code[20] Specifies the identifier of the vendor that you bought the items from. TableRelation Table 23 “Vendor”; NotBlank
3 No. Δ BC28 Code[20] Specifies the posted invoice number.
4 Pay-to Vendor No. Δ BC26 Code[20] Specifies the number of the vendor that you received the invoice from. TableRelation Table 23 “Vendor”; NotBlank
5 Pay-to Name Δ BC28 Text[100] Specifies the name of the vendor who you received the invoice from.
6 Pay-to Name 2 Δ BC27 Text[50] Specifies an additional part of the name of the vendor who you receive the invoice from.
7 Pay-to Address Δ BC28 Text[100] Specifies the address of the vendor that you received the invoice from.
8 Pay-to Address 2 Δ BC28 Text[50] Specifies additional address information.
9 Pay-to City Δ BC28 Text[30] Specifies the city of the vendor on the purchase document. TableRelation Table 225 “Post Code” (“Post Code”.City)
10 Pay-to Contact Δ BC28 Text[100] Specifies the name of the person you should contact at the vendor who you received the invoice from.
11 Your Reference Text[35] —
12 Ship-to Code Δ BC28 Code[10] Specifies the address on purchase orders shipped with a drop shipment directly from the vendor to a customer. TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Sell-to Customer No.”)))
13 Ship-to Name Δ BC28 Text[100] Specifies the name of the customer at the address that the items are shipped to.
14 Ship-to Name 2 Δ BC28 Text[50] Specifies an additional part of the name of the company at the address to which the items in the purchase order were shipped.
15 Ship-to Address Δ BC28 Text[100] Specifies the address that the items in the purchase order were shipped to.
16 Ship-to Address 2 Δ BC28 Text[50] Specifies additional address information.
17 Ship-to City Δ BC28 Text[30] Specifies the city of the vendor on the purchase document. TableRelation Table 225 “Post Code” (“Post Code”.City)
18 Ship-to Contact Δ BC28 Text[100] Specifies the name of a contact person at the address that the items in the purchase order were shipped to.
19 Order Date Date —
20 Posting Date Δ BC28 Date Specifies the date the purchase header was posted.
21 Expected Receipt Date Δ BC28 Date Specifies the date on which the invoiced items were expected.
22 Posting Description Δ BC28 Text[100] Specifies any text that is entered to accompany the posting, for example for information to auditors.
23 Payment Terms Code Δ BC28 Code[10] Specifies the code to use to find the payment terms that apply to the purchase header. TableRelation Table 3 “Payment Terms” (Payment Terms)
24 Due Date Δ BC28 Date Specifies when the invoice is due. The program calculates the date using the Payment Terms Code and Document Date fields on the purchase header.
25 Payment Discount % Δ BC28 Decimal Specifies the payment discount percent granted if payment is made on or before the date in the Pmt. Discount Date field.
26 Pmt. Discount Date Δ BC28 Date Specifies the date on which the amount in the entry must be paid for a payment discount to be granted.
27 Shipment Method Code Δ BC28 Code[10] Specifies the delivery conditions of the related shipment, such as free on board (FOB). TableRelation Table 10 “Shipment Method” (Shipment Method)
28 Location Code Δ BC28 Code[10] Specifies the code for the location where the items are registered. TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
29 Shortcut Dimension 1 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
30 Shortcut Dimension 2 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
31 Vendor Posting Group Δ BC28 Code[20] Specifies the vendor’s market type to link business transactions made for the vendor with the appropriate account in the general ledger. TableRelation Table 93 “Vendor Posting Group” (Vendor Posting Group); not editable
32 Currency Code Δ BC28 Code[10] Specifies the currency code used to calculate the amounts on the invoice. TableRelation Table 4 “Currency”; not editable
33 Currency Factor Δ BC28 Decimal —
35 Prices Including VAT Boolean —
37 Invoice Disc. Code Code[20] —
41 Language Code Code[10] — TableRelation Table 8 “Language”
42 Format Region Text[80] — TableRelation “Language Selection”.“Language Tag”
43 Purchaser Code Δ BC28 Code[20] Specifies which purchaser is assigned to the vendor. TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)
44 Order No. Δ BC28 Code[20] Specifies the number of the purchase order that this invoice was posted from.
46 Comment Boolean — FlowField: exist(“Purch. Comment Line” where(“Document Type” = const(“Posted Invoice”), “No.” = field(“No.”), “Document Line No.” = const(0))); not editable
47 No. Printed Δ BC28 Integer Specifies how many times the document has been printed. not editable
51 On Hold Code[3] —
52 Applies-to Doc. Type Enum “Gen. Journal Document Type” — enum Enum 6 “Gen. Journal Document Type”
53 Applies-to Doc. No. Code[20] —
55 Bal. Account No. Code[20] — TableRelation Table 15 “G/L Account”, Table 270 “Bank Account” (if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account”)
60 Amount Δ BC28 Decimal Specifies the total, in the currency of the invoice, of the amounts on all the invoice lines. FlowField: sum(“Purch. Inv. Line”.Amount where(“Document No.” = field(“No.”))); not editable
61 Amount Including VAT Δ BC28 Decimal Specifies the total of the amounts, including VAT, on all the lines on the document. FlowField: sum(“Purch. Inv. Line”.“Amount Including VAT” where(“Document No.” = field(“No.”))); not editable
66 Vendor Order No. Δ BC28 Code[35] Specifies the vendor’s order number.
68 Vendor Invoice No. Δ BC28 Code[35] Specifies the vendor’s own invoice number.
70 VAT Registration No. Text[20] —
72 Sell-to Customer No. Code[20] — TableRelation Table 18 “Customer”
73 Reason Code Code[10] — TableRelation Table 231 “Reason Code” (Reason Code)
74 Gen. Bus. Posting Group Code[20] — TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
76 Transaction Type Code[10] — TableRelation Table 258 “Transaction Type” (Transaction Type)
77 Transport Method Code[10] — TableRelation Table 259 “Transport Method” (Transport Method)
78 VAT Country/Region Code Code[10] — TableRelation Table 9 “Country/Region” (Country/Region)
79 Buy-from Vendor Name Δ BC28 Text[100] Specifies the name of the vendor who shipped the items.
80 Buy-from Vendor Name 2 Δ BC27 Text[50] Specifies an additional part of the name of the vendor that you’re buying from.
81 Buy-from Address Δ BC28 Text[100] Specifies the address of the vendor who shipped the items.
82 Buy-from Address 2 Δ BC28 Text[50] Specifies additional address information.
83 Buy-from City Δ BC28 Text[30] Specifies the city of the vendor on the purchase document. TableRelation Table 225 “Post Code” (“Post Code”.City)
84 Buy-from Contact Δ BC28 Text[100] Specifies the name of the contact person at the vendor who delivered the items.
85 Pay-to Post Code Δ BC28 Code[20] Specifies the post code of the vendor that you received the invoice from. TableRelation Table 225 “Post Code” (Post Code)
86 Pay-to County Δ BC28 Text[30] Specifies the state, province or county as a part of the address.
87 Pay-to Country/Region Code Δ BC28 Code[10] Specifies the country or region of the ship-to address. TableRelation Table 9 “Country/Region” (Country/Region)
88 Buy-from Post Code Δ BC28 Code[20] Specifies the post code of the vendor who delivered the items. TableRelation Table 225 “Post Code” (Post Code)
89 Buy-from County Δ BC28 Text[30] Specifies the state, province or county as a part of the address.
90 Buy-from Country/Region Code Δ BC28 Code[10] Specifies the country or region of the ship-to address. TableRelation Table 9 “Country/Region” (Country/Region)
91 Ship-to Post Code Δ BC28 Code[20] Specifies the postal code of the address that the items are shipped to. TableRelation Table 225 “Post Code” (Post Code)
92 Ship-to County Δ BC28 Text[30] Specifies the state, province or county as a part of the address.
93 Ship-to Country/Region Code Δ BC28 Code[10] Specifies the country or region of the ship-to address. TableRelation Table 9 “Country/Region” (Country/Region)
94 Bal. Account Type enum “Payment Balance Account Type” — enum Enum 96 “Payment Balance Account Type”
95 Order Address Code Δ BC28 Code[10] Specifies the order address of the related vendor. TableRelation Table 224 “Order Address” (“Order Address”.Code where(“Vendor No.” = field(“Buy-from Vendor No.”)))
97 Entry Point Code[10] — TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
98 Correction Boolean —
99 Document Date Δ BC28 Date Specifies the date on which the purchase document was created.
101 Area Code[10] — TableRelation Table 284 “Area”
102 Transaction Specification Code[10] — TableRelation Table 285 “Transaction Specification” (Transaction Specification)
104 Payment Method Code Δ BC28 Code[10] Specifies how to make payment, such as with bank transfer, cash, or check. TableRelation Table 289 “Payment Method” (Payment Method)
107 Pre-Assigned No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
108 No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series); not editable
110 Order No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
111 Pre-Assigned No. Δ BC28 Code[20] Specifies the number of the purchase document that the posted invoice was created for.
112 User ID Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
113 Source Code Code[10] — TableRelation Table 230 “Source Code” (Source Code)
114 Tax Area Code Δ BC28 Code[20] Specifies the tax area that is used to calculate and post sales tax. TableRelation Table 318 “Tax Area” (Tax Area)
115 Tax Liable Δ BC28 Boolean Specifies if the customer or vendor is liable for sales tax.
116 VAT Bus. Posting Group Code[20] — TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
119 VAT Base Discount % Δ BC28 Decimal —
135 Prepayment No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
140 Prepayment Invoice Boolean —
141 Prepayment Order No. Code[20] —
146 Spend Request No. + BC29 Code[20] Specifies the spend request that this purchase document relates to. TableRelation Table 6840 “Spend Request” (Spend Request)
147 Spend Request Close + BC29 Boolean Specifies that the spend request will be closed when the purchase document is posted.
151 Quote No. Δ BC28 Code[20] Specifies the number of the purchase quote document if a quote was used to start the purchase process. not editable
170 Creditor No. Δ BC28 Code[20] Specifies the number of the vendor.
171 Payment Reference Δ BC28 Code[50] Specifies the payment of the purchase invoice.
179 VAT Reporting Date Δ BC28 Date Specifies the VAT date on the invoice. not editable
180 Self-Billing Invoice + BC28 Boolean —
210 Ship-to Phone No. + BC25 Δ BC28 Text[30] Specifies the telephone number of the company’s shipping address.
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
1000 Remit-to Code Δ BC28 Code[20] Specifies the code for the vendor’s remit address for this invoice. TableRelation Table 2224 “Remit Address” (“Remit Address”.Code where(“Vendor No.” = field(“Buy-from Vendor No.”))); not editable
1302 Closed Δ BC24 Δ BC28 Boolean Specifies if the posted purchase invoice is paid. The check box will also be selected if a credit memo for the remaining amount has been applied. FlowField: - exist(“Vendor Ledger Entry” where(“Entry No.” = field(“Vendor Ledger Entry No.”), Open = filter(true))); not editable
1303 Remaining Amount Δ BC28 Decimal Specifies the remaining amount of the invoice. FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Vendor Ledger Entry No.” = field(“Vendor Ledger Entry No.”))); not editable
1304 Vendor Ledger Entry No. Integer — TableRelation Table 25 “Vendor Ledger Entry” (“Vendor Ledger Entry”.“Entry No.”); not editable
1305 Invoice Discount Amount Δ BC28 Decimal — FlowField: sum(“Purch. Inv. Line”.“Inv. Discount Amount” where(“Document No.” = field(“No.”))); not editable
1310 Cancelled Δ BC28 Boolean Specifies if the posted purchase invoice has been either corrected or canceled. FlowField: exist(“Cancelled Document” where(“Source ID” = const(122), “Cancelled Doc. No.” = field(“No.”))); not editable
1311 Corrective Δ BC28 Boolean Specifies if the posted purchase invoice is a corrective document. FlowField: exist(“Cancelled Document” where(“Source ID” = const(124), “Cancelled By Doc. No.” = field(“No.”))); not editable
1340 Dispute Status + BC28 Code[10] Specifies if there is an ongoing dispute for this document. TableRelation Table 142 “Dispute Status” (Dispute Status)
5050 Campaign No. Code[20] — TableRelation Table 5071 “Campaign”
5052 Buy-from Contact No. Δ BC28 Code[20] Specifies the number of the contact you bought the items from. TableRelation Table 5050 “Contact”
5053 Pay-to Contact No. Δ BC28 Code[20] Specifies the number of the contact you received the invoice from. TableRelation Table 5050 “Contact”
5700 Responsibility Center Δ BC28 Code[10] Specifies the code for the responsibility center that serves the vendor on this purchase document. TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
7000 Price Calculation Method Enum “Price Calculation Method” — enum Enum 7000 “Price Calculation Method”
8001 Draft Invoice SystemId Guid — DataClassification SystemMetadata

Keys

  • Key1: No. (clustered)
  • Key2: Order No.
  • Key3: Pre-Assigned No.
  • Key4: Vendor Invoice No., Posting Date
  • Key5: Buy-from Vendor No.
  • Key6: Prepayment Order No., Prepayment Invoice
  • Key7: Pay-to Vendor No.
  • Key8: Posting Date
  • Key9: Due Date

Events published

  • OnBeforePrintRecords(var PurchInvHeader: Record "Purch. Inv. Header"; ShowRequestPage: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeShowCanceledOrCorrCrMemo(var PurchInvHeader: Record "Purch. Inv. Header"; var IsHandled: Boolean) (integration)
  • OnBeforeDoPrintToDocumentAttachment(var PurchInvHeaderLocal: Record "Purch. Inv. Header"; var IsHandled: Boolean) (integration)
  • OnLookupAppliesToDocNoOnAfterSetFilters(var VendLedgEntry: Record "Vendor Ledger Entry"; PurchInvHeader: Record "Purch. Inv. Header") (integration)
  • OnBeforeSetSecurityFilterOnRespCenter(var PurchInvHeader: Record "Purch. Inv. Header"; var IsHandled: Boolean) (integration)
  • OnBeforCheckIfPurchaseInvoiceFullyOpen(var PurchInvHeader: Record "Purch. Inv. Header"; var FullyOpen: Boolean; var IsHandled: Boolean) (integration)

Trigger event subscribers

Procedures

  • IsFullyOpen(): Boolean
  • PrintRecords(ShowRequestPage: Boolean)
  • PrintToDocumentAttachment(var PurchInvHeaderLocal: Record "Purch. Inv. Header")
  • Navigate()
  • ShowDimensions()
  • SetSecurityFilterOnRespCenter()
  • ShowCanceledOrCorrCrMemo()
  • ShowCorrectiveCreditMemo()
  • ShowCancelledCreditMemo()

Plus 1 local procedures.

Triggers

OnDelete

Relations

Referenced by

16 fields in 11 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Countries that replace it

AT, AU, BE, CA, CH, DE, ES, FI, IT, MX, NL, NO, NZ, RU, SE, US

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Purch. Inv. Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources