Hist. Receivables Document

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

Table Type: Company

Table Name: Hist. Receivables Document
Database Table Name:

Table Number: 40904

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 Hist. Receivables Document 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 [Hist. Receivables Document]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Hist. Receivables Document].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Hist. Receivables Document].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Hist. Receivables Document].[Document Type] = [Sales Header].[Document Type]
      AND
         [Hist. Receivables Document].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Hist. Receivables Document].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Hist. Receivables Document].[Payment Terms Id] = [Payment Terms].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Receivables Document].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Receivables Document].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Hist. Receivables Document table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalInteger4
2Customer No. Primary Key SearchCustomer No.NormalCode35
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Hist. Receivables Document].[]
	       ,[Customer].[No_]
	FROM
	       [] AS [Hist. Receivables Document]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Hist. Receivables Document].[] = [Customer].[No_]
3Customer Name SearchCustomer NameNormalText100
4Document Type SearchDocument TypeNormalOption4
5Document No. SearchDocument No.NormalCode35
6Batch No. SearchBatch No.NormalCode35
7Batch Source SearchBatch SourceNormalText50
8Audit Code SearchAudit CodeNormalCode35
9Trx. Description SearchTrx. DescriptionNormalText50
10Document Date SearchDocument DateNormalDate4
11Due Date SearchDue DateNormalDate4
12Post Date SearchPost DateNormalDate4
13User SearchUserNormalText50
14Currency Code SearchCurrencyNormalCode10
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Hist. Receivables Document].[]
	       ,[Currency].[Code]
	FROM
	       [] AS [Hist. Receivables Document]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Hist. Receivables Document].[] = [Currency].[Code]
15Orig. Trx. Amount SearchOrig. Trx. AmountNormalDecimal12
16Current Trx. Amount SearchCurrent Trx. AmountNormalDecimal12
17Sales Amount SearchSales AmountNormalDecimal12
18Cost Amount SearchCost AmountNormalDecimal12
19Freight Amount SearchFreight AmountNormalDecimal12
20Misc. Amount SearchMisc. AmountNormalDecimal12
21Tax Amount SearchTax AmountNormalDecimal12
22Disc. Taken Amount SearchDisc. Taken AmountNormalDecimal12
23Customer Purchase No. SearchCustomer Purchase No.NormalCode35
24Salesperson No. SearchSalesperson No.NormalCode35
25Sales Territory SearchSales TerritoryNormalText50
26Ship Method SearchShip MethodNormalText50
27Cash Amount SearchCash AmountNormalDecimal12
28Commission Dollar Amount SearchCommission Dollar AmountNormalDecimal12
29Invoice Paid Off Date SearchInvoice Paid Off DateNormalDate4
30Payment Terms ID SearchPayment Terms IDNormalText50
Key to join to the Payment Terms table.

Show/hide example query

SELECT
	       [Hist. Receivables Document].[]
	       ,[Payment Terms].[$systemId]
	FROM
	       [] AS [Hist. Receivables Document]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Hist. Receivables Document].[] = [Payment Terms].[$systemId]
31Write Off Amount SearchWrite Off AmountNormalDecimal12
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

SELECT
	       [Hist. Receivables Document].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [Hist. Receivables Document]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Hist. Receivables Document].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16

Show/hide tables related from Hist. Receivables Document table

Leave a Reply

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