Sales Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSales Line

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Line No_]
   ,[Sell-to Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Shipment Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Outstanding Quantity]
   ,[Qty_ to Invoice]
   ,[Qty_ to Ship]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Line Discount Amount]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Price Group]
   ,[Job No_]
   ,[Work Type Code]
   ,[Recalculate Invoice Disc_]
   ,[Outstanding Amount]
   ,[Qty_ Shipped Not Invoiced]
   ,[Shipped Not Invoiced]
   ,[Quantity Shipped]
   ,[Quantity Invoiced]
   ,[Shipment No_]
   ,[Shipment Line No_]
   ,[Profit _]
   ,[Bill-to Customer No_]
   ,[Inv_ Discount Amount]
   ,[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 Category]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Clause Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Currency Code]
   ,[Outstanding Amount (LCY)]
   ,[Shipped Not Invoiced (LCY)]
   ,[Shipped Not Inv_ (LCY) No VAT]
   ,[Reserve]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[System-Created Entry]
   ,[Line Amount]
   ,[VAT Difference]
   ,[Inv_ Disc_ Amount to Invoice]
   ,[VAT Identifier]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Prepayment _]
   ,[Prepmt_ Line Amount]
   ,[Prepmt_ Amt_ Inv_]
   ,[Prepmt_ Amt_ Incl_ VAT]
   ,[Prepayment Amount]
   ,[Prepmt_ VAT Base Amt_]
   ,[Prepayment VAT _]
   ,[Prepmt_ VAT Calc_ Type]
   ,[Prepayment VAT Identifier]
   ,[Prepayment Tax Area Code]
   ,[Prepayment Tax Liable]
   ,[Prepayment Tax Group Code]
   ,[Prepmt Amt to Deduct]
   ,[Prepmt Amt Deducted]
   ,[Prepayment Line]
   ,[Prepmt_ Amount Inv_ Incl_ VAT]
   ,[Prepmt_ Amount Inv_ (LCY)]
   ,[IC Partner Code]
   ,[Prepmt_ VAT Amount Inv_ (LCY)]
   ,[Prepayment VAT Difference]
   ,[Prepmt VAT Diff_ to Deduct]
   ,[Prepmt VAT Diff_ Deducted]
   ,[IC Item Reference No_]
   ,[Pmt_ Discount Amount]
   ,[Prepmt_ Pmt_ Discount Amount]
   ,[Line Discount Calculation]
   ,[Dimension Set ID]
   ,[Qty_ to Assemble to Order]
   ,[Qty_ to Asm_ to Order (Base)]
   ,[Job Task No_]
   ,[Job Contract Entry No_]
   ,[Deferral Code]
   ,[Returns Deferral Start Date]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Planned]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Outstanding Qty_ (Base)]
   ,[Qty_ to Invoice (Base)]
   ,[Qty_ to Ship (Base)]
   ,[Qty_ Shipped Not Invd_ (Base)]
   ,[Qty_ Shipped (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[FA Posting Date]
   ,[Depreciation Book Code]
   ,[Depr_ until FA Posting Date]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[Responsibility Center]
   ,[Out-of-Stock Substitution]
   ,[Originally Ordered No_]
   ,[Originally Ordered Var_ Code]
   ,[Cross-Reference No_]
   ,[Unit of Measure (Cross Ref_)]
   ,[Cross-Reference Type]
   ,[Cross-Reference Type No_]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Special Order]
   ,[Special Order Purchase No_]
   ,[Special Order Purch_ Line No_]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Completely Shipped]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[Shipping Time]
   ,[Outbound Whse_ Handling Time]
   ,[Planned Delivery Date]
   ,[Planned Shipment Date]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Allow Item Charge Assignment]
   ,[Return Qty_ to Receive]
   ,[Return Qty_ to Receive (Base)]
   ,[Return Qty_ Rcd_ Not Invd_]
   ,[Ret_ Qty_ Rcd_ Not Invd_(Base)]
   ,[Return Rcd_ Not Invd_]
   ,[Return Rcd_ Not Invd_ (LCY)]
   ,[Return Qty_ Received]
   ,[Return Qty_ Received (Base)]
   ,[Appl_-from Item Entry]
   ,[BOM Item No_]
   ,[Return Receipt No_]
   ,[Return Receipt Line No_]
   ,[Return Reason Code]
   ,[Copied From Posted Doc_]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[Subtype]
   ,[Price description]
   ,[Reverse Charge Item]
   ,[Reverse Charge]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Sales 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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Line].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Sales Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Sales Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Sales Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Sales Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Sales Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Sales Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Sales Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Sales Line].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Sales Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Sales Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Sales Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Sales Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Document Type	int
