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$ext

Table Number: 37

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$ext]

Show/hide an example select of all columns by name

SELECT
   [Document Type]
   ,[Sell-to Customer No_]
   ,[Document No_]
   ,[Line 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]
   ,[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]
   ,[Selected Alloc_ Account No_]
   ,[Allocation Account No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Planned]
   ,[Qty_ Rounding Precision]
   ,[Unit of Measure Code]
   ,[Qty_ Rounding Precision (Base)]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

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$ext] AS [Sales Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Sales Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Sales Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Sales Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Sales Line].[Document No_] = [Sales Header Archive].[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 Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Sales 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 Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales 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 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 Line].[Work Type Code] = [Work Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Sales Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Sales 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 Line].[Exit Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Sales Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Sales Line].[Transaction Specification] = [Transaction Specification].[Code]
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_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
      ON
         [Sales Line].[VAT Clause Code] = [VAT Clause].[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_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Line].[Prepayment Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Sales Line].[Prepayment Tax Group Code] = [Tax Group].[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_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Sales Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
      ON
         [Sales Line].[Deferral Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Sales Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Sales Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Sales Line].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Sales 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 Line].[Responsibility Center] = [Responsibility Center].[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_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Sales Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Sales Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Sales Line].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
      ON
         [Sales Line].[Shpfy Refund Id] = [Shpfy Refund Header].[Refund Id]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Sales Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
Part of multi-key to join to the Sales Header table.

Show/hide example query

SELECT
       [Sales Line].[Document Type]
       ,[Sales Header].[Document Type]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
              ON
                     [Sales Line].[Document Type] = [Sales Header].[Document Type]
              AND
                     [Sales Line].[Document No_] = [Sales Header].[No_]
2Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-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$ext] 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_]
3Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Item”
  • “Resource”
  • “Fixed Asset”
  • “Charge (Item)”
  • “Allocation Account”
6No. SearchNo.NormalCode20No_nvarchar(40)
7Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Sales Line].[Location Code] = [Location].[Code]
8Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Sales Line].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Sales Line].[Posting Group] = [Customer Posting Group].[Code]
10Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
11Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
13Unit of Measure SearchUnit of MeasureNormalText50Unit of Measurenvarchar(100)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Sales Line].[Unit of Measure]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] 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] = [Unit of Measure].[Code]
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Outstanding Quantity SearchOutstanding QuantityNormalDecimal12Outstanding Quantitydecimal(38,38)
17Qty. to Invoice SearchQty. to InvoiceNormalDecimal12Qty_ to Invoicedecimal(38,38)
18Qty. to Ship SearchQty. to ShipNormalDecimal12Qty_ to Shipdecimal(38,38)
22Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
23Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
25VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
27Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
28Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
29Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
30Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
32Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
34Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
35Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
36Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
37Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
38Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
40Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
41Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
42Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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$ext] 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]
45Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Sales Line].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Sales Line].[Job No_] = [Job].[No_]
52Work Type Code SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

SELECT
       [Sales Line].[Work Type Code]
       ,[Work Type].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
              ON
                     [Sales Line].[Work Type Code] = [Work Type].[Code]
56Recalculate Invoice Disc. SearchRecalculate Invoice Disc.NormalBoolean4Recalculate Invoice Disc_tinyint
57Outstanding Amount SearchOutstanding AmountNormalDecimal12Outstanding Amountdecimal(38,38)
58Qty. Shipped Not Invoiced SearchQty. Shipped Not InvoicedNormalDecimal12Qty_ Shipped Not Invoiceddecimal(38,38)
59Shipped Not Invoiced SearchShipped Not InvoicedNormalDecimal12Shipped Not Invoiceddecimal(38,38)
60Quantity Shipped SearchQuantity ShippedNormalDecimal12Quantity Shippeddecimal(38,38)
61Quantity Invoiced SearchQuantity InvoicedNormalDecimal12Quantity Invoiceddecimal(38,38)
63Shipment No. SearchShipment No.NormalCode20Shipment No_nvarchar(40)
64Shipment Line No. SearchShipment Line No.NormalInteger4Shipment Line No_int
67Profit % SearchProfit %NormalDecimal12Profit _decimal(38,38)
68Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-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$ext] 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_]
69Inv. Discount Amount SearchInv. Discount AmountNormalDecimal12Inv_ Discount Amountdecimal(38,38)
71Purchase Order No. SearchPurchase Order No.NormalCode20Purchase Order No_nvarchar(40)
72Purch. Order Line No. SearchPurch. Order Line No.NormalInteger4Purch_ Order Line No_int
73Drop Shipment SearchDrop ShipmentNormalBoolean4Drop Shipmenttinyint
74Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Sales Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Sales Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Sales Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Sales Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
77VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
78Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Sales Line].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Sales Line].[Transaction Type] = [Transaction Type].[Code]
79Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Sales Line].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Sales Line].[Transport Method] = [Transport Method].[Code]
80Attached to Line No. SearchAttached to Line No.NormalInteger4Attached to Line No_int
81Exit Point SearchExit PointNormalCode10Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Sales Line].[Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Sales Line].[Exit Point] = [Entry/Exit Point].[Code]
82Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Sales Line].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Sales Line].[Area] = [Area].[Code]
83Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Sales Line].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Sales Line].[Transaction Specification] = [Transaction Specification].[Code]
84Tax Category SearchTax CategoryNormalCode10Tax Categorynvarchar(20)
85Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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$ext] 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]
86Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
87Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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$ext] 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]
88VAT Clause Code SearchTax Clause CodeNormalCode20VAT Clause Codenvarchar(40)
Key to join to the VAT Clause table.

