Diagrams

Table

Resource Cost

DynamicsDocs.comResource Cost«Table 202»Resource CostType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Cost Type; [Fixed,% Extra,LCY Extra]Direct Unit CostUnit Cost«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 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 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code<Code><Code><Work Type Code><Resource Group No.>

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

Fields

# Name Type
1 Type (Type) Option
2 Code (Code) Code20
3 Work Type Code (Work Type Code) Code10
4 Cost Type (Cost Type) Option
5 Direct Unit Cost (Direct Unit Cost) Decimal
6 Unit Cost (Unit Cost) Decimal

Keys

# Fields
0 Type,Code,Work Type Code (Type,Code,Work Type Code) Clustered: Yes
1 Cost Type,Code,Work Type Code (Cost Type,Code,Work Type Code)

Table Relations To Other Tables

Field Related Table Related Field
Code (Code) Resource No. (No.) 1..n
Code (Code) Resource Group No. (No.) 1..n
Work Type Code (Work Type Code) Work Type Code (Code) 1..n

Table Relations From Other Tables

From Table From Field