Sales Cr.Memo Line

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

Table Type: Company

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

Table Number: 115

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

Show/hide an example select of all columns

Show/hide an example select of all columns by name

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

Show/hide columns in Sales Cr.Memo Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
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

3Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
Key to join to the Sales Cr.Memo Header table.

Show/hide example query

4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Type Primary Key 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

8Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

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

15Quantity SearchQuantityNormalDecimal12Quantitydecimal(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

41Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

42Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

45Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

52Work Type Code SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

65Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
66Order Line No. SearchOrder Line No.NormalInteger4Order Line No_int
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

69Inv. Discount Amount SearchInv. Discount AmountNormalDecimal12Inv_ Discount Amountdecimal(38,38)
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

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

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

79Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

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

82Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

83Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

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

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

88VAT Clause Code SearchTax Clause CodeNormalCode20VAT Clause Codenvarchar(40)
Key to join to the VAT Clause table.

Show/hide example query

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

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

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)
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)
123Prepayment Line SearchPrepayment LineNormalBoolean4Prepayment Linetinyint
130IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

131Posting Date SearchPosting DateNormalDate4Posting Datedatetime
138IC Item Reference No. SearchIC Item Reference No.NormalCode50IC Item Reference No_nvarchar(100)
145Pmt. Discount Amount SearchPmt. Discount AmountNormalDecimal12Pmt_ 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

1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job Contract Entry No. SearchJob Contract Entry No.NormalInteger4Job Contract Entry No_int
1700Deferral Code SearchDeferral CodeNormalCode10Deferral Codenvarchar(20)
Key to join to the Deferral Template table.

Show/hide example query

5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5415Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
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

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

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

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

5710Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5711Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

5712Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchUnit of Measure (Item Ref.)NormalCode10Item 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)
5811Appl.-from Item Entry SearchAppl.-from Item EntryNormalInteger4Appl_-from Item Entryint
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

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

10000Package Tracking No. SearchPackage Tracking No.NormalText30
10001Retention Attached to Line No. SearchRetention Attached to Line No.NormalInteger4
10002Retention VAT % SearchRetention tax %NormalDecimal12
30103Shpfy Refund Id SearchShpfy Refund IdNormalBigInteger8
Key to join to the Shpfy Refund Header table.

Show/hide example query

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

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Sales Cr.Memo Line table

Leave a Reply

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