3	Document No_	nvarchar(40)
4	Line No_	int
5	Sell-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Line].[Sell-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Line].[Sell-to Customer No_] = [Customer].[No_]
6	Type	int
7	No_	nvarchar(40)
8	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Sales Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Sales Line].[Location Code] = [Location].[Code]
9	Posting Group	nvarchar(40)
10	Shipment Date	datetime
11	Description	nvarchar(200)
12	Description 2	nvarchar(100)
13	Unit of Measure	nvarchar(100)
14	Quantity	decimal(38,38)
15	Outstanding Quantity	decimal(38,38)
16	Qty_ to Invoice	decimal(38,38)
17	Qty_ to Ship	decimal(38,38)
18	Unit Price	decimal(38,38)
19	Unit Cost (LCY)	decimal(38,38)
20	VAT _	decimal(38,38)
21	Line Discount _	decimal(38,38)
22	Line Discount Amount	decimal(38,38)
23	Amount	decimal(38,38)
24	Amount Including VAT	decimal(38,38)
25	Allow Invoice Disc_	tinyint
26	Gross Weight	decimal(38,38)
27	Net Weight	decimal(38,38)
28	Units per Parcel	decimal(38,38)
29	Unit Volume	decimal(38,38)
30	Appl_-to Item Entry	int
31	Shortcut Dimension 1 Code	nvarchar(40)
32	Shortcut Dimension 2 Code	nvarchar(40)
33	Customer Price Group	nvarchar(20)
	Key to join to the Customer Price Group table. Show/hide example query SELECT [Sales Line].[Customer Price Group] ,[Customer Price Group].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group] ON [Sales Line].[Customer Price Group] = [Customer Price Group].[Code]
34	Job No_	nvarchar(40)
	Key to join to the Job table. Show/hide example query SELECT [Sales Line].[Job No_] ,[Job].[Job No_] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Sales Line].[Job No_] = [Job].[Job No_]
