Table "Purchase Header Archive"
Properties
| Name | Value |
|---|---|
| Caption | Purchase Header Archive |
| DataCaptionFields | 3,79,5047 |
| DrillDownPageID | Page Microsoft.Purchases.Archive."Purchase List Archive" |
| LookupPageID | Page Microsoft.Purchases.Archive."Purchase List Archive" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Document Type" | Enum Microsoft.Purchases.Document."Purchase Document Type" | |
| "Buy-from Vendor No." | Code[20] | Specifies the name of the vendor who delivered the items. |
| "No." | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. |
| "Pay-to Vendor No." | Code[20] | Specifies the number of the vendor that you received the invoice from. |
| "Pay-to Name" | Text[100] | Specifies the name of the vendor who you received the invoice from. |
| "Pay-to Name 2" | Text[50] | Specifies an additional part of the name of the vendor who you receive the invoice or credit memo from. |
| "Pay-to Address" | Text[100] | Specifies the address of the vendor that you received the invoice from. |
| "Pay-to Address 2" | Text[50] | Specifies an additional part of the address of the vendor that the invoice was received from. |
| "Pay-to City" | Text[30] | Specifies the city of the vendor that you received the invoice from. |
| "Pay-to Contact" | Text[100] | Specifies the name of the person to contact about an invoice from this vendor. |
| "Your Reference" | Text[35] | |
| "Ship-to Code" | 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. |
| "Ship-to Name" | Text[100] | Specifies the name of the customer at the address that the items are shipped to. |
| "Ship-to Name 2" | Text[50] | Specifies an additional part of the name of the customer at the address that the items are shipped to. |
| "Ship-to Address" | Text[100] | Specifies the address that the items are shipped to. |
| "Ship-to Address 2" | Text[50] | Specifies an additional part of the ship-to address, in case it is a long address. |
| "Ship-to City" | Text[30] | Specifies the city of the address that the items are shipped to. |
| "Ship-to Contact" | Text[100] | Specifies the name of the contact person at the address that the items are shipped to. |
| "Order Date" | Date | Specifies the date when the order was created. |
| "Posting Date" | Date | Specifies the entry's posting date. |
| "Expected Receipt Date" | Date | Specifies the date on which the invoiced items were expected. |
| "Posting Description" | Text[100] | |
| "Payment Terms Code" | Code[10] | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. |
| "Due Date" | Date | Specifies when the related purchase invoice must be paid. |
| "Payment Discount %" | Decimal | Specifies the payment discount percent granted if payment is made on or before the date in the Pmt. Discount Date field. |
| "Pmt. Discount Date" | Date | Specifies the date on which the amount in the entry must be paid for a payment discount to be granted. |
| "Shipment Method Code" | Code[10] | Specifies the delivery conditions of the related shipment, such as free on board (FOB). |
| "Location Code" | 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. |
| "Shortcut Dimension 1 Code" | 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. |
| "Shortcut Dimension 2 Code" | 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. |
| "Vendor Posting Group" | Code[20] | |
| "Currency Code" | Code[10] | Specifies the currency that is used on the entry. |
| "Currency Factor" | Decimal | |
| "Prices Including VAT" | Boolean | Specifies if the Unit Price and Line Amount fields on document lines should be shown with or without VAT. |
| "Invoice Disc. Code" | Code[20] | |
| "Language Code" | Code[10] | |
| "Format Region" | Text[80] | |
| "Purchaser Code" | Code[20] | Specifies which purchaser is assigned to the vendor. |
| "Order Class" | Code[10] | |
| Comment | Boolean | |
| "No. Printed" | Integer | |
| "On Hold" | 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. |
| "Applies-to Doc. Type" | Enum Microsoft.Finance.GeneralLedger.Journal."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. |
| "Applies-to Doc. No." | 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. |
| "Bal. Account No." | Code[20] | |
| Receive | Boolean | |
| Invoice | Boolean | |
| Amount | Decimal | Specifies the total amount for the archived purchase document. |
| "Amount Including VAT" | Decimal | Specifies the total amount including VAT for the archived purchase document. |
| "Receiving No." | Code[20] | |
| "Posting No." | Code[20] | |
| "Last Receiving No." | Code[20] | |
| "Last Posting No." | Code[20] | |
| "Vendor Order No." | Code[35] | Specifies the vendor's order number. |
| "Vendor Shipment No." | Code[35] | Specifies the vendor's shipment number. It is inserted in the corresponding field on the source document during posting. |
| "Vendor Invoice No." | 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 process. For example, if you attach the original invoice as a PDF, you might not need to enter the document number. To specify whether document numbers are required, in the Purchases & Payables Setup window, select or clear the Ext. Doc. No. Mandatory field. |
| "Vendor Cr. Memo No." | Code[35] | Specifies the number that the vendor uses for the credit memo you are creating in this purchase return order. |
| "VAT Registration No." | Text[20] | |
| "Sell-to Customer No." | Code[20] | Specifies the number of the customer. |
| "Reason Code" | Code[10] | |
| "Gen. Bus. Posting Group" | Code[20] | |
| "Transaction Type" | Code[10] | Specifies the type of transaction that the document represents, for the purpose of reporting to INTRASTAT. |
| "Transport Method" | Code[10] | Specifies the transport method, for the purpose of reporting to INTRASTAT. |
| "VAT Country/Region Code" | Code[10] | |
| "Buy-from Vendor Name" | Text[100] | Specifies the name of the vendor who delivered the items. |
| "Buy-from Vendor Name 2" | Text[50] | Specifies an additional part of the name of the vendor that you’re buying from. |
| "Buy-from Address" | Text[100] | Specifies the address of the vendor who delivered the items. |
| "Buy-from Address 2" | Text[50] | Specifies an additional part of the address of the vendor who delivered the items. |
| "Buy-from City" | Text[30] | Specifies the city of the vendor who delivered the items. |
| "Buy-from Contact" | Text[100] | Specifies the name of the contact person at the vendor who delivered the items. |
| "Pay-to Post Code" | Code[20] | Specifies the post code of the vendor that you received the invoice from. |
| "Pay-to County" | Text[30] | Specifies the county of the vendor on the purchase document. |
| "Pay-to Country/Region Code" | Code[10] | Specifies the country/region code of the address. |
| "Buy-from Post Code" | Code[20] | Specifies the post code of the vendor who delivered the items. |
| "Buy-from County" | Text[30] | Specifies the county of your vendor. |
| "Buy-from Country/Region Code" | Code[10] | Specifies the city of the vendor who delivered the items. |
| "Ship-to Post Code" | Code[20] | Specifies the postal code of the address that the items are shipped to. |
| "Ship-to County" | Text[30] | Specifies the county of the ship-to address. |
| "Ship-to Country/Region Code" | Code[10] | Specifies the country/region code of the address that the items are shipped to. |
| "Bal. Account Type" | Enum Microsoft.Bank.Payment."Payment Balance Account Type" | |
| "Order Address Code" | Code[10] | Specifies the order address of the related vendor. |
| "Entry Point" | Code[10] | Specifies the code of the port of entry where the items pass into your country/region, for reporting to Intrastat. |
| Correction | Boolean | |
| "Document Date" | Date | Specifies the date when the related document was created. |
| "Area" | Code[10] | Specifies the destination country or region for the purpose of Intrastat reporting. |
| "Transaction Specification" | Code[10] | Specifies a specification of the document's transaction, for the purpose of reporting to INTRASTAT. |
| "Payment Method Code" | Code[10] | Specifies how to make payment, such as with bank transfer, cash, or check. |
| "No. Series" | Code[20] | |
| "Posting No. Series" | Code[20] | |
| "Receiving No. Series" | Code[20] | |
| "Tax Area Code" | Code[20] | Specifies the tax area that is used to calculate and post sales tax. |
| "Tax Liable" | Boolean | Specifies if this vendor charges you sales tax for purchases. |
| "VAT Bus. Posting Group" | 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. |
| "Applies-to ID" | Code[50] | Specifies the ID of entries that will be applied to when you choose the Apply Entries action. |
| "VAT Base Discount %" | Decimal | |
| Status | Enum Microsoft.Purchases.Document."Purchase Document Status" | Specifies whether the record is open, waiting to be approved, invoiced for prepayment, or released to the next stage of processing. |
| "Invoice Discount Calculation" | Option | |
| "Invoice Discount Value" | Decimal | |
| "Send IC Document" | Boolean | |
| "IC Status" | Enum Microsoft.Intercompany.Setup."Purchase Document IC Status" | |
| "Buy-from IC Partner Code" | Code[20] | |
| "Pay-to IC Partner Code" | Code[20] | |
| "IC Reference Document No." | Code[20] | |
| "IC Direction" | Enum Microsoft.Intercompany.Setup."IC Direction Type" | |
| "Prepayment No." | Code[20] | |
| "Last Prepayment No." | Code[20] | |
| "Prepmt. Cr. Memo No." | Code[20] | |
| "Last Prepmt. Cr. Memo No." | Code[20] | |
| "Prepayment %" | Decimal | |
| "Prepayment No. Series" | Code[20] | |
| "Compress Prepayment" | Boolean | |
| "Prepayment Due Date" | Date | |
| "Prepmt. Cr. Memo No. Series" | Code[20] | |
| "Prepmt. Posting Description" | Text[100] | |
| "Prepmt. Pmt. Discount Date" | Date | |
| "Prepmt. Payment Terms Code" | Code[10] | |
| "Prepmt. Payment Discount %" | Decimal | |
| "No. of Archived Versions" | Integer | |
| "Spend Request No." | Code[20] | Specifies the spend request that this purchase document relates to. |
| "Spend Request Close" | Boolean | Specifies that the spend request will be closed when the purchase document is posted. |
| "Purchase Quote No." | Code[20] | |
| "Incoming Document Entry No." | Integer | |
| "VAT Reporting Date" | Date | Specifies the entry's VAT date. |
| "Ship-to Phone No." | Text[30] | Specifies the telephone number of the company's shipping address. |
| "Dimension Set ID" | Integer | |
| "Source Doc. Exists" | Boolean | |
| "Last Archived Date" | DateTime | |
| "Interaction Exist" | Boolean | Specifies that the archived document is linked to an interaction log entry. |
| "Time Archived" | Time | Specifies what time the document was archived. |
| "Date Archived" | Date | Specifies the date when the document was archived. |
| "Archived By" | Code[50] | Specifies the user ID of the person who archived this document. |
| "Version No." | Integer | Specifies the version number of the archived document. |
| "Doc. No. Occurrence" | Integer | |
| "Campaign No." | Code[20] | |
| "Buy-from Contact No." | Code[20] | Specifies the number of the contact person at the vendor who delivered the items. |
| "Pay-to Contact No." | Code[20] | Specifies the number of the person to contact about an invoice from this vendor. |
| "Responsibility Center" | 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. |
| "Completely Received" | Boolean | |
| "Posting from Whse. Ref." | Integer | |
| "Location Filter" | Code[10] | |
| "Requested Receipt Date" | Date | Specifies the date you want the vendor to deliver your order. |
| "Promised Receipt Date" | Date | Specifies the date that the vendor has promised to deliver the order. |
| "Lead Time Calculation" | DateFormula | Specifies a date formula for the amount of time it takes to replenish the item. |
| "Inbound Whse. Handling Time" | DateFormula | Specifies the time it takes to make items part of available inventory, after the items have been posted as received. |
| "Date Filter" | Date | |
| "Vendor Authorization No." | Code[35] | Specifies information about sales quotes, purchase quotes, or orders in earlier versions of the document. |
| "Return Shipment No." | Code[20] | |
| "Return Shipment No. Series" | Code[20] | |
| Ship | Boolean | |
| "Last Return Shipment No." | Code[20] | |
| "Price Calculation Method" | Enum Microsoft.Pricing.Calculation."Price Calculation Method" | |
| "Assigned User ID" | Code[50] | Specifies the ID of the user who is responsible for the document. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
ShowDimensions
procedure ShowDimensions()SetSecurityFilterOnRespCenter
procedure SetSecurityFilterOnRespCenter()Events
OnBeforeSetSecurityFilterOnRespCenter
[IntegrationEvent(False,False)]
local procedure OnBeforeSetSecurityFilterOnRespCenter(var PurchaseHeaderArchive: Record "Purchase Header Archive"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| PurchaseHeaderArchive | Table Microsoft.Purchases.Archive."Purchase Header Archive" | |
| IsHandled | Boolean |