tablePurchasing & Payablesofficial - Microsoftderived - from the source, no model text

Table 5109 "Purchase Header Archive"

Base Application · Microsoft.Purchases.Archive

Across versions

  1. BC23present
  2. BC241 fields added
  3. BC251 fields added
  4. BC26unchanged
  5. BC272 fields changed
  6. BC2887 fields changed
  7. BC292 fields added
  8. BC30unchanged

Neighbourhood 65 connected objects and pages

Table 225 "Post Code" (relates to, 6 links)Post CodeTable 308 "No. Series" (relates to, 6 links)No. SeriesTable 9 "Country/Region" (relates to, 4 links)Table 5110 "Purchase Line Archive" (relates to, 3 links)Table 112 "Sales Invoice Header" (relates to, 2 links)Sales Invoice HeaderTable 14 "Location" (relates to, 2 links)LocationTable 23 "Vendor" (relates to, 2 links)Table 3 "Payment Terms" (relates to, 2 links)Payment TermsTable 349 "Dimension Value" (relates to, 2 links)Table 38 "Purchase Header" (relates to, 2 links)Purchase HeaderTable 413 "IC Partner" (relates to, 2 links)Table 5050 "Contact" (relates to, 2 links)ContactTable 10 "Shipment Method" (relates to)Shipment MethodTable 120 "Purch. Rcpt. Header" (relates to)Table 122 "Purch. Inv. Header" (relates to)Purch. Inv. HeaderTable 13 "Salesperson/Purchaser" (relates to)Table 130 "Incoming Document" (relates to)Incoming DocumentTable 15 "G/L Account" (relates to)G/L AccountPage 5166 "Purchase List Archive" (pages and codeunits on it, 3 links)Purchase List ArchiveCodeunit 321 "Purch.HeaderArch-Printed" (pages and codeunits on it)Page 30216 "APIV2 - Purch. Qt. Archives" (pages and codeunits on it)APIV2 - Purch. Qt. ArchivesPage 30218 "APIV2 - Purch. Ord. Archives" (pages and codeunits on it)Page 30222 "APIV2 - P. Ret. Ord. Archives" (pages and codeunits on it)Page 30230 "APIV2 - P. Bl. Ord. Archives" (pages and codeunits on it)Page 5164 "Purchase Quote Archive" (pages and codeunits on it)Page 5167 "Purchase Order Archive" (pages and codeunits on it)Page 6623 "Blanket Purchase Order Archive" (pages and codeunits on it)Page 6625 "Blanket Purch. Order Archives" (pages and codeunits on it)Page 6644 "Purchase Return Order Archive" (pages and codeunits on it)Page 6646 "Purchase Return List Archive" (pages and codeunits on it)Page 9346 "Purchase Quote Archives" (pages and codeunits on it)Page 9347 "Purchase Order Archives" (pages and codeunits on it)Table extension 20511 "Subc. Purchase Header Arch" (extended by)Table extension 6803 "WHT Purchase Header Archive" (extended by)Codeunit 408 "DimensionManagement" (calls)Codeunit 5700 "User Setup Management" (calls)Table 23 "Vendor" (referenced by, 2 links)VendorTable 38 "Purchase Header" (referenced by)Archive sales, purchase, project, and service documents (Learn pages)Create a purchase quote to request an offer (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.Archive · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 9346 “Purchase Quote Archives” (2 Learn pages), Page 5164 “Purchase Quote Archive” (1), Page 5167 “Purchase Order Archive” (1), Page 6623 “Blanket Purchase Order Archive” (1), Page 6644 “Purchase Return Order Archive” (1), Page 9347 “Purchase Order Archives” (1).

Properties

Property Value
Caption Purchase Header Archive
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
1 Document Type Enum “Purchase Document Type” — enum Enum 38 “Purchase Document Type”
2 Buy-from Vendor No. Δ BC28 Code[20] Specifies the name of the vendor who delivered the items. TableRelation Table 23 “Vendor”
3 No. Δ BC28 Code[20] Specifies the number of the involved entry or record, according to the specified number series.
4 Pay-to Vendor No. Δ BC28 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 or credit memo 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 an additional part of the address of the vendor that the invoice was received from.
9 Pay-to City Δ BC28 Text[30] Specifies the city of the vendor that you received the invoice from. TableRelation Table 225 “Post Code” (“Post Code”.City)
10 Pay-to Contact Δ BC28 Text[100] Specifies the name of the person to contact about an invoice from this vendor.
11 Your Reference Text[35] —
12 Ship-to Code Δ BC28 Code[10] Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment.
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 customer at the address that the items are shipped to.
15 Ship-to Address Δ BC28 Text[100] Specifies the address that the items are shipped to.
16 Ship-to Address 2 Δ BC28 Text[50] Specifies an additional part of the ship-to address, in case it is a long address.
17 Ship-to City Δ BC28 Text[30] Specifies the city of the address that the items are shipped to. TableRelation Table 225 “Post Code” (“Post Code”.City)
18 Ship-to Contact Δ BC28 Text[100] Specifies the name of the contact person at the address that the items are shipped to.
19 Order Date Δ BC28 Date Specifies the date when the order was created.
20 Posting Date Δ BC28 Date Specifies the entry’s posting date.
21 Expected Receipt Date Δ BC28 Date Specifies the date on which the invoiced items were expected.
22 Posting Description Text[100] —
23 Payment Terms Code Δ BC28 Code[10] Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. TableRelation Table 3 “Payment Terms” (Payment Terms)
24 Due Date Δ BC28 Date Specifies when the related purchase invoice must be paid.
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 location where the items are to be placed when they are received. This field acts as the default location for new lines. Location code for individual lines can differ from it. 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 Code[20] — TableRelation Table 93 “Vendor Posting Group” (Vendor Posting Group)
32 Currency Code Δ BC28 Code[10] Specifies the currency that is used on the entry. TableRelation Table 4 “Currency”
33 Currency Factor Δ BC28 Decimal —
35 Prices Including VAT Δ BC28 Boolean Specifies if the Unit Price and Line Amount fields on document lines should be shown with or without VAT.
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)
45 Order Class Code[10] —
46 Comment Boolean — FlowField: exist(“Purch. Comment Line Archive” where(“Document Type” = field(“Document Type”), “No.” = field(“No.”), “Document Line No.” = const(0), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable
47 No. Printed Integer —
51 On Hold Δ BC28 Code[3] Specifies that the related entry represents an unpaid invoice for which either a payment suggestion, a reminder, or a finance charge memo exists.
52 Applies-to Doc. Type Δ BC28 Enum “Gen. Journal Document Type” Specifies the type of the posted document that this document or journal line will be applied to when you post, for example to register payment. enum Enum 6 “Gen. Journal Document Type”
53 Applies-to Doc. No. Δ BC28 Code[20] Specifies the number of the posted document that this document or journal line will be applied to when you post, for example to register payment.
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”)
57 Receive Boolean —
58 Invoice Boolean —
60 Amount Δ BC28 Decimal Specifies the total amount for the archived purchase document. FlowField: sum(“Purchase Line Archive”.Amount where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”)))
61 Amount Including VAT Δ BC28 Decimal Specifies the total amount including VAT for the archived purchase document. FlowField: sum(“Purchase Line Archive”.“Amount Including VAT” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable
62 Receiving No. Code[20] —
63 Posting No. Code[20] —
64 Last Receiving No. Code[20] — TableRelation Table 120 “Purch. Rcpt. Header” (Purch. Rcpt. Header)
65 Last Posting No. Code[20] — TableRelation Table 122 “Purch. Inv. Header” (Purch. Inv. Header)
66 Vendor Order No. Δ BC28 Code[35] Specifies the vendor’s order number.
67 Vendor Shipment No. Δ BC28 Code[35] Specifies the vendor’s shipment number. It is inserted in the corresponding field on the source document during posting.
68 Vendor Invoice No. Δ BC28 Code[35] Specifies the document number of the original document you received from the vendor. You can require the document number for posting, or let it be optional. By default, it’s required, so that this document references the original. Making document numbers optional removes a step from the posting proc…
69 Vendor Cr. Memo No. Δ BC28 Code[35] Specifies the number that the vendor uses for the credit memo you are creating in this purchase return order.
70 VAT Registration No. Text[20] —
72 Sell-to Customer No. Δ BC28 Code[20] Specifies the number of the customer. 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 Δ BC28 Code[10] Specifies the type of transaction that the document represents, for the purpose of reporting to INTRASTAT. TableRelation Table 258 “Transaction Type” (Transaction Type)
77 Transport Method Δ BC28 Code[10] Specifies the transport method, for the purpose of reporting to INTRASTAT. 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 delivered 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 delivered the items.
82 Buy-from Address 2 Δ BC28 Text[50] Specifies an additional part of the address of the vendor who delivered the items.
83 Buy-from City Δ BC28 Text[30] Specifies the city of the vendor who delivered the items. 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 county of the vendor on the purchase document.
87 Pay-to Country/Region Code Δ BC28 Code[10] Specifies the country/region code of the 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 county of your vendor.
90 Buy-from Country/Region Code Δ BC28 Code[10] Specifies the city of the vendor who delivered the items. 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 county of the ship-to address.
93 Ship-to Country/Region Code Δ BC28 Code[10] Specifies the country/region code of the address that the items are shipped to. 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 Δ BC28 Code[10] Specifies the code of the port of entry where the items pass into your country/region, for reporting to Intrastat. TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
98 Correction Boolean —
99 Document Date Δ BC28 Date Specifies the date when the related document was created.
101 Area Δ BC28 Code[10] Specifies the destination country or region for the purpose of Intrastat reporting. TableRelation Table 284 “Area”
102 Transaction Specification Δ BC28 Code[10] Specifies a specification of the document’s transaction, for the purpose of reporting to INTRASTAT. 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 No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
108 Posting No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
109 Receiving No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
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 this vendor charges you sales tax for purchases.
116 VAT Bus. Posting Group Δ BC28 Code[20] Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
118 Applies-to ID Δ BC28 Code[50] Specifies the ID of entries that will be applied to when you choose the Apply Entries action.
119 VAT Base Discount % Δ BC28 Decimal —
120 Status Δ BC28 Enum “Purchase Document Status” Specifies whether the record is open, waiting to be approved, invoiced for prepayment, or released to the next stage of processing. enum Enum 3812 “Purchase Document Status”
121 Invoice Discount Calculation Option — OptionCaption: None,%,Amount
122 Invoice Discount Value Δ BC28 Decimal —
123 Send IC Document Boolean —
124 IC Status Enum “Purchase Document IC Status” — enum Enum 125 “Purchase Document IC Status”
125 Buy-from IC Partner Code Code[20] — TableRelation Table 413 “IC Partner” (IC Partner); not editable
126 Pay-to IC Partner Code Code[20] — TableRelation Table 413 “IC Partner” (IC Partner); not editable
127 IC Reference Document No. Code[20] — not editable
129 IC Direction Enum “IC Direction Type” — enum Enum 129 “IC Direction Type”
130 Prepayment No. Code[20] —
131 Last Prepayment No. Code[20] — TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header)
132 Prepmt. Cr. Memo No. Code[20] —
133 Last Prepmt. Cr. Memo No. Code[20] — TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header)
134 Prepayment % Δ BC28 Decimal —
135 Prepayment No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
136 Compress Prepayment Boolean —
137 Prepayment Due Date Date —
138 Prepmt. Cr. Memo No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
139 Prepmt. Posting Description Text[100] —
142 Prepmt. Pmt. Discount Date Date —
143 Prepmt. Payment Terms Code Code[10] — TableRelation Table 3 “Payment Terms” (Payment Terms)
144 Prepmt. Payment Discount % Δ BC28 Decimal —
145 No. of Archived Versions Integer — FlowField: max(“Purchase Header Archive”.“Version No.” where(“Document Type” = field(“Document Type”), “No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”))); not editable
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 Purchase Quote No. Code[20] — TableRelation Table 38 “Purchase Header” (“Purchase Header”.“No.” where(“Document Type” = const(Quote), “No.” = field(“Purchase Quote No.”))); not editable
165 Incoming Document Entry No. + BC24 Integer — TableRelation Table 130 “Incoming Document” (Incoming Document)
179 VAT Reporting Date Δ BC28 Date Specifies the entry’s VAT date.
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
3998 Source Doc. Exists Boolean — FlowField: exist(“Purchase Header” where(“Document Type” = field(“Document Type”), “No.” = field(“No.”))); not editable
3999 Last Archived Date DateTime — FlowField: max(“Purchase Header Archive”.SystemCreatedAt where(“Document Type” = field(“Document Type”), “No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”))); not editable
5043 Interaction Exist Δ BC28 Boolean Specifies that the archived document is linked to an interaction log entry.
5044 Time Archived Δ BC28 Time Specifies what time the document was archived.
5045 Date Archived Δ BC28 Date Specifies the date when the document was archived.
5046 Archived By Δ BC28 Code[50] Specifies the user ID of the person who archived this document. TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
5047 Version No. Δ BC28 Integer Specifies the version number of the archived document.
5048 Doc. No. Occurrence Integer —
5050 Campaign No. Code[20] — TableRelation Table 5071 “Campaign”
5052 Buy-from Contact No. Δ BC28 Code[20] Specifies the number of the contact person at the vendor who delivered the items. TableRelation Table 5050 “Contact”
5053 Pay-to Contact No. Δ BC28 Code[20] Specifies the number of the person to contact about an invoice from this vendor. TableRelation Table 5050 “Contact”
5700 Responsibility Center Δ BC28 Code[10] Specifies the code of the responsibility center, such as a distribution hub, that is associated with the involved user, company, customer, or vendor. TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5752 Completely Received Boolean — FlowField: min(“Purchase Line Archive”.“Completely Received” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”), “Expected Receipt Date” = field(“Date Filter”), “Location Code” = field(“Locati…; not editable
5753 Posting from Whse. Ref. Integer —
5754 Location Filter Code[10] — TableRelation Table 14 “Location”; FlowFilter
5790 Requested Receipt Date Δ BC28 Date Specifies the date you want the vendor to deliver your order.
5791 Promised Receipt Date Δ BC28 Date Specifies the date that the vendor has promised to deliver the order.
5792 Lead Time Calculation Δ BC28 DateFormula Specifies a date formula for the amount of time it takes to replenish the item.
5793 Inbound Whse. Handling Time Δ BC28 DateFormula Specifies the time it takes to make items part of available inventory, after the items have been posted as received.
5796 Date Filter Date — FlowFilter
5800 Vendor Authorization No. Δ BC28 Code[35] Specifies information about sales quotes, purchase quotes, or orders in earlier versions of the document.
5801 Return Shipment No. Code[20] —
5802 Return Shipment No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
5803 Ship Boolean —
5804 Last Return Shipment No. Code[20] — TableRelation Table 6650 “Return Shipment Header” (Return Shipment Header)
7000 Price Calculation Method Enum “Price Calculation Method” — enum Enum 7000 “Price Calculation Method”
9000 Assigned User ID Δ BC28 Code[50] Specifies the ID of the user who is responsible for the document. TableRelation Table 91 “User Setup” (User Setup); DataClassification EndUserIdentifiableInformation

Keys

  • Key1: Document Type, No., Doc. No. Occurrence, Version No. (clustered)
  • Key2: Document Type, Buy-from Vendor No.
  • Key3: Document Type, Pay-to Vendor No.
  • Key4: Incoming Document Entry No.

Events published

  • OnBeforeSetSecurityFilterOnRespCenter(var PurchaseHeaderArchive: Record "Purchase Header Archive"; var IsHandled: Boolean) (integration)

Procedures

  • ShowDimensions()
  • SetSecurityFilterOnRespCenter()

Triggers

OnDelete

Relations

Referenced by

6 fields in 4 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, IT, MX, NZ, RU, 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: "Purchase Header Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources