Diagrams


Table

Job Ledger Entry

DynamicsDocs.comJob Ledger Entry«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 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 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 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«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 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]Description«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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«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 282»Entry/Exit PointCode [PK,NN]Description«Table 285»Transaction SpecificationCode [PK,NN]Text«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«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated<Job No.><No.><No.><No.><Resource Group No.><Unit of Measure Code><Unit of Measure Code><Location Code><Job Posting Group><Work Type Code><Customer Price Group><User ID><Reason Code><Transaction Type><Transport Method><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Entry/Exit Point><Transaction Specification><Job Task No.><Variant Code><Bin Code><Person Responsible><Resource Filter><Customer Price Group><Resource Gr. Filter><Job No.><Resource Group No.><Gen. Prod. Posting Group><Resource No.><Inventory Posting Group><Alternative Item No.><Location Filter><Gen. Prod. Posting Group><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code>

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 Job No. Code20
3 Posting Date Date
4 Document No. Code20
5 Type Option
7 No. Code20
8 Description Text50
9 Quantity Decimal (0:5)
11 Direct Unit Cost (LCY) Decimal
12 Unit Cost (LCY) Decimal Editable: No
13 Total Cost (LCY) Decimal Editable: No
14 Unit Price (LCY) Decimal Editable: No
15 Total Price (LCY) Decimal Editable: No
16 Resource Group No. Code20 Editable: No
17 Unit of Measure Code Code10
20 Location Code Code10
29 Job Posting Group Code10
30 Global Dimension 1 Code Code20
31 Global Dimension 2 Code Code20
32 Work Type Code Code10
33 Customer Price Group Code10
37 User ID Code50
38 Source Code Code10
60 Amt. to Post to G/L Decimal
61 Amt. Posted to G/L Decimal
64 Entry Type Option
75 Journal Batch Name Code10
76 Reason Code Code10
77 Transaction Type Code10
78 Transport Method Code10
79 Country/Region Code Code10
80 Gen. Bus. Posting Group Code10
81 Gen. Prod. Posting Group Code10
82 Entry/Exit Point Code10
83 Document Date Date
84 External Document No. Code35
85 Area Code10
86 Transaction Specification Code10
87 No. Series Code10
88 Additional-Currency Total Cost Decimal
89 Add.-Currency Total Price Decimal
94 Add.-Currency Line Amount Decimal
480 Dimension Set ID Integer Editable: No
1000 Job Task No. Code20
1001 Line Amount (LCY) Decimal Editable: No
1002 Unit Cost Decimal
1003 Total Cost Decimal
1004 Unit Price Decimal
1005 Total Price Decimal
1006 Line Amount Decimal
1007 Line Discount Amount Decimal
1008 Line Discount Amount (LCY) Decimal Editable: No
1009 Currency Code Code10
1010 Currency Factor Decimal
1016 Description 2 Text50
1017 Ledger Entry Type Option
1018 Ledger Entry No. Integer BlankZero: Yes
1019 Serial No. Code20
1020 Lot No. Code20
1021 Line Discount % Decimal (0:5)
1022 Line Type Option
1023 Original Unit Cost (LCY) Decimal Editable: No
1024 Original Total Cost (LCY) Decimal Editable: No
1025 Original Unit Cost Decimal
1026 Original Total Cost Decimal
1027 Original Total Cost (ACY) Decimal
1028 Adjusted Boolean
1029 DateTime Adjusted DateTime
5402 Variant Code Code10
5403 Bin Code Code20
5404 Qty. per Unit of Measure Decimal (0:5) Editable: No
5405 Quantity (Base) Decimal
5900 Service Order No. Code20
5901 Posted Service Shipment No. Code20

Keys

# Fields
0 Entry No. Clustered: Yes
1 Job No.,Job Task No.,Entry Type,Posting Date
2 Document No.,Posting Date
3 Job No.,Posting Date
4 Entry Type,Type,No.,Posting Date
5 Service Order No.,Posting Date
6 Job No.,Entry Type,Type,No.
7 Type,Entry Type,Country/Region Code,Source Code,Posting Date

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Bin Code Bin Code 1..n
Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Customer Price Group Customer Price Group Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Entry/Exit Point Entry/Exit Point Code 1..n
No. G/L Account No. 1..n
Ledger Entry No. G/L Entry Entry No. 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 Posting Group Inventory Posting Group Code 1..n
No. Item No. 1..n
Ledger Entry No. Item Ledger Entry Entry No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Job No. Job No. 1..n
Job Task No. Job Task Job Task No. 1..n
Location Code Location 1..n
No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Ledger Entry No. Res. Ledger Entry Entry No. 1..n
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
Transaction Specification Transaction Specification Code 1..n
Transaction Type Transaction Type Code 1..n
Transport Method Transport Method 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
Intrastat Jnl. Line Source Entry No. 1..n
Job Planning Line Job Ledger Entry No. 1..n
Job Planning Line Invoice Job Ledger Entry No. 1..n
Job Register To Entry No. 1..n
Value Entry Job Ledger Entry No. 1..n