Show/hide example query

SELECT
       [Sales Line].[VAT Clause Code]
       ,[VAT Clause].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
              ON
                     [Sales Line].[VAT Clause Code] = [VAT Clause].[Code]
89VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Sales Line].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Sales Line].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
90VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Sales Line].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Sales Line].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
91Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Line].[Currency Code] = [Currency].[Code]
92Outstanding Amount (LCY) SearchOutstanding Amount ($)NormalDecimal12Outstanding Amount (LCY)decimal(38,38)
93Shipped Not Invoiced (LCY) SearchShipped Not Invoiced ($) Incl. TaxNormalDecimal12Shipped Not Invoiced (LCY)decimal(38,38)
94Shipped Not Inv. (LCY) No VAT SearchShipped Not Invoiced ($)NormalDecimal12Shipped Not Inv_ (LCY) No VATdecimal(38,38)
95Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
96Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
97Blanket Order No. SearchBlanket Order No.NormalCode20Blanket Order No_nvarchar(40)
98Blanket Order Line No. SearchBlanket Order Line No.NormalInteger4Blanket Order Line No_int
99VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
100Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
101System-Created Entry SearchSystem-Created EntryNormalBoolean4
103Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
104VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
105Inv. Disc. Amount to Invoice SearchInv. Disc. Amount to InvoiceNormalDecimal12Inv_ Disc_ Amount to Invoicedecimal(38,38)
106VAT Identifier SearchTax IdentifierNormalCode20VAT Identifiernvarchar(40)
107IC Partner Ref. Type SearchIC Partner Ref. TypeNormalOption4IC Partner Ref_ Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Item”
  • “Charge (Item)”
  • “Cross Reference”
  • “Common Item No.”
  • “Vendor Item No.”
