Return Shipment Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RReturn 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
2	Buy-from Vendor No.	Buy-from Vendor No.	Normal	Code	20	Buy-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_]
3	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
4	Line No.	Line No.	Normal	Integer	4	Line No_	int
5	Type	Type	Normal	Option	4	Type	int
	Available options are: ” “ “G/L Account” “Item” “Resource” “Fixed Asset” “Charge (Item)” “Allocation Account”
6	No.	No.	Normal	Code	20	No_	nvarchar(40)
7	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
8	Posting Group	Posting Group	Normal	Code	20	Posting Group	nvarchar(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]
11	Description	Description	Normal	Text	100	Description	nvarchar(200)
12	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
13	Unit of Measure	Unit of Measure	Normal	Text	50	Unit of Measure	nvarchar(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]
15	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
22	Direct Unit Cost	Direct Unit Cost	Normal	Decimal	12	Direct Unit Cost	decimal(38,38)
23	Unit Cost (LCY)	Unit Cost ($)	Normal	Decimal	12	Unit Cost (LCY)	decimal(38,38)
25	VAT %	Tax %	Normal	Decimal	12	VAT _	decimal(38,38)
27	Line Discount %	Line Discount %	Normal	Decimal	12	Line Discount _	decimal(38,38)
31	Unit Price (LCY)	Unit Price ($)	Normal	Decimal	12	Unit Price (LCY)	decimal(38,38)
32	Allow Invoice Disc.	Allow Invoice Disc.	Normal	Boolean	4	Allow Invoice Disc_	tinyint
34	Gross Weight	Gross Weight	Normal	Decimal	12	Gross Weight	decimal(38,38)
35	Net Weight	Net Weight	Normal	Decimal	12	Net Weight	decimal(38,38)
36	Units per Parcel	Units per Parcel	Normal	Decimal	12	Units per Parcel	decimal(38,38)
37	Unit Volume	Unit Volume	Normal	Decimal	12	Unit Volume	decimal(38,38)
38	Appl.-to Item Entry	Appl.-to Item Entry	Normal	Integer	4	Appl_-to Item Entry	int
39	Item Shpt. Entry No.	Item Shpt. Entry No.	Normal	Integer	4	Item Shpt_ Entry No_	int
40	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(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]
41	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(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]
45	Job No.	Job No.	Normal	Code	20	Job 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_]
54	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
61	Quantity Invoiced	Quantity Invoiced	Normal	Decimal	12	Quantity Invoiced	decimal(38,38)
68	Pay-to Vendor No.	Vendor No.	Normal	Code	20	Pay-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_]
70	Vendor Item No.	Vendor Item No.	Normal	Text	50	Vendor Item No_	nvarchar(100)
74	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(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]
75	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(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]
77	VAT Calculation Type	VAT Calculation Type	Normal	Option	4	VAT Calculation Type	int
	Available options are: “Normal VAT” “Reverse Charge VAT” “Full VAT” “Sales Tax”
78	Transaction Type	Transaction Type	Normal	Code	10	Transaction Type	nvarchar(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]
79	Transport Method	Transport Method	Normal	Code	10	Transport Method	nvarchar(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]
80	Attached to Line No.	Attached to Line No.	Normal	Integer	4	Attached to Line No_	int
81	Entry Point	Entry Point	Normal	Code	10	Entry Point	nvarchar(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]
82	Area	Area	Normal	Code	10	Area	nvarchar(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]
83	Transaction Specification	Transaction Specification	Normal	Code	10	Transaction Specification	nvarchar(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]
85	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(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]
86	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
87	Tax Group Code	Tax Group Code	Normal	Code	20	Tax Group Code	nvarchar(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]
88	Use Tax	Use Tax	Normal	Boolean	4	Use Tax	tinyint
89	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(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]
90	VAT Prod. Posting Group	VAT Prod. Posting Group	Normal	Code	20	VAT Prod_ Posting Group	nvarchar(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]
91	Currency Code	Currency Code	FlowField	Code	10
	Key to join to the Currency table. Show/hide example query SELECT [Return Shipment Line].[] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Return Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Return Shipment Line].[] = [Currency].[Code]
