Hist. Receivables Document – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables HHist. 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 Name	Field Caption	Class	Type	Length
1	Primary Key	Primary Key	Normal	Integer	4
2	Customer No.	Customer No.	Normal	Code	35
	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_]
3	Customer Name	Customer Name	Normal	Text	100
4	Document Type	Document Type	Normal	Option	4
5	Document No.	Document No.	Normal	Code	35
6	Batch No.	Batch No.	Normal	Code	35
7	Batch Source	Batch Source	Normal	Text	50
8	Audit Code	Audit Code	Normal	Code	35
9	Trx. Description	Trx. Description	Normal	Text	50
10	Document Date	Document Date	Normal	Date	4
11	Due Date	Due Date	Normal	Date	4
12	Post Date	Post Date	Normal	Date	4
13	User	User	Normal	Text	50
14	Currency Code	Currency	Normal	Code	10
	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]
15	Orig. Trx. Amount	Orig. Trx. Amount	Normal	Decimal	12
16	Current Trx. Amount	Current Trx. Amount	Normal	Decimal	12
17	Sales Amount	Sales Amount	Normal	Decimal	12
18	Cost Amount	Cost Amount	Normal	Decimal	12
19	Freight Amount	Freight Amount	Normal	Decimal	12
20	Misc. Amount	Misc. Amount	Normal	Decimal	12
21	Tax Amount	Tax Amount	Normal	Decimal	12
22	Disc. Taken Amount	Disc. Taken Amount	Normal	Decimal	12
23	Customer Purchase No.	Customer Purchase No.	Normal	Code	35
24	Salesperson No.	Salesperson No.	Normal	Code	35
25	Sales Territory	Sales Territory	Normal	Text	50
26	Ship Method	Ship Method	Normal	Text	50
27	Cash Amount	Cash Amount	Normal	Decimal	12
28	Commission Dollar Amount	Commission Dollar Amount	Normal	Decimal	12
29	Invoice Paid Off Date	Invoice Paid Off Date	Normal	Date	4
30	Payment Terms ID	Payment Terms ID	Normal	Text	50
	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]
31	Write Off Amount	Write Off Amount	Normal	Decimal	12
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 [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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Show/hide tables related from Hist. Receivables Document table

Currency Sales Header Sales Header Archive

Dynamics 365 BC Table Reference Tables Company Tables HHist. Receivables Document

Leave a Reply Cancel reply