Diagrams


Table

Job WIP Total

DynamicsDocs.comJob WIP Total«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 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 1007»Job WIP WarningEntry No. [PK]Job No.Job Task No.Job WIP Total Entry No.Warning Message«Table 1018»Job WIP BufferPosting Group [PK]Type; [Applied Costs,Applied Sales,Rec...WIP Entry AmountG/L Account No. [PK]Bal. G/L Account No.WIP MethodJob No. [PK,NN]Job CompleteJob WIP Total Entry No. [PK]Reverse [PK]WIP Posting Method Used; [Per Job,Per...Dim Combination ID [PK]«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 1006»Job WIP MethodCode [PK,NN]DescriptionWIP CostWIP SalesRecognized Costs; [At Completion,Cost...Recognized Sales; [At Completion,Contr...ValidSystem DefinedSystem-Defined Index<Job No.><WIP Method><Job WIP Total Entry No.><Job WIP Total Entry No.><Job WIP Total Entry No.><Job WIP Total Entry No.><Job No.><WIP Method Used><Job No.><WIP Method Used><Job No.><Job No.><WIP Method>

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

Fields

# Name Type
1 Entry No. Integer AutoIncrement: Yes
2 Job No. Code20 NotBlank: Yes
Editable: No
3 Job Task No. Code20 NotBlank: Yes
4 WIP Method Code20 Editable: No
5 WIP Posting Date Date Editable: No
6 WIP Posting Date Filter Text250 Editable: No
7 WIP Planning Date Filter Text250 Editable: No
8 WIP Warnings Boolean FlowField
9 Posted to G/L Boolean
10 Schedule (Total Cost) Decimal Editable: No
11 Schedule (Total Price) Decimal Editable: No
12 Usage (Total Cost) Decimal Editable: No
13 Usage (Total Price) Decimal Editable: No
14 Contract (Total Cost) Decimal Editable: No
15 Contract (Total Price) Decimal Editable: No
16 Contract (Invoiced Price) Decimal Editable: No
17 Contract (Invoiced Cost) Decimal Editable: No
20 Calc. Recog. Sales Amount Decimal Editable: No
21 Calc. Recog. Costs Amount Decimal Editable: No
30 Cost Completion % Decimal BlankZero: Yes
Editable: No
31 Invoiced % Decimal BlankZero: Yes
Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Job No.,Job Task No.
2 Job No.,Posted to G/L

Table Relations To Other Tables

Field Related Table Related Field
Job No. Job No. 1..n
WIP Method Job WIP Method Code 1..n

Table Relations From Other Tables

From Table From Field
Job WIP Buffer Job WIP Total Entry No. 1..n
Job WIP Entry Job WIP Total Entry No. 1..n
Job WIP G/L Entry Job WIP Total Entry No. 1..n
Job WIP Warning Job WIP Total Entry No. 1..n