Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/40905
Table Type: Company
Table Name: Hist. Payables 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. Payables 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. Payables Document]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[Hist. Payables Document].[Document Type] = [Sales Header].[Document Type]
AND
[Hist. Payables Document].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[Hist. Payables Document].[Document Type] = [Sales Header Archive].[Document Type]
AND
[Hist. Payables Document].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Hist. Payables Document].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Hist. Payables Document].[Payment Terms Id] = [Payment Terms].[$systemId]
LEFT JOIN
[User] AS [User]
ON
[Hist. Payables Document].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Hist. Payables Document].[SystemModifiedBy] = [User].[User Security ID]