108IC Partner Reference SearchIC Partner ReferenceNormalCode20IC Partner Referencenvarchar(40)
109Prepayment % SearchPrepayment %NormalDecimal12Prepayment _decimal(38,38)
110Prepmt. Line Amount SearchPrepmt. Line AmountNormalDecimal12Prepmt_ Line Amountdecimal(38,38)
111Prepmt. Amt. Inv. SearchPrepmt. Amt. Inv.NormalDecimal12Prepmt_ Amt_ Inv_decimal(38,38)
112Prepmt. Amt. Incl. VAT SearchPrepmt. Amt. Incl. TaxNormalDecimal12Prepmt_ Amt_ Incl_ VATdecimal(38,38)
113Prepayment Amount SearchPrepayment AmountNormalDecimal12Prepayment Amountdecimal(38,38)
114Prepmt. VAT Base Amt. SearchPrepmt. Tax Base Amt.NormalDecimal12Prepmt_ VAT Base Amt_decimal(38,38)
115Prepayment VAT % SearchPrepayment Tax %NormalDecimal12Prepayment VAT _decimal(38,38)
116Prepmt. VAT Calc. Type SearchPrepmt. Tax Calc. TypeNormalOption4Prepmt_ VAT Calc_ Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
117Prepayment VAT Identifier SearchPrepayment Tax IdentifierNormalCode20Prepayment VAT Identifiernvarchar(40)
118Prepayment Tax Area Code SearchPrepayment Tax Area CodeNormalCode20Prepayment Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Sales Line].[Prepayment Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Sales Line].[Prepayment Tax Area Code] = [Tax Area].[Code]
119Prepayment Tax Liable SearchPrepayment Tax LiableNormalBoolean4Prepayment Tax Liabletinyint
120Prepayment Tax Group Code SearchPrepayment Tax Group CodeNormalCode20Prepayment Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Sales Line].[Prepayment Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Sales Line].[Prepayment Tax Group Code] = [Tax Group].[Code]
121Prepmt Amt to Deduct SearchPrepmt Amt to DeductNormalDecimal12Prepmt Amt to Deductdecimal(38,38)
122Prepmt Amt Deducted SearchPrepmt Amt DeductedNormalDecimal12Prepmt Amt Deducteddecimal(38,38)
123Prepayment Line SearchPrepayment LineNormalBoolean4Prepayment Linetinyint
124Prepmt. Amount Inv. Incl. VAT SearchPrepmt. Amount Inv. Incl. TaxNormalDecimal12Prepmt_ Amount Inv_ Incl_ VATdecimal(38,38)
129Prepmt. Amount Inv. (LCY) SearchPrepmt. Amount Inv. ($)NormalDecimal12Prepmt_ Amount Inv_ (LCY)decimal(38,38)
130IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(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$ext] 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]
132Prepmt. VAT Amount Inv. (LCY) SearchPrepmt. Tax Amount Inv. ($)NormalDecimal12Prepmt_ VAT Amount Inv_ (LCY)decimal(38,38)
135Prepayment VAT Difference SearchPrepayment Tax DifferenceNormalDecimal12Prepayment VAT Differencedecimal(38,38)
136Prepmt VAT Diff. to Deduct SearchPrepmt Tax Diff. to DeductNormalDecimal12Prepmt VAT Diff_ to Deductdecimal(38,38)
137Prepmt VAT Diff. Deducted SearchPrepmt Tax Diff. DeductedNormalDecimal12Prepmt VAT Diff_ Deducteddecimal(38,38)
138IC Item Reference No. SearchIC Item Reference No.NormalCode50IC Item Reference No_nvarchar(100)
145Pmt. Discount Amount SearchPmt. Discount AmountNormalDecimal12Pmt_ Discount Amountdecimal(38,38)
146Prepmt. Pmt. Discount Amount SearchPrepmt. Pmt. Discount AmountNormalDecimal12Prepmt_ Pmt_ Discount Amountdecimal(38,38)
180Line Discount Calculation SearchLine Discount CalculationNormalOption4Line Discount Calculationint
Available options are:
  • “None”
  • “%”
  • “Amount”
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Sales Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Sales Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
900Qty. to Assemble to Order SearchQty. to Assemble to OrderNormalDecimal12Qty_ to Assemble to Orderdecimal(38,38)
901Qty. to Asm. to Order (Base) SearchQty. to Asm. to Order (Base)NormalDecimal12Qty_ to Asm_ to Order (Base)decimal(38,38)
902ATO Whse. Outstanding Qty. SearchATO Whse. Outstanding Qty.FlowFieldDecimal12
903ATO Whse. Outstd. Qty. (Base) SearchATO Whse. Outstd. Qty. (Base)FlowFieldDecimal12
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job Contract Entry No. SearchJob Contract Entry No.NormalInteger4Job Contract Entry No_int
1300Posting Date SearchPosting DateFlowFieldDate4
1700Deferral Code SearchDeferral CodeNormalCode10Deferral Codenvarchar(20)
Key to join to the Deferral Template table.

Show/hide example query

SELECT
       [Sales Line].[Deferral Code]
       ,[Deferral Template].[Deferral Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
              ON
                     [Sales Line].[Deferral Code] = [Deferral Template].[Deferral Code]
1702Returns Deferral Start Date SearchReturns Deferral Start DateNormalDate4Returns Deferral Start Datedatetime
2675Selected Alloc. Account No. SearchAllocation Account No.NormalCode20Selected Alloc_ Account No_nvarchar(40)
Key to join to the Allocation Account table.

Show/hide example query

SELECT
       [Sales Line].[Selected Alloc_ Account No_]
       ,[Allocation Account].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Allocation Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Allocation Account]
              ON
                     [Sales Line].[Selected Alloc_ Account No_] = [Allocation Account].[No_]
2677Alloc. Acc. Modified by User SearchAllocation Account Distributions ModifiedFlowFieldBoolean4
2678Allocation Account No. SearchAllocation Account No.NormalCode20Allocation Account No_nvarchar(40)
Key to join to the Allocation Account table.

