Diagrams

Table

Job Resource Price

DynamicsDocs.comJob Resource Price«Table 1012»Job Resource PriceJob No. [PK,NN]Job Task No. [PK]Type; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %DescriptionApply Job PriceApply Job Discount«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total 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]...<Job No.><Job Task No.><Code><Code><Work Type Code><Currency Code><Person Responsible><Resource Filter><Resource Gr. Filter><Currency Code><Invoice Currency Code><Job No.><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 Job No. (Job No.) Code20 NotBlank: Yes
2 Job Task No. (Job Task No.) Code20
3 Type (Type) Option
4 Code (Code) Code20
5 Work Type Code (Work Type Code) Code10
6 Unit Price (Unit Price) Decimal
7 Currency Code (Currency Code) Code10
8 Unit Cost Factor (Unit Cost Factor) Decimal
9 Line Discount % (Line Discount %) Decimal
10 Description (Description) Text50 Editable: No
11 Apply Job Price (Apply Job Price) Boolean
12 Apply Job Discount (Apply Job Discount) Boolean

Keys

# Fields
0 Job No.,Job Task No.,Type,Code,Work Type Code,Currency Code (Job No.,Job Task No.,Type,Code,Work Type Code,Currency Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code (Currency Code) Currency Code (Code) 1..n
Job No. (Job No.) Job No. (No.) 1..n
Job Task No. (Job Task No.) Job Task Job Task No. (Job Task No.) 1..n
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