Hist. Payables Document

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:

Table Number: 40905

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]

Show/hide columns in Hist. Payables Document table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalInteger4
2Voucher No. Primary Key SearchVoucher No.NormalCode35
3Vendor No. SearchVendor No.NormalCode35
Key to join to the Vendor table.

Show/hide example query

SELECT
	       [Hist. Payables Document].[]
	       ,[Vendor].[No_]
	FROM
	       [] AS [Hist. Payables Document]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Hist. Payables Document].[] = [Vendor].[No_]
4Vendor Name SearchVendor NameNormalText100
5Document Type SearchDocument TypeNormalOption4
6Document No. SearchDocument No.NormalCode35
7Document Date SearchDocument DateNormalDate4
8Document Amount SearchDocument AmountNormalDecimal12
9Currency Code SearchCurrencyNormalCode10
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Hist. Payables Document].[]
	       ,[Currency].[Code]
	FROM
	       [] AS [Hist. Payables Document]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Hist. Payables Document].[] = [Currency].[Code]
10Current Trx. Amount SearchCurrent Trx. AmountNormalDecimal12
11Disc. Taken Amount SearchDisc. Taken AmountNormalDecimal12
12Batch No. SearchBatch No.NormalCode35
13Batch Source SearchBatch SourceNormalText50
14Due Date SearchDue DateNormalDate4
15Purchase No. SearchPurchase No.NormalCode35
16Audit Code SearchAudit CodeNormalCode35
17Trx. Description SearchTrx. DescriptionNormalText50
18Post Date SearchPost DateNormalDate4
19User SearchUserNormalText50
20Misc. Amount SearchMisc. AmountNormalDecimal12
21Freight Amount SearchFreight AmountNormalDecimal12
22Tax Amount SearchTax AmountNormalDecimal12
23Total Payments SearchTotal PaymentsNormalDecimal12
24Voided SearchVoidedNormalBoolean4
25Invoice Paid Off Date SearchInvoice Paid Off DateNormalDate4
26Ship Method SearchShip MethodNormalText50
271099 Amount Search1099 AmountNormalDecimal12
28Write Off Amount SearchWrite Off AmountNormalDecimal12
29Trade Discount Amount SearchTrade Discount AmountNormalDecimal12
30Payment Terms ID SearchPayment Terms IDNormalText50
Key to join to the Payment Terms table.

Show/hide example query

SELECT
	       [Hist. Payables Document].[]
	       ,[Payment Terms].[$systemId]
	FROM
	       [] AS [Hist. Payables Document]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Hist. Payables Document].[] = [Payment Terms].[$systemId]
311099 Type Search1099 TypeNormalText50
321099 Box Number Search1099 Box NumberNormalText50
33PO Number SearchPO NumberNormalCode35
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

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

Show/hide tables related from Hist. Payables Document table

Leave a Reply

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