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:
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 | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
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 querySELECT [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 querySELECT [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 querySELECT [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 querySELECT [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 |