Diagrams

Table

Job Journal Line

DynamicsDocs.comJob Journal Line«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 209»Job Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«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 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 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 94»Inventory Posting GroupCode [PK,NN]DescriptionUsed in ItemsUsed in Value Entries«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 237»Job Journal BatchJournal Template Name [PK,NN]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 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 282»Entry/Exit PointCode [PK,NN]Description«Table 285»Transaction SpecificationCode [PK,NN]Text«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«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Journal Template Name><Job No.><No.><No.><No.><Resource Group No.><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Location Code><Posting Group><Work Type Code><Customer Price Group><Journal Batch Name><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Entry/Exit Point><Transaction Specification><Time Sheet No.><Time Sheet Line No.><Time Sheet Date><Job Task No.><Variant Code><Reason Code><Journal Template Name><Person Responsible><Resource Filter><Customer Price Group><Resource Gr. Filter><Job No.><Job No.><Job No.><Resource Group No.><Base Unit of Measure><Unit of Measure Filter><Gen. Prod. Posting Group><Resource No.><Resource No.><Resource No.><Inventory Posting Group><Alternative Item No.><Location Filter><Gen. Prod. Posting Group><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Unit of Measure Filter><Code><Code><Unit of Measure Code><Work Type Code><Reason Code><Time Sheet No.><Time Sheet No.><Job Task No.><Job Task 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 (Journal Template Name) Code10
2 Line No. (Line No.) Integer
3 Job No. (Job No.) Code20
4 Posting Date (Posting Date) Date
5 Document No. (Document No.) Code20
6 Type (Type) Option
8 No. (No.) Code20
9 Description (Description) Text50
10 Quantity (Quantity) Decimal (0:5)
12 Direct Unit Cost (LCY) (Direct Unit Cost (LCY)) Decimal
13 Unit Cost (LCY) (Unit Cost (LCY)) Decimal Editable: No
14 Total Cost (LCY) (Total Cost (LCY)) Decimal Editable: No
15 Unit Price (LCY) (Unit Price (LCY)) Decimal Editable: No
16 Total Price (LCY) (Total Price (LCY)) Decimal Editable: No
17 Resource Group No. (Resource Group No.) Code20 Editable: No
18 Unit of Measure Code (Unit of Measure Code) Code10
21 Location Code (Location Code) Code10
22 Chargeable (Chargeable) Boolean
30 Posting Group (Posting Group) Code20 Editable: No
31 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
32 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
33 Work Type Code (Work Type Code) Code10
34 Customer Price Group (Customer Price Group) Code10
37 Applies-to Entry (Applies-to Entry) Integer
61 Entry Type (Entry Type) Option Editable: No
62 Source Code (Source Code) Code10 Editable: No
73 Journal Batch Name (Journal Batch Name) Code10
74 Reason Code (Reason Code) Code10
75 Recurring Method (Recurring Method) Option BlankZero: Yes
76 Expiration Date (Expiration Date) Date
77 Recurring Frequency (Recurring Frequency) DateFormula
79 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code20
80 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code20
81 Transaction Type (Transaction Type) Code10
82 Transport Method (Transport Method) Code10
83 Country/Region Code (Country/Region Code) Code10
86 Entry/Exit Point (Entry/Exit Point) Code10
87 Document Date (Document Date) Date
88 External Document No. (External Document No.) Code35
89 Area (Area) Code10
90 Transaction Specification (Transaction Specification) Code10
91 Serial No. (Serial No.) Code20
92 Posting No. Series (Posting No. Series) Code20
93 Source Currency Code (Source Currency Code) Code10 Editable: No
94 Source Currency Total Cost (Source Currency Total Cost) Decimal Editable: No
95 Source Currency Total Price (Source Currency Total Price) Decimal Editable: No
96 Source Currency Line Amount (Source Currency Line Amount) Decimal Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
950 Time Sheet No. (Time Sheet No.) Code20
951 Time Sheet Line No. (Time Sheet Line No.) Integer
952 Time Sheet Date (Time Sheet Date) Date
1000 Job Task No. (Job Task No.) Code20
1001 Total Cost (Total Cost) Decimal Editable: No
1002 Unit Price (Unit Price) Decimal
1003 Line Type (Line Type) Option
1004 Applies-from Entry (Applies-from Entry) Integer
1005 Job Posting Only (Job Posting Only) Boolean
1006 Line Discount % (Line Discount %) Decimal (0:5)
1007 Line Discount Amount (Line Discount Amount) Decimal
1008 Currency Code (Currency Code) Code10 Editable: No
1009 Line Amount (Line Amount) Decimal
1010 Currency Factor (Currency Factor) Decimal (0:15) Editable: No
1011 Unit Cost (Unit Cost) Decimal
1012 Line Amount (LCY) (Line Amount (LCY)) Decimal Editable: No
1013 Line Discount Amount (LCY) (Line Discount Amount (LCY)) Decimal Editable: No
1014 Total Price (Total Price) Decimal Editable: No
1015 Cost Factor (Cost Factor) Decimal Editable: No
1016 Description 2 (Description 2) Text50
1017 Ledger Entry Type (Ledger Entry Type) Option
1018 Ledger Entry No. (Ledger Entry No.) Integer BlankZero: Yes
1019 Job Planning Line No. (Job Planning Line No.) Integer BlankZero: Yes
1030 Remaining Qty. (Remaining Qty.) Decimal (0:5)
1031 Remaining Qty. (Base) (Remaining Qty. (Base)) Decimal
5402 Variant Code (Variant Code) Code10
5403 Bin Code (Bin Code) Code20
5404 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
5410 Quantity (Base) (Quantity (Base)) Decimal (0:5)
5468 Reserved Qty. (Base) (Reserved Qty. (Base)) Decimal (0:5) Editable: No
FlowField
5900 Service Order No. (Service Order No.) Code20
5901 Posted Service Shipment No. (Posted Service Shipment No.) Code20
6501 Lot No. (Lot No.) Code20 Editable: No

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Line No. (Journal Template Name,Journal Batch Name,Line No.) Clustered: Yes
1 Journal Template Name,Journal Batch Name,Type,No.,Unit of Measure Code,Work Type Code (Journal Template Name,Journal Batch Name,Type,No.,Unit of Measure Code,Work Type Code) MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Area (Area) Area Code (Code) 1..n
Country/Region Code (Country/Region Code) Country/Region Code (Code) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Customer Price Group (Customer Price Group) Customer Price Group Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
Entry/Exit Point (Entry/Exit Point) Entry/Exit Point Code (Code) 1..n
No. (No.) G/L Account No. (No.) 1..n
Ledger Entry No. (Ledger Entry No.) G/L Entry Entry No. (Entry No.) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Posting Group (Posting Group) Inventory Posting Group Code (Code) 1..n
No. (No.) Item No. (No.) 1..n
Ledger Entry No. (Ledger Entry No.) Item Ledger Entry Entry No. (Entry No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Job No. (Job No.) Job No. (No.) 1..n
Journal Batch Name (Journal Batch Name) Job Journal Batch Name (Name) 1..n
Journal Template Name (Journal Template Name) Job Journal Template Name (Name) 1..n
Job Task No. (Job Task No.) Job Task Job Task No. (Job Task No.) 1..n
Location Code (Location Code) Location () 1..n
Posting No. Series (Posting No. Series) No. Series Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Ledger Entry No. (Ledger Entry No.) Res. Ledger Entry Entry No. (Entry No.) 1..n
No. (No.) Resource No. (No.) 1..n
Resource Group No. (Resource Group No.) Resource Group No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Resource Unit of Measure Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
Time Sheet Date (Time Sheet Date) Time Sheet Detail Date (Date) 1..n
Time Sheet No. (Time Sheet No.) Time Sheet Header No. (No.) 1..n
Time Sheet Line No. (Time Sheet Line No.) Time Sheet Line Line No. (Line No.) 1..n
Transaction Specification (Transaction Specification) Transaction Specification Code (Code) 1..n
Transaction Type (Transaction Type) Transaction Type Code (Code) 1..n
Transport Method (Transport Method) Transport Method Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n
Work Type Code (Work Type Code) Work Type Code (Code) 1..n

Table Relations From Other Tables

From Table From Field