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
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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
2 | Customer No. | Customer No. | Normal | Code | 20 | Customer No_ | nvarchar(40) |
Key to join to the Customer table.Show/hide example query | |||||||
3 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
4 | Line No. | Line No. | Normal | Integer | 4 | Line No_ | int |
5 | Type | Type | Normal | Option | 4 | Type | int |
Available options are:
| |||||||
6 | No. | No. | Normal | Code | 20 | No_ | nvarchar(40) |
7 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
Key to join to the Location table.Show/hide example query | |||||||
8 | Posting Group | Posting Group | Normal | Code | 20 | Posting Group | nvarchar(40) |
Key to join to the Customer Posting Group table.Show/hide example query | |||||||
11 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
12 | Description 2 | Description 2 | Normal | Text | 50 | Description 2 | nvarchar(100) |
13 | Unit of Measure | Unit of Measure | Normal | Text | 50 | Unit of Measure | nvarchar(100) |
Key to join to the Unit of Measure table.Show/hide example query | |||||||
15 | Quantity | Quantity | Normal | Decimal | 12 | Quantity | decimal(38,38) |
22 | Unit Price | Unit Price | Normal | Decimal | 12 | Unit Price | decimal(38,38) |
23 | Unit Cost (LCY) | Unit Cost ($) | Normal | Decimal | 12 | Unit Cost (LCY) | decimal(38,38) |
25 | VAT % | Tax % | Normal | Decimal | 12 | VAT _ | decimal(38,38) |
27 | Line Discount % | Line Discount % | Normal | Decimal | 12 | Line Discount _ | decimal(38,38) |
32 | Allow Invoice Disc. | Allow Invoice Disc. | Normal | Boolean | 4 | Allow Invoice Disc_ | tinyint |
34 | Gross Weight | Gross Weight | Normal | Decimal | 12 | Gross Weight | decimal(38,38) |
35 | Net Weight | Net Weight | Normal | Decimal | 12 | Net Weight | decimal(38,38) |
36 | Units per Parcel | Units per Parcel | Normal | Decimal | 12 | Units per Parcel | decimal(38,38) |
37 | Unit Volume | Unit Volume | Normal | Decimal | 12 | Unit Volume | decimal(38,38) |
38 | Appl.-to Item Entry | Appl.-to Item Entry | Normal | Integer | 4 | Appl_-to Item Entry | int |
39 | Item Shpt. Entry No. | Item Shpt. Entry No. | Normal | Integer | 4 | Item Shpt_ Entry No_ | int |
40 | Shortcut Dimension 1 Code | Shortcut Dimension 1 Code | Normal | Code | 20 | Shortcut Dimension 1 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example query | |||||||
41 | Shortcut Dimension 2 Code | Shortcut Dimension 2 Code | Normal | Code | 20 | Shortcut Dimension 2 Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example query | |||||||
42 | Customer Price Group | Customer Price Group | Normal | Code | 10 | Customer Price Group | nvarchar(20) |
Key to join to the Customer Price Group table.Show/hide example query | |||||||
52 | Work Type Code | Work Type Code | Normal | Code | 10 | Work Type Code | nvarchar(20) |
Key to join to the Work Type table.Show/hide example query | |||||||
58 | Qty. Shipped Not Invoiced | Qty. Shipped Not Invoiced | Normal | Decimal | 12 | Qty_ Shipped Not Invoiced | decimal(38,38) |
61 | Quantity Invoiced | Quantity Invoiced | Normal | Decimal | 12 | Quantity Invoiced | decimal(38,38) |
65 | Order No. | Order No. | Normal | Code | 20 | Order No_ | nvarchar(40) |
66 | Order Line No. | Order Line No. | Normal | Integer | 4 | Order Line No_ | int |
68 | Bill-to Customer No. | Bill-to Customer No. | Normal | Code | 20 | Bill-to Customer No_ | nvarchar(40) |
Key to join to the Customer table.Show/hide example query | |||||||
74 | Gen. Bus. Posting Group | Gen. Bus. Posting Group | Normal | Code | 20 | Gen_ Bus_ Posting Group | nvarchar(40) |
Key to join to the Gen. Business Posting Group table.Show/hide example query | |||||||
75 | Gen. Prod. Posting Group | Gen. Prod. Posting Group | Normal | Code | 20 | Gen_ Prod_ Posting Group | nvarchar(40) |
Key to join to the Gen. Product Posting Group table.Show/hide example query | |||||||
77 | VAT Calculation Type | VAT Calculation Type | Normal | Option | 4 | VAT Calculation Type | int |
Available options are:
| |||||||
78 | Transaction Type | Transaction Type | Normal | Code | 10 | Transaction Type | nvarchar(20) |
Key to join to the Transaction Type table.Show/hide example query | |||||||
79 | Transport Method | Transport Method | Normal | Code | 10 | Transport Method | nvarchar(20) |
Key to join to the Transport Method table.Show/hide example query | |||||||
80 | Attached to Line No. | Attached to Line No. | Normal | Integer | 4 | Attached to Line No_ | int |
81 | Exit Point | Exit Point | Normal | Code | 10 | Exit Point | nvarchar(20) |
Key to join to the Entry/Exit Point table.Show/hide example query | |||||||
82 | Area | Area | Normal | Code | 10 | Area | nvarchar(20) |
Key to join to the Area table.Show/hide example query | |||||||
83 | Transaction Specification | Transaction Specification | Normal | Code | 10 | Transaction Specification | nvarchar(20) |
Key to join to the Transaction Specification table.Show/hide example query | |||||||
85 | Tax Area Code | Tax Area Code | Normal | Code | 20 | Tax Area Code | nvarchar(40) |
Key to join to the Tax Area table.Show/hide example query | |||||||
86 | Tax Liable | Tax Liable | Normal | Boolean | 4 | Tax Liable | tinyint |
87 | Tax Group Code | Tax Group Code | Normal | Code | 20 | Tax Group Code | nvarchar(40) |
Key to join to the Tax Group table.Show/hide example query | |||||||
89 | VAT Bus. Posting Group | VAT Bus. Posting Group | Normal | Code | 20 | VAT Bus_ Posting Group | nvarchar(40) |
Key to join to the VAT Business Posting Group table.Show/hide example query | |||||||
90 | VAT Prod. Posting Group | VAT Prod. Posting Group | Normal | Code | 20 | VAT Prod_ Posting Group | nvarchar(40) |
Key to join to the VAT Product Posting Group table.Show/hide example query | |||||||
91 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
Key to join to the Currency table.Show/hide example query | |||||||
99 | VAT Base Amount | Tax Base Amount | Normal | Decimal | 12 | VAT Base Amount | decimal(38,38) |
100 | Unit Cost | Unit Cost | Normal | Decimal | 12 | Unit Cost | decimal(38,38) |
480 | Dimension Set ID | Dimension Set ID | Normal | Integer | 4 | Dimension Set ID | int |
Key to join to the Dimension Set Entry table.Show/hide example query | |||||||
950 | Time Sheet No. | Time Sheet No. | Normal | Code | 20 | Time Sheet No_ | nvarchar(40) |
951 | Time Sheet Line No. | Time Sheet Line No. | Normal | Integer | 4 | Time Sheet Line No_ | int |
952 | Time Sheet Date | Time Sheet Date | Normal | Date | 4 | Time Sheet Date | datetime |
5402 | Variant Code | Variant Code | Normal | Code | 10 | Variant Code | nvarchar(20) |
Key to join to the Item Variant table.Show/hide example query | |||||||
5403 | Bin Code | Bin Code | Normal | Code | 20 | Bin Code | nvarchar(40) |
Key to join to the Bin table.Show/hide example query | |||||||
5404 | Qty. per Unit of Measure | Qty. per Unit of Measure | Normal | Decimal | 12 | Qty_ per Unit of Measure | decimal(38,38) |
5407 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
5415 | Quantity (Base) | Quantity (Base) | Normal | Decimal | 12 | Quantity (Base) | decimal(38,38) |
5458 | Qty. Shipped Not Invd. (Base) | Qty. Shipped Not Invd. (Base) | Normal | Decimal | 12 | Qty_ Shipped Not Invd_ (Base) | decimal(38,38) |
5461 | Qty. Invoiced (Base) | Qty. Invoiced (Base) | Normal | Decimal | 12 | Qty_ Invoiced (Base) | decimal(38,38) |
5700 | Responsibility Center | Responsibility Center | Normal | Code | 10 | Responsibility Center | nvarchar(20) |
Key to join to the Responsibility Center table.Show/hide example query | |||||||
5709 | Item Category Code | Item Category Code | Normal | Code | 20 | Item Category Code | nvarchar(40) |
Key to join to the Item Category table.Show/hide example query | |||||||
5710 | Nonstock | Catalog | Normal | Boolean | 4 | Nonstock | tinyint |
5712 | Product Group Code | Product Group Code | Normal | Code | 10 | Product Group Code | nvarchar(20) |
5817 | Correction | Correction | Normal | Boolean | 4 | Correction | tinyint |
5901 | Appl.-to Warranty Entry | Appl.-to Warranty Entry | Normal | Integer | 4 | Appl_-to Warranty Entry | int |
5902 | Service Item No. | Service Item No. | Normal | Code | 20 | Service Item No_ | nvarchar(40) |
Key to join to the Service Item table.Show/hide example query | |||||||
5903 | Appl.-to Service Entry | Appl.-to Service Entry | Normal | Integer | 4 | Appl_-to Service Entry | int |
5904 | Service Item Line No. | Service Item Line No. | Normal | Integer | 4 | Service Item Line No_ | int |
5905 | Service Item Serial No. | Service Item Serial No. | Normal | Code | 50 | Service Item Serial No_ | nvarchar(100) |
5906 | Service Item Line Description | Service Item Line Description | Normal | Text | 100 | Service Item Line Description | nvarchar(200) |
5908 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
5909 | Order Date | Order Date | Normal | Date | 4 | Order Date | datetime |
5910 | Needed by Date | Needed by Date | Normal | Date | 4 | Needed by Date | datetime |
5916 | Ship-to Code | Ship-to Code | Normal | Code | 10 | Ship-to Code | nvarchar(20) |
Key to join to the Ship-to Address table.Show/hide example query | |||||||
5918 | Quantity Consumed | Quantity Consumed | Normal | Decimal | 12 | Quantity Consumed | decimal(38,38) |
5920 | Qty. Consumed (Base) | Qty. Consumed (Base) | Normal | Decimal | 12 | Qty_ Consumed (Base) | decimal(38,38) |
5928 | Service Price Group Code | Service Price Group Code | Normal | Code | 10 | Service Price Group Code | nvarchar(20) |
Key to join to the Service Price Group table.Show/hide example query | |||||||
5929 | Fault Area Code | Fault Area Code | Normal | Code | 10 | Fault Area Code | nvarchar(20) |
Key to join to the Fault Area table.Show/hide example query | |||||||
5930 | Symptom Code | Symptom Code | Normal | Code | 10 | Symptom Code | nvarchar(20) |
Key to join to the Symptom Code table.Show/hide example query | |||||||
5931 | Fault Code | Fault Code | Normal | Code | 10 | Fault Code | nvarchar(20) |
5932 | Resolution Code | Resolution Code | Normal | Code | 10 | Resolution Code | nvarchar(20) |
Key to join to the Resolution Code table.Show/hide example query | |||||||
5933 | Exclude Warranty | Exclude Warranty | Normal | Boolean | 4 | Exclude Warranty | tinyint |
5934 | Warranty | Warranty | Normal | Boolean | 4 | Warranty | tinyint |
5936 | Contract No. | Contract No. | Normal | Code | 20 | Contract No_ | nvarchar(40) |
5938 | Contract Disc. % | Contract Disc. % | Normal | Decimal | 12 | Contract Disc_ _ | decimal(38,38) |
5939 | Warranty Disc. % | Warranty Disc. % | Normal | Decimal | 12 | Warranty Disc_ _ | decimal(38,38) |
5965 | Component Line No. | Component Line No. | Normal | Integer | 4 | Component Line No_ | int |
5966 | Spare Part Action | Spare Part Action | Normal | Option | 4 | Spare Part Action | int |
Available options are:
| |||||||
5967 | Fault Reason Code | Fault Reason Code | Normal | Code | 10 | Fault Reason Code | nvarchar(20) |
Key to join to the Fault Reason Code table.Show/hide example query | |||||||
5968 | Replaced Item No. | Replaced Item No. | Normal | Code | 20 | Replaced Item No_ | nvarchar(40) |
Key to join to the Item table.Show/hide example query | |||||||
5969 | Exclude Contract Discount | Exclude Contract Discount | Normal | Boolean | 4 | Exclude Contract Discount | tinyint |
5970 | Replaced Item Type | Replaced Item Type | Normal | Option | 4 | Replaced Item Type | int |
Available options are:
| |||||||
5994 | Price Adjmt. Status | Price Adjmt. Status | Normal | Option | 4 | Price Adjmt_ Status | int |
Available options are:
| |||||||
5997 | Line Discount Type | Line Discount Type | Normal | Option | 4 | Line Discount Type | int |
Available options are:
| |||||||
5999 | Copy Components From | Copy Components From | Normal | Option | 4 | Copy Components From | int |
Available options are:
| |||||||
6608 | Return Reason Code | Return Reason Code | Normal | Code | 10 | Return Reason Code | nvarchar(20) |
Key to join to the Return Reason table.Show/hide example query | |||||||
7000 | Price Calculation Method | Price Calculation Method | Normal | Option | 4 | Price Calculation Method | int |
Available options are:
| |||||||
7001 | Allow Line Disc. | Allow Line Disc. | Normal | Boolean | 4 | Allow Line Disc_ | tinyint |
7002 | Customer Disc. Group | Customer Disc. Group | Normal | Code | 20 | Customer Disc_ Group | nvarchar(40) |
Key to join to the Customer Discount Group table.Show/hide example query | |||||||
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example query | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |