GP SY06000 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP SY06000

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

Table Type: Company

Table Name: GP SY06000
Database Table Name:

Table Number: 40111

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 SY06000 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 SY06000]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [GP SY06000].[VENDORID] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [GP SY06000].[CUSTNMBR] = [Customer].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [GP SY06000].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP SY06000].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP SY06000 table

Field No.	Field Name	Field Caption	Class	Type	Length
1	SERIES	SERIES	Normal	Integer	4
2	CustomerVendor_ID	CustomerVendor_ID	Normal	Text	15
3	ADRSCODE	ADRSCODE	Normal	Text	15
4	VENDORID	VENDORID	Normal	Text	15
	Key to join to the Vendor table. Show/hide example query SELECT [GP SY06000].[] ,[Vendor].[No_] FROM [] AS [GP SY06000] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GP SY06000].[] = [Vendor].[No_]
5	CUSTNMBR	CUSTNMBR	Normal	Text	15
	Key to join to the Customer table. Show/hide example query SELECT [GP SY06000].[] ,[Customer].[No_] FROM [] AS [GP SY06000] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GP SY06000].[] = [Customer].[No_]
6	EFTUseMasterID	EFTUseMasterID	Normal	Integer	4
7	EFTBankType	EFTBankType	Normal	Integer	4
8	FRGNBANK	FRGNBANK	Normal	Boolean	4
9	INACTIVE	INACTIVE	Normal	Boolean	4
10	BANKNAME	BANKNAME	Normal	Text	31
11	EFTBankAcct	EFTBankAcct	Normal	Text	35
12	EFTBankBranch	EFTBankBranch	Normal	Text	15
13	GIROPostType	GIROPostType	Normal	Integer	4
14	EFTBankCode	EFTBankCode	Normal	Text	15
15	EFTBankBranchCode	EFTBankBranchCode	Normal	Text	5
16	EFTBankCheckDigit	EFTBankCheckDigit	Normal	Text	3
17	BSROLLNO	BSROLLNO	Normal	Text	31
18	IntlBankAcctNum	IntlBankAcctNum	Normal	Text	35
19	SWIFTADDR	SWIFTADDR	Normal	Text	11
20	CustVendCountryCode	CustVendCountryCode	Normal	Text	3
21	DeliveryCountryCode	DeliveryCountryCode	Normal	Text	3
22	BNKCTRCD	BNKCTRCD	Normal	Text	3
23	CBANKCD	CBANKCD	Normal	Text	9
24	ADDRESS1	ADDRESS1	Normal	Text	61
25	ADDRESS2	ADDRESS2	Normal	Text	61
26	ADDRESS3	ADDRESS3	Normal	Text	61
27	ADDRESS4	ADDRESS4	Normal	Text	61
28	RegCode1	RegCode1	Normal	Text	31
29	RegCode2	RegCode2	Normal	Text	31
30	BankInfo7	BankInfo7	Normal	Integer	4
31	EFTTransitRoutingNo	EFTTransitRoutingNo	Normal	Text	11
32	CURNCYID	CURNCYID	Normal	Text	15
33	EFTTransferMethod	EFTTransferMethod	Normal	Integer	4
34	EFTAccountType	EFTAccountType	Normal	Integer	4
35	EFTPrenoteDate	EFTPrenoteDate	Normal	DateTime	8
36	EFTTerminationDate	EFTTerminationDate	Normal	DateTime	8
37	DEX_ROW_ID	DEX_ROW_ID	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [GP SY06000].[] ,[User].[User Security ID] FROM [] AS [GP SY06000] LEFT JOIN [User] AS [User] ON [GP SY06000].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16