35	Work Type Code	nvarchar(20)
36	Recalculate Invoice Disc_	tinyint
37	Outstanding Amount	decimal(38,38)
38	Qty_ Shipped Not Invoiced	decimal(38,38)
39	Shipped Not Invoiced	decimal(38,38)
40	Quantity Shipped	decimal(38,38)
41	Quantity Invoiced	decimal(38,38)
42	Shipment No_	nvarchar(40)
43	Shipment Line No_	int
44	Profit _	decimal(38,38)
45	Bill-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Line].[Bill-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Line].[Bill-to Customer No_] = [Customer].[No_]
46	Inv_ Discount Amount	decimal(38,38)
47	Purchase Order No_	nvarchar(40)
48	Purch_ Order Line No_	int
49	Drop Shipment	tinyint
50	Gen_ Bus_ Posting Group	nvarchar(40)
51	Gen_ Prod_ Posting Group	nvarchar(40)
52	VAT Calculation Type	int
53	Transaction Type	nvarchar(20)
54	Transport Method	nvarchar(20)
55	Attached to Line No_	int
56	Exit Point	nvarchar(20)
57	Area	nvarchar(20)
58	Transaction Specification	nvarchar(20)
59	Tax Category	nvarchar(20)
60	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Sales Line].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Sales Line].[Tax Area Code] = [Tax Area].[Code]
61	Tax Liable	tinyint
62	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Sales Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Sales Line].[Tax Group Code] = [Tax Group].[Code]
63	VAT Clause Code	nvarchar(40)
64	VAT Bus_ Posting Group	nvarchar(40)
65	VAT Prod_ Posting Group	nvarchar(40)
66	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Sales Line].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Sales Line].[Currency Code] = [Currency].[Code]
67	Outstanding Amount (LCY)	decimal(38,38)
68	Shipped Not Invoiced (LCY)	decimal(38,38)
69	Shipped Not Inv_ (LCY) No VAT	decimal(38,38)
70	Reserve	int
71	Blanket Order No_	nvarchar(40)
72	Blanket Order Line No_	int
73	VAT Base Amount	decimal(38,38)
74	Unit Cost	decimal(38,38)
75	System-Created Entry	tinyint
76	Line Amount	decimal(38,38)
77	VAT Difference	decimal(38,38)
78	Inv_ Disc_ Amount to Invoice	decimal(38,38)
79	VAT Identifier	nvarchar(40)
80	IC Partner Ref_ Type	int
81	IC Partner Reference	nvarchar(40)
82	Prepayment _	decimal(38,38)
83	Prepmt_ Line Amount	decimal(38,38)
84	Prepmt_ Amt_ Inv_	decimal(38,38)
85	Prepmt_ Amt_ Incl_ VAT	decimal(38,38)
86	Prepayment Amount	decimal(38,38)
87	Prepmt_ VAT Base Amt_	decimal(38,38)
88	Prepayment VAT _	decimal(38,38)
89	Prepmt_ VAT Calc_ Type	int
90	Prepayment VAT Identifier	nvarchar(40)
91	Prepayment Tax Area Code	nvarchar(40)
92	Prepayment Tax Liable	tinyint
93	Prepayment Tax Group Code	nvarchar(40)
94	Prepmt Amt to Deduct	decimal(38,38)
95	Prepmt Amt Deducted	decimal(38,38)
96	Prepayment Line	tinyint
97	Prepmt_ Amount Inv_ Incl_ VAT	decimal(38,38)
98	Prepmt_ Amount Inv_ (LCY)	decimal(38,38)
99	IC Partner Code	nvarchar(40)
	Key to join to the IC Partner table. Show/hide example query SELECT [Sales Line].[IC Partner Code] ,[IC Partner].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner] ON [Sales Line].[IC Partner Code] = [IC Partner].[Code]
100	Prepmt_ VAT Amount Inv_ (LCY)	decimal(38,38)
101	Prepayment VAT Difference	decimal(38,38)
102	Prepmt VAT Diff_ to Deduct	decimal(38,38)
103	Prepmt VAT Diff_ Deducted	decimal(38,38)
104	IC Item Reference No_	nvarchar(100)
105	Pmt_ Discount Amount	decimal(38,38)
106	Prepmt_ Pmt_ Discount Amount	decimal(38,38)
107	Line Discount Calculation	int
108	Dimension Set ID	int
109	Qty_ to Assemble to Order	decimal(38,38)
110	Qty_ to Asm_ to Order (Base)	decimal(38,38)
111	Job Task No_	nvarchar(40)
	Key to join to the Job Task table. Show/hide example query SELECT [Sales Line].[Job Task No_] ,[Job Task].[Job Task No_] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task] ON [Sales Line].[Job Task No_] = [Job Task].[Job Task No_]
