Service Shipment Line

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

Table Type: Company

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

Table Number: 5991

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 Shipment 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 Service Shipment Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

3Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Item”
  • “Resource”
  • “Cost”
  • “G/L 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

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)
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
39Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
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

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

Show/hide example query

58Qty. Shipped Not Invoiced SearchQty. Shipped Not InvoicedNormalDecimal12Qty_ Shipped Not Invoiceddecimal(38,38)
61Quantity Invoiced SearchQuantity InvoicedNormalDecimal12Quantity Invoiceddecimal(38,38)
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

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

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

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

91Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

99VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
100Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

950Time Sheet No. SearchTime Sheet No.NormalCode20Time Sheet No_nvarchar(40)
951Time Sheet Line No. SearchTime Sheet Line No.NormalInteger4Time Sheet Line No_int
952Time Sheet Date SearchTime Sheet DateNormalDate4Time Sheet Datedatetime
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)
5458Qty. Shipped Not Invd. (Base) SearchQty. Shipped Not Invd. (Base)NormalDecimal12Qty_ Shipped Not Invd_ (Base)decimal(38,38)
5461Qty. Invoiced (Base) SearchQty. Invoiced (Base)NormalDecimal12Qty_ Invoiced (Base)decimal(38,38)
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

5709Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

5710Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5712Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5817Correction SearchCorrectionNormalBoolean4Correctiontinyint
5901Appl.-to Warranty Entry SearchAppl.-to Warranty EntryNormalInteger4Appl_-to Warranty Entryint
5902Service Item No. SearchService Item No.NormalCode20Service Item No_nvarchar(40)
Key to join to the Service Item table.

Show/hide example query

5903Appl.-to Service Entry SearchAppl.-to Service EntryNormalInteger4Appl_-to Service Entryint
5904Service Item Line No. SearchService Item Line No.NormalInteger4Service Item Line No_int
5905Service Item Serial No. SearchService Item Serial No.NormalCode50Service Item Serial No_nvarchar(100)
5906Service Item Line Description SearchService Item Line DescriptionNormalText100Service Item Line Descriptionnvarchar(200)
5908Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5909Order Date SearchOrder DateNormalDate4Order Datedatetime
5910Needed by Date SearchNeeded by DateNormalDate4Needed by Datedatetime
5916Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

5918Quantity Consumed SearchQuantity ConsumedNormalDecimal12Quantity Consumeddecimal(38,38)
5920Qty. Consumed (Base) SearchQty. Consumed (Base)NormalDecimal12Qty_ Consumed (Base)decimal(38,38)
5928Service Price Group Code SearchService Price Group CodeNormalCode10Service Price Group Codenvarchar(20)
Key to join to the Service Price Group table.

Show/hide example query

5929Fault Area Code SearchFault Area CodeNormalCode10Fault Area Codenvarchar(20)
Key to join to the Fault Area table.

Show/hide example query

5930Symptom Code SearchSymptom CodeNormalCode10Symptom Codenvarchar(20)
Key to join to the Symptom Code table.

Show/hide example query

5931Fault Code SearchFault CodeNormalCode10Fault Codenvarchar(20)
5932Resolution Code SearchResolution CodeNormalCode10Resolution Codenvarchar(20)
Key to join to the Resolution Code table.

Show/hide example query

5933Exclude Warranty SearchExclude WarrantyNormalBoolean4Exclude Warrantytinyint
5934Warranty SearchWarrantyNormalBoolean4Warrantytinyint
5936Contract No. SearchContract No.NormalCode20Contract No_nvarchar(40)
5938Contract Disc. % SearchContract Disc. %NormalDecimal12Contract Disc_ _decimal(38,38)
5939Warranty Disc. % SearchWarranty Disc. %NormalDecimal12Warranty Disc_ _decimal(38,38)
5965Component Line No. SearchComponent Line No.NormalInteger4Component Line No_int
5966Spare Part Action SearchSpare Part ActionNormalOption4Spare Part Actionint
Available options are:
  • ” “
  • “Permanent”
  • “Temporary”
  • “Component Replaced”
  • “Component Installed”
5967Fault Reason Code SearchFault Reason CodeNormalCode10Fault Reason Codenvarchar(20)
Key to join to the Fault Reason Code table.

Show/hide example query

5968Replaced Item No. SearchReplaced Item No.NormalCode20Replaced Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

5969Exclude Contract Discount SearchExclude Contract DiscountNormalBoolean4Exclude Contract Discounttinyint
5970Replaced Item Type SearchReplaced Item TypeNormalOption4Replaced Item Typeint
Available options are:
  • ” “
  • “Service Item”
  • “Item”
5994Price Adjmt. Status SearchPrice Adjmt. StatusNormalOption4Price Adjmt_ Statusint
Available options are:
  • ” “
  • “Adjusted”
  • “Modified”
5997Line Discount Type SearchLine Discount TypeNormalOption4Line Discount Typeint
Available options are:
  • ” “
  • “Warranty Disc.”
  • “Contract Disc.”
  • “Line Disc.”
  • “Manual”
5999Copy Components From SearchCopy Components FromNormalOption4Copy Components Fromint
Available options are:
  • “None”
  • “Item BOM”
  • “Old Service Item”
  • “Old Serv.Item w/o Serial No.”
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

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 Service Shipment Line table

Leave a Reply

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