Show/hide example query

SELECT
       [Sales Line].[Allocation Account No_]
       ,[Allocation Account].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Allocation Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Allocation Account]
              ON
                     [Sales Line].[Allocation Account No_] = [Allocation Account].[No_]
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Sales Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Sales Line].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Sales Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Sales Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5405Planned SearchPlannedNormalBoolean4Plannedtinyint
5406Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5408Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
5415Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5416Outstanding Qty. (Base) SearchOutstanding Qty. (Base)NormalDecimal12Outstanding Qty_ (Base)decimal(38,38)
5417Qty. to Invoice (Base) SearchQty. to Invoice (Base)NormalDecimal12Qty_ to Invoice (Base)decimal(38,38)
5418Qty. to Ship (Base) SearchQty. to Ship (Base)NormalDecimal12Qty_ to Ship (Base)decimal(38,38)
5458Qty. Shipped Not Invd. (Base) SearchQty. Shipped Not Invd. (Base)NormalDecimal12Qty_ Shipped Not Invd_ (Base)decimal(38,38)
5460Qty. Shipped (Base) SearchQty. Shipped (Base)NormalDecimal12Qty_ Shipped (Base)decimal(38,38)
5461Qty. Invoiced (Base) SearchQty. Invoiced (Base)NormalDecimal12Qty_ Invoiced (Base)decimal(38,38)
5495Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
5600FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
5602Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Sales Line].[Depreciation Book Code]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Sales Line].[Depreciation Book Code] = [Depreciation Book].[Code]
5605Depr. until FA Posting Date SearchDepr. until FA Posting DateNormalBoolean4Depr_ until FA Posting Datetinyint
5612Duplicate in Depreciation Book SearchDuplicate in Depreciation BookNormalCode10Duplicate in Depreciation Booknvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Sales Line].[Duplicate in Depreciation Book]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Sales Line].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
5613Use Duplication List SearchUse Duplication ListNormalBoolean4Use Duplication Listtinyint
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Sales Line].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Sales Line].[Responsibility Center] = [Responsibility Center].[Code]
5701Out-of-Stock Substitution SearchOut-of-Stock SubstitutionNormalBoolean4Out-of-Stock Substitutiontinyint
5702Substitution Available SearchSubstitution AvailableFlowFieldBoolean4
5703Originally Ordered No. SearchOriginally Ordered No.NormalCode20Originally Ordered No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Sales Line].[Originally Ordered No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Sales Line].[Originally Ordered No_] = [Item].[No_]
5704Originally Ordered Var. Code SearchOriginally Ordered Var. CodeNormalCode10Originally Ordered Var_ Codenvarchar(20)
5705Cross-Reference No. SearchCross-Reference No.NormalCode20Cross-Reference No_nvarchar(40)
5706Unit of Measure (Cross Ref.) SearchUnit of Measure (Cross Ref.)NormalCode10Unit of Measure (Cross Ref_)nvarchar(20)
5707Cross-Reference Type SearchCross-Reference TypeNormalOption4Cross-Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5708Cross-Reference Type No. SearchCross-Reference Type No.NormalCode30Cross-Reference Type No_nvarchar(60)
5709Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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$ext] 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]
5710Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5711Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
       [Sales Line].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Sales Line].[Purchasing Code] = [Purchasing].[Code]
5712Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5713Special Order SearchSpecial OrderNormalBoolean4Special Ordertinyint
5714Special Order Purchase No. SearchSpecial Order Purchase No.NormalCode20Special Order Purchase No_nvarchar(40)
5715Special Order Purch. Line No. SearchSpecial Order Purch. Line No.NormalInteger4Special Order Purch_ Line No_int
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchReference Unit of MeasureNormalCode10Item Reference Unit of Measurenvarchar(20)
5727Item Reference Type SearchItem Reference TypeNormalOption4Item Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5728Item Reference Type No. SearchItem Reference Type No.NormalCode30Item Reference Type No_nvarchar(60)
5749Whse. Outstanding Qty. SearchWhse. Outstanding Qty.FlowFieldDecimal12
5750Whse. Outstanding Qty. (Base) SearchWhse. Outstanding Qty. (Base)FlowFieldDecimal12
5752Completely Shipped SearchCompletely ShippedNormalBoolean4Completely Shippedtinyint
5790Requested Delivery Date SearchRequested Delivery DateNormalDate4Requested Delivery Datedatetime
5791Promised Delivery Date SearchPromised Delivery DateNormalDate4Promised Delivery Datedatetime
5792Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
5793Outbound Whse. Handling Time SearchOutbound Whse. Handling TimeNormalDateFormula32Outbound Whse_ Handling Timevarchar(32)
5794Planned Delivery Date SearchPlanned Delivery DateNormalDate4Planned Delivery Datedatetime
5795Planned Shipment Date SearchPlanned Shipment DateNormalDate4Planned Shipment Datedatetime
5796Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
              ON
                     [Sales Line].[Shipping Agent Code] = [Shipping Agent].[Code]
