Diagrams


Table

Res. Ledger Entry

DynamicsDocs.comRes. Ledger Entry«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 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 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 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 240»Resource RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«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 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 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«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 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«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 IDIdLast Modified Date Time«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 230»Source CodeCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Resource No.><Resource Group No.><Work Type Code><Job No.><Unit of Measure Code><Global Dimension 1 Code><Global Dimension 2 Code><User ID><Source Code><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><No. Series><Source No.><Dimension Set ID><Ledger Entry No.><Ledger Entry No.><Ledger Entry No.><From Entry No.><To Entry No.><Job No.><No.><Resource Group No.><Unit of Measure Code><User ID><Work Type Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Job Ledger Entry No.><Job No.><No.><Resource Group No.><Global Dimension 1 Code><Global Dimension 2 Code><Work Type Code><User ID><Source Code><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><No. Series><Dimension Set ID><Job No.><No.><Resource Group No.><Unit of Measure Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Work Type Code><Source Code><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Posting No. Series><Dimension Set ID><Source Code><User ID><Resource Group No.><Global Dimension 1 Code><Global Dimension 2 Code><Base Unit of Measure><Unit of Measure Filter><Gen. Prod. Posting Group><No. Series><Person Responsible><Resource Filter><Unit of Measure Filter><Global Dimension 1 Code><Global Dimension 2 Code><Resource Gr. Filter><Unit of Measure Code><Bill-to Customer No.><Global Dimension 1 Code><Global Dimension 2 Code><No. Series><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Gen. Bus. Posting Group><No. Series><Bill-to Customer No.>

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

Fields

# Name Type
1 Entry No. Integer
2 Entry Type Option
3 Document No. Code20
4 Posting Date Date
5 Resource No. Code20
6 Resource Group No. Code20
7 Description Text50
8 Work Type Code Code10
9 Job No. Code20
10 Unit of Measure Code Code10
11 Quantity Decimal (0:5)
12 Direct Unit Cost Decimal
13 Unit Cost Decimal
14 Total Cost Decimal
15 Unit Price Decimal
16 Total Price Decimal
17 Global Dimension 1 Code Code20
18 Global Dimension 2 Code Code20
20 User ID Code50
21 Source Code Code10
22 Chargeable Boolean
23 Journal Batch Name Code10
24 Reason Code Code10
25 Gen. Bus. Posting Group Code20
26 Gen. Prod. Posting Group Code20
27 Document Date Date
28 External Document No. Code35
29 No. Series Code20
30 Source Type Option
31 Source No. Code20
32 Qty. per Unit of Measure Decimal
33 Quantity (Base) Decimal
90 Order Type Option
91 Order No. Code20
92 Order Line No. Integer
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Resource No.,Posting Date
2 Entry Type,Chargeable,Unit of Measure Code,Resource No.,Posting Date
3 Entry Type,Chargeable,Unit of Measure Code,Resource Group No.,Posting Date
4 Document No.,Posting Date
5 Order Type,Order No.,Order Line No.,Entry Type

Table Relations To Other Tables

Field Related Table Related Field
Source No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Job No. Job No. 1..n
No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Resource No. Resource No. 1..n
Resource Group No. Resource Group No. 1..n
Source Code Source Code Code 1..n
Unit of Measure Code Unit of Measure Code 1..n
User ID User User Name 1..n
Work Type Code Work Type Code 1..n

Table Relations From Other Tables

From Table From Field
Job Journal Line Ledger Entry No. 1..n
Job Ledger Entry Ledger Entry No. 1..n
Job Planning Line Ledger Entry No. 1..n
Resource Register To Entry No. 1..n