Diagrams

Table

Job WIP Warning

DynamicsDocs.comJob WIP Warning«Table 1007»Job WIP WarningEntry No. [PK]Job No.Job Task No.Job WIP Total Entry No.Warning Message«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 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 %<Job No.><Job Task No.><Job WIP Total Entry No.><Job No.><Job No.>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer Editable: No
2 Job No. (Job No.) Code20
3 Job Task No. (Job Task No.) Code20
4 Job WIP Total Entry No. (Job WIP Total Entry No.) Integer Editable: No
5 Warning Message (Warning Message) Text250 Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Job No.,Job Task No. (Job No.,Job Task No.)
2 Job WIP Total Entry No. (Job WIP Total Entry No.)

Table Relations To Other Tables

Field Related Table Related Field
Job No. (Job No.) Job No. (No.) 1..n
Job Task No. (Job Task No.) Job Task Job Task No. (Job Task No.) 1..n
Job WIP Total Entry No. (Job WIP Total Entry No.) Job WIP Total Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field