Table 120 "Purch. Rcpt. Header"
Base Application · Microsoft.Purchases.History
Across versions
- BC23present
- BC24declaration changed
- BC251 fields added
- BC262 fields changed
- BC272 fields changed
- BC2852 fields changed
- BC29-30unchanged
Neighbourhood 55 connected objects and pages
Base Application · Microsoft.Purchases.History · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 145 “Posted Purchase Receipts” (2 Learn pages), Page 30064 “APIV2 - Purchase Receipts” (2), Page 136 “Posted Purchase Receipt” (1).
Properties
| Property | Value |
|---|---|
| Caption | Purch. Rcpt. 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 name of the vendor who delivered the items. | TableRelation Table 23 “Vendor”; NotBlank |
| 3 | No. Δ BC28 | Code[20] | Specifies the number of a general ledger account, item, additional cost, or fixed asset, depending on what you selected in the Type field. | |
| 4 | Pay-to Vendor No. Δ BC26 | Code[20] | Specifies the number of the vendor that you receiv or 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 or received 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 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. | 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 that items on the purchase order were shipped to, as a drop shipment. | |
| 14 | Ship-to Name 2 Δ BC28 | Text[50] | Specifies an additional part of the name of the customer that items on the purchase order were shipped to, as a drop shipment. | |
| 15 | Ship-to Address Δ BC28 | Text[100] | Specifies the address that items on the purchase order were shipped to, as a drop shipment.. | |
| 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 contact person at the customer that items on the purchase order were shipped to, as a drop shipment. | |
| 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 you expect the items to be available in your warehouse. If you leave the field blank, it will be calculated as follows: Planned Receipt Date + Safety Lead Time + Inbound Warehouse Handling Time = Expected Receipt Date. | |
| 22 | Posting Description | Text[100] | — | |
| 23 | Payment Terms Code | Code[10] | — | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 24 | Due Date | Date | — | |
| 25 | Payment Discount % Δ BC28 | Decimal | — | |
| 26 | Pmt. Discount Date | Date | — | |
| 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 a code for the location where you want the items to be placed when they are received. | 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); not editable |
| 32 | Currency Code | Code[10] | — | TableRelation Table 4 “Currency”; not editable |
| 33 | Currency Factor Δ BC28 | Decimal | — | |
| 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 line number of the order that created the entry. | |
| 46 | Comment | Boolean | — | FlowField: exist(“Purch. Comment Line” where(“Document Type” = const(Receipt), “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”) |
| 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. | |
| 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 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 state, province or county related to the posted purchase order. | |
| 87 | Pay-to Country/Region Code Δ BC28 | Code[10] | Specifies the country or region of the vendor on the purchase document. | 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 related to the posted purchase order. | |
| 90 | Buy-from Country/Region Code Δ BC28 | Code[10] | Specifies the country or region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 91 | Ship-to Post Code Δ BC28 | Code[20] | Specifies the post code that items on the purchase order were shipped to, as a drop shipment. | TableRelation Table 225 “Post Code” (Post Code) |
| 92 | Ship-to County Δ BC28 | Text[30] | Specifies the state, province or county related to the posted purchase order. | |
| 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 when the related 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 | Code[10] | — | TableRelation Table 289 “Payment Method” (Payment Method) |
| 109 | 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) |
| 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 | Code[20] | — | TableRelation Table 318 “Tax Area” (Tax Area) |
| 115 | Tax Liable | Boolean | — | |
| 116 | VAT Bus. Posting Group | Code[20] | — | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 119 | VAT Base Discount % Δ BC28 | Decimal | — | |
| 151 | Quote No. Δ BC28 | Code[20] | Specifies the quote number for the posted purchase receipt. | not editable |
| 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 |
| 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 responsibility center code that is linked to this posted return receipt. | TableRelation Table 5714 “Responsibility Center” (Responsibility Center) |
| 5790 | Requested Receipt Date Δ BC28 | Date | Specifies the date that you want the vendor to deliver to the ship-to address. The value in the field is used to calculate the latest date you can order the items to have them delivered on the requested receipt date. If you do not need delivery on a specific date, you can leave the field blank. | not editable |
| 5791 | Promised Receipt Date Δ BC28 | Date | Specifies the date that the vendor has promised to deliver the order. | not editable |
| 5792 | Lead Time Calculation Δ BC28 | DateFormula | Specifies a date formula for the amount of time it takes to replenish the item. | not editable |
| 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. | not editable |
| 7000 | Price Calculation Method | Enum “Price Calculation Method” | — | enum Enum 7000 “Price Calculation Method” |
Keys
- Key1: No. (clustered)
- Key2: Order No.
- Key3: Pay-to Vendor No.
- Key4: Buy-from Vendor No.
- Key5: Posting Date
- Key6: Location Code
Events published
OnLookupAppliesToDocNoOnAfterSetFilters(var VendLedgEntry: Record "Vendor Ledger Entry"; PurchRcptHeader: Record "Purch. Rcpt. Header")(integration)OnBeforePrintRecords(var PurchRcptHeader: Record "Purch. Rcpt. Header"; ShowRequestPage: Boolean; var IsHandled: Boolean)(integration)OnBeforeSetSecurityFilterOnRespCenter(var PurchRcptHeader: Record "Purch. Rcpt. Header"; var IsHandled: Boolean)(integration)
Procedures
PrintRecords(ShowRequestForm: Boolean)ShowDimensions()SetSecurityFilterOnRespCenter()
Triggers
OnDelete
Relations
- drill-down page Page 145 “Posted Purchase Receipts”
- lookup page Page 145 “Posted Purchase Receipts”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Purchaser Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Sell-to Customer No.: TableRelation Table 18 “Customer”
- Ship-to Code: TableRelation Table 222 “Ship-to Address”
- Order Address Code: TableRelation Table 224 “Order Address”
- Buy-from City: TableRelation Table 225 “Post Code”
- Buy-from Post Code: TableRelation Table 225 “Post Code”
- Pay-to City: TableRelation Table 225 “Post Code”
- Pay-to Post Code: TableRelation Table 225 “Post Code”
- Ship-to City: TableRelation Table 225 “Post Code”
- Ship-to Post Code: TableRelation Table 225 “Post Code”
- Buy-from Vendor No.: TableRelation Table 23 “Vendor”
- Pay-to Vendor No.: TableRelation Table 23 “Vendor”
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Transaction Type: TableRelation Table 258 “Transaction Type”
- Transport Method: TableRelation Table 259 “Transport Method”
- Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Entry Point: TableRelation Table 282 “Entry/Exit Point”
- Area: TableRelation Table 284 “Area”
- Transaction Specification: TableRelation Table 285 “Transaction Specification”
- Payment Method Code: TableRelation Table 289 “Payment Method”
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- No. Series: TableRelation Table 308 “No. Series”
- Order No. Series: TableRelation Table 308 “No. Series”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Comment: CalcFormula Table 43 “Purch. Comment Line”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Buy-from Contact No.: TableRelation Table 5050 “Contact”
- Pay-to Contact no.: TableRelation Table 5050 “Contact”
- Campaign No.: TableRelation Table 5071 “Campaign”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Language Code: TableRelation Table 8 “Language”
- Buy-from Country/Region Code: TableRelation Table 9 “Country/Region”
- Pay-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Ship-to Country/Region Code: TableRelation Table 9 “Country/Region”
- VAT Country/Region Code: TableRelation Table 9 “Country/Region”
- Vendor Posting Group: TableRelation Table 93 “Vendor Posting Group”
Referenced by
10 fields in 8 objects relate to this table (TableRelation or CalcFormula).
- Table 121 “Purch. Rcpt. Line”: Currency Code, Document No.
- Table 23 “Vendor”: No. of Pstd. Receipts, Pay-to No. of Pstd. Receipts
- Table 38 “Purchase Header”: Last Receiving No.
- Table 5109 “Purchase Header Archive”: Last Receiving No.
- Table 7340 “Posted Invt. Put-away Header”: Source No.
- Table 7342 “Posted Invt. Pick Header”: Source No.
- Table 7344 “Registered Invt. Movement Hdr.”: Source No.
- Table 9050 “Warehouse Basic Cue”: Posted Purch. Receipts - Today
Pages and codeunits on this table
- Page 136 “Posted Purchase Receipt” (source table)
- Page 145 “Posted Purchase Receipts” (source table)
- Page 30064 “APIV2 - Purchase Receipts” (source table)
- Page 399 “Purchase Receipt Statistics” (source table)
- Codeunit 318 “Purch.Rcpt.-Printed” (codeunit runs on it)
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.
- Codeunit 364 “PostPurch-Delete” (2 calls:
OnDelete → DeletePurchRcptLines,OnDelete → IsDocumentDeletionAllowed) - Codeunit 1535 “Approvals Mgmt.” (1 call:
OnDelete → DeletePostedApprovalEntries) - Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 5700 “User Setup Management” (1 call:
SetSecurityFilterOnRespCenter → GetPurchasesFilter)
Countries that replace it
AU, BE, CA, ES, 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: "Purch. Rcpt. Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.