GPPOPReceiptLineHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPPOPReceiptLineHist

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

Table Type: Company

Table Name: GPPOPReceiptLineHist
Database Table Name:

Table Number: 4062

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 GPPOPReceiptLineHist 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 [GPPOPReceiptLineHist]
LEFT JOIN
   [User] AS [User]
      ON
         [GPPOPReceiptLineHist].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GPPOPReceiptLineHist].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GPPOPReceiptLineHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	POPRCTNM	POP Receipt Number	Normal	Text	18
2	RCPTLNNM	Receipt Line Number	Normal	Integer	4
3	PONUMBER	PO Number	Normal	Text	18
4	ITEMNMBR	Item Number	Normal	Text	32
5	ITEMDESC	Item Description	Normal	Text	102
6	VNDITNUM	Vendor Item Number	Normal	Text	32
7	VNDITDSC	Vendor Item Description	Normal	Text	102
8	UMQTYINB	U Of M QTY In Base	Normal	Decimal	12
9	ACTLSHIP	Actual Ship Date	Normal	Date	4
10	COMMNTID	Comment ID	Normal	Text	16
11	INVINDX	Inventory Index	Normal	Integer	4
12	UOFM	U Of M	Normal	Text	10
13	UNITCOST	Unit Cost	Normal	Decimal	12
14	EXTDCOST	Extended Cost	Normal	Decimal	12
15	LOCNCODE	Location Code	Normal	Text	12
16	RcptLineNoteIDArray_1	ReceiptLine Note ID Array 1	Normal	Decimal	12
17	RcptLineNoteIDArray_2	ReceiptLine Note ID Array 2	Normal	Decimal	12
18	RcptLineNoteIDArray_3	ReceiptLine Note ID Array 3	Normal	Decimal	12
19	RcptLineNoteIDArray_4	ReceiptLine Note ID Array 4	Normal	Decimal	12
20	RcptLineNoteIDArray_5	ReceiptLine Note ID Array 5	Normal	Decimal	12
21	RcptLineNoteIDArray_6	ReceiptLine Note ID Array 6	Normal	Decimal	12
22	RcptLineNoteIDArray_7	ReceiptLine Note ID Array 7	Normal	Decimal	12
23	RcptLineNoteIDArray_8	ReceiptLine Note ID Array 8	Normal	Decimal	12
24	NONINVEN	Non-Inventory Item	Normal	Option	4
25	DECPLCUR	Decimal Places Currency	Normal	Option	4
26	DECPLQTY	Decimal Places QTYS	Normal	Option	4
27	ITMTRKOP	Item Tracking Option	Normal	Option	4
28	TRXSORCE	TRX Source	Normal	Text	14
29	JOBNUMBR	Job Number	Normal	Text	18
30	COSTCODE	Cost Code	Normal	Text	28
31	COSTTYPE	Cost Code Type	Normal	Integer	4
32	CURRNIDX	Currency Index	Normal	Integer	4
33	ORUNTCST	Originating Unit Cost	Normal	Decimal	12
34	OREXTCST	Originating Extended Cost	Normal	Decimal	12
35	ODECPLCU	Originating Decimal Places Currency	Normal	Option	4
36	BOLPRONUMBER	BOL_PRO Number	Normal	Text	32
37	Capital_Item	Capital Item	Normal	Boolean	4
38	Product_Indicator	Product Indicator	Normal	Integer	4
39	Purchase_IV_Item_Taxable	Purchase IV Item Taxable	Normal	Option	4
40	Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	Normal	Text	16
41	Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	Normal	Text	16
42	BSIVCTTL	Based On Invoice Total	Normal	Boolean	4
43	TAXAMNT	Tax Amount	Normal	Decimal	12
44	ORTAXAMT	Originating Tax Amount	Normal	Decimal	12
45	BCKTXAMT	Backout Tax Amount	Normal	Decimal	12
46	OBTAXAMT	Originating Backout Tax Amount	Normal	Decimal	12
47	PURPVIDX	Purchase Price Variance Index	Normal	Integer	4
48	SHIPMTHD	Shipping Method	Normal	Text	16
49	Landed_Cost_Group_ID	Landed Cost Group ID	Normal	Text	16
50	Landed_Cost_Warnings	Landed Cost Warnings	Normal	Integer	4
51	Landed_Cost	Landed Cost	Normal	Boolean	4
52	Invoice_Match	Invoice Match	Normal	Boolean	4
53	RCPTRETNUM	Receipt Return Number	Normal	Text	18
54	RCPTRETLNNUM	Receipt Return Line Number	Normal	Integer	4
55	INVRETNUM	Invoice Return Number	Normal	Text	18
56	INVRETLNNUM	Invoice Return Line Number	Normal	Integer	4
57	ISLINEINTRA	IsLineIntrastat	Normal	Boolean	4
58	ProjNum	Project Number	Normal	Text	16
59	CostCatID	Cost Category ID	Normal	Text	16
60	TrackedDropShipped	TrackedDropShipped	Normal	Boolean	4
61	OriginatingPrepaymentAmt	Originating Prepayment Amount	Normal	Decimal	12
62	ORDISTKN	Originating Discount Taken Amount	Normal	Decimal	12
63	ORTDISAM	Originating Trade Discount Amount	Normal	Decimal	12
64	ORFRTAMT	Originating Freight Amount	Normal	Decimal	12
65	ORMISCAMT	Originating Misc Amount	Normal	Decimal	12
66	OriginatingPPTaxAmount	Originating Prepayment Tax Amount	Normal	Decimal	12
67	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 [GPPOPReceiptLineHist].[] ,[User].[User Security ID] FROM [] AS [GPPOPReceiptLineHist] LEFT JOIN [User] AS [User] ON [GPPOPReceiptLineHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Dynamics 365 BC Table Reference Tables Company Tables GGPPOPReceiptLineHist

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 GPPOPReceiptLineHist table

Show/hide example query

Leave a Reply Cancel reply