Diagrams


Table

Time Sheet Line

DynamicsDocs.comTime Sheet Line«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 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 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 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 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 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«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 AdministratorTime Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. 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.><Job No.><Job Task No.><Cause of Absence Code><Work Type Code><Approver ID><Approved By><Service Order No.><Assembly Order No.><Time Sheet Line No.><Time Sheet Line No.><Time Sheet Line No.><Time Sheet Line No.><Work Type Code><Job No.><Time Sheet No.><Job No.><Work Type Code><Time Sheet No.><Job Task No.><Document No.><Job No.><Job Task No.><Work Type Code><Attached to Line No.><Time Sheet No.><Work Type Code><Time Sheet No.><Owner User ID><Approver User ID><Job No.><Approver ID><Substitute><Assigned User ID><Assigned User ID>

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 Line No. Integer
3 Time Sheet Starting Date Date Editable: No
5 Type Option
6 Job No. Code20
7 Job Task No. Code20
9 Cause of Absence Code Code10
10 Description Text50
11 Work Type Code Code10
12 Approver ID Code50 Editable: No
13 Service Order No. Code20
14 Service Order Line No. Integer
15 Total Quantity Decimal Editable: No
FlowField
17 Chargeable Boolean
18 Assembly Order No. Code20 Editable: No
19 Assembly Order Line No. Integer Editable: No
20 Status Option Editable: No
21 Approved By Code50 Editable: No
22 Approval Date Date Editable: No
23 Posted Boolean Editable: No
26 Comment Boolean Editable: No
FlowField

Keys

# Fields
0 Time Sheet No.,Line No. Clustered: Yes
1 Type
2 Time Sheet 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
Service Order No. Service Header No. 1..n
Time Sheet No. Time Sheet Header No. 1..n
Approved By User Setup User ID 1..n
Work Type Code Work Type Code 1..n

Table Relations From Other Tables

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