Diagrams


DynamicsDocs.comJob«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 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 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<Bill-to Customer No.><Person Responsible><Resource Filter><Job Posting Group><Customer Disc. Group><Customer Price Group><Resource Gr. Filter><WIP Method><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.>

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

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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