Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/93
Table Type: Company
Table Name: Vendor Posting Group
Database Table Name: CRONUS UK Ltd_$Vendor Posting Group$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 Vendor Posting Group can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[Code]
,[Payables Account]
,[Service Charge Acc_]
,[Payment Disc_ Debit Acc_]
,[Invoice Rounding Account]
,[Debit Curr_ Appln_ Rndg_ Acc_]
,[Credit Curr_ Appln_ Rndg_ Acc_]
,[Debit Rounding Account]
,[Credit Rounding Account]
,[Payment Disc_ Credit Acc_]
,[Payment Tolerance Debit Acc_]
,[Payment Tolerance Credit Acc_]
,[Description]
,[View All Accounts on Lookup]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Payables Account] = [G/L Account].[No_]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Invoice Rounding Account] = [G/L Account].[No_]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Debit Rounding Account] = [G/L Account].[No_]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Credit Rounding Account] = [G/L Account].[No_]
LEFT JOIN
[User] AS [User]
ON
[Vendor Posting Group].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Vendor Posting Group].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Vendor Posting Group table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Code | Code | Normal | Code | 20 | Code | nvarchar(40) |
2 | Payables Account | Payables Account | Normal | Code | 20 | Payables Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Payables Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Payables Account] = [G/L Account].[No_] | |||||||
7 | Service Charge Acc. | Service Charge Acc. | Normal | Code | 20 | Service Charge Acc_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Service Charge Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Service Charge Acc_] = [G/L Account].[No_] | |||||||
8 | Payment Disc. Debit Acc. | Payment Disc. Debit Acc. | Normal | Code | 20 | Payment Disc_ Debit Acc_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Payment Disc_ Debit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Payment Disc_ Debit Acc_] = [G/L Account].[No_] | |||||||
9 | Invoice Rounding Account | Invoice Rounding Account | Normal | Code | 20 | Invoice Rounding Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Invoice Rounding Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Invoice Rounding Account] = [G/L Account].[No_] | |||||||
10 | Debit Curr. Appln. Rndg. Acc. | Debit Curr. Appln. Rndg. Acc. | Normal | Code | 20 | Debit Curr_ Appln_ Rndg_ Acc_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Debit Curr_ Appln_ Rndg_ Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Debit Curr_ Appln_ Rndg_ Acc_] = [G/L Account].[No_] | |||||||
11 | Credit Curr. Appln. Rndg. Acc. | Credit Curr. Appln. Rndg. Acc. | Normal | Code | 20 | Credit Curr_ Appln_ Rndg_ Acc_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Credit Curr_ Appln_ Rndg_ Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Credit Curr_ Appln_ Rndg_ Acc_] = [G/L Account].[No_] | |||||||
12 | Debit Rounding Account | Debit Rounding Account | Normal | Code | 20 | Debit Rounding Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Debit Rounding Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Debit Rounding Account] = [G/L Account].[No_] | |||||||
13 | Credit Rounding Account | Credit Rounding Account | Normal | Code | 20 | Credit Rounding Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Credit Rounding Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Credit Rounding Account] = [G/L Account].[No_] | |||||||
16 | Payment Disc. Credit Acc. | Payment Disc. Credit Acc. | Normal | Code | 20 | Payment Disc_ Credit Acc_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Payment Disc_ Credit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Payment Disc_ Credit Acc_] = [G/L Account].[No_] | |||||||
17 | Payment Tolerance Debit Acc. | Payment Tolerance Debit Acc. | Normal | Code | 20 | Payment Tolerance Debit Acc_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Payment Tolerance Debit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Payment Tolerance Debit Acc_] = [G/L Account].[No_] | |||||||
18 | Payment Tolerance Credit Acc. | Payment Tolerance Credit Acc. | Normal | Code | 20 | Payment Tolerance Credit Acc_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Vendor Posting Group].[Payment Tolerance Credit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Vendor Posting Group].[Payment Tolerance Credit Acc_] = [G/L Account].[No_] | |||||||
20 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
21 | View All Accounts on Lookup | View All Accounts on Lookup | Normal | Boolean | 4 | View All Accounts on Lookup | tinyint |
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 querySELECT
[Vendor Posting Group].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[User] AS [User]
ON
[Vendor Posting Group].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Vendor Posting Group].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
LEFT JOIN
[User] AS [User]
ON
[Vendor Posting Group].[$systemModifiedBy] = [User].[User Security ID] |