Sales Line Archive

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

Table Type: Company

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

Table Number: 5108

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Doc_ No_ Occurrence]
   ,[Version No_]
   ,[Line No_]
   ,[Sell-to Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Quantity Disc_ Code]
   ,[Shipment Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Outstanding Quantity]
   ,[Qty_ to Invoice]
   ,[Qty_ to Ship]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Quantity Disc_ _]
   ,[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]
   ,[Price Group Code]
   ,[Allow Quantity Disc_]
   ,[Job No_]
   ,[Work Type Code]
   ,[Cust__Item 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 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)]
   ,[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]
   ,[IC Partner Code]
   ,[IC Item Reference No_]
   ,[Pmt_ Discount Amount]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Job Contract Entry No_]
   ,[Deferral Code]
   ,[Returns Deferral Start Date]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Planned]
   ,[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 Amt_ Rcd_ Not Invd_]
   ,[Ret_ Amt_ Rcd_ Not Invd_ (LCY)]
   ,[Return Qty_ Received]
   ,[Return Qty_ Received (Base)]
   ,[Appl_-from Item Entry]
   ,[Service Contract No_]
   ,[Service Order No_]
   ,[Service Item No_]
   ,[Appl_-to Service Entry]
   ,[Service Item Line No_]
   ,[Serv_ Price Adjmt_ Gr_ Code]
   ,[BOM Item No_]
   ,[Return Receipt No_]
   ,[Return Receipt Line No_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Line Archive$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 Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Line Archive].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Line Archive].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Sales Line Archive].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Line Archive].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Line Archive].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Sales Line Archive].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Line Archive].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Sales Line Archive].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Sales Line Archive].[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 Archive].[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 Archive].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Sales Line Archive].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Sales Line Archive].[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 Archive].[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 Archive].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Sales Line Archive table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3Document No_ Primary Key Searchnvarchar(40)
