MS-QBO Invoice

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

Table Type: Company

Table Name: MS-QBO Invoice
Database Table Name: CRONUS UK Ltd_$MS-QBO Invoice$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7822

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 MS-QBO Invoice can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$MS-QBO Invoice$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Id]
   ,[SyncToken]
   ,[MetaData]
   ,[MetaData CreateTime]
   ,[MetaData LastUpdatedTime]
   ,[CustomField]
   ,[DocNumber]
   ,[TxnDate]
   ,[DepartmentRef]
   ,[CurrencyRef]
   ,[ExchangeRate]
   ,[PrivateNote]
   ,[LinkedTxn]
   ,[Line]
   ,[TxnTaxDetail]
   ,[CustomerRef]
   ,[CustomerMemo]
   ,[BillAddr]
   ,[ShipAddr]
   ,[ClassRef]
   ,[SalesTermRef]
   ,[DueDate]
   ,[GlobalTaxCalculation]
   ,[ShipMethodRef]
   ,[ShipDate]
   ,[TrackingNum]
   ,[TotalAmt]
   ,[HomeTotalAmt]
   ,[ApplyTaxAfterDiscount]
   ,[PrintStatus]
   ,[EmailStatus]
   ,[BillEmail]
   ,[DeliveryInfo]
   ,[Balance]
   ,[HomeBalance]
   ,[TxnSource]
   ,[Deposit]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$MS-QBO Invoice$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in MS-QBO Invoice table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Id Primary Key Searchnvarchar(500)
3SyncToken Searchnvarchar(500)
4MetaData Searchimage
5MetaData CreateTime Searchdatetime
6MetaData LastUpdatedTime Searchdatetime
7CustomField Searchimage
8DocNumber Searchnvarchar(42)
9TxnDate Searchdatetime
10DepartmentRef Searchimage
11CurrencyRef Searchimage
12ExchangeRate Searchdecimal(38,38)
13PrivateNote Searchimage
14LinkedTxn Searchimage
15Line Searchimage
16TxnTaxDetail Searchimage
17CustomerRef Searchimage
18CustomerMemo Searchimage
19BillAddr Searchimage
20ShipAddr Searchimage
21ClassRef Searchimage
22SalesTermRef Searchimage
23DueDate Searchdatetime
24GlobalTaxCalculation Searchimage
25ShipMethodRef Searchimage
26ShipDate Searchdatetime
27TrackingNum Searchnvarchar(500)
28TotalAmt Searchdecimal(38,38)
29HomeTotalAmt Searchdecimal(38,38)
30ApplyTaxAfterDiscount Searchtinyint
31PrintStatus Searchnvarchar(26)
32EmailStatus Searchnvarchar(20)
33BillEmail Searchimage
34DeliveryInfo Searchnvarchar(500)
35Balance Searchdecimal(38,38)
36HomeBalance Searchdecimal(38,38)
37TxnSource Searchnvarchar(500)
38Deposit Searchnvarchar(60)
39$systemId Searchuniqueidentifier
40$systemCreatedAt Searchdatetime
41$systemCreatedBy Searchuniqueidentifier
42$systemModifiedAt Searchdatetime
43$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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