Vendor Posting Group

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

Table Number: 93

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Payables Account Searchnvarchar(40)
4Service Charge Acc_ Searchnvarchar(40)
5Payment Disc_ Debit Acc_ Searchnvarchar(40)
6Invoice Rounding Account Searchnvarchar(40)
7Debit Curr_ Appln_ Rndg_ Acc_ Searchnvarchar(40)
8Credit Curr_ Appln_ Rndg_ Acc_ Searchnvarchar(40)
9Debit Rounding Account Searchnvarchar(40)
10Credit Rounding Account Searchnvarchar(40)
11Payment Disc_ Credit Acc_ Searchnvarchar(40)
12Payment Tolerance Debit Acc_ Searchnvarchar(40)
13Payment Tolerance Credit Acc_ Searchnvarchar(40)
14Description Searchnvarchar(200)
15View All Accounts on Lookup Searchtinyint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *