GPSOPDepositHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPSOPDepositHist

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

Table Type: Company

Table Name: GPSOPDepositHist
Database Table Name:

Table Number: 4069

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

Show/hide columns in GPSOPDepositHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	SOPTYPE	SOP Type	Normal	Option	4
2	SOPNUMBE	SOP Number	Normal	Text	22
3	LNITMSEQ	Line Item Sequence	Normal	Integer	4
4	CUSTNMBR	Customer Number	Normal	Text	16
	Key to join to the Customer table. Show/hide example query SELECT [GPSOPDepositHist].[] ,[Customer].[No_] FROM [] AS [GPSOPDepositHist] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GPSOPDepositHist].[] = [Customer].[No_]
5	CUSTNAME	Customer Name	Normal	Text	66
6	DOCDATE	Document Date	Normal	Date	4
7	DOCNUMBR	Document Number	Normal	Text	22
8	RMDTYPAL	RM Document Type-All	Normal	Option	4
9	PYMTTYPE	Payment Type	Normal	Option	4
10	AMNTPAID	Amount Paid	Normal	Decimal	12
11	OAMTPAID	Originating Amount Paid	Normal	Decimal	12
12	CHEKBKID	Checkbook ID	Normal	Text	16
13	CHEKNMBR	Check Number	Normal	Text	22
14	CARDNAME	Card Name	Normal	Text	16
15	RCTNCCRD	Receipt Number Credit Card	Normal	Text	22
16	EXPNDATE	Expiration Date	Normal	Date	4
17	AUTHCODE	Authorization Code	Normal	Text	16
18	PYMNTDAT	Payment Date	Normal	Date	4
19	GLPOSTDT	GL Posting Date	Normal	Date	4
20	CASHINDEX	Cash Index	Normal	Integer	4
21	DEPINDEX	Deposits Index	Normal	Integer	4
22	DELETE1	Delete	Normal	Boolean	4
23	CURNCYID	Currency ID	Normal	Text	16
24	CURRNIDX	Currency Index	Normal	Integer	4
25	XCHGRATE	Exchange Rate	Normal	Decimal	12
26	DENXRATE	Denomination Exchange Rate	Normal	Decimal	12
27	RATETPID	Rate Type ID	Normal	Text	16
28	RTCLCMTD	Rate Calculation Method	Normal	Option	4
29	EXGTBLID	Exchange Table ID	Normal	Text	16
30	EXCHDATE	Exchange Date	Normal	Date	4
31	MCTRXSTT	MC Transaction State	Normal	Option	4
32	TIME1	Time	Normal	DateTime	8
33	TRXSORCE	TRX Source	Normal	Text	14
34	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 [GPSOPDepositHist].[] ,[User].[User Security ID] FROM [] AS [GPSOPDepositHist] LEFT JOIN [User] AS [User] ON [GPSOPDepositHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16