Table 6651 "Return Shipment Line"

Base Application · Microsoft.Purchases.History · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Return Shipment 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	Buy-from Vendor No. Δ BC28	Code[20]	Specifies the name of the vendor who delivered the items.	TableRelation Table 23 “Vendor”; not editable
3	Document No. Δ BC28	Code[20]	Specifies the number of the related document.	TableRelation Table 6650 “Return Shipment Header” (Return Shipment Header)
4	Line No.	Integer	—
5	Type Δ BC28	Enum “Purchase Line Type”	Specifies the line type.	enum Enum 39 “Purchase 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(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge” else if (Type = const(Resource)) Resource)
7	Location Code Δ BC28	Code[10]	Specifies the location from where inventory items to the customer on the sales document are to be shipped by default.	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
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	Direct Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the selected item or resource.
23	Unit Cost (LCY) Δ BC28	Decimal	Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 5858 “Get Pst.Doc-RtrnShptLn Subform”
25	VAT % Δ BC28	Decimal	—	not editable
27	Line Discount % Δ BC28	Decimal	—
31	Unit Price (LCY) Δ BC28	Decimal	—
32	Allow Invoice Disc.	Boolean	—
34	Gross Weight Δ BC28	Decimal	Specifies the gross weight of one unit of the item. In the purchase statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular purchase document.
35	Net Weight Δ BC28	Decimal	Specifies the net weight of one unit of the item. In the purchase statistics window, the net weight on the line is included in the total net weight of all the lines for the particular purchase document.
36	Units per Parcel Δ BC28	Decimal	Specifies the number of units per parcel of the item. In the purchase 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 purchase document.
37	Unit Volume Δ BC28	Decimal	Specifies the volume of one unit of the item. In the purchase 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 purchase 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 Shpt. 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)))
45	Job No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project.	TableRelation Table 167 “Job”
54	Indirect Cost % Δ BC28	Decimal	—
61	Quantity Invoiced Δ BC28	Decimal	Specifies how many units of the item on the line have been posted as invoiced.	not editable
68	Pay-to Vendor No. Δ BC28	Code[20]	Specifies the number of the vendor that you received the invoice from.	TableRelation Table 23 “Vendor”; not editable
70	Vendor Item No.	Text[50]	—
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 6651 “Return Shipment Line” (“Return Shipment Line”.“Line No.” where(“Document No.” = field(“Document No.”)))
81	Entry 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)
88	Use Tax	Boolean	—
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 Shipment 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. Δ BC24	Code[20]	Project Task No. caption	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
1019	Job Planning Line No. + BC26	Integer	Project Planning Line 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	—
5601	FA Posting Type	Enum “Purchase FA Posting Type”	—	enum Enum 5607 “Purchase FA Posting Type”
5602	Depreciation Book Code	Code[10]	—	TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5603	Salvage Value Δ BC28	Decimal	—
5605	Depr. until FA Posting Date	Boolean	—
5606	Depr. Acquisition Cost	Boolean	—
5609	Maintenance Code	Code[10]	—	TableRelation Table 5626 “Maintenance”
5610	Insurance No.	Code[20]	—	TableRelation Table 5628 “Insurance”
5611	Budgeted FA No.	Code[20]	—	TableRelation Table 5600 “Fixed Asset” (Fixed Asset)
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. Shipped Not Invd. Δ BC28	Decimal	Specifies the quantity of the item that has been posted as shipped but has not yet been posted as invoiced.	not editable
5811	Item Charge Base Amount	Decimal	—
5817	Correction Δ BC28	Boolean	Specifies the entry as a corrective entry. You can use the field if you need to post a corrective entry to an account.	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”
8512	Buy-from Vendor Name + BC26 Δ BC28	Text[100]	Specifies the name of the vendor who delivered the items.	FlowField: lookup(Vendor.Name where(“No.” = field(“Buy-from Vendor 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: Pay-to Vendor No.
Key5: Buy-from Vendor No.

Events published

OnBeforeCopyPurchLineCostAndDiscountFromPurchOrderLine(var PurchaseLine: Record "Purchase Line"; PurchOrderLine: Record "Purchase Line"; var IsHandled: Boolean) (integration)
OnAfterCopyFieldsFromReturnShipmentLine(var ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseLine: Record "Purchase Line") (integration)
OnAfterInitFromPurchLine(ReturnShptHeader: Record "Return Shipment Header"; PurchLine: Record "Purchase Line"; var ReturnShptLine: Record "Return Shipment Line") (integration)
OnAfterInsertInvLineFromRetShptLine(var PurchLine: Record "Purchase Line"; var PurchOrderLine: Record "Purchase Line"; var ReturnShipmentLine: Record "Return Shipment Line") (integration)
OnBeforeInsertInvLineFromRetShptLine(var PurchLine: Record "Purchase Line"; var PurchOrderLine: Record "Purchase Line"; var ReturnShipmentLine: Record "Return Shipment Line"; var IsHandled: Boolean; var NextLineNo: Integer) (integration)
OnInsertInvLineFromRetShptLineOnBeforeValidatePurchaseLine(var ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseLine: Record "Purchase Line"; var IsHandled: Boolean; var PurchHeader: Record "Purchase Header") (integration)
OnInsertInvLineFromRetShptLineOnBeforePurchLineInsert(var ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseLine: Record "Purchase Line"; var NextLineNo: Integer; var IsHandled: Boolean) (integration)
OnInsertInvLineFromRetShptLineOnBeforeClearLineNumbers(var ReturnShipmentLine: Record "Return Shipment Line"; var PurchLine: Record "Purchase Line"; var NextLineNo: Integer; var TempPurchLine: Record "Purchase Line" temporary) (integration)
OnBeforeSetSecurityFilterOnRespCenter(var ReturnShipmentLine: Record "Return Shipment Line"; var IsHandled: Boolean) (integration)
OnBeforeShowItemTrackingLines(var ReturnShipmentLine: Record "Return Shipment Line"; var IsHandled: Boolean) + BC25 (integration)
OnInsertInvLineFromRetShptLineOnBeforeCalculateDirectCost(var ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseHeader: Record "Purchase Header"; var PurchaseLine: Record "Purchase Line"; var PurchasesPayablesSetup: Record "Purchases & Payables Setup"; var IsHandled: Boolean) + BC25 (integration)
OnInsertInvLineFromRetShptLineOnAfterPurchLineInsert(var ReturnShipmentLine: Record "Return Shipment Line"; var PurchaseLine: Record "Purchase Line"; var NextLineNo: Integer) + BC25 (integration)
OnIsProdOrder(var ReturnShipmentLine: Record "Return Shipment Line"; var Result: Boolean) + BC27 (integration)
- subscribers: Codeunit 99000789 “Mfg. Purchase Document Mgt.” ReturnShipmentLineOnIsProdOrder
OnTestProdOrder(var ReturnShipmentLine: Record "Return Shipment Line"; var Result: Boolean) + BC27 (integration)
- subscribers: Codeunit 99000789 “Mfg. Purchase Document Mgt.” ReturnShipmentLineOnTestProdOrder

Procedures

GetCurrencyCode(): Code[10]
ShowDimensions()
ShowItemTrackingLines()
InsertInvLineFromRetShptLine(var PurchaseLine: Record "Purchase Line") Δ BC25
GetPurchCrMemoLines(var TempPurchCrMemoLine: Record "Purch. Cr. Memo Line" temporary)
FilterPstdDocLnItemLedgEntries(var ItemLedgEntry: Record "Item Ledger Entry")
ShowItemPurchCrMemoLines()
ShowLineComments()
InitFromPurchLine(ReturnShipmentHeader: Record "Return Shipment Header"; PurchLine: Record "Purchase Line") Δ BC25
HasTypeToFillMandatoryFields(): Boolean
SetSecurityFilterOnRespCenter()
IsProdOrder(): Boolean + BC27
TestProdOrder(): Boolean + BC27

Plus 2 local procedures.

Triggers

OnDelete

Relations

lookup page Page 6653 “Posted Return Shipment Lines”
Job Task No.: TableRelation Table 1001 “Job Task”
Location Code: TableRelation Table 14 “Location”
No.: TableRelation Table 15 “G/L Account” (conditional)
No.: TableRelation Table 156 “Resource” (conditional)
Job No.: TableRelation Table 167 “Job”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Buy-from Vendor Name: CalcFormula Table 23 “Vendor”
Buy-from Vendor No.: TableRelation Table 23 “Vendor”
Pay-to Vendor No.: TableRelation Table 23 “Vendor”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Transaction Type: TableRelation Table 258 “Transaction Type”
Transport Method: TableRelation Table 259 “Transport Method”
No.: TableRelation Table 27 “Item” (conditional)
Entry Point: TableRelation Table 282 “Entry/Exit Point”
Area: TableRelation Table 284 “Area”
Transaction Specification: TableRelation Table 285 “Transaction Specification”
Tax Area Code: TableRelation Table 318 “Tax Area”
Tax Group Code: TableRelation Table 321 “Tax Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Blanket Order No.: TableRelation Table 36 “Sales Header”
Blanket Order Line No.: TableRelation Table 37 “Sales Line”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Variant Code: TableRelation Table 5401 “Item Variant”
Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
Budgeted FA No.: TableRelation Table 5600 “Fixed Asset”
No.: TableRelation Table 5600 “Fixed Asset” (conditional)
Posting Group: TableRelation Table 5606 “FA Posting Group” (conditional)
Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
Duplicate in Depreciation Book: TableRelation Table 5611 “Depreciation Book”
Maintenance Code: TableRelation Table 5626 “Maintenance”
Insurance No.: TableRelation Table 5628 “Insurance”
Responsibility Center: TableRelation Table 5714 “Responsibility Center”
Purchasing Code: TableRelation Table 5721 “Purchasing”
Item Category Code: TableRelation Table 5722 “Item Category”
No.: TableRelation Table 5800 “Item Charge” (conditional)
Return Reason Code: TableRelation Table 6635 “Return Reason”
Currency Code: CalcFormula Table 6650 “Return Shipment Header”
Document No.: TableRelation Table 6650 “Return Shipment Header”
Attached to Line No.: TableRelation Table 6651 “Return Shipment Line”
Bin Code: TableRelation Table 7354 “Bin”
Posting Group: TableRelation Table 94 “Inventory Posting Group” (conditional)

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 6651 “Return Shipment Line”: Attached to Line No.

Pages and codeunits on this table

Page 5858 “Get Pst.Doc-RtrnShptLn Subform” (source table)
Page 6648 “Get Return Shipment Lines” (source table)
Page 6651 “Posted Return Shipment Subform” (source table)
Page 6653 “Posted Return Shipment Lines” (source table)
Page 6657 “Return Shipment Lines” (source table)
Codeunit 5814 “Undo Return Shipment Line” (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 379 “Transfer Old Ext. Text Lines” (3 calls: InsertInvLineFromRetShptLine → ClearLineNumbers, InsertInvLineFromRetShptLine → GetNewLineNumber, InsertInvLineFromRetShptLine → TransferExtendedText)
Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
Codeunit 5700 “User Setup Management” (1 call: SetSecurityFilterOnRespCenter → GetPurchasesFilter)
Codeunit 6500 “Item Tracking Management” (1 call: InsertInvLineFromRetShptLine → CopyHandledItemTrkgToInvLine)
Codeunit 6503 “Item Tracking Doc. Management” (1 call: ShowItemTrackingLines → ShowItemTrackingForShptRcptLine)

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 Shipment Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.