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
   [Buy-from Vendor No_]
   ,[Document No_]
   ,[Line 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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Return Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Return Shipment Line].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Return Shipment Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Return Shipment Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Return Shipment Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Return Shipment Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Return Shipment Line].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Return Shipment Line].[Entry Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Return Shipment Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Return Shipment Line].[Transaction Specification] = [Transaction Specification].[Code]
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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Return Shipment Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Return Shipment Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Return Shipment Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Return Shipment Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Return Shipment Line].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
      ON
         [Return Shipment Line].[Maintenance Code] = [Maintenance].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Return Shipment Line].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Return Shipment Line].[Responsibility Center] = [Responsibility Center].[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_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Return Shipment Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Return Shipment Line].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Return Shipment Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Return Shipment Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Return Shipment Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Buy-from Vendor No. SearchBuy-from Vendor No.NormalCode20Buy-from Vendor No_nvarchar(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_]
3Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Item”
  • “Resource”
  • “Fixed Asset”
  • “Charge (Item)”
  • “Allocation Account”
6No. SearchNo.NormalCode20No_nvarchar(40)
7Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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 SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Return Shipment Line].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Return Shipment Line].[Posting Group] = [Customer Posting Group].[Code]
11Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
13Unit of Measure SearchUnit of MeasureNormalText50Unit of Measurenvarchar(100)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Return Shipment Line].[Unit of Measure]
       ,[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] = [Unit of Measure].[Code]
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
22Direct Unit Cost SearchDirect Unit CostNormalDecimal12Direct Unit Costdecimal(38,38)
23Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
25VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
27Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
31Unit Price (LCY) SearchUnit Price ($)NormalDecimal12Unit Price (LCY)decimal(38,38)
32Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
34Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
35Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
36Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
37Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
38Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
39Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
40Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Return Shipment Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Return Shipment Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
41Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Return Shipment Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Return Shipment Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
45Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Return Shipment Line].[Job No_]
       ,[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].[No_]
54Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
61Quantity Invoiced SearchQuantity InvoicedNormalDecimal12Quantity Invoiceddecimal(38,38)
68Pay-to Vendor No. SearchVendor No.NormalCode20Pay-to Vendor No_nvarchar(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_]
70Vendor Item No. SearchVendor Item No.NormalText50Vendor Item No_nvarchar(100)
74Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Return Shipment Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Return Shipment Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Return Shipment Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Return Shipment Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
77VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
78Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Return Shipment Line].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Return Shipment Line].[Transaction Type] = [Transaction Type].[Code]
79Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Return Shipment Line].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Return Shipment Line].[Transport Method] = [Transport Method].[Code]
80Attached to Line No. SearchAttached to Line No.NormalInteger4Attached to Line No_int
81Entry Point SearchEntry PointNormalCode10Entry Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Return Shipment Line].[Entry Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Return Shipment Line].[Entry Point] = [Entry/Exit Point].[Code]
82Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Return Shipment Line].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Return Shipment Line].[Area] = [Area].[Code]
83Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Return Shipment Line].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Return Shipment Line].[Transaction Specification] = [Transaction Specification].[Code]
85Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
86Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
87Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
88Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
89VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Return Shipment Line].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Return Shipment Line].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
90VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Return Shipment Line].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Return Shipment Line].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
91Currency Code SearchCurrency CodeFlowFieldCode10
97Blanket Order No. SearchBlanket Order No.NormalCode20Blanket Order No_nvarchar(40)
98Blanket Order Line No. SearchBlanket Order Line No.NormalInteger4Blanket Order Line No_int
99VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
100Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
131Posting Date SearchPosting DateNormalDate4Posting Datedatetime
138IC Item Reference No. SearchIC Item Reference No.NormalCode50IC Item Reference No_nvarchar(100)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Return Shipment Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Return Shipment Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
5401Prod. Order No. SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Return Shipment Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Return Shipment Line].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Return Shipment Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Return Shipment Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5415Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5461Qty. Invoiced (Base) SearchQty. Invoiced (Base)NormalDecimal12Qty_ Invoiced (Base)decimal(38,38)
5600FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
5601FA Posting Type SearchFA Posting TypeNormalOption4FA Posting Typeint
Available options are:
  • ” “
  • “Acquisition Cost”
  • “Maintenance”
  • “Appreciation”
