Diagrams

Table

Unit of Measure

DynamicsDocs.comUnit of Measure«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 1301»Item TemplateKey [PK]Code [NN]Template Name [NN]Base Unit of MeasureType; [Inventory,Service]Inventory Posting GroupItem Disc. GroupAllow Invoice Disc.Price/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Indirect Cost %Price Includes VATGen. Prod. Posting GroupAutomatic Ext. TextsTax Group CodeVAT Prod. Posting GroupItem Category CodeService Item GroupWarehouse Class Code«Table 152»Resource GroupNo. [PK,NN]NameDate FilterCapacityQty. on Order [Job]Qty. Quoted [Job]Unit of Measure FilterUsage [Qty.]Usage [Cost]Usage [Price]Sales [Qty.]Sales [Cost]Sales [Price]Chargeable FilterGlobal Dimension 1 CodeGlobal Dimension 2 CodeNo. of Resources AssignedQty. on Service Order«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«Table 278»Job Journal QuantityIs Total [PK]Unit of Measure Code [PK]Line Type; [,Total] [PK]Work Type Code [PK]Quantity«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 5220»Human Resource Unit of MeasureCode [PK,NN]Qty. per Unit of Measure«Table 5402»Unit of Measure TranslationCode [PK,NN]Language Code [PK,NN]Description [NN]«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 5718»Nonstock ItemEntry No. [PK]Manufacturer CodeVendor No.Vendor Item No.DescriptionUnit of MeasurePublished CostNegotiated CostUnit PriceGross WeightNet WeightItem Template CodeProduct Group CodeLast Date ModifiedBar CodeItem No.CommentNo. Series«Table 5905»Service CostCode [PK,NN]DescriptionAccount No.Default Unit PriceDefault QuantityUnit of Measure CodeCost Type; [Travel,Support,Other]Service Zone CodeDefault Unit Cost«Table 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,Order]«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 99000779»Production BOM VersionProduction BOM No. [PK,NN]Version Code [PK]DescriptionStarting DateUnit of Measure CodeLast Date ModifiedStatus; [New,Certified,Under Developme...No. Series<Base Unit of Measure><Unit of Measure Filter><Base Unit of Measure><Unit of Measure Filter><Unit of Measure Code><Code><Unit of Measure Code><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Code><Code><Code><Unit of Measure><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Resource Group No.><Resource No.><Preferred Resource><Work Type Code><Alternative Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Item No.><Item No.><Item No.><Unit of Measure Code><Unit of Measure Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text10
3 International Standard Code (International Standard Code) Code10
4 Symbol (Symbol) Text10
5 Last Modified Date Time (Last Modified Date Time) DateTime Editable: No
8000 Id (Id) GUID

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Description (Description)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Filed Contract Line Unit of Measure Code (Unit of Measure Code) 1..n
Gen. Journal Line Job Unit Of Measure Code (Job Unit Of Measure Code) 1..n
Human Resource Unit of Measure Code (Code) 1..1
Item Unit of Measure Id (Unit of Measure Id) 1..n
Item Template Base Unit of Measure (Base Unit of Measure) 1..n
Item Unit of Measure Code (Code) 1..n
Job Journal Line Unit of Measure Code (Unit of Measure Code) 1..n
Job Journal Quantity Unit of Measure Code (Unit of Measure Code) 1..n
Job Planning Line Unit of Measure Code (Unit of Measure Code) 1..n
Loaner Unit of Measure Code (Unit of Measure Code) 1..n
Nonstock Item Unit of Measure (Unit of Measure) 1..n
Production BOM Header Unit of Measure Code (Unit of Measure Code) 1..n
Production BOM Line Unit of Measure Code (Unit of Measure Code) 1..n
Production BOM Version Unit of Measure Code (Unit of Measure Code) 1..n
Purch. Cr. Memo Line Unit of Measure Code (Unit of Measure Code) 1..n
Purch. Inv. Line Unit of Measure Code (Unit of Measure Code) 1..n
Purch. Inv. Line Aggregate Unit of Measure Code (Unit of Measure Code) 1..n
Purch. Rcpt. Line Unit of Measure Code (Unit of Measure Code) 1..n
Purchase Line Unit of Measure Code (Unit of Measure Code) 1..n
Purchase Line Archive Unit of Measure Code (Unit of Measure Code) 1..n
Requisition Line Unit of Measure Code (Unit of Measure Code) 1..n
Res. Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Resource Unit of Measure Filter (Unit of Measure Filter) 1..n
Resource Group Unit of Measure Filter (Unit of Measure Filter) 1..n
Resource Unit of Measure Code (Code) 1..n
Return Receipt Line Unit of Measure Code (Unit of Measure Code) 1..n
Return Shipment Line Unit of Measure Code (Unit of Measure Code) 1..n
Sales Cr.Memo Line Unit of Measure Code (Unit of Measure Code) 1..n
Sales Invoice Line Unit of Measure Code (Unit of Measure Code) 1..n
Sales Invoice Line Aggregate Unit of Measure Id (Unit of Measure Id) 1..n
Sales Line Unit of Measure Code (Unit of Measure Code) 1..n
Sales Line Archive Unit of Measure Code (Unit of Measure Code) 1..n
Sales Shipment Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Contract Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Cost Unit of Measure Code (Unit of Measure Code) 1..n
Service Cr.Memo Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Invoice Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Item Unit of Measure Code (Unit of Measure Code) 1..n
Service Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Service Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Shipment Line Unit of Measure Code (Unit of Measure Code) 1..n
Standard Purchase Line Unit of Measure Code (Unit of Measure Code) 1..n
Standard Sales Line Unit of Measure Code (Unit of Measure Code) 1..n
Standard Service Line Unit of Measure Code (Unit of Measure Code) 1..n
Unit of Measure Translation Code (Code) 1..n
Warranty Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Work Type Unit of Measure Code (Unit of Measure Code) 1..n