Diagrams

Table

Time Sheet Header Archive

DynamicsDocs.comTime Sheet Header Archive«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 955»Time Sheet Line ArchiveTime 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 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 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.><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. (No.) Code20
3 Starting Date (Starting Date) Date
4 Ending Date (Ending Date) Date
5 Resource No. (Resource No.) Code20
7 Owner User ID (Owner User ID) Code50
8 Approver User ID (Approver User ID) Code50
20 Quantity (Quantity) Decimal FlowField
26 Comment (Comment) Boolean Editable: No
FlowField
30 Status Filter (Status Filter) Option FlowFilter
31 Job No. Filter (Job No. Filter) Code20 FlowFilter
32 Job Task No. Filter (Job Task No. Filter) Code20 FlowFilter
33 Date Filter (Date Filter) Date FlowFilter
34 Posted Filter (Posted Filter) Boolean FlowFilter
35 Type Filter (Type Filter) Option FlowFilter

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Time Sheet Detail Archive Time Sheet No. (Time Sheet No.) 1..n
Time Sheet Line Archive Time Sheet No. (Time Sheet No.) 1..n