Diagrams

Table

Job Planning Line - Calendar

DynamicsDocs.comJob Planning Line - Calendar«Table 1034»Job Planning Line - CalendarJob No. [PK]Job Task No. [PK]Planning Line No. [PK]Resource No.Planning DateQuantityDescriptionUIDSequence«Table 1003»Job Planning LineLine No. [PK]Job No. [PK,NN]Planning DateDocument No.Type; [Resource,Item,G/L Account,Text]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeLast Date ModifiedUser IDWork Type CodeCustomer Price GroupCountry/Region CodeGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateJob Task No. [PK,NN]Line Amount [LCY]Unit CostTotal CostUnit PriceTotal PriceLine Amount...«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]...<Job No.><Job Task No.><Planning Line No.><Resource No.><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
2 Job Task No. (Job Task No.) Code20
3 Planning Line No. (Planning Line No.) Integer
4 Resource No. (Resource No.) Code20
6 Planning Date (Planning Date) Date
7 Quantity (Quantity) Decimal
8 Description (Description) Text50
9 UID (UID) GUID
10 Sequence (Sequence) Integer

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Planning Line No. (Planning Line No.) Job Planning Line Line No. (Line No.) 1..1
Resource No. (Resource No.) Resource No. (No.) 1..n

Table Relations From Other Tables

From Table From Field