Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1315
Table Type: Company
Table Name: Purch. Price Line Disc. Buff.
Database Table Name: CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 1315Due 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 Purch. Price Line Disc. Buff. can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Currency Code]
,[Starting Date]
,[Line Discount _]
,[Direct Unit Cost]
,[Minimum Quantity]
,[Ending Date]
,[Line Type]
,[Item No_]
,[Vendor No_]
,[Unit of Measure Code]
,[Variant Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Price Line Disc. Buff.]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Purch. Price Line Disc. Buff.].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Purch. Price Line Disc. Buff.].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Purch. Price Line Disc. Buff.].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
[User] AS [User]
ON
[Purch. Price Line Disc. Buff.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Purch. Price Line Disc. Buff.].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 3 | Currency Code  | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
| Key to join to the Currency table.SELECT
[Purch. Price Line Disc. Buff.].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Price Line Disc. Buff.]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Purch. Price Line Disc. Buff.].[Currency Code] = [Currency].[Code] |
| 4 | Starting Date  | Starting Date | Normal | Date | 4 | Starting Date | datetime |
| 5 | Line Discount % | Line Discount % | Normal | Decimal | 12 | Line Discount _ | decimal(38,38) |
| 6 | Direct Unit Cost | Direct Unit Cost | Normal | Decimal | 12 | Direct Unit Cost | decimal(38,38) |
| 14 | Minimum Quantity | Minimum Quantity | Normal | Decimal | 12 | Minimum Quantity | decimal(38,38) |
| 15 | Ending Date | Ending Date | Normal | Date | 4 | Ending Date | datetime |
| Key to join to the Inventory Period table.SELECT
[Purch. Price Line Disc. Buff.].[Ending Date]
,[Inventory Period].[Ending Date]
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Price Line Disc. Buff.]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Purch. Price Line Disc. Buff.].[Ending Date] = [Inventory Period].[Ending Date] |
| 1300 | Line Type | Line Type | Normal | Option | 4 | Line Type | int |
| Available options are:
- ” “
- “Purchase Line Discount”
- “Purchase Price”
|
| 1301 | Item No. | Item No. | Normal | Code | 20 | Item No_ | nvarchar(40) |
| Key to join to the Item table.SELECT
[Purch. Price Line Disc. Buff.].[Item No_]
,[Item].[No_]
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Price Line Disc. Buff.]
LEFT JOIN
[CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
ON
[Purch. Price Line Disc. Buff.].[Item No_] = [Item].[No_] |
| 1303 | Vendor No. | Vendor No. | Normal | Code | 20 | Vendor No_ | nvarchar(40) |
| Key to join to the Vendor table.SELECT
[Purch. Price Line Disc. Buff.].[Vendor No_]
,[Vendor].[No_]
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Price Line Disc. Buff.]
LEFT JOIN
[CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
ON
[Purch. Price Line Disc. Buff.].[Vendor No_] = [Vendor].[No_] |
| 5400 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 20 | Unit of Measure Code | nvarchar(40) |
| 5700 | Variant Code | Variant Code | Normal | Code | 20 | Variant Code | nvarchar(40) |
| Key to join to the Item Variant table.SELECT
[Purch. Price Line Disc. Buff.].[Variant Code]
,[Item Variant].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Price Line Disc. Buff.]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Purch. Price Line Disc. Buff.].[Variant Code] = [Item Variant].[Code] |
| 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.SELECT
[Purch. Price Line Disc. Buff.].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Price Line Disc. Buff.]
LEFT JOIN
[User] AS [User]
ON
[Purch. Price Line Disc. Buff.].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
