Diagrams

Table

Job Planning Line

DynamicsDocs.comJob Planning Line«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 1020»Job Usage LinkJob No. [PK]Job Task No. [PK]Line No. [PK]Entry No. [PK]«Table 1022»Job Planning Line InvoiceJob No. [PK]Job Task No. [PK]Job Planning Line No. [PK]Document Type; [,Invoice,Credit Memo,P...Document No. [PK]Line No. [PK]Quantity TransferredTransferred DateInvoiced DateInvoiced Amount [LCY]Invoiced Cost Amount [LCY]Job Ledger Entry No.«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 7»Standard TextCode [PK,NN]Description«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 Code«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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«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 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«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 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 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«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 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 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«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.><No.><Resource Group No.><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Location Code><User ID><Work Type Code><Customer Price Group><Country/Region Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Job Task No.><Currency Code><Job Ledger Entry No.><Ledger Entry No.><Ledger Entry No.><Ledger Entry No.><Variant Code><Bin Code><Line No.><Job Planning Line No.><Job No.><Job Task No.><Job No.><Job Task No.><Job Ledger Entry No.><Person Responsible><Resource Filter><Customer Price Group><Resource Gr. Filter><Bill-to Country/Region Code><Currency Code><Invoice Currency Code><Job No.><Job No.><Job No.><Job No.><Job No.><Resource Group No.><Base Unit of Measure><Unit of Measure Filter><Gen. Prod. Posting Group><Country/Region Code><No.><Resource No.><Resource No.><Alternative Item No.><Country/Region Purchased Code><Country/Region of Origin Code><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.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><No.><Item No.><Source No.><Originally Ordered No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><No.><G/L Account No.><Bal. Account No.><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Unit of Measure Filter><Resource Group No.><Resource Group No.><Code><Unit of Measure Code><Unit of Measure Code><Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><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><Country/Region Code><Location Code><Location Code><User ID><User ID><Work Type Code><Work Type Code><Customer Price Group><Country/Region Code><Country/Region Code><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Job Task No.><Job Task No.><Currency Code><Ledger Entry No.><Ledger Entry No.><Ledger Entry No.><Variant Code><Bin Code><Variant Code><Originally Ordered Var. Code><Reversed by Entry No.><Reversed Entry No.>

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

Fields

# Name Type
1 Line No. Integer Editable: No
2 Job No. Code20 NotBlank: Yes
3 Planning 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 Last Date Modified Date Editable: No
30 User ID Code50 Editable: No
32 Work Type Code Code10
33 Customer Price Group Code10
79 Country/Region Code Code10 Editable: No
80 Gen. Bus. Posting Group Code10 Editable: No
81 Gen. Prod. Posting Group Code10 Editable: No
83 Document Date Date
1000 Job Task No. Code20 NotBlank: Yes
1001 Line Amount (LCY) Decimal Editable: No
1002 Unit Cost Decimal
1003 Total Cost Decimal Editable: No
1004 Unit Price Decimal
1005 Total Price Decimal Editable: No
1006 Line Amount Decimal
1007 Line Discount Amount Decimal
1008 Line Discount Amount (LCY) Decimal Editable: No
1015 Cost Factor Decimal Editable: No
1019 Serial No. Code20 Editable: No
1020 Lot No. Code20 Editable: No
1021 Line Discount % Decimal (0:5) BlankZero: Yes
1022 Line Type Option
1023 Currency Code Code10 Editable: No
1024 Currency Date Date
1025 Currency Factor Decimal (0:15) Editable: No
1026 Schedule Line Boolean Editable: No
1027 Contract Line Boolean Editable: No
1030 Job Contract Entry No. Integer Editable: No
1035 Invoiced Amount (LCY) Decimal Editable: No
FlowField
1036 Invoiced Cost Amount (LCY) Decimal Editable: No
FlowField
1037 VAT Unit Price Decimal
1038 VAT Line Discount Amount Decimal
1039 VAT Line Amount Decimal
1041 VAT % Decimal
1042 Description 2 Text50
1043 Job Ledger Entry No. Integer BlankZero: Yes
Editable: No
1048 Status Option Editable: No
1050 Ledger Entry Type Option
1051 Ledger Entry No. Integer BlankZero: Yes
1052 System-Created Entry Boolean
1053 Usage Link Boolean
1060 Remaining Qty. Decimal (0:5) Editable: No
1061 Remaining Qty. (Base) Decimal (0:5) Editable: No
1062 Remaining Total Cost Decimal Editable: No
1063 Remaining Total Cost (LCY) Decimal Editable: No
1064 Remaining Line Amount Decimal Editable: No
1065 Remaining Line Amount (LCY) Decimal Editable: No
1070 Qty. Posted Decimal (0:5) Editable: No
1071 Qty. to Transfer to Journal Decimal (0:5)
1072 Posted Total Cost Decimal Editable: No
1073 Posted Total Cost (LCY) Decimal Editable: No
1074 Posted Line Amount Decimal Editable: No
1075 Posted Line Amount (LCY) Decimal Editable: No
1080 Qty. Transferred to Invoice Decimal (0:5) Editable: No
FlowField
1081 Qty. to Transfer to Invoice Decimal (0:5)
1090 Qty. Invoiced Decimal (0:5) Editable: No
FlowField
1091 Qty. to Invoice Decimal (0:5) Editable: No
1100 Reserved Quantity Decimal (0:5) Editable: No
FlowField
1101 Reserved Qty. (Base) Decimal (0:5) Editable: No
FlowField
1102 Reserve Option
1103 Planned Boolean Editable: No
5402 Variant Code Code10
5403 Bin Code Code20
5404 Qty. per Unit of Measure Decimal (0:5) Editable: No
5410 Quantity (Base) Decimal (0:5)
5790 Requested Delivery Date Date
5791 Promised Delivery Date Date
5794 Planned Delivery Date Date
5900 Service Order No. Code20

Keys

# Fields
0 Job No.,Job Task No.,Line No. Clustered: Yes
1 Job No.,Job Task No.,Schedule Line,Planning Date
2 Job No.,Job Task No.,Contract Line,Planning Date
3 Job No.,Job Task No.,Schedule Line,Currency Date
4 Job No.,Job Task No.,Contract Line,Currency Date
5 Job No.,Schedule Line,Type,No.,Planning Date
6 Job No.,Schedule Line,Type,Resource Group No.,Planning Date
7 Status,Schedule Line,Type,No.,Planning Date
8 Status,Schedule Line,Type,Resource Group No.,Planning Date
9 Job No.,Contract Line
10 Job Contract Entry No.
11 Type,No.,Job No.,Job Task No.,Usage Link,System-Created Entry
12 Status,Type,No.,Variant Code,Location Code,Planning Date

Table Relations To Other Tables

Field Related Table Related Field
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
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
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 Ledger Entry No. Job Ledger Entry Entry No. 1..n
Job Task No. Job Task Job Task No. 1..n
Location Code Location 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
No. Standard Text 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 Planning Line Invoice Job Planning Line No. 1..n
Job Usage Link Line No. 1..n