Return Shipment Line #6651

Other table in Microsoft Dynamics 365 Business Central. 113 fields, 0 records in Cronus demo.

113
Fields
0
Records
2
Primary key
2
FlowFields
38
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Document No., Line No..

All fields (113)

Return Shipment Line — FIELDS
NO.FIELDTYPECLASSRELATION
2 Buy-from Vendor No. Code Normal → Vendor #23
3 Document No. PK Code Normal → Return Shipment Header #6650
4 Line No. PK Integer Normal
5 Type Option Normal
6 No. Code Normal
7 Location Code Code Normal → Location #14
8 Posting Group Code Normal
11 Description Text Normal
12 Description 2 Text Normal
13 Unit of Measure Text Normal
15 Quantity Decimal Normal
22 Direct Unit Cost Decimal Normal
23 Unit Cost (LCY) Decimal Normal
25 VAT % Decimal Normal
27 Line Discount % Decimal Normal
31 Unit Price (LCY) Decimal Normal
32 Allow Invoice Disc. Boolean Normal
34 Gross Weight Decimal Normal
35 Net Weight Decimal Normal
36 Units per Parcel Decimal Normal
37 Unit Volume Decimal Normal
38 Appl.-to Item Entry Integer Normal
39 Item Shpt. Entry No. Integer Normal
40 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
41 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
45 Project No. Code Normal → Job #167
54 Indirect Cost % Decimal Normal
61 Quantity Invoiced Decimal Normal
68 Pay-to Vendor No. Code Normal → Vendor #23
70 Vendor Item No. Text Normal
74 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
75 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
77 VAT Calculation Type Option Normal
78 Transaction Type Code Normal → Transaction Type #258
79 Transport Method Code Normal → Transport Method #259
80 Attached to Line No. Integer Normal → Return Shipment Line #6651
81 Entry Point Code Normal → Entry/Exit Point #282
82 Area Code Normal → Area #284
83 Transaction Specification Code Normal → Transaction Specification #285
85 Tax Area Code Code Normal → Tax Area #318
86 Tax Liable Boolean Normal
87 Tax Group Code Code Normal → Tax Group #321
88 Use Tax Boolean Normal
89 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
90 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
91 Currency Code ⚡ FLOW Code FlowField
97 Blanket Order No. Code Normal → Sales Header #36
98 Blanket Order Line No. Integer Normal → Sales Line #37
99 VAT Base Amount Decimal Normal
100 Unit Cost Decimal Normal
131 Posting Date Date Normal
138 IC Item Reference No. Code Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1001 Project Task No. Code Normal → Job Task #1001
1019 Project Planning Line No. Integer Normal
5401 Prod. Order No. Code Normal
5402 Variant Code Code Normal
5403 Bin Code Code Normal → Bin #7354
5404 Qty. per Unit of Measure Decimal Normal
5407 Unit of Measure Code Code Normal
5415 Quantity (Base) Decimal Normal
5461 Qty. Invoiced (Base) Decimal Normal
5600 FA Posting Date Date Normal
5601 FA Posting Type Option Normal
5602 Depreciation Book Code Code Normal → Depreciation Book #5611
5603 Salvage Value Decimal Normal
5605 Depr. until FA Posting Date Boolean Normal
5606 Depr. Acquisition Cost Boolean Normal
5609 Maintenance Code Code Normal → Maintenance #5626
5610 Insurance No. Code Normal → Insurance #5628
5611 Budgeted FA No. Code Normal → Fixed Asset #5600
5612 Duplicate in Depreciation Book Code Normal → Depreciation Book #5611
5613 Use Duplication List Boolean Normal
5700 Responsibility Center Code Normal → Responsibility Center #5714
5709 Item Category Code Code Normal
5710 Catalog Boolean Normal
5711 Purchasing Code Code Normal → Purchasing #5721
5725 Item Reference No. Code Normal
5726 Unit of Measure (Item Ref.) Code Normal
5727 Item Reference Type Option Normal
5728 Item Reference Type No. Code Normal
5805 Return Qty. Shipped Not Invd. Decimal Normal
5811 Item Charge Base Amount Decimal Normal
5817 Correction Boolean Normal
6210 Sustainability Account No. Code Normal → Sustainability Account #6210
6211 Sustainability Account Name Text Normal
6212 Sustainability Account Category Code Normal → Sustain. Account Category #6211
6213 Sustainability Account Subcategory Code Normal → Sustain. Account Subcategory #6212
6214 Emission CO2 Per Unit Decimal Normal
6215 Emission CH4 Per Unit Decimal Normal
6216 Emission N2O Per Unit Decimal Normal
6217 Emission CO2 Decimal Normal
6218 Emission CH4 Decimal Normal
6219 Emission N2O Decimal Normal
6223 Energy Source Code Code Normal → Sustainability Energy Source #6233
6224 Renewable Energy Boolean Normal
6225 Energy Consumption Per Unit Decimal Normal
6226 Energy Consumption Decimal Normal
6228 Source of Emission Data Option Normal
6229 Emission Verified Boolean Normal
6230 CBAM Compliance Boolean Normal
6231 Emission Cost per Unit Decimal Normal
6232 Total Emission Cost Decimal Normal
6602 Return Order No. Code Normal
6603 Return Order Line No. Integer Normal
6608 Return Reason Code Code Normal → Return Reason #6635
7000 Price Calculation Method Option Normal
8512 Buy-from Vendor Name ⚡ FLOW Text FlowField
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (34)

Tables referenced by fields on the Return Shipment Line table through TableRelation properties.

Vendor
#23 · Purchasing · via Buy-from Vendor No., Pay-to Vendor No.
Return Shipment Header
#6650 · Other · via Document No.
Location
#14 · General Ledger · via Location Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Job
#167 · Other · via Project No.
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Return Shipment Line
#6651 · Other · via Attached to Line No.
Entry/Exit Point
#282 · Other · via Entry Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Tax Area
#318 · Other · via Tax Area Code
Tax Group
#321 · Other · via Tax Group Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Sales Header
#36 · Sales Documents · via Blanket Order No.
Sales Line
#37 · Sales Documents · via Blanket Order Line No.
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Job Task
#1001 · Jobs · via Project Task No.
Bin
#7354 · Warehouse · via Bin Code
Depreciation Book
#5611 · Fixed Assets · via Depreciation Book Code, Duplicate in Depreciation Book
Maintenance
#5626 · Fixed Assets · via Maintenance Code
Insurance
#5628 · Fixed Assets · via Insurance No.
Fixed Asset
#5600 · Fixed Assets · via Budgeted FA No.
Responsibility Center
#5714 · Other · via Responsibility Center
Purchasing
#5721 · Other · via Purchasing Code
Sustainability Account
#6210 · Other · via Sustainability Account No.
Sustain. Account Category
#6211 · Other · via Sustainability Account Category
Sustain. Account Subcategory
#6212 · Other · via Sustainability Account Subcategory
Sustainability Energy Source
#6233 · Other · via Energy Source Code
Return Reason
#6635 · Other · via Return Reason Code