Diagrams

Table

Resource Group

DynamicsDocs.comResource Group«Table 152»Resource GroupNo. [PK,NN]NameDate FilterCapacityQty. on Order [Job]Qty. Quoted [Job]Unit of Measure FilterUsage [Qty.]Usage [Cost]Usage [Price]Sales [Qty.]Sales [Cost]Sales [Price]Chargeable FilterGlobal Dimension 1 CodeGlobal Dimension 2 CodeNo. of Resources AssignedQty. on Service Order«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 1012»Job Resource PriceJob No. [PK,NN]Job Task No. [PK]Type; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %DescriptionApply Job PriceApply Job Discount«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 160»Res. Capacity EntryEntry No. [PK]Resource No.Resource Group No.DateCapacity«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 169»Job Ledger EntryEntry 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 CodeJob Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeWork Type CodeCustomer Price GroupUser IDSource CodeAmt. to Post to G/LAmt. Posted to G/LEntry Type; [Usage,Sale]Journal Batch NameReason CodeTransaction TypeTransport MethodCountry/Region Code...«Table 201»Resource PriceType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Unit PriceCurrency Code [PK]«Table 202»Resource CostType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Cost Type; [Fixed,% Extra,LCY Extra]Direct Unit CostUnit Cost«Table 203»Res. Ledger EntryEntry 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 PriceGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeChargeableJournal Batch NameReason CodeGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateExternal Document No.No. SeriesSource Type; [,Customer]Source No.Qty. per Unit of Measure...«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 335»Resource Price ChangeType; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Currency Code [PK]Current Unit PriceNew Unit Price«Table 352»Default DimensionTable ID [PK,NN]No. [PK]Dimension Code [PK,NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...Table CaptionMulti Selection Action; [,Change,Delet...«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 5901»Service Item LineDocument No. [PK]Line No. [PK]Service Item No.Service Item Group CodeItem No.Serial No.DescriptionDescription 2Repair Status CodePriority; [Low,Medium,High]Response Time [Hours]Response DateResponse TimeStarting DateStarting TimeFinishing DateFinishing TimeService Shelf No.Warranty Starting Date [Parts]Warranty Ending Date [Parts]WarrantyWarranty % [Parts]Warranty % [Labor]Warranty Starting Date [Labor]Warranty Ending Date [Labor]Contract No.Location of Service ItemLoaner No.Vendor No.Vendor Item No.Fault Reason Code...«Table 5950»Service Order AllocationEntry No. [PK]Status; [Nonactive,Active,Finished,Can...Document No.Allocation DateResource No.Resource Group No.Service Item Line No.Allocated HoursStarting TimeFinishing TimeDescriptionReason CodeService Item No.PostedService Item DescriptionService Item Serial No.Repair StatusService StartedDocument Type; [Quote,Order]«Table 5972»Contract/Service DiscountContract Type; [Quote,Contract,Templat...Contract No. [PK]Type; [Service Item Group,Resource Gro...No. [PK]Starting Date [PK]Discount %«Table 5989»Service Shipment Item LineNo. [PK]Line No. [PK]Service Item No.Service Item Group CodeItem No.Serial No.DescriptionDescription 2Priority; [Low,Medium,High]Response Time [Hours]Response DateResponse TimeStarting DateStarting TimeFinishing DateFinishing TimeService Shelf No.Warranty Starting Date [Parts]Warranty Ending Date [Parts]WarrantyWarranty % [Parts]Warranty % [Labor]Warranty Starting Date [Labor]Warranty Ending Date [Labor]Contract No.Location of Service ItemLoaner No.Vendor No.Vendor Item No.Fault Reason CodeService Price Group Code...«Table 5990»Service Shipment HeaderCustomer No. [NN]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 DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«Table 5992»Service Invoice HeaderCustomer No. [NN]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 DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«Table 5994»Service Cr.Memo HeaderCustomer No. [NN]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 ContactPosting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price GroupPrices Including VAT...«Table 6083»Serv. Price Adjustment DetailServ. Price Adjmt. Gr. Code [PK,NN]Type; [Item,Resource,Resource Group,Se...No. [PK]Work Type [PK]Gen. Prod. Posting Group [PK]Description«Table 97»Comment LineTable Name; [G/L Account,Customer,Vend...No. [PK]Line No. [PK]DateCodeComment«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID<Unit of Measure Filter><Global Dimension 1 Code><Global Dimension 2 Code><Resource Group No.><Code><Resource Group No.><Resource Group No.><Resource Gr. Filter><Resource Group No.><Code><Code><Resource Group No.><Resource Group No.><Resource Group No.><Code><No.><Resource Group Filter><Resource Group Filter><Resource Group No.><No.><Resource Group Filter><Resource Group Filter><Resource Group Filter><Resource Group Filter><No.><No.><Job No.><No.><Unit of Measure Code><Job Ledger Entry No.><Ledger Entry No.><Job No.><Code><Global Dimension 1 Code><Global Dimension 2 Code><Base Unit of Measure><Unit of Measure Filter><Resource No.><Person Responsible><Resource Filter><No.><Code><Code><Resource No.><Resource No.><No.><Code><No.><Resource Filter><Resource Filter><Resource No.><Resource Filter><Resource Filter><Resource Filter><Resource Filter><No.><No.><Global Dimension 1 Code><Global Dimension 2 Code><Job No.><Job No.><Job No.><Job No.><No.><No.><Global Dimension 1 Code><Global Dimension 2 Code><Ledger Entry No.><Unit of Measure Code><Global Dimension 1 Code><Global Dimension 2 Code><Ledger Entry No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Unit of Measure Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Value Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Last Shipping No.><Last Posting No.><Document No.><Service Order Filter><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Service Item Line No.><No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code>

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 NotBlank: Yes
2 Name (Name) Text50
22 Date Filter (Date Filter) Date FlowFilter
23 Capacity (Capacity) Decimal (0:5) FlowField
24 Qty. on Order (Job) (Qty. on Order (Job)) Decimal (0:5) Editable: No
FlowField
25 Qty. Quoted (Job) (Qty. Quoted (Job)) Decimal (0:5) Editable: No
FlowField
26 Unit of Measure Filter (Unit of Measure Filter) Code10 FlowFilter
27 Usage (Qty.) (Usage (Qty.)) Decimal (0:5) Editable: No
FlowField
28 Usage (Cost) (Usage (Cost)) Decimal Editable: No
FlowField
29 Usage (Price) (Usage (Price)) Decimal Editable: No
FlowField
30 Sales (Qty.) (Sales (Qty.)) Decimal (0:5) Editable: No
FlowField
31 Sales (Cost) (Sales (Cost)) Decimal Editable: No
FlowField
32 Sales (Price) (Sales (Price)) Decimal Editable: No
FlowField
33 Chargeable Filter (Chargeable Filter) Boolean FlowFilter
34 Global Dimension 1 Code (Global Dimension 1 Code) Code20
35 Global Dimension 2 Code (Global Dimension 2 Code) Code20
36 No. of Resources Assigned (No. of Resources Assigned) Integer Editable: No
FlowField
5900 Qty. on Service Order (Qty. on Service Order) Decimal (0:5) FlowField

Keys

# Fields
0 No. (No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Unit of Measure Filter (Unit of Measure Filter) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Comment Line No. (No.) 1..n
Contract/Service Discount No. (No.) 1..n
Default Dimension No. (No.) 1..n
Job Resource Gr. Filter (Resource Gr. Filter) 1..n
Job Journal Line Resource Group No. (Resource Group No.) 1..n
Job Ledger Entry Resource Group No. (Resource Group No.) 1..n
Job Planning Line Resource Group No. (Resource Group No.) 1..n
Job Resource Price Code (Code) 1..n
Res. Capacity Entry Resource Group No. (Resource Group No.) 1..n
Res. Journal Line Resource Group No. (Resource Group No.) 1..n
Res. Ledger Entry Resource Group No. (Resource Group No.) 1..n
Resource Resource Group No. (Resource Group No.) 1..n
Resource Cost Code (Code) 1..n
Resource Price Code (Code) 1..n
Resource Price Change Code (Code) 1..n
Serv. Price Adjustment Detail No. (No.) 1..n
Service Cr.Memo Header Resource Group Filter (Resource Group Filter) 1..n
Service Header Resource Group Filter (Resource Group Filter) 1..n
Service Invoice Header Resource Group Filter (Resource Group Filter) 1..n
Service Item Line Resource Group Filter (Resource Group Filter) 1..n
Service Order Allocation Resource Group No. (Resource Group No.) 1..n
Service Shipment Header Resource Group Filter (Resource Group Filter) 1..n
Service Shipment Item Line Resource Group Filter (Resource Group Filter) 1..n