Diagrams


Table

Job Task

DynamicsDocs.comJob Task«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 1002»Job Task DimensionJob No. [PK,NN]Job Task No. [PK,NN]Dimension Code [PK]Dimension Value CodeMultiple Selection Action; [,Change,De...«Table 1007»Job WIP WarningEntry No. [PK]Job No.Job Task No.Job WIP Total Entry No.Warning Message«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 1013»Job Item PriceJob No. [PK,NN]Job Task No. [PK]Item No. [PK]Unit of Measure Code [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %DescriptionVariant Code [PK]Apply Job PriceApply Job Discount«Table 1014»Job G/L Account PriceJob No. [PK,NN]Job Task No. [PK]G/L Account No. [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %Unit CostDescription«Table 1020»Job Usage LinkJob No. [PK]Job Task No. [PK]Line No. [PK]Entry No. [PK]«Table 952»Time Sheet DetailTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Posted«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...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 208»Job Posting GroupCode [PK,NN]WIP Costs AccountWIP Accrued Costs AccountJob Costs Applied AccountJob Costs Adjustment AccountG/L Expense Acc. [Contract]Job Sales Adjustment AccountWIP Accrued Sales AccountWIP Invoiced Sales AccountJob Sales Applied AccountRecognized Costs AccountRecognized Sales AccountItem Costs Applied AccountResource Costs Applied AccountG/L Costs Applied Account«Table 1006»Job WIP MethodCode [PK,NN]DescriptionWIP CostWIP SalesRecognized Costs; [At Completion,Cost...Recognized Sales; [At Completion,Contr...ValidSystem DefinedSystem-Defined Index<Job No.><Job Posting Group><WIP Method><Job No.><Job Task No.><Job Task No.><Job Task No.><Job Task No.><Job Task No.><Job Task No.><Job Task No.><Job No.><Job No.><Job No.><Job No.><Job No.><Job No.><Job Posting Group><WIP Method>

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
Editable: No
2 Job Task No. (Job Task No.) Code20 NotBlank: Yes
3 Description (Description) Text50
4 Job Task Type (Job Task Type) Option
6 WIP-Total (WIP-Total) Option
7 Job Posting Group (Job Posting Group) Code10
9 WIP Method (WIP Method) Code20
10 Schedule (Total Cost) (Schedule (Total Cost)) Decimal BlankZero: Yes
Editable: No
FlowField
11 Schedule (Total Price) (Schedule (Total Price)) Decimal BlankZero: Yes
Editable: No
FlowField
12 Usage (Total Cost) (Usage (Total Cost)) Decimal BlankZero: Yes
Editable: No
FlowField
13 Usage (Total Price) (Usage (Total Price)) Decimal BlankZero: Yes
Editable: No
FlowField
14 Contract (Total Cost) (Contract (Total Cost)) Decimal BlankZero: Yes
Editable: No
FlowField
15 Contract (Total Price) (Contract (Total Price)) Decimal BlankZero: Yes
Editable: No
FlowField
16 Contract (Invoiced Price) (Contract (Invoiced Price)) Decimal BlankZero: Yes
Editable: No
FlowField
17 Contract (Invoiced Cost) (Contract (Invoiced Cost)) Decimal BlankZero: Yes
Editable: No
FlowField
19 Posting Date Filter (Posting Date Filter) Date FlowFilter
20 Planning Date Filter (Planning Date Filter) Date FlowFilter
21 Totaling (Totaling) Text250
22 New Page (New Page) Boolean
23 No. of Blank Lines (No. of Blank Lines) Integer BlankZero: Yes
24 Indentation (Indentation) Integer
34 Recognized Sales Amount (Recognized Sales Amount) Decimal BlankZero: Yes
Editable: No
37 Recognized Costs Amount (Recognized Costs Amount) Decimal BlankZero: Yes
Editable: No
56 Recognized Sales G/L Amount (Recognized Sales G/L Amount) Decimal BlankZero: Yes
Editable: No
57 Recognized Costs G/L Amount (Recognized Costs G/L Amount) Decimal BlankZero: Yes
Editable: No
60 Global Dimension 1 Code (Global Dimension 1 Code) Code20
61 Global Dimension 2 Code (Global Dimension 2 Code) Code20
62 Outstanding Orders (Outstanding Orders) Decimal FlowField
63 Amt. Rcd. Not Invoiced (Amt. Rcd. Not Invoiced) Decimal FlowField
64 Remaining (Total Cost) (Remaining (Total Cost)) Decimal BlankZero: Yes
Editable: No
FlowField
65 Remaining (Total Price) (Remaining (Total Price)) Decimal BlankZero: Yes
Editable: No
FlowField
66 Start Date (Start Date) Date Editable: No
FlowField
67 End Date (End Date) Date Editable: No
FlowField

Keys

# Fields
0 Job No.,Job Task No. (Job No.,Job Task No.) Clustered: Yes
1 Job Task No. (Job Task No.)

Table Relations To Other Tables

Field Related Table Related Field
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Job No. (Job No.) Job No. (No.) 1..n
Job Posting Group (Job Posting Group) Job Posting Group Code (Code) 1..n
WIP Method (WIP Method) Job WIP Method Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Gen. Journal Line Job Task No. (Job Task No.) 1..n
Item Ledger Entry Job Task No. (Job Task No.) 1..n
Job G/L Account Price Job Task No. (Job Task No.) 1..n
Job Item Price Job Task No. (Job Task No.) 1..n
Job Journal Line Job Task No. (Job Task No.) 1..n
Job Ledger Entry Job Task No. (Job Task No.) 1..n
Job Planning Line Job Task No. (Job Task No.) 1..n
Job Planning Line Invoice Job Task No. (Job Task No.) 1..n
Job Resource Price Job Task No. (Job Task No.) 1..n
Job Task Dimension Job Task No. (Job Task No.) 1..n
Job Usage Link Job Task No. (Job Task No.) 1..n
Job WIP Warning Job Task No. (Job Task No.) 1..n
Prepayment Inv. Line Buffer Job Task No. (Job Task No.) 1..n
Purch. Cr. Memo Line Job Task No. (Job Task No.) 1..n
Purch. Inv. Line Job Task No. (Job Task No.) 1..n
Purch. Rcpt. Line Job Task No. (Job Task No.) 1..n
Purchase Line Job Task No. (Job Task No.) 1..n
Return Shipment Line Job Task No. (Job Task No.) 1..n
Sales Cr.Memo Line Job Task No. (Job Task No.) 1..n
Sales Invoice Line Job Task No. (Job Task No.) 1..n
Sales Line Job Task No. (Job Task No.) 1..n
Sales Shipment Line Job Task No. (Job Task No.) 1..n
Service Ledger Entry Job Task No. (Job Task No.) 1..n
Service Line Job Task No. (Job Task No.) 1..n
Time Sheet Detail Job Task No. (Job Task No.) 1..n
Time Sheet Detail Archive Job Task No. (Job Task No.) 1..n
Time Sheet Line Job Task No. (Job Task No.) 1..n
Time Sheet Line Archive Job Task No. (Job Task No.) 1..n
Value Entry Job Task No. (Job Task No.) 1..n