GPPOPSerialLotHist

Dynamics 365 BC Table ReferenceTablesCompany TablesGGPPOPSerialLotHist

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

Table Type: Company

Table Name: GPPOPSerialLotHist
Database Table Name:

Table Number: 4063

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

Show/hide columns in GPPOPSerialLotHist table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1POPRCTNM SearchPOP Receipt NumberNormalText18
2RCPTLNNM Primary Key SearchReceipt Line NumberNormalInteger4
3SLTSQNUM Primary Key SearchSerial/Lot SEQ NumberNormalInteger4
4SERLTNUM Primary Key SearchSerial/Lot NumberNormalText22
5SERLTQTY SearchSerial/Lot QTYNormalDecimal12
6DATERECD SearchDate ReceivedNormalDate4
7DTSEQNUM SearchDate SEQ NumberNormalDecimal12
8UNITCOST SearchUnit CostNormalDecimal12
9TRXSORCE SearchTRX SourceNormalText14
10ITEMNMBR SearchItem NumberNormalText32
11QTYTYPE SearchQTY TypeNormalOption4
12BIN Primary Key SearchBinNormalText16
13MFGDATE SearchManufacture DateNormalDate4
14EXPNDATE SearchExpiration DateNormalDate4
15DEX_ROW_ID SearchDEX_ROW_IDNormalInteger4
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

SELECT
	       [GPPOPSerialLotHist].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [GPPOPSerialLotHist]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [GPPOPSerialLotHist].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16
Dynamics 365 BC Table ReferenceTablesCompany TablesGGPPOPSerialLotHist

Leave a Reply

Your email address will not be published. Required fields are marked *