GPPOPReceiptHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPPOPReceiptHist

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

Table Type: Company

Table Name: GPPOPReceiptHist
Database Table Name:

Table Number: 4061

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

Show/hide columns in GPPOPReceiptHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	POPRCTNM	POP Receipt Number	Normal	Text	18
2	POPTYPE	POP Type	Normal	Option	4
3	VNDDOCNM	Vendor Document Number	Normal	Text	22
4	receiptdate	Receipt Date	Normal	Date	4
5	GLPOSTDT	GL Posting Date	Normal	Date	4
6	ACTLSHIP	Actual Ship Date	Normal	Date	4
7	BCHSOURC	Batch Source	Normal	Text	16
8	BACHNUMB	Batch Number	Normal	Text	16
9	VENDORID	Vendor ID	Normal	Text	16
	Key to join to the Vendor table. Show/hide example query SELECT [GPPOPReceiptHist].[] ,[Vendor].[No_] FROM [] AS [GPPOPReceiptHist] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GPPOPReceiptHist].[] = [Vendor].[No_]
10	VENDNAME	Vendor Name	Normal	Text	66
11	SUBTOTAL	Subtotal	Normal	Decimal	12
12	TRDISAMT	Trade Discount Amount	Normal	Decimal	12
14	FRTAMNT	Freight Amount	Normal	Decimal	12
15	MISCAMNT	Misc Amount	Normal	Decimal	12
16	TAXAMNT	Tax Amount	Normal	Decimal	12
17	TEN99AMNT	1099 Amount	Normal	Decimal	12
18	PYMTRMID	Payment Terms ID	Normal	Text	22
19	DSCPCTAM	Discount Percent Amount	Normal	Integer	4
20	DSCDLRAM	Discount Dollar Amount	Normal	Decimal	12
21	DISAVAMT	Discount Available Amount	Normal	Decimal	12
22	DISCDATE	Discount Date	Normal	Date	4
23	DUEDATE	Due Date	Normal	Date	4
24	REFRENCE	Reference	Normal	Text	32
25	VOIDSTTS	Void Status	Normal	Option	4
26	RCPTNOTE_1	Receipt Note ID Array 1	Normal	Decimal	12
27	RCPTNOTE_2	Receipt Note ID Array 2	Normal	Decimal	12
28	RCPTNOTE_3	Receipt Note ID Array 3	Normal	Decimal	12
29	RCPTNOTE_4	Receipt Note ID Array 4	Normal	Decimal	12
30	RCPTNOTE_5	Receipt Note ID Array 5	Normal	Decimal	12
31	RCPTNOTE_6	Receipt Note ID Array 6	Normal	Decimal	12
32	RCPTNOTE_7	Receipt Note ID Array 7	Normal	Decimal	12
33	RCPTNOTE_8	Receipt Note ID Array 8	Normal	Decimal	12
34	POSTEDDT	Posted Date	Normal	Date	4
35	PTDUSRID	Posted User ID	Normal	Text	16
36	USER2ENT	User To Enter	Normal	Text	16
37	CREATDDT	Created Date	Normal	Date	4
38	MODIFDT	Modified Date	Normal	Date	4
39	TRXSORCE	TRX Source	Normal	Text	14
40	VCHRNMBR	Voucher Number	Normal	Text	22
41	Tax_Date	Tax Date	Normal	Date	4
42	CURNCYID	Currency ID	Normal	Text	16
43	CURRNIDX	Currency Index	Normal	Integer	4
44	RATETPID	Rate Type ID	Normal	Text	16
45	EXGTBLID	Exchange Table ID	Normal	Text	16
46	XCHGRATE	Exchange Rate	Normal	Decimal	12
47	EXCHDATE	Exchange Date	Normal	Date	4
48	TIME1	Time	Normal	DateTime	8
49	RATECALC	Rate Calc Method	Normal	Option	4
50	DENXRATE	Denomination Exchange Rate	Normal	Decimal	12
51	MCTRXSTT	MC Transaction State	Normal	Option	4
52	ORSUBTOT	Originating Subtotal	Normal	Decimal	12
53	ORTDISAM	Originating Trade Discount Amount	Normal	Decimal	12
54	ORFRTAMT	Originating Freight Amount	Normal	Decimal	12
55	ORMISCAMT	Originating Misc Amount	Normal	Decimal	12
56	ORTAXAMT	Originating Tax Amount	Normal	Decimal	12
57	OR1099AM	Originating 1099 Amount	Normal	Decimal	12
58	ORDDLRAT	Originating Discount Dollar Amount	Normal	Decimal	12
59	ORDAVAMT	Originating Discount Available Amount	Normal	Decimal	12
60	SIMPLIFD	Simplified	Normal	Boolean	4
61	WITHHAMT	Withholding Amount	Normal	Decimal	12
62	ECTRX	EC Transaction	Normal	Boolean	4
63	TXRGNNUM	Tax Registration Number	Normal	Text	26
64	TAXSCHID	Tax Schedule ID	Normal	Text	16
65	BSIVCTTL	Based On Invoice Total	Normal	Boolean	4
66	Purchase_Freight_Taxable	Purchase Freight Taxable	Normal	Option	4
67	Purchase_Misc_Taxable	Purchase Misc Taxable	Normal	Option	4
68	FRTSCHID	Freight Schedule ID	Normal	Text	16
69	MSCSCHID	Misc Schedule ID	Normal	Text	16
70	FRTTXAMT	Freight Tax Amount	Normal	Decimal	12
71	ORFRTTAX	Originating Freight Tax Amount	Normal	Decimal	12
72	MSCTXAMT	Misc Tax Amount	Normal	Decimal	12
73	ORMSCTAX	Originating Misc Tax Amount	Normal	Decimal	12
74	BCKTXAMT	Backout Tax Amount	Normal	Decimal	12
75	OBTAXAMT	Originating Backout Tax Amount	Normal	Decimal	12
76	TaxInvReqd	Tax Invoice Required	Normal	Boolean	4
77	BackoutFreightTaxAmt	Backout Freight Tax Amount	Normal	Decimal	12
78	OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	Normal	Decimal	12
79	BackoutMiscTaxAmt	Backout Misc Tax Amount	Normal	Decimal	12
80	OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	Normal	Decimal	12
81	TaxInvRecvd	Tax Invoice Received	Normal	Boolean	4
82	APLYWITH	Apply Withholding	Normal	Boolean	4
83	PPSTAXRT	PPS Tax Rate	Normal	Integer	4
84	SHIPMTHD	Shipping Method	Normal	Text	16
85	Total_Landed_Cost_Amount	Total Landed Cost Amount	Normal	Decimal	12
86	CBVAT	Cash Based Tax	Normal	Boolean	4
87	VADCDTRO	Vendor Address Code – Remit To	Normal	Text	16
88	REVALJRNENTRY	Revaluation Journal Entry	Normal	Integer	4
89	REVALTRXSOURCE	Revaluation TRX Source	Normal	Text	14
90	TEN99TYPE	1099 Type	Normal	Option	4
91	TEN99BOXNUMBER	1099 Box Number	Normal	Integer	4
92	REPLACEGOODS	Replace Returned Goods	Normal	Boolean	4
93	INVOICEEXPECTED	Invoice Expected Returns	Normal	Boolean	4
94	PrepaymentAmount	Prepayment Amount	Normal	Decimal	12
95	OriginatingPrepaymentAmt	Originating Prepayment Amount	Normal	Decimal	12
96	DISTKNAM	Discount Taken Amount	Normal	Decimal	12
97	ORDISTKN	Originating Discount Taken Amount	Normal	Decimal	12
98	DISAVTKN	Discount Available Taken	Normal	Decimal	12
99	ORDATKN	Originating Discount Available Taken	Normal	Decimal	12
100	InvoiceReceiptDate	Invoice Receipt Date	Normal	Date	4
101	Workflow_Status	Workflow Status	Normal	Option	4
102	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 [GPPOPReceiptHist].[] ,[User].[User Security ID] FROM [] AS [GPPOPReceiptHist] LEFT JOIN [User] AS [User] ON [GPPOPReceiptHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16