4Doc_ No_ Occurrence Primary Key Searchint
5Version No_ Primary Key Searchint
6Line No_ Primary Key Searchint
7Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Line Archive].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Line Archive].[Sell-to Customer No_] = [Customer].[No_]
8Type Searchint
9No_ Searchnvarchar(40)
10Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Sales Line Archive].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Sales Line Archive].[Location Code] = [Location].[Code]
11Posting Group Searchnvarchar(40)
12Quantity Disc_ Code Searchnvarchar(40)
13Shipment Date Searchdatetime
14Description Searchnvarchar(200)
15Description 2 Searchnvarchar(100)
16Unit of Measure Searchnvarchar(100)
17Quantity Searchdecimal(38,38)
18Outstanding Quantity Searchdecimal(38,38)
19Qty_ to Invoice Searchdecimal(38,38)
20Qty_ to Ship Searchdecimal(38,38)
21Unit Price Searchdecimal(38,38)
22Unit Cost (LCY) Searchdecimal(38,38)
23VAT _ Searchdecimal(38,38)
24Quantity Disc_ _ Searchdecimal(38,38)
25Line Discount _ Searchdecimal(38,38)
26Line Discount Amount Searchdecimal(38,38)
27Amount Searchdecimal(38,38)
28Amount Including VAT Searchdecimal(38,38)
29Allow Invoice Disc_ Searchtinyint
30Gross Weight Searchdecimal(38,38)
31Net Weight Searchdecimal(38,38)
32Units per Parcel Searchdecimal(38,38)
33Unit Volume Searchdecimal(38,38)
34Appl_-to Item Entry Searchint
35Shortcut Dimension 1 Code Searchnvarchar(40)
36Shortcut Dimension 2 Code Searchnvarchar(40)
37Price Group Code Searchnvarchar(20)
38Allow Quantity Disc_ Searchtinyint
39Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Sales Line Archive].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Sales Line Archive].[Job No_] = [Job].[Job No_]
40Work Type Code Searchnvarchar(20)
41Cust__Item Disc_ _ Searchdecimal(38,38)
42Outstanding Amount Searchdecimal(38,38)
43Qty_ Shipped Not Invoiced Searchdecimal(38,38)
44Shipped Not Invoiced Searchdecimal(38,38)
45Quantity Shipped Searchdecimal(38,38)
46Quantity Invoiced Searchdecimal(38,38)
47Shipment No_ Searchnvarchar(40)
48Shipment Line No_ Searchint
49Profit _ Searchdecimal(38,38)
50Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Line Archive].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Line Archive].[Bill-to Customer No_] = [Customer].[No_]
51Inv_ Discount Amount Searchdecimal(38,38)
52Purchase Order No_ Searchnvarchar(40)
53Purch_ Order Line No_ Searchint
54Drop Shipment Searchtinyint
55Gen_ Bus_ Posting Group Searchnvarchar(40)
56Gen_ Prod_ Posting Group Searchnvarchar(40)
57VAT Calculation Type Searchint
58Transaction Type Searchnvarchar(20)
59Transport Method Searchnvarchar(20)
60Attached to Line No_ Searchint
61Exit Point Searchnvarchar(20)
62Area Searchnvarchar(20)
63Transaction Specification Searchnvarchar(20)
64Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Sales Line Archive].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Sales Line Archive].[Tax Area Code] = [Tax Area].[Code]
65Tax Liable Searchtinyint
66Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Sales Line Archive].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Sales Line Archive].[Tax Group Code] = [Tax Group].[Code]
67VAT Clause Code Searchnvarchar(40)
68VAT Bus_ Posting Group Searchnvarchar(40)
69VAT Prod_ Posting Group Searchnvarchar(40)
70Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Sales Line Archive].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Line Archive].[Currency Code] = [Currency].[Code]
71Outstanding Amount (LCY) Searchdecimal(38,38)
72Shipped Not Invoiced (LCY) Searchdecimal(38,38)
73Reserve Searchint
74Blanket Order No_ Searchnvarchar(40)
75Blanket Order Line No_ Searchint
76VAT Base Amount Searchdecimal(38,38)
77Unit Cost Searchdecimal(38,38)
78System-Created Entry Searchtinyint
79Line Amount Searchdecimal(38,38)
80VAT Difference Searchdecimal(38,38)
81Inv_ Disc_ Amount to Invoice Searchdecimal(38,38)
82VAT Identifier Searchnvarchar(40)
83IC Partner Ref_ Type Searchint
84IC Partner Reference Searchnvarchar(40)
85Prepayment _ Searchdecimal(38,38)
86Prepmt_ Line Amount Searchdecimal(38,38)
87Prepmt_ Amt_ Inv_ Searchdecimal(38,38)
88Prepmt_ Amt_ Incl_ VAT Searchdecimal(38,38)
89Prepayment Amount Searchdecimal(38,38)
90Prepmt_ VAT Base Amt_ Searchdecimal(38,38)
91Prepayment VAT _ Searchdecimal(38,38)
92Prepmt_ VAT Calc_ Type Searchint
93Prepayment VAT Identifier Searchnvarchar(40)
94Prepayment Tax Area Code Searchnvarchar(40)
95Prepayment Tax Liable Searchtinyint
96Prepayment Tax Group Code Searchnvarchar(40)
97Prepmt Amt to Deduct Searchdecimal(38,38)
98Prepmt Amt Deducted Searchdecimal(38,38)
99Prepayment Line Searchtinyint
100Prepmt_ Amount Inv_ Incl_ VAT Searchdecimal(38,38)
101IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Sales Line Archive].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Sales Line Archive].[IC Partner Code] = [IC Partner].[Code]
102IC Item Reference No_ Searchnvarchar(100)
103Pmt_ Discount Amount Searchdecimal(38,38)
104Dimension Set ID Searchint
105Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Sales Line Archive].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Sales Line Archive].[Job Task No_] = [Job Task].[Job Task No_]
106Job Contract Entry No_ Searchint
107Deferral Code Searchnvarchar(20)
108Returns Deferral Start Date Searchdatetime
109Variant Code Searchnvarchar(20)
110Bin Code Searchnvarchar(40)
111Qty_ per Unit of Measure Searchdecimal(38,38)
112Planned Searchtinyint
113Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Sales Line Archive].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Sales Line Archive].[Unit of Measure Code] = [Unit of Measure].[Code]
114Quantity (Base) Searchdecimal(38,38)
115Outstanding Qty_ (Base) Searchdecimal(38,38)
116Qty_ to Invoice (Base) Searchdecimal(38,38)
117Qty_ to Ship (Base) Searchdecimal(38,38)
118Qty_ Shipped Not Invd_ (Base) Searchdecimal(38,38)
119Qty_ Shipped (Base) Searchdecimal(38,38)
120Qty_ Invoiced (Base) Searchdecimal(38,38)
121FA Posting Date Searchdatetime
122Depreciation Book Code Searchnvarchar(20)
123Depr_ until FA Posting Date Searchtinyint
124Duplicate in Depreciation Book Searchnvarchar(20)
125Use Duplication List Searchtinyint
126Responsibility Center Searchnvarchar(20)
127Out-of-Stock Substitution Searchtinyint
128Originally Ordered No_ Searchnvarchar(40)
129Originally Ordered Var_ Code Searchnvarchar(20)
130Cross-Reference No_ Searchnvarchar(40)
131Unit of Measure (Cross Ref_) Searchnvarchar(20)
132Cross-Reference Type Searchint
133Cross-Reference Type No_ Searchnvarchar(60)
134Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Sales Line Archive].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Sales Line Archive].[Item Category Code] = [Item Category].[Code]
135Nonstock Searchtinyint
136Purchasing Code Searchnvarchar(20)
137Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Sales Line Archive].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Sales Line Archive].[Product Group Code] = [Product Group].[Code]
138Special Order Searchtinyint
139Special Order Purchase No_ Searchnvarchar(40)
140Special Order Purch_ Line No_ Searchint
141Item Reference No_ Searchnvarchar(100)
142Item Reference Unit of Measure Searchnvarchar(20)
143Item Reference Type Searchint
144Item Reference Type No_ Searchnvarchar(60)
145Completely Shipped Searchtinyint
146Requested Delivery Date Searchdatetime
147Promised Delivery Date Searchdatetime
148Shipping Time Searchvarchar(32)
149Outbound Whse_ Handling Time Searchvarchar(32)
150Planned Delivery Date Searchdatetime
151Planned Shipment Date Searchdatetime
152Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Sales Line Archive].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Sales Line Archive].[Shipping Agent Code] = [Shipping Agent].[Code]
153Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Sales Line Archive].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Sales Line Archive].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
154Allow Item Charge Assignment Searchtinyint
155Return Qty_ to Receive Searchdecimal(38,38)
156Return Qty_ to Receive (Base) Searchdecimal(38,38)
157Return Qty_ Rcd_ Not Invd_ Searchdecimal(38,38)
158Ret_ Qty_ Rcd_ Not Invd_(Base) Searchdecimal(38,38)
159Return Amt_ Rcd_ Not Invd_ Searchdecimal(38,38)
160Ret_ Amt_ Rcd_ Not Invd_ (LCY) Searchdecimal(38,38)
161Return Qty_ Received Searchdecimal(38,38)
162Return Qty_ Received (Base) Searchdecimal(38,38)
163Appl_-from Item Entry Searchint
164Service Contract No_ Searchnvarchar(40)
165Service Order No_ Searchnvarchar(40)
166Service Item No_ Searchnvarchar(40)
167Appl_-to Service Entry Searchint
168Service Item Line No_ Searchint
169Serv_ Price Adjmt_ Gr_ Code Searchnvarchar(20)
170BOM Item No_ Searchnvarchar(40)
171Return Receipt No_ Searchnvarchar(40)
172Return Receipt Line No_ Searchint
173Return Reason Code Searchnvarchar(20)
174Price Calculation Method Searchint
175Allow Line Disc_ Searchtinyint
176Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Sales Line Archive].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Sales Line Archive].[Customer Disc_ Group] = [Customer Discount Group].[No_]
177$systemId Searchuniqueidentifier
178$systemCreatedAt Searchdatetime
179$systemCreatedBy Searchuniqueidentifier
180$systemModifiedAt Searchdatetime
181$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Line Archive table

Leave a Reply

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