GPPOPPOLineHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPPOPPOLineHist

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

Table Type: Company

Table Name: GPPOPPOLineHist
Database Table Name:

Table Number: 4058

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

Show/hide columns in GPPOPPOLineHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	PONUMBER	PO Number	Normal	Text	18
2	ORD	Ord	Normal	Integer	4
3	POLNESTA	PO Line Status	Normal	Option	4
4	POTYPE	PO Type	Normal	Option	4
5	ITEMNMBR	Item Number	Normal	Text	32
6	ITEMDESC	Item Description	Normal	Text	102
7	VENDORID	Vendor ID	Normal	Text	16
	Key to join to the Vendor table. Show/hide example query SELECT [GPPOPPOLineHist].[] ,[Vendor].[No_] FROM [] AS [GPPOPPOLineHist] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GPPOPPOLineHist].[] = [Vendor].[No_]
8	VNDITNUM	Vendor Item Number	Normal	Text	32
9	VNDITDSC	Vendor Item Description	Normal	Text	102
10	NONINVEN	Non-Inventory Item	Normal	Option	4
11	LOCNCODE	Location Code	Normal	Text	12
12	UOFM	U Of M	Normal	Text	10
13	UMQTYINB	U Of M QTY In Base	Normal	Decimal	12
14	QTYORDER	QTY Ordered	Normal	Decimal	12
15	QTYCANCE	QTY Canceled	Normal	Decimal	12
16	UNITCOST	Unit Cost	Normal	Decimal	12
17	EXTDCOST	Extended Cost	Normal	Decimal	12
18	INVINDX	Inventory Index	Normal	Integer	4
19	REQDATE	Required Date	Normal	Date	4
20	PRMDATE	Promised Date	Normal	Date	4
21	PRMSHPDTE	Promised Ship Date	Normal	Date	4
22	REQSTDBY	Requested By	Normal	Text	22
23	COMMNTID	Comment ID	Normal	Text	16
24	DOCTYPE	Document Type	Normal	Option	4
25	POLNEARY_1	PO Line Note ID Array	Normal	Decimal	12
26	POLNEARY_2	PO Line Note ID Array	Normal	Decimal	12
27	POLNEARY_3	PO Line Note ID Array	Normal	Decimal	12
28	POLNEARY_4	PO Line Note ID Array	Normal	Decimal	12
29	POLNEARY_5	PO Line Note ID Array	Normal	Decimal	12
30	POLNEARY_6	PO Line Note ID Array	Normal	Decimal	12
31	POLNEARY_7	PO Line Note ID Array	Normal	Decimal	12
32	POLNEARY_8	PO Line Note ID Array	Normal	Decimal	12
33	POLNEARY_9	PO Line Note ID Array	Normal	Decimal	12
34	DECPLCUR	Decimal Places Currency	Normal	Option	4
35	DECPLQTY	Decimal Places QTYS	Normal	Option	4
36	BRKFLD1	Break Field 1	Normal	Integer	4
37	JOBNUMBR	Job Number	Normal	Text	18
38	COSTCODE	Cost Code	Normal	Text	28
39	COSTTYPE	Cost Code Type	Normal	Integer	4
40	CURRNIDX	Currency Index	Normal	Integer	4
41	ORUNTCST	Originating Unit Cost	Normal	Decimal	12
42	OREXTCST	Originating Extended Cost	Normal	Decimal	12
43	LINEORIGIN	Line Origin	Normal	Option	4
44	FREEONBOARD	Free On Board	Normal	Option	4
45	ODECPLCU	Originating Decimal Places Currency	Normal	Option	4
46	Product_Indicator	Product Indicator	Normal	Integer	4
47	Source_Document_Number	Source Document Number	Normal	Text	12
48	Source_Document_Line_Num	Source Document Line Number	Normal	Integer	4
49	RELEASEBYDATE	Release By Date	Normal	Date	4
50	Released_Date	Released Date	Normal	Date	4
51	Purchase_IV_Item_Taxable	Purchase IV Item Taxable	Normal	Option	4
52	Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	Normal	Text	16
53	Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	Normal	Text	16
54	PURCHSITETXSCHSRC	Purchase Site Tax Schedule Source	Normal	Integer	4
55	BSIVCTTL	Based On Invoice Total	Normal	Boolean	4
56	TAXAMNT	Tax Amount	Normal	Decimal	12
57	ORTAXAMT	Originating Tax Amount	Normal	Decimal	12
58	BCKTXAMT	Backout Tax Amount	Normal	Decimal	12
59	OBTAXAMT	Originating Backout Tax Amount	Normal	Decimal	12
60	Landed_Cost_Group_ID	Landed Cost Group ID	Normal	Text	16
61	SHIPMTHD	Shipping Method	Normal	Text	16
62	LineNumber	LineNumber	Normal	Integer	4
63	ORIGPRMDATE	Original Promised Date	Normal	Date	4
64	FSTRCPTDT	First Receipt Date	Normal	Date	4
65	LSTRCPTDT	Last Receipt Date	Normal	Date	4
66	RELEASE	Release	Normal	Integer	4
67	ADRSCODE	Address Code	Normal	Text	16
68	CMPNYNAM	Company Name	Normal	Text	66
69	CONTACT	Contact	Normal	Text	62
70	ADDRESS1	Address 1	Normal	Text	62
71	ADDRESS2	Address 2	Normal	Text	62
72	ADDRESS3	Address 3	Normal	Text	62
73	CITY	City	Normal	Text	36
	Key to join to the Post Code table. Show/hide example query SELECT [GPPOPPOLineHist].[] ,[Post Code].[City] FROM [] AS [GPPOPPOLineHist] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GPPOPPOLineHist].[] = [Post Code].[City]
74	STATE	State	Normal	Text	30
75	ZIPCODE	Zip Code	Normal	Text	12
76	CCode	Country Code	Normal	Text	8
77	COUNTRY	Country	Normal	Text	62
78	PHONE1	Phone 1	Normal	Text	22
79	PHONE2	Phone 2	Normal	Text	22
80	PHONE3	Phone 3	Normal	Text	22
81	FAX	Fax	Normal	Text	22
82	ADDRSOURCE	Address Source	Normal	Integer	4
83	Flags	Flags	Normal	Integer	4
84	ProjNum	Project Number	Normal	Text	16
85	CostCatID	Cost Category ID	Normal	Text	16
86	ITMTRKOP	Item Tracking Option	Normal	Option	4
87	VCTNMTHD	Valuation Method	Normal	Option	4
88	Print_Phone_NumberGB	Print Phone Number GB	Normal	Option	4
89	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
90	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 [GPPOPPOLineHist].[] ,[User].[User Security ID] FROM [] AS [GPPOPPOLineHist] LEFT JOIN [User] AS [User] ON [GPPOPPOLineHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16