Diagrams


DynamicsDocs.comJob«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 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 1007»Job WIP WarningEntry No. [PK]Job No.Job Task No.Job WIP Total Entry No.Warning Message«Table 1012»Job Resource PriceJob No. [PK,NN]Job Task No. [PK]Type; [Resource,Group<Resource>,All] [...Code [PK]Work Type Code [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %DescriptionApply Job PriceApply Job Discount«Table 1013»Job Item PriceJob No. [PK,NN]Job Task No. [PK]Item No. [PK]Unit of Measure Code [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %DescriptionVariant Code [PK]Apply Job PriceApply Job Discount«Table 1014»Job G/L Account PriceJob No. [PK,NN]Job Task No. [PK]G/L Account No. [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %Unit CostDescription«Table 1020»Job Usage LinkJob No. [PK]Job Task No. [PK]Line No. [PK]Entry No. [PK]«Table 1021»Job WIP TotalEntry No. [PK]Job No. [NN]Job Task No. [NN]WIP MethodWIP Posting DateWIP Posting Date FilterWIP Planning Date FilterWIP WarningsPosted to G/LSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Calc. Recog. Sales AmountCalc. Recog. Costs AmountCost Completion %Invoiced %«Table 9154»My JobUser ID [PK]Job No. [PK,NN]Exclude from Business ChartDescriptionStatus; [Planning,Quote,Open,Completed...Bill-to NamePercent CompletedPercent Invoiced«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 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 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 208»Job Posting GroupCode [PK,NN]WIP Costs AccountWIP Accrued Costs AccountJob Costs Applied AccountJob Costs Adjustment AccountG/L Expense Acc. [Contract]Job Sales Adjustment AccountWIP Accrued Sales AccountWIP Invoiced Sales AccountJob Sales Applied AccountRecognized Costs AccountRecognized Sales AccountItem Costs Applied AccountResource Costs Applied AccountG/L Costs Applied Account«Table 340»Customer Discount GroupCode [PK,NN]Description«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«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 1006»Job WIP MethodCode [PK,NN]DescriptionWIP CostWIP SalesRecognized Costs; [At Completion,Cost...Recognized Sales; [At Completion,Contr...ValidSystem DefinedSystem-Defined Index«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Bill-to Customer No.><Person Responsible><Resource Filter><Job Posting Group><Customer Disc. Group><Customer Price Group><Resource Gr. Filter><WIP Method><Project Manager><Job No.><Job No.><Job No.><Job No.><Job No.><Job No.><Job No.><Job No.><Job No.><Job Posting Group><WIP Method><Job Task No.><Job Task No.><Job Task No.><Job Task No.><Job Task No.><Job Task No.><Job WIP Total Entry No.><Code><Code><WIP Method><Resource No.><Customer Price Group><Customer Disc. Group><Bill-to Customer No.><Resource Group No.><Time Sheet Owner User ID><Time Sheet Approver User ID><Approver ID><Substitute>

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

Fields

# Name Type
1 No. Code20
2 Search Description Code50
3 Description Text50
4 Description 2 Text50
5 Bill-to Customer No. Code20
12 Creation Date Date Editable: No
13 Starting Date Date
14 Ending Date Date
19 Status Option
20 Person Responsible Code20
21 Global Dimension 1 Code Code20
22 Global Dimension 2 Code Code20
23 Job Posting Group Code10
24 Blocked Option
29 Last Date Modified Date Editable: No
30 Comment Boolean Editable: No
FlowField
31 Customer Disc. Group Code20
32 Customer Price Group Code10
41 Language Code Code10
49 Scheduled Res. Qty. Decimal (0:5) Editable: No
FlowField
50 Resource Filter Code20 FlowFilter
51 Posting Date Filter Date FlowFilter
55 Resource Gr. Filter Code20 FlowFilter
56 Scheduled Res. Gr. Qty. Decimal (0:5) Editable: No
FlowField
57 Picture BLOB [Bitmap]
58 Bill-to Name Text50
59 Bill-to Address Text50
60 Bill-to Address 2 Text50
61 Bill-to City Text30
63 Bill-to County Text30
64 Bill-to Post Code Code20
66 No. Series Code10 Editable: No
67 Bill-to Country/Region Code Code10 Editable: Yes
68 Bill-to Name 2 Text50
117 Reserve Option
140 Image Media
1000 WIP Method Code20
1001 Currency Code Code10
1002 Bill-to Contact No. Code20
1003 Bill-to Contact Text50
1004 Planning Date Filter Date FlowFilter
1005 Total WIP Cost Amount Decimal Editable: No
FlowField
1006 Total WIP Cost G/L Amount Decimal Editable: No
FlowField
1007 WIP Entries Exist Boolean FlowField
1008 WIP Posting Date Date Editable: No
1009 WIP G/L Posting Date Date Editable: No
FlowField
1011 Invoice Currency Code Code10
1012 Exch. Calculation (Cost) Option
1013 Exch. Calculation (Price) Option
1014 Allow Schedule/Contract Lines Boolean
1015 Complete Boolean
1017 Recog. Sales Amount Decimal Editable: No
FlowField
1018 Recog. Sales G/L Amount Decimal Editable: No
FlowField
1019 Recog. Costs Amount Decimal Editable: No
FlowField
1020 Recog. Costs G/L Amount Decimal Editable: No
FlowField
1021 Total WIP Sales Amount Decimal Editable: No
FlowField
1022 Total WIP Sales G/L Amount Decimal Editable: No
FlowField
1023 WIP Completion Calculated Boolean FlowField
1024 Next Invoice Date Date FlowField
1025 Apply Usage Link Boolean
1026 WIP Warnings Boolean Editable: No
FlowField
1027 WIP Posting Method Option
1028 Applied Costs G/L Amount Decimal Editable: No
FlowField
1029 Applied Sales G/L Amount Decimal Editable: No
FlowField
1030 Calc. Recog. Sales Amount Decimal Editable: No
FlowField
1031 Calc. Recog. Costs Amount Decimal Editable: No
FlowField
1032 Calc. Recog. Sales G/L Amount Decimal Editable: No
FlowField
1033 Calc. Recog. Costs G/L Amount Decimal Editable: No
FlowField
1034 WIP Completion Posted Boolean FlowField
1035 Over Budget Boolean
1036 Project Manager Code50

Keys

# Fields
0 No. Clustered: Yes
1 Search Description
2 Bill-to Customer No.
3 Description
4 Status

Table Relations To Other Tables

Field Related Table Related Field
Bill-to Country/Region Code Country/Region Code 1..n
Invoice Currency Code Currency Code 1..n
Bill-to Customer No. Customer No. 1..n
Customer Disc. Group Customer Discount Group Code 1..n
Customer Price Group Customer Price Group Code 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Job Posting Group Job Posting Group Code 1..n
WIP Method Job WIP Method Code 1..n
Language Code Language Code 1..n
No. Series No. Series Code 1..n
Resource Filter Resource No. 1..n
Resource Gr. Filter Resource Group No. 1..n
Project Manager User Setup User ID 1..n

Table Relations From Other Tables

From Table From Field
Cash Flow Forecast Entry Source No. 1..n
Comment Line No. 1..n
Default Dimension No. 1..n
Deferral Post. Buffer Job No. 1..n
G/L Entry Job No. 1..n
Gen. Journal Line Job No. 1..n
Invoice Post. Buffer Job No. 1..n
Item Ledger Entry Job No. 1..n
Job G/L Account Price Job No. 1..n
Job Item Price Job No. 1..n
Job Journal Line Job No. 1..n
Job Ledger Entry Job No. 1..n
Job Planning Line Job No. 1..n
Job Planning Line Invoice Job No. 1..n
Job Posting Buffer Job No. 1..n
Job Resource Price Job No. 1..n
Job Task Job No. 1..n
Job Usage Link Job No. 1..n
Job WIP Buffer Job No. 1..n
Job WIP Entry Job No. 1..n
Job WIP G/L Entry Job No. 1..n
Job WIP Total Job No. 1..n
Job WIP Warning Job No. 1..n
My Job Job No. 1..n
Prepayment Inv. Line Buffer Job No. 1..n
Purch. Cr. Memo Line Job No. 1..n
Purch. Inv. Line Job No. 1..n
Purch. Rcpt. Line Job No. 1..n
Purchase Line Job No. 1..n
Purchase Line Archive Job No. 1..n
Res. Journal Line Job No. 1..n
Res. Ledger Entry Job No. 1..n
Return Receipt Line Job No. 1..n
Return Shipment Line Job No. 1..n
Sales Cr.Memo Line Job No. 1..n
Sales Invoice Line Job No. 1..n
Sales Line Job No. 1..n
Sales Line Archive Job No. 1..n
Sales Shipment Line Job No. 1..n
Service Ledger Entry Job No. 1..n
Service Line Job No. 1..n
Standard General Journal Line Job No. 1..n
Time Sheet Detail Job No. 1..n
Time Sheet Detail Archive Job No. 1..n
Time Sheet Line Job No. 1..n
Time Sheet Line Archive Job No. 1..n
Value Entry Job No. 1..n