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
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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
2 | Sell-to Customer No. | Sell-to Customer No. | Normal | Code | 20 | Sell-to 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) |
Key to join to the Sales Cr.Memo Header table.Show/hide example query | |||||||
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 | |||||||
10 | Shipment Date | Shipment Date | Normal | Date | 4 | Shipment Date | datetime |
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) |
28 | Line Discount Amount | Line Discount Amount | Normal | Decimal | 12 | Line Discount Amount | decimal(38,38) |
29 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
30 | Amount Including VAT | Amount Including Tax | Normal | Decimal | 12 | Amount Including VAT | 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 |
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 | |||||||
45 | Job No. | Job No. | Normal | Code | 20 | Job No_ | nvarchar(40) |
Key to join to the Job 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 | |||||||
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 | |||||||
69 | Inv. Discount Amount | Inv. Discount Amount | Normal | Decimal | 12 | Inv_ Discount Amount | decimal(38,38) |
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 | |||||||
84 | Tax Category | Tax Category | Normal | Code | 10 | Tax Category | nvarchar(20) |
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 | |||||||
88 | VAT Clause Code | Tax Clause Code | Normal | Code | 20 | VAT Clause Code | nvarchar(40) |
Key to join to the VAT Clause 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 | |||||||
97 | Blanket Order No. | Blanket Order No. | Normal | Code | 20 | Blanket Order No_ | nvarchar(40) |
98 | Blanket Order Line No. | Blanket Order Line No. | Normal | Integer | 4 | Blanket Order Line No_ | int |
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) |
101 | System-Created Entry | System-Created Entry | Normal | Boolean | 4 | ||
103 | Line Amount | Line Amount | Normal | Decimal | 12 | Line Amount | decimal(38,38) |
104 | VAT Difference | Tax Difference | Normal | Decimal | 12 | VAT Difference | decimal(38,38) |
106 | VAT Identifier | Tax Identifier | Normal | Code | 20 | VAT Identifier | nvarchar(40) |
107 | IC Partner Ref. Type | IC Partner Ref. Type | Normal | Option | 4 | IC Partner Ref_ Type | int |
Available options are:
| |||||||
108 | IC Partner Reference | IC Partner Reference | Normal | Code | 20 | IC Partner Reference | nvarchar(40) |
123 | Prepayment Line | Prepayment Line | Normal | Boolean | 4 | Prepayment Line | tinyint |
130 | IC Partner Code | IC Partner Code | Normal | Code | 20 | IC Partner Code | nvarchar(40) |
Key to join to the IC Partner table.Show/hide example query | |||||||
131 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
138 | IC Item Reference No. | IC Item Reference No. | Normal | Code | 50 | IC Item Reference No_ | nvarchar(100) |
145 | Pmt. Discount Amount | Pmt. Discount Amount | Normal | Decimal | 12 | Pmt_ Discount Amount | decimal(38,38) |
180 | Line Discount Calculation | Line Discount Calculation | Normal | Option | 4 | Line Discount Calculation | int |
Available options are:
| |||||||
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 | |||||||
1001 | Job Task No. | Job Task No. | Normal | Code | 20 | Job Task No_ | nvarchar(40) |
1002 | Job Contract Entry No. | Job Contract Entry No. | Normal | Integer | 4 | Job Contract Entry No_ | int |
1700 | Deferral Code | Deferral Code | Normal | Code | 10 | Deferral Code | nvarchar(20) |
Key to join to the Deferral Template table.Show/hide example query | |||||||
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) |
5600 | FA Posting Date | FA Posting Date | Normal | Date | 4 | FA Posting Date | datetime |
5602 | Depreciation Book Code | Depreciation Book Code | Normal | Code | 10 | Depreciation Book Code | nvarchar(20) |
Key to join to the Depreciation Book table.Show/hide example query | |||||||
5605 | Depr. until FA Posting Date | Depr. until FA Posting Date | Normal | Boolean | 4 | Depr_ until FA Posting Date | tinyint |
5612 | Duplicate in Depreciation Book | Duplicate in Depreciation Book | Normal | Code | 10 | Duplicate in Depreciation Book | nvarchar(20) |
Key to join to the Depreciation Book table.Show/hide example query | |||||||
5613 | Use Duplication List | Use Duplication List | Normal | Boolean | 4 | Use Duplication List | tinyint |
5700 | Responsibility Center | Responsibility Center | Normal | Code | 10 | Responsibility Center | nvarchar(20) |
Key to join to the Responsibility Center table.Show/hide example query | |||||||
5705 | Cross-Reference No. | Cross-Reference No. | Normal | Code | 20 | Cross-Reference No_ | nvarchar(40) |
5706 | Unit of Measure (Cross Ref.) | Unit of Measure (Cross Ref.) | Normal | Code | 10 | Unit of Measure (Cross Ref_) | nvarchar(20) |
5707 | Cross-Reference Type | Cross-Reference Type | Normal | Option | 4 | Cross-Reference Type | int |
Available options are:
| |||||||
5708 | Cross-Reference Type No. | Cross-Reference Type No. | Normal | Code | 30 | Cross-Reference Type No_ | nvarchar(60) |
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 |
5711 | Purchasing Code | Purchasing Code | Normal | Code | 10 | Purchasing Code | nvarchar(20) |
Key to join to the Purchasing table.Show/hide example query | |||||||
5712 | Product Group Code | Product Group Code | Normal | Code | 10 | Product Group Code | nvarchar(20) |
5725 | Item Reference No. | Item Reference No. | Normal | Code | 50 | Item Reference No_ | nvarchar(100) |
5726 | Item Reference Unit of Measure | Unit of Measure (Item Ref.) | Normal | Code | 10 | Item Reference Unit of Measure | nvarchar(20) |
5727 | Item Reference Type | Item Reference Type | Normal | Option | 4 | Item Reference Type | int |
Available options are:
| |||||||
5728 | Item Reference Type No. | Item Reference Type No. | Normal | Code | 30 | Item Reference Type No_ | nvarchar(60) |
5811 | Appl.-from Item Entry | Appl.-from Item Entry | Normal | Integer | 4 | Appl_-from Item Entry | int |
6600 | Return Receipt No. | Return Receipt No. | Normal | Code | 20 | Return Receipt No_ | nvarchar(40) |
6601 | Return Receipt Line No. | Return Receipt Line No. | Normal | Integer | 4 | Return Receipt Line No_ | int |
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 | |||||||
10000 | Package Tracking No. | Package Tracking No. | Normal | Text | 30 | ||
10001 | Retention Attached to Line No. | Retention Attached to Line No. | Normal | Integer | 4 | ||
10002 | Retention VAT % | Retention tax % | Normal | Decimal | 12 | ||
30103 | Shpfy Refund Id | Shpfy Refund Id | Normal | BigInteger | 8 | ||
Key to join to the Shpfy Refund Header table.Show/hide example query | |||||||
30104 | Shpfy Refund Line Id | Shopify Refund Line Id | Normal | BigInteger | 8 | ||
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 |