Return Shipment Line

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/6651

Table Type: Company

Table Name: Return Shipment Line
Database Table Name: CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 6651

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Return Shipment Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Buy-from Vendor No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Direct Unit Cost]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Unit Price (LCY)]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Item Shpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Job No_]
   ,[Indirect Cost _]
   ,[Quantity Invoiced]
   ,[Pay-to Vendor No_]
   ,[Vendor Item No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Entry Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Prod_ Order No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[FA Posting Date]
   ,[FA Posting Type]
   ,[Depreciation Book Code]
   ,[Salvage Value]
   ,[Depr_ until FA Posting Date]
   ,[Depr_ Acquisition Cost]
   ,[Maintenance Code]
   ,[Insurance No_]
   ,[Budgeted FA No_]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[Responsibility Center]
   ,[Cross-Reference No_]
   ,[Unit of Measure (Cross Ref_)]
   ,[Cross-Reference Type]
   ,[Cross-Reference Type No_]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Return Qty_ Shipped Not Invd_]
   ,[Item Charge Base Amount]
   ,[Correction]
   ,[Return Order No_]
   ,[Return Order Line No_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Return Shipment Line].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Return Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Return Shipment Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Return Shipment Line].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Return Shipment Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Return Shipment Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Return Shipment Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Return Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Return Shipment Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Return Shipment Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Return Shipment Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Buy-from Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Return Shipment Line].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Return Shipment Line].[Buy-from Vendor No_] = [Vendor].[No_]
5Type Searchint
6No_ Searchnvarchar(40)
7Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Return Shipment Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Return Shipment Line].[Location Code] = [Location].[Code]
8Posting Group Searchnvarchar(40)
9Description Searchnvarchar(200)
10Description 2 Searchnvarchar(100)
11Unit of Measure Searchnvarchar(100)
12Quantity Searchdecimal(38,38)
13Direct Unit Cost Searchdecimal(38,38)
14Unit Cost (LCY) Searchdecimal(38,38)
15VAT _ Searchdecimal(38,38)
16Line Discount _ Searchdecimal(38,38)
17Unit Price (LCY) Searchdecimal(38,38)
18Allow Invoice Disc_ Searchtinyint
19Gross Weight Searchdecimal(38,38)
20Net Weight Searchdecimal(38,38)
21Units per Parcel Searchdecimal(38,38)
22Unit Volume Searchdecimal(38,38)
23Appl_-to Item Entry Searchint
24Item Shpt_ Entry No_ Searchint
25Shortcut Dimension 1 Code Searchnvarchar(40)
26Shortcut Dimension 2 Code Searchnvarchar(40)
27Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Return Shipment Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Return Shipment Line].[Job No_] = [Job].[Job No_]
28Indirect Cost _ Searchdecimal(38,38)
29Quantity Invoiced Searchdecimal(38,38)
30Pay-to Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Return Shipment Line].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Return Shipment Line].[Pay-to Vendor No_] = [Vendor].[No_]
31Vendor Item No_ Searchnvarchar(100)
32Gen_ Bus_ Posting Group Searchnvarchar(40)
33Gen_ Prod_ Posting Group Searchnvarchar(40)
34VAT Calculation Type Searchint
35Transaction Type Searchnvarchar(20)
36Transport Method Searchnvarchar(20)
37Attached to Line No_ Searchint
38Entry Point Searchnvarchar(20)
39Area Searchnvarchar(20)
40Transaction Specification Searchnvarchar(20)
41Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Return Shipment Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Return Shipment Line].[Tax Area Code] = [Tax Area].[Code]
42Tax Liable Searchtinyint
43Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Return Shipment Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Return Shipment Line].[Tax Group Code] = [Tax Group].[Code]
44Use Tax Searchtinyint
45VAT Bus_ Posting Group Searchnvarchar(40)
46VAT Prod_ Posting Group Searchnvarchar(40)
47Blanket Order No_ Searchnvarchar(40)
48Blanket Order Line No_ Searchint
49VAT Base Amount Searchdecimal(38,38)
50Unit Cost Searchdecimal(38,38)
51Posting Date Searchdatetime
52IC Item Reference No_ Searchnvarchar(100)
53Dimension Set ID Searchint
54Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Return Shipment Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Return Shipment Line].[Job Task No_] = [Job Task].[Job Task No_]
55Prod_ Order No_ Searchnvarchar(40)
56Variant Code Searchnvarchar(20)
57Bin Code Searchnvarchar(40)
58Qty_ per Unit of Measure Searchdecimal(38,38)
59Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Return Shipment Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Return Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
60Quantity (Base) Searchdecimal(38,38)
61Qty_ Invoiced (Base) Searchdecimal(38,38)
62FA Posting Date Searchdatetime
63FA Posting Type Searchint
64Depreciation Book Code Searchnvarchar(20)
65Salvage Value Searchdecimal(38,38)
66Depr_ until FA Posting Date Searchtinyint
67Depr_ Acquisition Cost Searchtinyint
68Maintenance Code Searchnvarchar(20)
69Insurance No_ Searchnvarchar(40)
70Budgeted FA No_ Searchnvarchar(40)
71Duplicate in Depreciation Book Searchnvarchar(20)
72Use Duplication List Searchtinyint
73Responsibility Center Searchnvarchar(20)
74Cross-Reference No_ Searchnvarchar(40)
75Unit of Measure (Cross Ref_) Searchnvarchar(20)
76Cross-Reference Type Searchint
77Cross-Reference Type No_ Searchnvarchar(60)
78Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Return Shipment Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Return Shipment Line].[Item Category Code] = [Item Category].[Code]
79Nonstock Searchtinyint
80Purchasing Code Searchnvarchar(20)
81Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Return Shipment Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Return Shipment Line].[Product Group Code] = [Product Group].[Code]
82Item Reference No_ Searchnvarchar(100)
83Item Reference Unit of Measure Searchnvarchar(20)
84Item Reference Type Searchint
85Item Reference Type No_ Searchnvarchar(60)
86Return Qty_ Shipped Not Invd_ Searchdecimal(38,38)
87Item Charge Base Amount Searchdecimal(38,38)
88Correction Searchtinyint
89Return Order No_ Searchnvarchar(40)
90Return Order Line No_ Searchint
91Return Reason Code Searchnvarchar(20)
92Price Calculation Method Searchint
93$systemId Searchuniqueidentifier
94$systemCreatedAt Searchdatetime
95$systemCreatedBy Searchuniqueidentifier
96$systemModifiedAt Searchdatetime
97$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Return Shipment Line table

Leave a Reply

Your email address will not be published. Required fields are marked *