Unit of Measure

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

Table Type: Company

Table Name: Unit of Measure
Database Table Name: CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Unit of Measure can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Description]
   ,[International Standard Code]
   ,[Symbol]
   ,[Last Modified Date Time]
   ,[Coupled to CRM]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Unit of Measure table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Description Searchnvarchar(100)
4International Standard Code Searchnvarchar(20)
5Symbol Searchnvarchar(20)
6Last Modified Date Time Searchdatetime
7Coupled to CRM Searchtinyint
8Id Searchuniqueidentifier
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Unit of Measure table

Assembly HeaderAssembly LineAvailability Calc_ OverviewBin ContentBin Creation Worksheet LineBOM BufferBOM ComponentCapacity Ledger EntryCause of AbsenceDirect Trans_ LineEmployee AbsenceFamily LineFiled Contract LineHandled IC Inbox Purch_ LineHandled IC Inbox Sales LineHandled IC Outbox Purch_ LineHandled IC Outbox Sales LineIC Inbox Purchase LineIC Inbox Sales LineIC Outbox Purchase LineIC Outbox Sales LineInternal Movement LineInventory ProfileInvt_ Document LineInvt_ Receipt LineInvt_ Shipment LineItemItemItemItem IdentifierItem Journal LineItem Ledger EntryJob Difference BufferJob Item PriceJob Journal LineJob Journal QuantityJob Ledger EntryJob Planning LineJob Posting BufferLoanerOrder Promising LinePhys_ Inventory Ledger EntryPhys_ Invt_ Record LinePlanning ComponentPosted Assembly HeaderPosted Assembly LinePosted Invt_ Pick LinePosted Invt_ Put-away LinePosted Whse_ Receipt LinePosted Whse_ Shipment LinePrice List LinePrice Worksheet LineProduction BOM HeaderProduction BOM LineProduction BOM VersionProduction Forecast EntryProduction Matrix BOM LineProd_ Order ComponentProd_ Order LinePstd_ Phys_ Invt_ Record LinePurchase LinePurchase Line ArchivePurchase Line DiscountPurchase PricePurch_ Cr_ Memo LinePurch_ Inv_ LinePurch_ Price Line Disc_ Buff_Purch_ Rcpt_ LineRegistered Invt_ Movement LineRegistered Whse_ Activity LineRequisition LineRes_ Journal LineRes_ Ledger EntryReturn Receipt LineReturn Shipment LineSales Cr_Memo LineSales Invoice LineSales LineSales Line ArchiveSales Line DiscountSales PriceSales Price and Line Disc BuffSales Price WorksheetSales Shipment LineService Contract LineService CostService Cr_Memo LineService Invoice LineService ItemService Ledger EntryService LineService Order Posting BufferService Shipment LineStandard Item Journal LineStandard Purchase LineStandard Sales LineStandard Service LineStockkeeping UnitTransfer LineTransfer Receipt LineTransfer Shipment LineUnplanned DemandWarehouse Activity LineWarehouse EntryWarehouse Journal LineWarehouse Receipt LineWarehouse Shipment LineWarranty Ledger EntryWhse_ Cross-Dock OpportunityWhse_ Internal Pick LineWhse_ Internal Put-away LineWhse_ Worksheet LineWork CenterWork Type

Leave a Reply

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