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
[timestamp]
,[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 columns in Vendor Posting Group table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Code  | nvarchar(40) |
| 3 | Payables Account | nvarchar(40) |
| 4 | Service Charge Acc_ | nvarchar(40) |
| 5 | Payment Disc_ Debit Acc_ | nvarchar(40) |
| 6 | Invoice Rounding Account | nvarchar(40) |
| 7 | Debit Curr_ Appln_ Rndg_ Acc_ | nvarchar(40) |
| 8 | Credit Curr_ Appln_ Rndg_ Acc_ | nvarchar(40) |
| 9 | Debit Rounding Account | nvarchar(40) |
| 10 | Credit Rounding Account | nvarchar(40) |
| 11 | Payment Disc_ Credit Acc_ | nvarchar(40) |
| 12 | Payment Tolerance Debit Acc_ | nvarchar(40) |
| 13 | Payment Tolerance Credit Acc_ | nvarchar(40) |
| 14 | Description | nvarchar(200) |
| 15 | View All Accounts on Lookup | tinyint |
| 16 | $systemId | uniqueidentifier |
| 17 | $systemCreatedAt | datetime |
| 18 | $systemCreatedBy | uniqueidentifier |
| 19 | $systemModifiedAt | datetime |
| 20 | $systemModifiedBy | uniqueidentifier |