112	Job Contract Entry No_	int
113	Deferral Code	nvarchar(20)
114	Returns Deferral Start Date	datetime
115	Variant Code	nvarchar(20)
116	Bin Code	nvarchar(40)
117	Qty_ per Unit of Measure	decimal(38,38)
118	Planned	tinyint
119	Qty_ Rounding Precision	decimal(38,38)
120	Qty_ Rounding Precision (Base)	decimal(38,38)
121	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Sales Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Sales Line].[Unit of Measure Code] = [Unit of Measure].[Code]
122	Quantity (Base)	decimal(38,38)
123	Outstanding Qty_ (Base)	decimal(38,38)
124	Qty_ to Invoice (Base)	decimal(38,38)
125	Qty_ to Ship (Base)	decimal(38,38)
126	Qty_ Shipped Not Invd_ (Base)	decimal(38,38)
127	Qty_ Shipped (Base)	decimal(38,38)
128	Qty_ Invoiced (Base)	decimal(38,38)
129	FA Posting Date	datetime
130	Depreciation Book Code	nvarchar(20)
131	Depr_ until FA Posting Date	tinyint
132	Duplicate in Depreciation Book	nvarchar(20)
133	Use Duplication List	tinyint
134	Responsibility Center	nvarchar(20)
135	Out-of-Stock Substitution	tinyint
136	Originally Ordered No_	nvarchar(40)
137	Originally Ordered Var_ Code	nvarchar(20)
138	Cross-Reference No_	nvarchar(40)
139	Unit of Measure (Cross Ref_)	nvarchar(20)
140	Cross-Reference Type	int
141	Cross-Reference Type No_	nvarchar(60)
142	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Sales Line].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Sales Line].[Item Category Code] = [Item Category].[Code]
143	Nonstock	tinyint
144	Purchasing Code	nvarchar(20)
145	Product Group Code	nvarchar(20)
	Key to join to the Product Group table. Show/hide example query SELECT [Sales Line].[Product Group Code] ,[Product Group].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group] ON [Sales Line].[Product Group Code] = [Product Group].[Code]
146	Special Order	tinyint
147	Special Order Purchase No_	nvarchar(40)
148	Special Order Purch_ Line No_	int
149	Item Reference No_	nvarchar(100)
150	Item Reference Unit of Measure	nvarchar(20)
151	Item Reference Type	int
152	Item Reference Type No_	nvarchar(60)
153	Completely Shipped	tinyint
154	Requested Delivery Date	datetime
155	Promised Delivery Date	datetime
156	Shipping Time	varchar(32)
157	Outbound Whse_ Handling Time	varchar(32)
158	Planned Delivery Date	datetime
159	Planned Shipment Date	datetime
160	Shipping Agent Code	nvarchar(20)
	Key to join to the Shipping Agent table. Show/hide example query SELECT [Sales Line].[Shipping Agent Code] ,[Shipping Agent].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent] ON [Sales Line].[Shipping Agent Code] = [Shipping Agent].[Code]
161	Shipping Agent Service Code	nvarchar(20)
	Key to join to the Shipping Agent Services table. Show/hide example query SELECT [Sales Line].[Shipping Agent Service Code] ,[Shipping Agent Services].[Code] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services] ON [Sales Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
162	Allow Item Charge Assignment	tinyint
163	Return Qty_ to Receive	decimal(38,38)
164	Return Qty_ to Receive (Base)	decimal(38,38)
165	Return Qty_ Rcd_ Not Invd_	decimal(38,38)
166	Ret_ Qty_ Rcd_ Not Invd_(Base)	decimal(38,38)
167	Return Rcd_ Not Invd_	decimal(38,38)
168	Return Rcd_ Not Invd_ (LCY)	decimal(38,38)
169	Return Qty_ Received	decimal(38,38)
170	Return Qty_ Received (Base)	decimal(38,38)
171	Appl_-from Item Entry	int
172	BOM Item No_	nvarchar(40)
173	Return Receipt No_	nvarchar(40)
174	Return Receipt Line No_	int
175	Return Reason Code	nvarchar(20)
176	Copied From Posted Doc_	tinyint
177	Price Calculation Method	int
178	Allow Line Disc_	tinyint
179	Customer Disc_ Group	nvarchar(40)
	Key to join to the Customer Discount Group table. Show/hide example query SELECT [Sales Line].[Customer Disc_ Group] ,[Customer Discount Group].[No_] FROM [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line] LEFT JOIN [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group] ON [Sales Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
180	Subtype	int
181	Price description	nvarchar(160)
182	Reverse Charge Item	tinyint
183	Reverse Charge	decimal(38,38)
184	$systemId	uniqueidentifier
185	$systemCreatedAt	datetime
186	$systemCreatedBy	uniqueidentifier
187	$systemModifiedAt	datetime
188	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Sales Line table

Currency Customer Customer Discount Group Customer Price Group IC Partner Item Category Job Job Task Location Product Group Shipping Agent Shipping Agent Services Tax Area Tax Group Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables SSales Line

Leave a Reply Cancel reply