Sales Shipment Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSales Shipment Line

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

Table Type: Company

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

Table Number: 111

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 Sales Shipment Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Sell-to Customer No_]
   ,[Document No_]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Shipment Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[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]
   ,[Customer Price Group]
   ,[Job No_]
   ,[Work Type Code]
   ,[Qty_ Shipped Not Invoiced]
   ,[Quantity Invoiced]
   ,[Order No_]
   ,[Order Line No_]
   ,[Bill-to Customer No_]
   ,[Purchase Order No_]
   ,[Purch_ Order Line No_]
   ,[Drop Shipment]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Dimension Set ID]
   ,[Authorized for Credit Card]
   ,[Job Task No_]
   ,[Job Contract Entry No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[FA Posting Date]
   ,[Depreciation Book Code]
   ,[Depr_ until FA Posting Date]
   ,[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_]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[Shipping Time]
   ,[Outbound Whse_ Handling Time]
   ,[Planned Delivery Date]
   ,[Planned Shipment Date]
   ,[Appl_-from Item Entry]
   ,[Item Charge Base Amount]
   ,[Correction]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[Document Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Sales Shipment Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
2	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	Sell-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Shipment Line].[Sell-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Shipment Line].[Sell-to Customer No_] = [Customer].[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 [Sales Shipment Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Sales 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 [Sales Shipment Line].[Posting Group] ,[Customer Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group] ON [Sales Shipment Line].[Posting Group] = [Customer Posting Group].[Code]
10	Shipment Date	Shipment Date	Normal	Date	4	Shipment Date	datetime
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 [Sales Shipment Line].[Unit of Measure] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Sales Shipment Line].[Unit of Measure] = [Unit of Measure].[Code]
15	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
22	Unit Price	Unit Price	Normal	Decimal	12	Unit Price	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)
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 [Sales Shipment Line].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Sales 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 [Sales Shipment Line].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Sales Shipment Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
42	Customer Price Group	Customer Price Group	Normal	Code	10	Customer Price Group	nvarchar(20)
	Key to join to the Customer Price Group table. Show/hide example query SELECT [Sales Shipment Line].[Customer Price Group] ,[Customer Price Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group] ON [Sales Shipment Line].[Customer Price Group] = [Customer Price Group].[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 [Sales Shipment Line].[Job No_] ,[Job].[No_] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Sales Shipment Line].[Job No_] = [Job].[No_]
52	Work Type Code	Work Type Code	Normal	Code	10	Work Type Code	nvarchar(20)
	Key to join to the Work Type table. Show/hide example query SELECT [Sales Shipment Line].[Work Type Code] ,[Work Type].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type] ON [Sales Shipment Line].[Work Type Code] = [Work Type].[Code]
