Table "Purch. Inv. Header"
Properties
| Name | Value |
|---|---|
| Caption | Purch. Inv. Header |
| DataCaptionFields | 3,79 |
| DrillDownPageID | Page Microsoft.Purchases.History."Posted Purchase Invoices" |
| LookupPageID | Page Microsoft.Purchases.History."Posted Purchase Invoices" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Buy-from Vendor No." | Code[20] | Specifies the identifier of the vendor that you bought the items from. |
| "No." | Code[20] | Specifies the posted invoice number. |
| "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 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 additional address information. |
| "Pay-to City" | Text[30] | Specifies the city of the vendor on the purchase document. |
| "Pay-to Contact" | Text[100] | Specifies the name of the person you should contact at the vendor who you received the invoice from. |
| "Your Reference" | Text[35] | |
| "Ship-to Code" | Code[10] | Specifies the address on purchase orders shipped with a drop shipment directly from the vendor to a customer. |
| "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 company at the address to which the items in the purchase order were shipped. |
| "Ship-to Address" | Text[100] | Specifies the address that the items in the purchase order were shipped to. |
| "Ship-to Address 2" | Text[50] | Specifies additional address information. |
| "Ship-to City" | Text[30] | Specifies the city of the vendor on the purchase document. |
| "Ship-to Contact" | Text[100] | Specifies the name of a contact person at the address that the items in the purchase order were shipped to. |
| "Order Date" | Date | |
| "Posting Date" | Date | Specifies the date the purchase header was posted. |
| "Expected Receipt Date" | Date | Specifies the date on which the invoiced items were expected. |
| "Posting Description" | Text[100] | Specifies any text that is entered to accompany the posting, for example for information to auditors. |
| "Payment Terms Code" | Code[10] | Specifies the code to use to find the payment terms that apply to the purchase header. |
| "Due Date" | 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. |
| "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 code for the location where the items are registered. |
| "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] | Specifies the vendor's market type to link business transactions made for the vendor with the appropriate account in the general ledger. |
| "Currency Code" | Code[10] | Specifies the currency code used to calculate the amounts on the invoice. |
| "Currency Factor" | Decimal | |
| "Prices Including VAT" | Boolean | |
| "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 No." | Code[20] | Specifies the number of the purchase order that this invoice was posted from. |
| Comment | Boolean | |
| "No. Printed" | Integer | Specifies how many times the document has been printed. |
| "On Hold" | Code[3] | |
| "Applies-to Doc. Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | |
| "Applies-to Doc. No." | Code[20] | |
| "Bal. Account No." | Code[20] | |
| Amount | Decimal | Specifies the total, in the currency of the invoice, of the amounts on all the invoice lines. |
| "Amount Including VAT" | Decimal | Specifies the total of the amounts, including VAT, on all the lines on the document. |
| "Vendor Order No." | Code[35] | Specifies the vendor's order number. |
| "Vendor Invoice No." | Code[35] | Specifies the vendor's own invoice number. |
| "VAT Registration No." | Text[20] | |
| "Sell-to Customer No." | Code[20] | |
| "Reason Code" | Code[10] | |
| "Gen. Bus. Posting Group" | Code[20] | |
| "Transaction Type" | Code[10] | |
| "Transport Method" | Code[10] | |
| "VAT Country/Region Code" | Code[10] | |
| "Buy-from Vendor Name" | Text[100] | Specifies the name of the vendor who shipped 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 shipped the items. |
| "Buy-from Address 2" | Text[50] | Specifies additional address information. |
| "Buy-from City" | Text[30] | Specifies the city of the vendor on the purchase document. |
| "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 state, province or county as a part of the address. |
| "Pay-to Country/Region Code" | Code[10] | Specifies the country or region of the ship-to 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 state, province or county as a part of the address. |
| "Buy-from Country/Region Code" | Code[10] | Specifies the country or region of the ship-to address. |
| "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 state, province or county as a part of the address. |
| "Ship-to Country/Region Code" | Code[10] | Specifies the country or region of the ship-to address. |
| "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] | |
| Correction | Boolean | |
| "Document Date" | Date | Specifies the date on which the purchase document was created. |
| "Area" | Code[10] | |
| "Transaction Specification" | Code[10] | |
| "Payment Method Code" | Code[10] | Specifies how to make payment, such as with bank transfer, cash, or check. |
| "Pre-Assigned No. Series" | Code[20] | |
| "No. Series" | Code[20] | |
| "Order No. Series" | Code[20] | |
| "Pre-Assigned No." | Code[20] | Specifies the number of the purchase document that the posted invoice was created for. |
| "User ID" | Code[50] | |
| "Source Code" | Code[10] | |
| "Tax Area Code" | Code[20] | Specifies the tax area that is used to calculate and post sales tax. |
| "Tax Liable" | Boolean | Specifies if the customer or vendor is liable for sales tax. |
| "VAT Bus. Posting Group" | Code[20] | |
| "VAT Base Discount %" | Decimal | |
| "Prepayment No. Series" | Code[20] | |
| "Prepayment Invoice" | Boolean | |
| "Prepayment Order No." | Code[20] | |
| "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. |
| "Quote No." | Code[20] | Specifies the number of the purchase quote document if a quote was used to start the purchase process. |
| "Creditor No." | Code[20] | Specifies the number of the vendor. |
| "Payment Reference" | Code[50] | Specifies the payment of the purchase invoice. |
| "VAT Reporting Date" | Date | Specifies the VAT date on the invoice. |
| "Self-Billing Invoice" | Boolean | |
| "Ship-to Phone No." | Text[30] | Specifies the telephone number of the company's shipping address. |
| "Dimension Set ID" | Integer | |
| "Remit-to Code" | Code[20] | Specifies the code for the vendor's remit address for this invoice. |
| Closed | 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. |
| "Remaining Amount" | Decimal | Specifies the remaining amount of the invoice. |
| "Vendor Ledger Entry No." | Integer | |
| "Invoice Discount Amount" | Decimal | |
| Cancelled | Boolean | Specifies if the posted purchase invoice has been either corrected or canceled. |
| Corrective | Boolean | Specifies if the posted purchase invoice is a corrective document. |
| "Dispute Status" | Code[10] | Specifies if there is an ongoing dispute for this document. |
| "Campaign No." | Code[20] | |
| "Buy-from Contact No." | Code[20] | Specifies the number of the contact you bought the items from. |
| "Pay-to Contact No." | Code[20] | Specifies the number of the contact you received the invoice from. |
| "Responsibility Center" | Code[10] | Specifies the code for the responsibility center that serves the vendor on this purchase document. |
| "Price Calculation Method" | Enum Microsoft.Pricing.Calculation."Price Calculation Method" | |
| "Draft Invoice SystemId" | Guid | |
| 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
IsFullyOpen
procedure IsFullyOpen(): Boolean
Returns
| Type | Description |
|---|---|
| Boolean |
PrintRecords
procedure PrintRecords(ShowRequestPage: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| ShowRequestPage | Boolean |
PrintToDocumentAttachment
procedure PrintToDocumentAttachment(var PurchInvHeaderLocal: Record "Purch. Inv. Header")
Parameters
| Name | Type | Description |
|---|---|---|
| PurchInvHeaderLocal | Table Microsoft.Purchases.History."Purch. Inv. Header" |
Navigate
procedure Navigate()
ShowDimensions
procedure ShowDimensions()
SetSecurityFilterOnRespCenter
procedure SetSecurityFilterOnRespCenter()
ShowCanceledOrCorrCrMemo
procedure ShowCanceledOrCorrCrMemo()
ShowCorrectiveCreditMemo
procedure ShowCorrectiveCreditMemo()
ShowCancelledCreditMemo
procedure ShowCancelledCreditMemo()
Events
OnBeforePrintRecords
[IntegrationEvent(False,False)]
local procedure OnBeforePrintRecords(var PurchInvHeader: Record "Purch. Inv. Header"; ShowRequestPage: Boolean; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| PurchInvHeader | Table Microsoft.Purchases.History."Purch. Inv. Header" | |
| ShowRequestPage | Boolean | |
| IsHandled | Boolean |
OnBeforeShowCanceledOrCorrCrMemo
[IntegrationEvent(False,False)]
local procedure OnBeforeShowCanceledOrCorrCrMemo(var PurchInvHeader: Record "Purch. Inv. Header"; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| PurchInvHeader | Table Microsoft.Purchases.History."Purch. Inv. Header" | |
| IsHandled | Boolean |
OnBeforeDoPrintToDocumentAttachment
[IntegrationEvent(False,False)]
local procedure OnBeforeDoPrintToDocumentAttachment(var PurchInvHeaderLocal: Record "Purch. Inv. Header"; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| PurchInvHeaderLocal | Table Microsoft.Purchases.History."Purch. Inv. Header" | |
| IsHandled | Boolean |
OnLookupAppliesToDocNoOnAfterSetFilters
[IntegrationEvent(False,False)]
local procedure OnLookupAppliesToDocNoOnAfterSetFilters(var VendLedgEntry: Record "Vendor Ledger Entry"; PurchInvHeader: Record "Purch. Inv. Header")
Parameters
| Name | Type | Description |
|---|---|---|
| VendLedgEntry | Table Microsoft.Purchases.Payables."Vendor Ledger Entry" | |
| PurchInvHeader | Table Microsoft.Purchases.History."Purch. Inv. Header" |
OnBeforeSetSecurityFilterOnRespCenter
[IntegrationEvent(False,False)]
local procedure OnBeforeSetSecurityFilterOnRespCenter(var PurchInvHeader: Record "Purch. Inv. Header"; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| PurchInvHeader | Table Microsoft.Purchases.History."Purch. Inv. Header" | |
| IsHandled | Boolean |
OnBeforCheckIfPurchaseInvoiceFullyOpen
[IntegrationEvent(False,False)]
local procedure OnBeforCheckIfPurchaseInvoiceFullyOpen(var PurchInvHeader: Record "Purch. Inv. Header"; var FullyOpen: Boolean; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| PurchInvHeader | Table Microsoft.Purchases.History."Purch. Inv. Header" | |
| FullyOpen | Boolean | |
| IsHandled | Boolean |