Diagrams


Table

Resource Price Change

DynamicsDocs.comResource Price Change«Table 335»Resource Price ChangeType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Currency Code [PK]Current Unit PriceNew Unit Price«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«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...<Code><Code><Work Type Code><Currency 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
2 Type Option
3 Code Code20
4 Work Type Code Code10
5 Currency Code Code10
6 Current Unit Price Decimal
7 New Unit Price Decimal

Keys

# Fields
0 Type,Code,Work Type Code,Currency Code Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field