58	Qty. Shipped Not Invoiced	Qty. Shipped Not Invoiced	Normal	Decimal	12	Qty_ Shipped Not Invoiced	decimal(38,38)
61	Quantity Invoiced	Quantity Invoiced	Normal	Decimal	12	Quantity Invoiced	decimal(38,38)
65	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
66	Order Line No.	Order Line No.	Normal	Integer	4	Order Line No_	int
68	Bill-to Customer No.	Bill-to Customer No.	Normal	Code	20	Bill-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Shipment Line].[Bill-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Shipment Line].[Bill-to Customer No_] = [Customer].[No_]
71	Purchase Order No.	Purchase Order No.	Normal	Code	20	Purchase Order No_	nvarchar(40)
72	Purch. Order Line No.	Purch. Order Line No.	Normal	Integer	4	Purch_ Order Line No_	int
73	Drop Shipment	Drop Shipment	Normal	Boolean	4	Drop Shipment	tinyint
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 [Sales Shipment Line].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Sales 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 [Sales Shipment Line].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Sales 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 [Sales Shipment Line].[Transaction Type] ,[Transaction Type].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type] ON [Sales 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 [Sales Shipment Line].[Transport Method] ,[Transport Method].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method] ON [Sales 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	Exit Point	Exit Point	Normal	Code	10	Exit Point	nvarchar(20)
	Key to join to the Entry/Exit Point table. Show/hide example query SELECT [Sales Shipment Line].[Exit Point] ,[Entry/Exit Point].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point] ON [Sales Shipment Line].[Exit 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 [Sales Shipment Line].[Area] ,[Area].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area] ON [Sales 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 [Sales Shipment Line].[Transaction Specification] ,[Transaction Specification].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification] ON [Sales 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 [Sales Shipment Line].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Sales 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 [Sales Shipment Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Sales Shipment Line].[Tax Group Code] = [Tax Group].[Code]
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 [Sales Shipment Line].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Sales 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 [Sales Shipment Line].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [Sales 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 [Sales Shipment Line].[] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Sales 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)
107	IC Partner Ref. Type	IC Partner Ref. Type	Normal	Option	4	IC Partner Ref_ Type	int
	Available options are: ” “ “G/L Account” “Item” “Charge (Item)” “Cross Reference” “Common Item No.” “Vendor Item No.”
108	IC Partner Reference	IC Partner Reference	Normal	Code	20	IC Partner Reference	nvarchar(40)
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 [Sales Shipment Line].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Sales Shipment Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
826	Authorized for Credit Card	Authorized for Credit Card	Normal	Boolean	4	Authorized for Credit Card	tinyint
1001	Job Task No.	Job Task No.	Normal	Code	20	Job Task No_	nvarchar(40)
1002	Job Contract Entry No.	Job Contract Entry No.	Normal	Integer	4	Job Contract Entry No_	int
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 [Sales Shipment Line].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Sales 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 [Sales Shipment Line].[Bin Code] ,[Bin].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin] ON [Sales 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
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 [Sales Shipment Line].[Depreciation Book Code] ,[Depreciation Book].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book] ON [Sales Shipment Line].[Depreciation Book Code] = [Depreciation Book].[Code]
5605	Depr. until FA Posting Date	Depr. until FA Posting Date	Normal	Boolean	4	Depr_ until FA Posting Date	tinyint
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 [Sales Shipment Line].[Duplicate in Depreciation Book] ,[Depreciation Book].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book] ON [Sales 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 [Sales Shipment Line].[Responsibility Center] ,[Responsibility Center].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center] ON [Sales 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 [Sales Shipment Line].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Sales 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 [Sales Shipment Line].[Purchasing Code] ,[Purchasing].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing] ON [Sales 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)
5790	Requested Delivery Date	Requested Delivery Date	Normal	Date	4	Requested Delivery Date	datetime
5791	Promised Delivery Date	Promised Delivery Date	Normal	Date	4	Promised Delivery Date	datetime
5792	Shipping Time	Shipping Time	Normal	DateFormula	32	Shipping Time	varchar(32)
5793	Outbound Whse. Handling Time	Outbound Whse. Handling Time	Normal	DateFormula	32	Outbound Whse_ Handling Time	varchar(32)
5794	Planned Delivery Date	Planned Delivery Date	Normal	Date	4	Planned Delivery Date	datetime
5795	Planned Shipment Date	Planned Shipment Date	Normal	Date	4	Planned Shipment Date	datetime
5811	Appl.-from Item Entry	Appl.-from Item Entry	Normal	Integer	4	Appl_-from Item Entry	int
5812	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
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 [Sales Shipment Line].[Return Reason Code] ,[Return Reason].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason] ON [Sales 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”
7001	Allow Line Disc.	Allow Line Disc.	Normal	Boolean	4	Allow Line Disc_	tinyint
7002	Customer Disc. Group	Customer Disc. Group	Normal	Code	20	Customer Disc_ Group	nvarchar(40)
	Key to join to the Customer Discount Group table. Show/hide example query SELECT [Sales Shipment Line].[Customer Disc_ Group] ,[Customer Discount Group].[Code] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group] ON [Sales Shipment Line].[Customer Disc_ Group] = [Customer Discount Group].[Code]
8000	Document Id	Document Id	Normal	GUID	16	Document Id	uniqueidentifier
10000	Package Tracking No.	Package Tracking No.	Normal	Text	30
10003	Custom Transit Number	Custom Transit Number	Normal	Text	30
30100	Shpfy Order Line Id	Shopify Order Line Id	Normal	BigInteger	8
30101	Shpfy Order No.	Shopify Order No.	Normal	Code	50
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 [Sales Shipment Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Line] LEFT JOIN [User] AS [User] ON [Sales 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 Sales Shipment Line table

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

Dynamics 365 BC Table Reference Tables Company Tables SSales Shipment Line

Leave a Reply Cancel reply