Diagrams


Table

Job WIP Method

DynamicsDocs.comJob WIP Method«Table 1006»Job WIP MethodCode [PK,NN]DescriptionWIP CostWIP SalesRecognized Costs; [At Completion,Cost...Recognized Sales; [At Completion,Contr...ValidSystem DefinedSystem-Defined Index«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 1004»Job WIP EntryEntry No. [PK]Job No.Document No.G/L Account No.WIP Posting DateWIP Entry AmountJob Posting GroupType; [Applied Costs,Applied Sales,Rec...G/L Bal. Account No.WIP Method UsedJob CompleteJob WIP Total Entry No.ReverseWIP Posting Method Used; [Per Job,Per...Global Dimension 1 CodeGlobal Dimension 2 CodeDimension Set ID«Table 1005»Job WIP G/L EntryEntry No. [PK]Job No.Document No.G/L Account No.Posting DateWIP Entry AmountJob Posting GroupType; [Applied Costs,Applied Sales,Rec...G/L Bal. Account No.WIP Method UsedWIP Posting Method Used; [Per Job,Per...WIP Posting DateDescriptionG/L Entry No.ReversedReverseWIP Transaction No.Reverse DateJob CompleteJob WIP Total Entry No.Global Dimension 1 CodeGlobal Dimension 2 CodeDimension Set ID«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 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 315»Jobs SetupPrimary Key [PK]Job Nos.Apply Usage Link by DefaultDefault WIP MethodDefault Job Posting GroupDefault WIP Posting Method; [Per Job,P...Allow Sched/Contract Lines DefLogo Position on Documents; [No Logo,L...Job WIP Nos.Automatic Update Job Item Cost<WIP Method><WIP Method Used><WIP Method Used><WIP Method><WIP Method><Default WIP Method><Job No.><Job No.><Job WIP Total Entry No.><Job No.><Job WIP Total Entry 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 Code Code20 NotBlank: Yes
2 Description Text50
3 WIP Cost Boolean
4 WIP Sales Boolean
5 Recognized Costs Option
6 Recognized Sales Option
7 Valid Boolean
8 System Defined Boolean Editable: No
9 System-Defined Index Integer Editable: No

Keys

# Fields
0 Code Clustered: Yes
1 Valid

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Job WIP Method 1..n
Job Task WIP Method 1..n
Job WIP Entry WIP Method Used 1..n
Job WIP G/L Entry WIP Method Used 1..n
Job WIP Total WIP Method 1..n
Jobs Setup Default WIP Method 1..n