GP POPPOLine – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP POPPOLine

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

Table Type: Company

Table Name: GP POPPOLine
Database Table Name:

Table Number: 40103

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

Show/hide columns in GP POPPOLine table

Field No.	Field Name	Field Caption	Class	Type	Length
1	PONUMBER	PONUMBER	Normal	Text	18
2	ORD	ORD	Normal	Integer	4
3	POLNESTA	POLNESTA	Normal	Option	4
4	POTYPE	POTYPE	Normal	Option	4
5	ITEMNMBR	ITEMNMBR	Normal	Text	32
6	ITEMDESC	ITEMDESC	Normal	Text	102
7	VENDORID	VENDORID	Normal	Text	16
	Key to join to the Vendor table. Show/hide example query SELECT [GP POPPOLine].[] ,[Vendor].[No_] FROM [] AS [GP POPPOLine] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GP POPPOLine].[] = [Vendor].[No_]
8	VNDITNUM	VNDITNUM	Normal	Text	32
9	VNDITDSC	VNDITDSC	Normal	Text	102
10	NONINVEN	NONINVEN	Normal	Integer	4
11	LOCNCODE	LOCNCODE	Normal	Text	12
12	UOFM	UOFM	Normal	Text	10
13	UMQTYINB	UMQTYINB	Normal	Decimal	12
14	QTYORDER	QTYORDER	Normal	Decimal	12
15	QTYCANCE	QTYCANCE	Normal	Decimal	12
16	QTYCMTBASE	QTYCMTBASE	Normal	Decimal	12
17	QTYUNCMTBASE	QTYUNCMTBASE	Normal	Decimal	12
18	UNITCOST	UNITCOST	Normal	Decimal	12
19	EXTDCOST	EXTDCOST	Normal	Decimal	12
20	INVINDX	INVINDX	Normal	Integer	4
21	REQDATE	REQDATE	Normal	Date	4
22	PRMDATE	PRMDATE	Normal	Date	4
23	PRMSHPDTE	PRMSHPDTE	Normal	Date	4
24	REQSTDBY	REQSTDBY	Normal	Text	22
25	COMMNTID	COMMNTID	Normal	Text	16
26	DOCTYPE	DOCTYPE	Normal	Option	4
27	POLNEARY_1	POLNEARY_1	Normal	Decimal	12
28	POLNEARY_2	POLNEARY_2	Normal	Decimal	12
29	POLNEARY_3	POLNEARY_3	Normal	Decimal	12
30	POLNEARY_4	POLNEARY_4	Normal	Decimal	12
31	POLNEARY_5	POLNEARY_5	Normal	Decimal	12
32	POLNEARY_6	POLNEARY_6	Normal	Decimal	12
33	POLNEARY_7	POLNEARY_7	Normal	Decimal	12
34	POLNEARY_8	POLNEARY_8	Normal	Decimal	12
35	POLNEARY_9	POLNEARY_9	Normal	Decimal	12
36	DECPLCUR	DECPLCUR	Normal	Option	4
37	DECPLQTY	DECPLQTY	Normal	Option	4
38	ITMTRKOP	ITMTRKOP	Normal	Option	4
39	VCTNMTHD	VCTNMTHD	Normal	Option	4
40	BRKFLD1	BRKFLD1	Normal	Integer	4
41	PO_Line_Status_Orig	PO_Line_Status_Orig	Normal	Option	4
42	QTY_Canceled_Orig	QTY_Canceled_Orig	Normal	Decimal	12
43	OPOSTSUB	OPOSTSUB	Normal	Decimal	12
44	JOBNUMBR	JOBNUMBR	Normal	Text	18
45	COSTCODE	COSTCODE	Normal	Text	28
46	COSTTYPE	COSTTYPE	Normal	Integer	4
47	CURNCYID	CURNCYID	Normal	Text	16
48	CURRNIDX	CURRNIDX	Normal	Integer	4
49	XCHGRATE	XCHGRATE	Normal	Decimal	12
50	RATECALC	RATECALC	Normal	Integer	4
51	DENXRATE	DENXRATE	Normal	Decimal	12
52	ORUNTCST	ORUNTCST	Normal	Decimal	12
53	OREXTCST	OREXTCST	Normal	Decimal	12
54	LINEORIGIN	LINEORIGIN	Normal	Option	4
55	FREEONBOARD	FREEONBOARD	Normal	Option	4
56	ODECPLCU	ODECPLCU	Normal	Option	4
57	Capital_Item	Capital_Item	Normal	Boolean	4
58	Product_Indicator	Product_Indicator	Normal	Integer	4
59	Source_Document_Number	Source_Document_Number	Normal	Text	12
60	Source_Document_Line_Num	Source_Document_Line_Num	Normal	Integer	4
61	RELEASEBYDATE	RELEASEBYDATE	Normal	Date	4
62	Released_Date	Released_Date	Normal	Date	4
63	Change_Order_Flag	Change_Order_Flag	Normal	Integer	4
64	Purchase_IV_Item_Taxable	Purchase_IV_Item_Taxable	Normal	Option	4
65	Purchase_Item_Tax_Schedu	Purchase_Item_Tax_Schedu	Normal	Text	16
66	Purchase_Site_Tax_Schedu	Purchase_Site_Tax_Schedu	Normal	Text	16
67	PURCHSITETXSCHSRC	PURCHSITETXSCHSRC	Normal	Integer	4
68	BSIVCTTL	BSIVCTTL	Normal	Boolean	4
69	TAXAMNT	TAXAMNT	Normal	Decimal	12
70	ORTAXAMT	ORTAXAMT	Normal	Decimal	12
71	BCKTXAMT	BCKTXAMT	Normal	Decimal	12
72	OBTAXAMT	OBTAXAMT	Normal	Decimal	12
73	Landed_Cost_Group_ID	Landed_Cost_Group_ID	Normal	Text	16
74	PLNNDSPPLID	PLNNDSPPLID	Normal	Integer	4
75	SHIPMTHD	SHIPMTHD	Normal	Text	16
76	BackoutTradeDiscTax	BackoutTradeDiscTax	Normal	Decimal	12
77	OrigBackoutTradeDiscTax	OrigBackoutTradeDiscTax	Normal	Decimal	12
78	LineNumber	LineNumber	Normal	Integer	4
79	ORIGPRMDATE	ORIGPRMDATE	Normal	Date	4
80	FSTRCPTDT	FSTRCPTDT	Normal	Date	4
81	LSTRCPTDT	LSTRCPTDT	Normal	Date	4
82	RELEASE	RELEASE	Normal	Integer	4
83	ADRSCODE	ADRSCODE	Normal	Text	16
84	CMPNYNAM	CMPNYNAM	Normal	Text	66
85	CONTACT	CONTACT	Normal	Text	62
86	ADDRESS1	ADDRESS1	Normal	Text	62
87	ADDRESS2	ADDRESS2	Normal	Text	62
88	ADDRESS3	ADDRESS3	Normal	Text	62
89	CITY	CITY	Normal	Text	36
	Key to join to the Post Code table. Show/hide example query SELECT [GP POPPOLine].[] ,[Post Code].[City] FROM [] AS [GP POPPOLine] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP POPPOLine].[] = [Post Code].[City]
90	STATE	STATE	Normal	Text	30
91	ZIPCODE	ZIPCODE	Normal	Text	12
92	CCode	CCode	Normal	Text	8
93	COUNTRY	COUNTRY	Normal	Text	62
94	PHONE1	PHONE1	Normal	Text	22
95	PHONE2	PHONE2	Normal	Text	22
96	PHONE3	PHONE3	Normal	Text	22
97	FAX	FAX	Normal	Text	22
98	ADDRSOURCE	ADDRSOURCE	Normal	Integer	4
99	Flags	Flags	Normal	Integer	4
100	ProjNum	ProjNum	Normal	Text	16
101	CostCatID	CostCatID	Normal	Text	16
102	Print_Phone_NumberGB	Print_Phone_NumberGB	Normal	Integer	4
103	QTYCommittedInBaseOrig	QTYCommittedInBaseOrig	Normal	Decimal	12
104	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
105	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 POPPOLine].[] ,[User].[User Security ID] FROM [] AS [GP POPPOLine] LEFT JOIN [User] AS [User] ON [GP POPPOLine].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16