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

Show/hide tables related from Sales Line table

Leave a Reply

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