Diagrams


Table

Time Sheet Header

DynamicsDocs.comTime Sheet Header«Table 950»Time Sheet HeaderNo. [PK]Starting DateEnding DateResource No.Owner User IDApprover User IDOpen ExistsSubmitted ExistsRejected ExistsApproved ExistsPosted ExistsQuantityPosted QuantityCommentStatus Filter; [Open,Submitted,Rejecte...Job No. FilterJob Task No. FilterDate FilterPosted FilterType Filter; [,Resource,Job,Service,Ab...«Table 207»Res. Journal LineJournal Template Name [PK]Line No. [PK]Entry Type; [Usage,Sale]Document No.Posting DateResource No.Resource Group No.DescriptionWork Type CodeJob No.Unit of Measure CodeQuantityDirect Unit CostUnit CostTotal CostUnit PriceTotal PriceShortcut Dimension 1 CodeShortcut Dimension 2 CodeSource CodeJournal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateExternal Document No.Posting No. SeriesSource Type; [,Customer]...«Table 210»Job Journal LineJournal Template Name [PK]Line No. [PK]Job No.Posting DateDocument No.Type; [Resource,Item,G/L Account]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeChargeablePosting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeWork Type CodeCustomer Price GroupApplies-to EntryEntry Type; [Usage,Sale]Source CodeJournal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring Frequency...«Table 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price Group...«Table 5991»Service Shipment LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No.Order Line No.Bill-to Customer No....«Table 951»Time Sheet LineTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«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 958»Time Sheet Posting EntryEntry No. [PK]Time Sheet No.Time Sheet Line No.Time Sheet DateQuantityDocument No.Posting DateDescription«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 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Resource No.><Owner User ID><Approver User ID><Time Sheet No.><Time Sheet No.><Time Sheet No.><Time Sheet No.><Time Sheet No.><Time Sheet No.><Time Sheet No.><Resource No.><Time Sheet Line No.><Time Sheet Date><No.><Time Sheet Line No.><Time Sheet Date><No.><Attached to Line No.><Time Sheet Line No.><Time Sheet Date><No.><Time Sheet Line No.><Time Sheet Date><Approver ID><Approved By><Resource No.><Time Sheet Owner User ID><Time Sheet Approver User ID><Approver ID><Substitute>

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

Fields

# Name Type
1 No. Code20
3 Starting Date Date
4 Ending Date Date
5 Resource No. Code20
7 Owner User ID Code50
8 Approver User ID Code50
12 Open Exists Boolean Editable: No
FlowField
13 Submitted Exists Boolean Editable: No
FlowField
14 Rejected Exists Boolean Editable: No
FlowField
15 Approved Exists Boolean Editable: No
FlowField
16 Posted Exists Boolean Editable: No
FlowField
20 Quantity Decimal FlowField
21 Posted Quantity Decimal FlowField
26 Comment Boolean Editable: No
FlowField
30 Status Filter Option FlowFilter
31 Job No. Filter Code20 FlowFilter
32 Job Task No. Filter Code20 FlowFilter
33 Date Filter Date FlowFilter
34 Posted Filter Boolean FlowFilter
35 Type Filter Option FlowFilter

Keys

# Fields
0 No. Clustered: Yes
1 Resource No.,Starting Date

Table Relations To Other Tables

Field Related Table Related Field
Resource No. Resource No. 1..n
Approver User ID User Setup User ID 1..n

Table Relations From Other Tables

From Table From Field
Job Journal Line Time Sheet No. 1..n
Res. Journal Line Time Sheet No. 1..n
Service Line Time Sheet No. 1..n
Service Shipment Line Time Sheet No. 1..n
Time Sheet Detail Time Sheet No. 1..n
Time Sheet Line Time Sheet No. 1..n
Time Sheet Posting Entry Time Sheet No. 1..n