Diagrams


Table

Job Posting Group

DynamicsDocs.comJob Posting Group«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 AccountDescriptionUsed in JobsUsed in Ledger Entries«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 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 212»Job Posting BufferJob No. [PK]Entry Type; [Usage,Sale] [PK]Posting Group Type; [Resource,Item,G/L...No. [PK]Posting Group [PK]Global Dimension 1 CodeGlobal Dimension 2 CodeUnit of Measure Code [PK]Work Type Code [PK]AmountQuantityTotal CostTotal PriceApplies-to IDGen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK]Additional-Currency AmountDimension Entry No. [PK]Variant Code [PK]Dimension Set ID«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«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....<WIP Costs Account><WIP Accrued Costs Account><Job Costs Applied Account><Job Costs Adjustment Account><G/L Expense Acc. (Contract)><Job Sales Adjustment Account><WIP Accrued Sales Account><WIP Invoiced Sales Account><Job Sales Applied Account><Recognized Costs Account><Recognized Sales Account><Item Costs Applied Account><Resource Costs Applied Account><G/L Costs Applied Account><Job Posting Group><Job Posting Group><Job Posting Group><Job Posting Group><Posting Group><Default Job Posting Group><Job No.><Job No.><G/L Account No.><G/L Bal. Account No.><Job No.><G/L Account No.><G/L Bal. Account 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 WIP Costs Account Code20
3 WIP Accrued Costs Account Code20
4 Job Costs Applied Account Code20
5 Job Costs Adjustment Account Code20
6 G/L Expense Acc. (Contract) Code20
7 Job Sales Adjustment Account Code20
8 WIP Accrued Sales Account Code20
9 WIP Invoiced Sales Account Code20
10 Job Sales Applied Account Code20
11 Recognized Costs Account Code20
12 Recognized Sales Account Code20
13 Item Costs Applied Account Code20
14 Resource Costs Applied Account Code20
15 G/L Costs Applied Account Code20
20 Description Text50
21 Used in Jobs Integer BlankZero: Yes
Editable: No
FlowField
22 Used in Ledger Entries Integer BlankZero: Yes
Editable: No
FlowField

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
G/L Costs Applied Account G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field
Job Job Posting Group 1..n
Job Posting Buffer Posting Group 1..n
Job Task Job Posting Group 1..n
Job WIP Entry Job Posting Group 1..n
Job WIP G/L Entry Job Posting Group 1..n
Jobs Setup Default Job Posting Group 1..n