tableSales & Receivablesofficial - Microsoftderived - from the source, no model text

Table 6661 "Return Receipt Line"

Base Application · Microsoft.Sales.History

Across versions

  1. BC23present
  2. BC242 fields changed, 1 events added
  3. BC251 events added
  4. BC265 fields removed, 3 fields added
  5. BC27unchanged
  6. BC2839 fields changed
  7. BC29-30unchanged

Neighbourhood 53 connected objects and pages

Table 18 "Customer" (relates to, 3 links)CustomerTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 5404 "Item Unit of Measure" (relates to, 2 links)Table 5611 "Depreciation Book" (relates to, 2 links)Depreciation BookTable 6660 "Return Receipt Header" (relates to, 2 links)Return Receipt HeaderTable 1001 "Job Task" (relates to)Job TaskTable 14 "Location" (relates to)Table 15 "G/L Account" (relates to)G/L AccountTable 156 "Resource" (relates to)Table 167 "Job" (relates to)JobTable 200 "Work Type" (relates to)Work TypeTable 204 "Unit of Measure" (relates to)Unit of MeasureTable 250 "Gen. Business Posting Group" (relates to)Gen. Business Posting GroupTable 251 "Gen. Product Posting Group" (relates to)Table 258 "Transaction Type" (relates to)Transaction TypeTable 259 "Transport Method" (relates to)Table 27 "Item" (relates to)Table 282 "Entry/Exit Point" (relates to)Table 284 "Area" (relates to)Table 285 "Transaction Specification" (relates to)Table 318 "Tax Area" (relates to)Table 321 "Tax Group" (relates to)Table 323 "VAT Business Posting Group" (relates to)Table 324 "VAT Product Posting Group" (relates to)Table 340 "Customer Discount Group" (relates to)Table 36 "Sales Header" (relates to)Page 6663 "Posted Return Receipt Lines" (pages and codeunits on it, 2 links)Posted Return Receipt LinesCodeunit 5816 "Undo Return Receipt Line" (pages and codeunits on it)Page 5853 "Get Pst.Doc-RtrnRcptLn Subform" (pages and codeunits on it)Page 6638 "Get Return Receipt Lines" (pages and codeunits on it)Page 6661 "Posted Return Receipt Subform" (pages and codeunits on it)Page 6667 "Return Receipt Lines" (pages and codeunits on it)Table extension 30111 "Shpfy Return Receipt Line" (extended by)Table extension 6240 "Sust. Sales Ret. Rcpt. Line" (extended by)Codeunit 379 "Transfer Old Ext. Text Lines" (calls, 3 links)Transfer Old Ext. Text LinesCodeunit 53 "Translation Helper" (calls, 2 links)Translation HelperCodeunit 408 "DimensionManagement" (calls)Codeunit 5700 "User Setup Management" (calls)Codeunit 6500 "Item Tracking Management" (calls)Codeunit 6503 "Item Tracking Doc. Management" (calls)

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.Sales.History · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Return Receipt Line
DataClassification CustomerContent
Permissions TableData “Item Ledger Entry” = r, TableData “Value Entry” = r

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. Δ BC28 Code[20] Specifies the number of the customer. TableRelation Table 18 “Customer”; not editable
3 Document No. Δ BC28 Code[20] Specifies the number of the related document. TableRelation Table 6660 “Return Receipt Header” (Return Receipt Header)
4 Line No. Integer —
5 Type Δ BC28 Enum “Sales Line Type” Specifies the line type. enum Enum 37 “Sales Line Type”
6 No. Δ BC28 Code[20] Specifies the number of the involved entry or record, according to the specified number series. TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge”)
7 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)))
8 Posting Group Code[20] — TableRelation Table 5606 “FA Posting Group”, Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group” else if (Type = const(“Fixed Asset”)) “FA Posting Group”); not editable
10 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.
11 Description Δ BC28 Text[100] Specifies either the name of or the description of the item, general ledger account or item charge.
12 Description 2 Δ BC28 Text[50] Specifies information in addition to the description.
13 Unit of Measure Δ BC28 Text[50] Specifies the name of the item or resource’s unit of measure, such as piece or hour.
15 Quantity Δ BC28 Decimal Specifies the number of units of the item, general ledger account, or item charge on the line.
22 Unit Price Decimal —
23 Unit Cost (LCY) Δ BC28 Decimal Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 5853 “Get Pst.Doc-RtrnRcptLn Subform”
25 VAT % Δ BC28 Decimal — not editable
27 Line Discount % Δ BC28 Decimal —
32 Allow Invoice Disc. Boolean —
34 Gross Weight Δ BC28 Decimal Specifies the gross weight of one unit of the item. In the sales statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular sales document.
35 Net Weight Δ BC28 Decimal Specifies the net weight of one unit of the item. In the sales statistics window, the net weight on the line is included in the total net weight of all the lines for the particular sales document.
36 Units per Parcel Δ BC28 Decimal Specifies the number of units per parcel of the item. In the sales statistics window, the number of units per parcel on the line helps to determine the total number of units for all the lines for the particular sales document.
37 Unit Volume Δ BC28 Decimal Specifies the volume of one unit of the item. In the sales statistics window, the volume of one unit of the item on the line is included in the total volume of all the lines for the particular sales document.
38 Appl.-to Item Entry Δ BC28 Integer Specifies the number of the item ledger entry that the document or journal line is applied to.
39 Item Rcpt. Entry No. Integer —
40 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)))
41 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)))
42 Customer Price Group Code[10] — TableRelation Table 6 “Customer Price Group” (Customer Price Group)
45 Job No. Δ BC24 Δ BC28 Code[20] Specifies the number of the related project. TableRelation Table 167 “Job”
52 Work Type Code Code[10] — TableRelation Table 200 “Work Type” (Work Type)
61 Quantity Invoiced Δ BC28 Decimal Specifies how many units of the item on the line have been posted as invoiced. not editable
68 Bill-to Customer No. Δ BC28 Code[20] Specifies the number of the customer that you send or sent the invoice or credit memo to. TableRelation Table 18 “Customer”; not editable
74 Gen. Bus. Posting Group Code[20] — TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75 Gen. Prod. Posting Group Code[20] — TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
77 VAT Calculation Type Enum “Tax Calculation Type” — enum Enum 254 “Tax Calculation Type”
78 Transaction Type Code[10] — TableRelation Table 258 “Transaction Type” (Transaction Type)
79 Transport Method Code[10] — TableRelation Table 259 “Transport Method” (Transport Method)
80 Attached to Line No. Integer — TableRelation Table 6661 “Return Receipt Line” (“Return Receipt Line”.“Line No.” where(“Document No.” = field(“Document No.”)))
81 Exit Point Code[10] — TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
82 Area Code[10] — TableRelation Table 284 “Area”
83 Transaction Specification Code[10] — TableRelation Table 285 “Transaction Specification” (Transaction Specification)
85 Tax Area Code Code[20] — TableRelation Table 318 “Tax Area” (Tax Area)
86 Tax Liable Boolean —
87 Tax Group Code Code[20] — TableRelation Table 321 “Tax Group” (Tax Group)
89 VAT Bus. Posting Group Code[20] — TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
90 VAT Prod. Posting Group Code[20] — TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
91 Currency Code Δ BC24 Δ BC28 Code[10] Specifies the currency that is used on the entry. FlowField: lookup(“Return Receipt Header”.“Currency Code” where(“No.” = field(“Document No.”))); not editable
97 Blanket Order No. Δ BC28 Code[20] Specifies the number of the blanket order that the record originates from. TableRelation Table 36 “Sales Header” (“Sales Header”.“No.” where(“Document Type” = const(“Blanket Order”)))
98 Blanket Order Line No. Δ BC28 Integer Specifies the number of the blanket order line that the record originates from. TableRelation Table 37 “Sales Line” (“Sales Line”.“Line No.” where(“Document Type” = const(“Blanket Order”), “Document No.” = field(“Blanket Order No.”)))
99 VAT Base Amount Decimal — not editable
100 Unit Cost Decimal — not editable
131 Posting Date Date —
138 IC Item Reference No. Code[50] —
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
1001 Job Task No. + BC26 Code[20] Project Task No. caption TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
1002 Job Contract Entry No. + BC26 Integer Project Contract Entry No. caption
5402 Variant Code Δ BC28 Code[10] Specifies the variant of the item on the line. TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
5403 Bin Code Δ BC28 Code[20] Specifies the bin where the items are picked or put away. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”), “Item Filter” = field(“No.”), “Variant Filter” = field(“Variant Code”)))
5404 Qty. per Unit of Measure Δ BC28 Decimal — not editable
5407 Unit of Measure Code Δ BC28 Code[10] Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”)
5415 Quantity (Base) Δ BC28 Decimal —
5461 Qty. Invoiced (Base) Δ BC28 Decimal — not editable
5600 FA Posting Date Date —
5602 Depreciation Book Code Code[10] — TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5605 Depr. until FA Posting Date Boolean —
5612 Duplicate in Depreciation Book Code[10] — TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5613 Use Duplication List Boolean —
5700 Responsibility Center Code[10] — TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5709 Item Category Code Code[20] — TableRelation Table 5722 “Item Category” (if (Type = const(Item)) “Item Category”)
5710 Nonstock Δ BC28 Boolean Specifies that this item is a catalog item.
5711 Purchasing Code Code[10] — TableRelation Table 5721 “Purchasing”
5725 Item Reference No. Δ BC28 Code[50] Specifies the referenced item number.
5726 Item Reference Unit of Measure Code[10] Unit of Measure (Item Ref.) caption TableRelation Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5727 Item Reference Type Enum “Item Reference Type” — enum Enum 5726 “Item Reference Type”
5728 Item Reference Type No. Code[30] —
5805 Return Qty. Rcd. Not Invd. Δ BC28 Decimal Specifies the quantity from the line that has been posted as received but that has not yet been posted as invoiced. not editable
5811 Appl.-from Item Entry Δ BC28 Integer Specifies the number of the item ledger entry that the document or journal line is applied from.
5812 Item Charge Base Amount Decimal —
5817 Correction Boolean — not editable
6602 Return Order No. Δ BC28 Code[20] Specifies the return order number this line is associated with. not editable
6603 Return Order Line No. Integer — not editable
6608 Return Reason Code Δ BC28 Code[10] Specifies the code explaining why the item was returned. TableRelation Table 6635 “Return Reason” (Return Reason)
7000 Price Calculation Method Enum “Price Calculation Method” — enum Enum 7000 “Price Calculation Method”
7001 Allow Line Disc. Boolean —
7002 Customer Disc. Group Code[20] — TableRelation Table 340 “Customer Discount Group” (Customer Discount Group)
7012 Sell-to Customer Name + BC26 Δ BC28 Text[100] Specifies the name of the customer. FlowField: lookup(Customer.Name where(“No.” = field(“Sell-to Customer No.”))); not editable

