Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/609
Table Type: Company
Table Name: Buffer IC Inbox Sales Line
Database Table Name: CRONUS UK Ltd_$Buffer IC Inbox Sales 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 Buffer IC Inbox Sales 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 Buffer IC Inbox Sales Line table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Document Type | Document Type | Normal | Option | 4 | Document Type | int |
Available options are:
| |||||||
3 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
4 | Line No. | Line No. | Normal | Integer | 4 | Line No_ | int |
11 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
12 | Description 2 | Description 2 | Normal | Text | 50 | Description 2 | nvarchar(100) |
15 | Quantity | Quantity | Normal | Decimal | 12 | Quantity | decimal(38,38) |
22 | Unit Price | Unit Price | Normal | Decimal | 12 | Unit Price | 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) |
30 | Amount Including VAT | Amount Including VAT | Normal | Decimal | 12 | Amount Including VAT | decimal(38,38) |
45 | Job No. | Job No. | Normal | Code | 20 | Job No_ | nvarchar(40) |
Key to join to the Job table.Show/hide example query | |||||||
73 | Drop Shipment | Drop Shipment | Normal | Boolean | 4 | Drop Shipment | tinyint |
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 | VAT Base Amount | Normal | Decimal | 12 | VAT Base Amount | decimal(38,38) |
103 | Line Amount | Line Amount | Normal | Decimal | 12 | Line Amount | decimal(38,38) |
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) |
125 | 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 | |||||||
126 | IC Transaction No. | IC Transaction No. | Normal | Integer | 4 | IC Transaction No_ | int |
127 | Transaction Source | Transaction Source | Normal | Option | 4 | Transaction Source | int |
Available options are:
| |||||||
128 | Item Ref. | Item Ref. | Normal | Option | 4 | Item Ref_ | int |
Available options are:
| |||||||
138 | IC Item Reference No. | IC Item Reference No. | Normal | Code | 50 | IC Item Reference No_ | nvarchar(100) |
5407 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
5790 | Requested Delivery Date | Requested Delivery Date | Normal | Date | 4 | Requested Delivery Date | datetime |
5791 | Promised Delivery Date | Promised Delivery Date | Normal | Date | 4 | Promised Delivery Date | datetime |
8100 | Operation ID | Operation ID | Normal | GUID | 16 | Operation ID | uniqueidentifier |
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 |