5602Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Return Shipment Line].[Depreciation Book Code]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Return Shipment Line].[Depreciation Book Code] = [Depreciation Book].[Code]
5603Salvage Value SearchSalvage ValueNormalDecimal12Salvage Valuedecimal(38,38)
5605Depr. until FA Posting Date SearchDepr. until FA Posting DateNormalBoolean4Depr_ until FA Posting Datetinyint
5606Depr. Acquisition Cost SearchDepr. Acquisition CostNormalBoolean4Depr_ Acquisition Costtinyint
5609Maintenance Code SearchMaintenance CodeNormalCode10Maintenance Codenvarchar(20)
Key to join to the Maintenance table.

Show/hide example query

SELECT
       [Return Shipment Line].[Maintenance Code]
       ,[Maintenance].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
              ON
                     [Return Shipment Line].[Maintenance Code] = [Maintenance].[Code]
5610Insurance No. SearchInsurance No.NormalCode20Insurance No_nvarchar(40)
Key to join to the Insurance table.

Show/hide example query

SELECT
       [Return Shipment Line].[Insurance No_]
       ,[Insurance].[No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
              ON
                     [Return Shipment Line].[Insurance No_] = [Insurance].[No_]
5611Budgeted FA No. SearchBudgeted FA No.NormalCode20Budgeted FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
       [Return Shipment Line].[Budgeted FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [Return Shipment Line].[Budgeted FA No_] = [Fixed Asset].[No_]
5612Duplicate in Depreciation Book SearchDuplicate in Depreciation BookNormalCode10Duplicate in Depreciation Booknvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Return Shipment Line].[Duplicate in Depreciation Book]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Return Shipment Line].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
5613Use Duplication List SearchUse Duplication ListNormalBoolean4Use Duplication Listtinyint
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Return Shipment Line].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Return Shipment Line].[Responsibility Center] = [Responsibility Center].[Code]
5705Cross-Reference No. SearchCross-Reference No.NormalCode20Cross-Reference No_nvarchar(40)
5706Unit of Measure (Cross Ref.) SearchUnit of Measure (Cross Ref.)NormalCode10Unit of Measure (Cross Ref_)nvarchar(20)
5707Cross-Reference Type SearchCross-Reference TypeNormalOption4Cross-Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5708Cross-Reference Type No. SearchCross-Reference Type No.NormalCode30Cross-Reference Type No_nvarchar(60)
5709Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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]
5710Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5711Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
       [Return Shipment Line].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Return Shipment Line].[Purchasing Code] = [Purchasing].[Code]
5712Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchUnit of Measure (Item Ref.)NormalCode10Item Reference Unit of Measurenvarchar(20)
5727Item Reference Type SearchItem Reference TypeNormalOption4Item Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5728Item Reference Type No. SearchItem Reference Type No.NormalCode30Item Reference Type No_nvarchar(60)
5805Return Qty. Shipped Not Invd. SearchReturn Qty. Shipped Not Invd.NormalDecimal12Return Qty_ Shipped Not Invd_decimal(38,38)
5811Item Charge Base Amount SearchItem Charge Base AmountNormalDecimal12Item Charge Base Amountdecimal(38,38)
5817Correction SearchCorrectionNormalBoolean4Correctiontinyint
6602Return Order No. SearchReturn Order No.NormalCode20Return Order No_nvarchar(40)
6603Return Order Line No. SearchReturn Order Line No.NormalInteger4Return Order Line No_int
6608Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

SELECT
       [Return Shipment Line].[Return Reason Code]
       ,[Return Reason].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
              ON
                     [Return Shipment Line].[Return Reason Code] = [Return Reason].[Code]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Return Shipment Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Return Shipment Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Return Shipment Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Return Shipment Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Return Shipment Line table

Leave a Reply

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