Keys

  • Key1: Document No., Line No. (clustered)
  • Key2: Return Order No., Return Order Line No.
  • Key3: Blanket Order No., Blanket Order Line No.
  • Key4: Item Rcpt. Entry No.
  • Key5: Bill-to Customer No.
  • Key6: Sell-to Customer No.
  • Key7: Appl.-from Item Entry

Events published

  • OnAfterCopyFieldsFromReturnReceiptLine(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line") (integration): Raised after copying fields from the return receipt line to a sales line.
  • OnAfterInitFromSalesLine(ReturnRcptHeader: Record "Return Receipt Header"; SalesLine: Record "Sales Line"; var ReturnRcptLine: Record "Return Receipt Line") (integration): Raised after initializing the return receipt line from a sales line.
  • OnAftertInsertInvLineFromRetRcptLine(var SalesLine: Record "Sales Line"; var SalesOrderLine: Record "Sales Line"; var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean) (integration): Raised after inserting an invoice line from a return receipt line.
  • OnBeforeCopySalesLinePriceAndDiscountFromSalesOrderLine(var SalesLine: Record "Sales Line"; SalesOrderLine: Record "Sales Line"; var IsHandled: Boolean) (integration): Raised before copying price and discount from a sales order line to a sales line.
  • OnBeforeInsertInvLineFromRetRcptLine(var SalesLine: Record "Sales Line"; SalesOrderLine: Record "Sales Line"; var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean; NextLineNo: Integer) (integration): Raised before inserting an invoice line from a return receipt line.
  • OnBeforeInsertInvLineFromRetRcptLineBeforeInsertTextLine(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var NextLineNo: Integer; var IsHandled: Boolean) (integration): Raised before inserting a text line when inserting an invoice line from a return receipt line.
  • OnInsertInvLineFromRetRcptLineOnBeforeInitSalesLine(var ReturnReceiptLine: Record "Return Receipt Line"; SalesLine: Record "Sales Line") (integration): Raised before initializing the sales line during InsertInvLineFromRetRcptLine.
  • OnInsertInvLineFromRetRcptLineOnAfterInsertAllLines(ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean) (integration): Raised after inserting all lines during InsertInvLineFromRetRcptLine.
  • OnInsertInvLineFromRetRcptLineOnBeforeValidateSalesLineQuantity(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean; var SalesHeader: Record "Sales Header") (integration): Raised before validating the sales line quantity during InsertInvLineFromRetRcptLine.
  • OnAfterDescriptionSalesLineInsert(var SalesLine: Record "Sales Line"; ReturnReceiptLine: Record "Return Receipt Line"; var NextLineNo: Integer) (integration): Raised after inserting the description sales line.
  • OnInsertInvLineFromRetRcptLine(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean) (integration): Raised during the insertion of an invoice line from a return receipt line.
  • OnOnInsertInvLineFromRetRcptLineOnAfterCopySalesLinePriceAndDiscount(var SalesLine: Record "Sales Line"; SalesOrderLine: Record "Sales Line"; ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header") (integration): Raised after copying sales line price and discount during InsertInvLineFromRetRcptLine.
  • OnInsertInvLineFromRetRcptLineOnAfterSalesHeaderGet(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line") (integration): Raised after getting the sales header during InsertInvLineFromRetRcptLine.
  • OnInsertInvLineFromRetRcptLineOnBeforeNoExtTextLineError(var ReturnReceiptLine: Record "Return Receipt Line") (integration): Raised before raising the no extended text line error during InsertInvLineFromRetRcptLine.
  • OnInsertInvLineFromRetRcptLineOnAfterCalcUnitPrice(var ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header"; SalesHeader2: Record "Sales Header"; var SalesLine: Record "Sales Line"; var SalesOrderLine: Record "Sales Line"; Currency: Record Currency) (integration): Raised after calculating the unit price during InsertInvLineFromRetRcptLine.
  • OnBeforeSetSecurityFilterOnRespCenter(var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean) (integration): Raised before setting the security filter on responsibility center for the return receipt line.
  • OnInsertInvLineFromRetRcptLineOnBeforeSalesHeaderGet(var SalesHeader: Record "Sales Header"; ReturnReceiptLine: Record "Return Receipt Line"; var TempSalesLine: Record "Sales Line" temporary; var IsHandled: boolean) + BC24 (integration): Raised before getting the sales header during InsertInvLineFromRetRcptLine.
  • OnBeforeShowItemTrackingLines(var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean) + BC25 (integration): Raised before showing item tracking lines for the return receipt line.

Procedures

  • GetCurrencyCode(): Code[10]: Retrieves the currency code from the return receipt header.
  • ShowDimensions(): Opens the dimension set entries page for this return receipt line.
  • ShowItemTrackingLines(): Opens the Item Tracking Lines page showing the tracking for this return receipt line.
  • InsertInvLineFromRetRcptLine(var SalesLine: Record "Sales Line"): Inserts a sales credit memo line from this return receipt line.
  • GetSalesCrMemoLines(var TempSalesCrMemoLine: Record "Sales Cr.Memo Line" temporary): Retrieves credit memo lines associated with this return receipt line.
  • FilterPstdDocLnItemLedgEntries(var ItemLedgEntry: Record "Item Ledger Entry"): Applies filters to item ledger entries to retrieve entries for this posted document line.
  • ShowItemSalesCrMemoLines(): Opens a page displaying the credit memo lines for this return receipt line.
  • ShowLineComments(): Opens a page displaying the comments for this return receipt line.
  • InitFromSalesLine(ReturnRcptHeader: Record "Return Receipt Header"; SalesLine: Record "Sales Line"): Initializes the return receipt line from a sales line when posting a sales return.
  • HasTypeToFillMandatoryFields(): Boolean: Determines whether the line has a type that requires mandatory fields to be filled.
  • SetSecurityFilterOnRespCenter(): Applies a security filter based on the user’s responsibility center setup.

Plus 2 local procedures.

Triggers

OnDelete

Relations

Referenced by

1 fields in 1 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.

Countries that replace it

CA, IT, MX, 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: "Return Receipt Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources