Diagrams


Table

Time Sheet Detail Archive

DynamicsDocs.comTime Sheet Detail Archive«Table 956»Time Sheet Detail ArchiveTime 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...PostedDocument No.Posting Date«Table 954»Time Sheet Header ArchiveNo. [PK]Starting DateEnding DateResource No.Owner User IDApprover User IDQuantityCommentStatus Filter; [Open,Submitted,Rejecte...Job No. FilterJob Task No. FilterDate FilterPosted FilterType Filter; [,Resource,Job,Service,Ab...«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 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 5206»Cause of AbsenceCode [PK,NN]DescriptionUnit of Measure CodeTotal Absence [Base]Global Dimension 1 FilterGlobal Dimension 2 FilterEmployee No. FilterDate Filter«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 900»Assembly HeaderDocument Type; [Quote,Order,,,Blanket...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedItem No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Assembled QuantityAssembled Quantity [Base]Quantity to AssembleQuantity to Assemble [Base]Reserved QuantityReserved Qty. [Base]Planning Flexibility; [Unlimited,None]...<Time Sheet No.><Resource No.><Job No.><Job Task No.><Cause of Absence Code><Service Order No.><Assembly Order No.><Resource No.><Person Responsible><Resource Filter><Resource Filter><Job No.>

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

Fields

# Name Type
1 Time Sheet No. Code20
2 Time Sheet Line No. Integer
3 Date Date
4 Type Option
5 Resource No. Code20
6 Job No. Code20
7 Job Task No. Code20
9 Cause of Absence Code Code10
13 Service Order No. Code20
14 Service Order Line No. Integer
15 Quantity Decimal Editable: No
16 Posted Quantity Decimal
18 Assembly Order No. Code20
19 Assembly Order Line No. Integer
20 Status Option
23 Posted Boolean
24 Document No. Code20
25 Posting Date Date

Keys

# Fields
0 Time Sheet No.,Time Sheet Line No.,Date Clustered: Yes
1 Type,Job No.,Job Task No.,Status,Posted

Table Relations To Other Tables

Field Related Table Related Field
Assembly Order No. Assembly Header No. 1..n
Cause of Absence Code Cause of Absence Code 1..n
Job No. Job No. 1..n
Job Task No. Job Task Job Task No. 1..n
Resource No. Resource No. 1..n
Service Order No. Service Header No. 1..n
Time Sheet No. Time Sheet Header Archive No. 1..n

Table Relations From Other Tables

From Table From Field