Table 6660 "Return Receipt Header"
Base Application · Microsoft.Sales.History
Across versions
- BC23present
- BC241 fields changed
- BC251 fields added
- BC262 fields changed, 1 fields removed
- BC273 fields changed
- BC2846 fields changed, 3 procedures added
- BC29-30unchanged
Neighbourhood 55 connected objects and pages
Base Application · Microsoft.Sales.History · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 6662 “Posted Return Receipts” (3 Learn pages), Page 6660 “Posted Return Receipt” (1).
Properties
| Property | Value |
|---|---|
| Caption | Return Receipt 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 | Sell-to Customer No. Δ BC26 | Code[20] | Specifies the number of the customer who returned the products. | TableRelation Table 18 “Customer”; NotBlank |
| 3 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | |
| 4 | Bill-to Customer No. Δ BC26 | Code[20] | Specifies the number of the customer that you send or sent the credit memo to. | TableRelation Table 18 “Customer”; NotBlank |
| 5 | Bill-to Name Δ BC28 | Text[100] | Specifies the name of the customer that you send or sent the invoice or credit memo to. | |
| 6 | Bill-to Name 2 Δ BC27 | Text[50] | Specifies an additional part of the name of the customer that you send or sent the invoice or credit memo to. | |
| 7 | Bill-to Address Δ BC28 | Text[100] | Specifies the address of the customer to whom you sent the invoice. | |
| 8 | Bill-to Address 2 Δ BC28 | Text[50] | Specifies an additional line of the address. | |
| 9 | Bill-to City Δ BC28 | Text[30] | Specifies the city of the address. | TableRelation Table 225 “Post Code” (if (“Bill-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Bill-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Bill-to Country/Region Code”))) |
| 10 | Bill-to Contact Δ BC28 | Text[100] | Specifies the name of the contact person at the customer’s billing address. | |
| 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 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” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Ship-to Country/Region Code”))) |
| 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 | Date | — | |
| 20 | Posting Date Δ BC28 | Date | Specifies the entry’s posting date. | |
| 21 | Shipment Date Δ BC28 | Date | Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time. | |
| 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 | Customer Posting Group | Code[20] | — | TableRelation Table 92 “Customer Posting Group” (Customer Posting Group); not editable |
| 32 | Currency Code Δ BC28 | Code[10] | Specifies the currency that is used on the entry. | TableRelation Table 4 “Currency”; not editable |
| 33 | Currency Factor Δ BC28 | Decimal | — | |
| 34 | Customer Price Group | Code[10] | — | TableRelation Table 6 “Customer Price Group” (Customer Price Group) |
| 35 | Prices Including VAT | Boolean | — | |
| 37 | Invoice Disc. Code | Code[20] | — | |
| 40 | Customer Disc. Group | Code[20] | — | TableRelation Table 340 “Customer Discount Group” (Customer Discount Group) |
| 41 | Language Code | Code[10] | — | TableRelation Table 8 “Language” |
| 42 | Format Region | Text[80] | — | TableRelation “Language Selection”.“Language Tag” |
| 43 | Salesperson Code Δ BC28 | Code[20] | Specifies which salesperson is associated with the posted return receipt. | TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser) |
| 46 | Comment | Boolean | — | FlowField: exist(“Sales Comment Line” where(“Document Type” = const(“Posted Return 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”) |
| 70 | VAT Registration No. Δ BC28 | Text[20] | Specifies the customer’s VAT registration number for customers. | |
| 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) |
| 75 | EU 3-Party Trade | Boolean | — | |
| 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 | Sell-to Customer Name Δ BC28 | Text[100] | Specifies the name of the customer. | |
| 80 | Sell-to Customer Name 2 Δ BC27 | Text[50] | Specifies an additional part of the name of the customer who will receive the products and be billed by default. | |
| 81 | Sell-to Address Δ BC28 | Text[100] | Specifies the main address of the customer. | |
| 82 | Sell-to Address 2 Δ BC28 | Text[50] | Specifies an additional part of the address. | |
| 83 | Sell-to City Δ BC28 | Text[30] | Specifies the city of the customer’s main address. | TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Sell-to Country/Region Code”))) |
| 84 | Sell-to Contact Δ BC28 | Text[100] | Specifies the name of the contact person at the customer’s main address. | |
| 85 | Bill-to Post Code Δ BC28 | Code[20] | Specifies the postal code of the customer’s billing address. | TableRelation Table 225 “Post Code” (if (“Bill-to Country/Region Code” = const(‘’)) “Post Code” else if (“Bill-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Bill-to Country/Region Code”))) |
| 86 | Bill-to County | Text[30] | — | |
| 87 | Bill-to Country/Region Code Δ BC28 | Code[10] | Specifies the country/region code of the customer’s billing address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 88 | Sell-to Post Code Δ BC28 | Code[20] | Specifies the postal code of the customer’s main address. | TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code” else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Sell-to Country/Region Code”))) |
| 89 | Sell-to County | Text[30] | — | |
| 90 | Sell-to Country/Region Code Δ BC28 | Code[10] | Specifies the country/region code of the customer’s main 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” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code” else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Ship-to Country/Region Code”))) |
| 92 | Ship-to County | Text[30] | — | |
| 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” |
| 97 | Exit 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. | |
| 100 | External Document No. Δ BC28 | Code[35] | Specifies a document number that refers to the customer’s or vendor’s numbering system. | |
| 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) |
| 105 | Shipping Agent Code Δ BC28 | Code[10] | Specifies which shipping agent is used to transport the items on the sales document to the customer. | TableRelation Table 291 “Shipping Agent” (Shipping Agent) |
| 106 | Package Tracking No. Δ BC24 Δ BC27 Δ BC28 | Text[50] | Specifies the shipping agent’s package number. | |
| 109 | No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series); not editable |
| 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 | — | |
| 181 | Rcvd.-from Count./Region Code | Code[10] | Received-from Country/Region Code caption | TableRelation Table 9 “Country/Region” (Country/Region) |
| 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 | Sell-to Contact No. Δ BC28 | Code[20] | Specifies the number of the contact person at the customer’s main address. | TableRelation Table 5050 “Contact” |
| 5053 | Bill-to Contact No. Δ BC28 | Code[20] | Specifies the number of the contact person at the customer’s billing address. | TableRelation Table 5050 “Contact” |
| 5055 | Opportunity No. | Code[20] | — | TableRelation Table 5092 “Opportunity” |
| 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) |
| 5790 | Requested Delivery Date | Date | — | not editable |
| 5791 | Promised Delivery Date | Date | — | not editable |
| 5792 | Shipping Time | DateFormula | — | not editable |
| 5793 | Warehouse Handling Time | DateFormula | — | not editable |
| 5797 | Late Order Shipping | Boolean | — | not editable |
| 6601 | Return Order No. Δ BC28 | Code[20] | Specifies the number of the return order that will post a return receipt. | |
| 6602 | Return Order No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 7000 | Price Calculation Method | Enum “Price Calculation Method” | — | enum Enum 7000 “Price Calculation Method” |
| 7001 | Allow Line Disc. | Boolean | — |
Keys
- Key1: No. (clustered)
- Key2: Return Order No.
- Key3: Sell-to Customer No., External Document No.
- Key4: Bill-to Customer No.
- Key5: Posting Date
Events published
OnBeforePrintRecords(var ReturnRcptHeader: Record "Return Receipt Header"; ShowDialog: Boolean; var IsHandled: Boolean)(integration): Raised before printing return receipt records.OnBeforeEmailRecords(var ReturnRcptHeader: Record "Return Receipt Header"; var ShowDialog: Boolean; var IsHandled: Boolean)(integration): Raised before emailing return receipt records.OnBeforeSetSecurityFilterOnRespCenter(var ReturnReceiptHeader: Record "Return Receipt Header"; var IsHandled: Boolean)(integration): Raised before setting security filter on responsibility center for the return receipt.OnLookupAppliesToDocNoOnAfterSetFilters(var CustLedgEntry: Record "Cust. Ledger Entry"; ReturnReceiptHeader: Record "Return Receipt Header")(integration): Raised after setting filters when looking up the applies-to document number.OnBeforeCheckNoPrinted(var ReturnRcptHeader: Record "Return Receipt Header"; var IsHandled: Boolean)(integration): Raised before checking the number of times the return receipt has been printed.
Procedures
GetCustomerVATRegistrationNumber(): Text: Gets the customer’s VAT registration number from this return receipt.GetCustomerVATRegistrationNumberLbl(): Text: Gets the label for the customer’s VAT registration number field.GetCustomerGlobalLocationNumber(): Text: Gets the customer’s Global Location Number (GLN).GetCustomerGlobalLocationNumberLbl(): Text: Gets the label for the customer’s Global Location Number field.GetLegalStatement(): Text: Gets the legal statement text from the Sales and Receivables Setup.PrintRecords(ShowDialog: Boolean): Prints the return receipt records using the configured report selection.CheckNoPrinted(): Validates that the return receipt has been printed at least once.EmailRecords(ShowDialog: Boolean): Sends the return receipt records via email using the configured document sending profile.ShowDimensions(): Opens a page showing the dimension set for this return receipt.SetSecurityFilterOnRespCenter(): Sets a security filter based on the user’s responsibility center.StartTrackingSite(): Opens the shipping agent’s tracking website for the package.SendRecords()+ BC28: Sends the selected return receipt records using the customer’s document sending profile.PrintToDocumentAttachment(var ReturnReceiptHeader: Record "Return Receipt Header")+ BC28: Prints the return receipt and attaches it to the document.
Plus 1 local procedures.
Triggers
OnDelete
Relations
- lookup page Page 6662 “Posted Return Receipts”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Bill-to Customer No.: TableRelation Table 18 “Customer”
- Sell-to Customer No.: TableRelation Table 18 “Customer”
- Ship-to Code: TableRelation Table 222 “Ship-to Address”
- Bill-to City: TableRelation Table 225 “Post Code” (conditional)
- Bill-to Post Code: TableRelation Table 225 “Post Code” (conditional)
- Sell-to City: TableRelation Table 225 “Post Code” (conditional)
- Sell-to Post Code: TableRelation Table 225 “Post Code” (conditional)
- Ship-to City: TableRelation Table 225 “Post Code” (conditional)
- Ship-to Post Code: TableRelation Table 225 “Post Code” (conditional)
- 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)
- Exit 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”
- Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- No. Series: TableRelation Table 308 “No. Series”
- Return 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”
- Customer Disc. Group: TableRelation Table 340 “Customer Discount 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 44 “Sales Comment Line”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Bill-to Contact No.: TableRelation Table 5050 “Contact”
- Sell-to Contact No.: TableRelation Table 5050 “Contact”
- Campaign No.: TableRelation Table 5071 “Campaign”
- Opportunity No.: TableRelation Table 5092 “Opportunity”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Customer Price Group: TableRelation Table 6 “Customer Price Group”
- Language Code: TableRelation Table 8 “Language”
- Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Rcvd.-from Count./Region Code: TableRelation Table 9 “Country/Region”
- Sell-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”
- Customer Posting Group: TableRelation Table 92 “Customer Posting Group”
Referenced by
6 fields in 4 objects relate to this table (TableRelation or CalcFormula).
- Table 18 “Customer”: Bill-To No. of Pstd. Return R., No. of Pstd. Return Receipts
- Table 6661 “Return Receipt Line”: Currency Code, Document No.
- Table 36 “Sales Header”: Last Return Receipt No.
- Table 5107 “Sales Header Archive”: Last Return Receipt No.
Pages and codeunits on this table
- Page 1353 “Posted Return Receipt - Update” (source table)
- Page 30252 “APIV2 - Return Receipts” (source table)
- Page 6660 “Posted Return Receipt” (source table)
- Page 6662 “Posted Return Receipts” (source table)
- Page 6665 “Return Receipt Statistics” (source table)
- Codeunit 1407 “Return Receipt Header - Edit” (codeunit runs on it)
- Codeunit 6661 “Return Receipt - 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 363 “PostSales-Delete” (2 calls:
OnDelete → DeleteSalesRcptLines,OnDelete → IsDocumentDeletionAllowed) - Codeunit 452 “Report Distribution Management” (2 calls:
EmailRecords → GetFullDocumentTypeText,SendRecords → GetFullDocumentTypeText) - Codeunit 1535 “Approvals Mgmt.” (1 call:
OnDelete → DeletePostedApprovalEntries) - Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 5700 “User Setup Management” (1 call:
SetSecurityFilterOnRespCenter → GetSalesFilter)
Countries that replace it
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: "Return Receipt Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.