5797Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
5800Allow Item Charge Assignment SearchAllow Item Charge AssignmentNormalBoolean4Allow Item Charge Assignmenttinyint
5801Qty. to Assign SearchQty. to AssignFlowFieldDecimal12
5802Qty. Assigned SearchQty. AssignedFlowFieldDecimal12
5803Return Qty. to Receive SearchReturn Qty. to ReceiveNormalDecimal12Return Qty_ to Receivedecimal(38,38)
5804Return Qty. to Receive (Base) SearchReturn Qty. to Receive (Base)NormalDecimal12Return Qty_ to Receive (Base)decimal(38,38)
5805Return Qty. Rcd. Not Invd. SearchReturn Qty. Rcd. Not Invd.NormalDecimal12Return Qty_ Rcd_ Not Invd_decimal(38,38)
5806Ret. Qty. Rcd. Not Invd.(Base) SearchRet. Qty. Rcd. Not Invd.(Base)NormalDecimal12Ret_ Qty_ Rcd_ Not Invd_(Base)decimal(38,38)
5807Return Rcd. Not Invd. SearchReturn Rcd. Not Invd.NormalDecimal12Return Rcd_ Not Invd_decimal(38,38)
5808Return Rcd. Not Invd. (LCY) SearchReturn Rcd. Not Invd. ($)NormalDecimal12Return Rcd_ Not Invd_ (LCY)decimal(38,38)
5809Return Qty. Received SearchReturn Qty. ReceivedNormalDecimal12Return Qty_ Receiveddecimal(38,38)
5810Return Qty. Received (Base) SearchReturn Qty. Received (Base)NormalDecimal12Return Qty_ Received (Base)decimal(38,38)
5811Appl.-from Item Entry SearchAppl.-from Item EntryNormalInteger4Appl_-from Item Entryint
5812Item Charge Qty. to Handle SearchItem Charge Qty. to HandleFlowFieldDecimal12
5909BOM Item No. SearchBOM Item No.NormalCode20BOM Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Sales Line].[BOM Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Sales Line].[BOM Item No_] = [Item].[No_]
6600Return Receipt No. SearchReturn Receipt No.NormalCode20Return Receipt No_nvarchar(40)
6601Return Receipt Line No. SearchReturn Receipt Line No.NormalInteger4Return Receipt Line No_int
6608Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

SELECT
       [Sales Line].[Return Reason Code]
       ,[Return Reason].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
              ON
                     [Sales Line].[Return Reason Code] = [Return Reason].[Code]
6610Copied From Posted Doc. SearchCopied From Posted Doc.NormalBoolean4Copied From Posted Doc_tinyint
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
7002Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Sales Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] 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].[Code]
7003Subtype SearchSubtypeNormalOption4Subtypeint
Available options are:
  • ” “
  • “Item – Inventory”
  • “Item – Service”
  • “Comment”
7004Price description SearchPrice descriptionNormalText80Price descriptionnvarchar(160)
7010Attached Doc Count SearchAttached Doc CountFlowFieldInteger4
7011Attached Lines Count SearchAttached Lines CountFlowFieldInteger4
10000Package Tracking No. SearchPackage Tracking No.NormalText30
10001Retention Attached to Line No. SearchRetention Attached to Line No.NormalInteger4
10002Retention VAT % SearchRetention tax %NormalDecimal12
10003Custom Transit Number SearchCustom Transit NumberNormalText30
30100Shpfy Order Line Id SearchShopify Order Line IdNormalBigInteger8
30101Shpfy Order No. SearchShopify Order No.NormalCode50
30103Shpfy Refund Id SearchShopify Refund IdNormalBigInteger8
30104Shpfy Refund Line Id SearchShopify Refund Line IdNormalBigInteger8
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Sales Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Sales Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Sales Line table

Leave a Reply

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