Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/92
Table Type: Company
Table Name: Customer Posting Group
Database Table Name: CRONUS UK Ltd_$Customer 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 Customer Posting Group can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[Code]
,[Receivables Account]
,[Service Charge Acc_]
,[Payment Disc_ Debit Acc_]
,[Invoice Rounding Account]
,[Additional Fee Account]
,[Interest 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_]
,[Add_ Fee per Line Account]
,[Description]
,[View All Accounts on Lookup]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Customer 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_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Receivables Account] = [G/L Account].[No_]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer 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
[Customer Posting Group].[Additional Fee Account] = [G/L Account].[No_]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Interest Account] = [G/L Account].[No_]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer 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
[Customer Posting Group].[Credit Rounding Account] = [G/L Account].[No_]
LEFT JOIN
[User] AS [User]
ON
[Customer Posting Group].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Customer Posting Group].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Customer 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 | Receivables Account | Receivables Account | Normal | Code | 20 | Receivables Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Customer Posting Group].[Receivables Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Receivables 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
[Customer Posting Group].[Service Charge Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer 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
[Customer Posting Group].[Payment Disc_ Debit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer 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
[Customer Posting Group].[Invoice Rounding Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Invoice Rounding Account] = [G/L Account].[No_] | |||||||
10 | Additional Fee Account | Additional Fee Account | Normal | Code | 20 | Additional Fee Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Customer Posting Group].[Additional Fee Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Additional Fee Account] = [G/L Account].[No_] | |||||||
11 | Interest Account | Interest Account | Normal | Code | 20 | Interest Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Customer Posting Group].[Interest Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Interest Account] = [G/L Account].[No_] | |||||||
12 | 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
[Customer Posting Group].[Debit Curr_ Appln_ Rndg_ Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Debit Curr_ Appln_ Rndg_ Acc_] = [G/L Account].[No_] | |||||||
13 | 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
[Customer Posting Group].[Credit Curr_ Appln_ Rndg_ Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Credit Curr_ Appln_ Rndg_ Acc_] = [G/L Account].[No_] | |||||||
14 | 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
[Customer Posting Group].[Debit Rounding Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Debit Rounding Account] = [G/L Account].[No_] | |||||||
15 | 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
[Customer Posting Group].[Credit Rounding Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer 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
[Customer Posting Group].[Payment Disc_ Credit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer 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
[Customer Posting Group].[Payment Tolerance Debit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer 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
[Customer Posting Group].[Payment Tolerance Credit Acc_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Payment Tolerance Credit Acc_] = [G/L Account].[No_] | |||||||
19 | Add. Fee per Line Account | Add. Fee per Line Account | Normal | Code | 20 | Add_ Fee per Line Account | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Customer Posting Group].[Add_ Fee per Line Account]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Customer Posting Group].[Add_ Fee per Line Account] = [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
[Customer Posting Group].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[User] AS [User]
ON
[Customer 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
[Customer Posting Group].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
LEFT JOIN
[User] AS [User]
ON
[Customer Posting Group].[$systemModifiedBy] = [User].[User Security ID] |