97	Blanket Order No.	Blanket Order No.	Normal	Code	20	Blanket Order No_	nvarchar(40)
98	Blanket Order Line No.	Blanket Order Line No.	Normal	Integer	4	Blanket Order Line No_	int
99	VAT Base Amount	Tax Base Amount	Normal	Decimal	12	VAT Base Amount	decimal(38,38)
100	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
131	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
138	IC Item Reference No.	IC Item Reference No.	Normal	Code	50	IC Item Reference No_	nvarchar(100)
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
1001	Job Task No.	Job Task No.	Normal	Code	20	Job Task No_	nvarchar(40)
5401	Prod. Order No.	Prod. Order No.	Normal	Code	20	Prod_ Order No_	nvarchar(40)
5402	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(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]
5403	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(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]
5404	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
5407	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
5415	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
5461	Qty. Invoiced (Base)	Qty. Invoiced (Base)	Normal	Decimal	12	Qty_ Invoiced (Base)	decimal(38,38)
5600	FA Posting Date	FA Posting Date	Normal	Date	4	FA Posting Date	datetime
5601	FA Posting Type	FA Posting Type	Normal	Option	4	FA Posting Type	int
	Available options are: ” “ “Acquisition Cost” “Maintenance” “Appreciation”
5602	Depreciation Book Code	Depreciation Book Code	Normal	Code	10	Depreciation Book Code	nvarchar(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]
5603	Salvage Value	Salvage Value	Normal	Decimal	12	Salvage Value	decimal(38,38)
5605	Depr. until FA Posting Date	Depr. until FA Posting Date	Normal	Boolean	4	Depr_ until FA Posting Date	tinyint
5606	Depr. Acquisition Cost	Depr. Acquisition Cost	Normal	Boolean	4	Depr_ Acquisition Cost	tinyint
5609	Maintenance Code	Maintenance Code	Normal	Code	10	Maintenance Code	nvarchar(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]
5610	Insurance No.	Insurance No.	Normal	Code	20	Insurance 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_]
5611	Budgeted FA No.	Budgeted FA No.	Normal	Code	20	Budgeted 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_]
5612	Duplicate in Depreciation Book	Duplicate in Depreciation Book	Normal	Code	10	Duplicate in Depreciation Book	nvarchar(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]
5613	Use Duplication List	Use Duplication List	Normal	Boolean	4	Use Duplication List	tinyint
5700	Responsibility Center	Responsibility Center	Normal	Code	10	Responsibility Center	nvarchar(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]
5705	Cross-Reference No.	Cross-Reference No.	Normal	Code	20	Cross-Reference No_	nvarchar(40)
5706	Unit of Measure (Cross Ref.)	Unit of Measure (Cross Ref.)	Normal	Code	10	Unit of Measure (Cross Ref_)	nvarchar(20)
5707	Cross-Reference Type	Cross-Reference Type	Normal	Option	4	Cross-Reference Type	int
	Available options are: ” “ “Customer” “Vendor” “Bar Code”
5708	Cross-Reference Type No.	Cross-Reference Type No.	Normal	Code	30	Cross-Reference Type No_	nvarchar(60)
5709	Item Category Code	Item Category Code	Normal	Code	20	Item Category Code	nvarchar(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]
5710	Nonstock	Catalog	Normal	Boolean	4	Nonstock	tinyint
5711	Purchasing Code	Purchasing Code	Normal	Code	10	Purchasing Code	nvarchar(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]
5712	Product Group Code	Product Group Code	Normal	Code	10	Product Group Code	nvarchar(20)
5725	Item Reference No.	Item Reference No.	Normal	Code	50	Item Reference No_	nvarchar(100)
5726	Item Reference Unit of Measure	Unit of Measure (Item Ref.)	Normal	Code	10	Item Reference Unit of Measure	nvarchar(20)
5727	Item Reference Type	Item Reference Type	Normal	Option	4	Item Reference Type	int
	Available options are: ” “ “Customer” “Vendor” “Bar Code”
5728	Item Reference Type No.	Item Reference Type No.	Normal	Code	30	Item Reference Type No_	nvarchar(60)
5805	Return Qty. Shipped Not Invd.	Return Qty. Shipped Not Invd.	Normal	Decimal	12	Return Qty_ Shipped Not Invd_	decimal(38,38)
5811	Item Charge Base Amount	Item Charge Base Amount	Normal	Decimal	12	Item Charge Base Amount	decimal(38,38)
5817	Correction	Correction	Normal	Boolean	4	Correction	tinyint
6602	Return Order No.	Return Order No.	Normal	Code	20	Return Order No_	nvarchar(40)
6603	Return Order Line No.	Return Order Line No.	Normal	Integer	4	Return Order Line No_	int
6608	Return Reason Code	Return Reason Code	Normal	Code	10	Return Reason Code	nvarchar(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]
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Return Shipment Line table

Currency Item Category Location Product Group Responsibility Center Tax Area Tax Group Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables RReturn Shipment Line

Leave a Reply Cancel reply