Diagrams


Table

Res. Journal Line

DynamicsDocs.comRes. Journal Line«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 206»Res. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«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 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«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 230»Source CodeCode [PK,NN]Description«Table 236»Res. Journal BatchJournal Template Name [PK]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«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«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 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<Journal Template Name><Resource No.><Resource Group No.><Work Type Code><Job No.><Unit of Measure Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Source Code><Journal Batch Name><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Posting No. Series><Source No.><Dimension Set ID><Time Sheet No.><Time Sheet Line No.><Time Sheet Date><Source Code><Reason Code><No. Series><Posting No. Series><Journal Template Name><Resource Group No.><Global Dimension 1 Code><Global Dimension 2 Code><Gen. Prod. Posting Group><No. Series><Person Responsible><Resource Filter><Resource No.><Resource No.><Resource No.><Global Dimension 1 Code><Global Dimension 2 Code><Resource Gr. Filter><Work Type Code><Bill-to Customer No.><Global Dimension 1 Code><Global Dimension 2 Code><No. Series><Job No.><Job No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Reason Code><No. Series><Posting No. Series><Gen. Bus. Posting Group><No. Series><Bill-to Customer No.><Time Sheet No.><Time Sheet No.>

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

Fields

# Name Type
1 Journal Template Name Code10
2 Line No. Integer
3 Entry Type Option
4 Document No. Code20
5 Posting Date Date
6 Resource No. Code20
7 Resource Group No. Code20 Editable: No
8 Description Text50
9 Work Type Code Code10
10 Job No. Code20
11 Unit of Measure Code Code10
12 Quantity Decimal (0:5)
13 Direct Unit Cost Decimal
14 Unit Cost Decimal
15 Total Cost Decimal
16 Unit Price Decimal
17 Total Price Decimal
18 Shortcut Dimension 1 Code Code20
19 Shortcut Dimension 2 Code Code20
21 Source Code Code10 Editable: No
23 Journal Batch Name Code10
24 Reason Code Code10
25 Recurring Method Option BlankZero: Yes
26 Expiration Date Date
27 Recurring Frequency DateFormula
28 Gen. Bus. Posting Group Code20
29 Gen. Prod. Posting Group Code20
30 Document Date Date
31 External Document No. Code35
32 Posting No. Series Code20
33 Source Type Option
34 Source No. Code20
35 Qty. per Unit of Measure Decimal
90 Order Type Option Editable: No
91 Order No. Code20 Editable: No
92 Order Line No. Integer Editable: No
480 Dimension Set ID Integer Editable: No
950 Time Sheet No. Code20
951 Time Sheet Line No. Integer
952 Time Sheet Date Date
959 System-Created Entry Boolean Editable: No

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Source No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut 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
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Journal Batch Name Res. Journal Batch Name 1..n
Journal Template Name Res. Journal Template Name 1..n
Resource No. Resource No. 1..n
Resource Group No. Resource Group No. 1..n
Unit of Measure Code Resource Unit of Measure Code 1..n
Source Code Source Code Code 1..n
Time Sheet Date Time Sheet Detail Date 1..n
Time Sheet No. Time Sheet Header No. 1..n
Time Sheet Line No. Time Sheet Line Line No. 1..n
Work Type Code Work Type Code 1..n

Table Relations From Other Tables

From Table From Field