GP Posting Accounts – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP Posting Accounts

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/4027

Table Type: Company

Table Name: GP Posting Accounts
Database Table Name:

Table Number: 4027

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 GP Posting Accounts can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [GP Posting Accounts]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Posting Accounts].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Posting Accounts].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Posting Accounts table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Id	Id	Normal	Integer	4
2	SalesAccount	SalesAccount	Normal	Code	20
3	SalesAccountIdx	SalesAccountIdx	Normal	Integer	4
4	SalesLineDiscAccount	SalesLineDiscAccount	Normal	Code	20
5	SalesLineDiscAccountIdx	SalesLineDiscAccountIdx	Normal	Integer	4
6	SalesInvDiscAccount	SalesInvDiscAccount	Normal	Code	20
7	SalesInvDiscAccountIdx	SalesInvDiscAccountIdx	Normal	Integer	4
8	SalesPmtDiscDebitAccount	SalesPmtDiscDebitAccount	Normal	Code	20
9	SalesPmtDiscDebitAccountIdx	SalesPmtDiscDebitAccountIdx	Normal	Integer	4
10	PurchAccount	PurchAccount	Normal	Code	20
11	PurchAccountIdx	PurchAccountIdx	Normal	Integer	4
12	PurchInvDiscAccount	PurchInvDiscAccount	Normal	Code	20
13	PurchInvDiscAccountIdx	PurchInvDiscAccountIdx	Normal	Integer	4
14	PurchLineDiscAccount	PurchLineDiscAccount	Normal	Code	20
15	PurchLineDiscAccountIdx	PurchLineDiscAccountIdx	Normal	Integer	4
16	COGSAccount	COGSAccount	Normal	Code	20
17	COGSAccountIdx	COGSAccountIdx	Normal	Integer	4
18	InventoryAdjmtAccount	InventoryAdjmtAccount	Normal	Code	20
19	InventoryAdjmtAccountIdx	InventoryAdjmtAccountIdx	Normal	Integer	4
20	SalesCreditMemoAccount	SalesCreditMemoAccount	Normal	Code	20
21	SalesCreditMemoAccountIdx	SalesCreditMemoAccountIdx	Normal	Integer	4
22	PurchPmtDiscDebitAcc	PurchPmtDiscDebitAcc	Normal	Code	20
23	PurchPmtDiscDebitAccIdx	PurchPmtDiscDebitAccIdx	Normal	Integer	4
24	PurchPrepaymentsAccount	PurchPrepaymentsAccount	Normal	Code	20
25	PurchPrepaymentsAccountIdx	PurchPrepaymentsAccountIdx	Normal	Integer	4
26	PurchaseVarianceAccount	PurchaseVarianceAccount	Normal	Code	20
27	PurchaseVarianceAccountIdx	PurchaseVarianceAccountIdx	Normal	Integer	4
28	InventoryAccount	InventoryAccount	Normal	Code	20
29	InventoryAccountIdx	InventoryAccountIdx	Normal	Integer	4
30	ReceivablesAccount	ReceivablesAccount	Normal	Code	20
31	ReceivablesAccountIdx	ReceivablesAccountIdx	Normal	Integer	4
32	ServiceChargeAccount	ServiceChargeAccount	Normal	Code	20
33	ServiceChargeAccountIdx	ServiceChargeAccountIdx	Normal	Integer	4
34	PaymentDiscDebitAccount	PaymentDiscDebitAccount	Normal	Code	20
35	PaymentDiscDebitAccountIdx	PaymentDiscDebitAccountIdx	Normal	Integer	4
36	PayablesAccount	PayablesAccount	Normal	Code	20
37	PayablesAccountIdx	PayablesAccountIdx	Normal	Integer	4
38	PurchServiceChargeAccount	PurchServiceChargeAccount	Normal	Code	20
39	PurchServiceChargeAccountIdx	PurchServiceChargeAccountIdx	Normal	Integer	4
40	PurchPmtDiscDebitAccount	PurchPmtDiscDebitAccount	Normal	Code	20
41	PurchPmtDiscDebitAccountIdx	PurchPmtDiscDebitAccountIdx	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Dynamics 365 BC Table Reference Tables Company Tables GGP Posting Accounts

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in GP Posting Accounts table

Leave a Reply Cancel reply