GPSOPDistributionWorkHist

Dynamics 365 BC Table ReferenceTablesCompany TablesGGPSOPDistributionWorkHist

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

Table Type: Company

Table Name: GPSOPDistributionWorkHist
Database Table Name:

Table Number: 4070

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

Show/hide columns in GPSOPDistributionWorkHist table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1SOPTYPE SearchSOP TypeNormalOption4
2SOPNUMBE Primary Key SearchSOP NumberNormalText22
3SEQNUMBR Primary Key SearchSequence NumberNormalInteger4
4DISTTYPE Primary Key SearchDistribution TypeNormalOption4
5DistRef SearchDistribution ReferenceNormalText32
6ACTINDX SearchAccount IndexNormalInteger4
7DEBITAMT SearchDebit AmountNormalDecimal12
8ORDBTAMT SearchOriginating Debit AmountNormalDecimal12
9CRDTAMNT SearchCredit AmountNormalDecimal12
10ORCRDAMT SearchOriginating Credit AmountNormalDecimal12
11CURRNIDX SearchCurrency IndexNormalInteger4
12TRXSORCE SearchTRX SourceNormalText14
13POSTED SearchPostedNormalBoolean4
14Contract_Exchange_Rate SearchContract Exchange RateNormalDecimal12
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
	       [GPSOPDistributionWorkHist].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [GPSOPDistributionWorkHist]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [GPSOPDistributionWorkHist].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16
Dynamics 365 BC Table ReferenceTablesCompany TablesGGPSOPDistributionWorkHist

Leave a Reply

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