Service Line Price Adjmt.

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

Table Type: Company

Table Name: Service Line Price Adjmt.
Database Table Name: CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 6084

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Document Type]
   ,[Document No_]
   ,[Service Line No_]
   ,[Service Item Line No_]
   ,[Service Item No_]
   ,[Serv_ Price Adjmt_ Gr_ Code]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Quantity]
   ,[Amount]
   ,[New Amount]
   ,[Unit Price]
   ,[New Unit Price]
   ,[Unit Cost]
   ,[Discount _]
   ,[Discount Amount]
   ,[Amount incl_ VAT]
   ,[New Amount incl_ VAT]
   ,[Weight]
   ,[Adjustment Type]
   ,[Service Price Group Code]
   ,[Manually Adjusted]
   ,[Vat _]
   ,[New Amount Excl_ VAT]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line Price Adjmt.]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Service Line Price Adjmt.].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Service Line Price Adjmt.].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Service Line Price Adjmt.].[Document Type] = [Sales Header].[Document Type]
      AND
         [Service Line Price Adjmt.].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
      ON
         [Service Line Price Adjmt.].[Service Price Group Code] = [Service Price Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Line Price Adjmt.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Line Price Adjmt.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Line Price Adjmt. table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
2Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
3Service Line No. Primary Key SearchService Line No.NormalInteger4Service Line No_int
4Service Item Line No. Primary Key SearchService Item Line No.NormalInteger4Service Item Line No_int
5Service Item No. SearchService Item No.NormalCode20Service Item No_nvarchar(40)
Key to join to the Service Item table.

Show/hide example query

SELECT
       [Service Line Price Adjmt.].[Service Item No_]
       ,[Service Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line Price Adjmt.]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
              ON
                     [Service Line Price Adjmt.].[Service Item No_] = [Service Item].[No_]
6Serv. Price Adjmt. Gr. Code SearchServ. Price Adjmt. Gr. CodeNormalCode10Serv_ Price Adjmt_ Gr_ Codenvarchar(20)
Key to join to the Service Price Adjustment Group table.

Show/hide example query

SELECT
       [Service Line Price Adjmt.].[Serv_ Price Adjmt_ Gr_ Code]
       ,[Service Price Adjustment Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line Price Adjmt.]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Adjustment Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Adjustment Group]
              ON
                     [Service Line Price Adjmt.].[Serv_ Price Adjmt_ Gr_ Code] = [Service Price Adjustment Group].[Code]
7Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Item”
  • “Resource”
  • “Cost”
  • “G/L Account”
8No. SearchNo.NormalCode20No_nvarchar(40)
9Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
14Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
15New Amount SearchNew AmountNormalDecimal12New Amountdecimal(38,38)
16Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
17New Unit Price SearchNew Unit PriceNormalDecimal12New Unit Pricedecimal(38,38)
18Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
19Discount % SearchDiscount %NormalDecimal12Discount _decimal(38,38)
20Discount Amount SearchDiscount AmountNormalDecimal12Discount Amountdecimal(38,38)
21Amount incl. VAT SearchAmount incl. TaxNormalDecimal12Amount incl_ VATdecimal(38,38)
22New Amount incl. VAT SearchNew Amount incl. TaxNormalDecimal12New Amount incl_ VATdecimal(38,38)
24Weight SearchWeightNormalDecimal12Weightdecimal(38,38)
25Adjustment Type SearchAdjustment TypeNormalOption4Adjustment Typeint
Available options are:
  • “Fixed”
  • “Maximum”
  • “Minimum”
26Service Price Group Code SearchService Price Group CodeNormalCode10Service Price Group Codenvarchar(20)
Key to join to the Service Price Group table.

Show/hide example query

SELECT
       [Service Line Price Adjmt.].[Service Price Group Code]
       ,[Service Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line Price Adjmt.]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
              ON
                     [Service Line Price Adjmt.].[Service Price Group Code] = [Service Price Group].[Code]
27Manually Adjusted SearchManually AdjustedNormalBoolean4Manually Adjustedtinyint
28Vat % SearchTax %NormalDecimal12Vat _decimal(38,38)
29New Amount Excl. VAT SearchNew Amount Excl. TaxNormalDecimal12New Amount Excl_ VATdecimal(38,38)
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
       [Service Line Price Adjmt.].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line Price Adjmt.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Line Price Adjmt.].[$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
       [Service Line Price Adjmt.].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Line Price Adjmt_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line Price Adjmt.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Line Price Adjmt.].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Line Price Adjmt. table

Leave a Reply

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