Diagrams


Table

General Posting Setup

DynamicsDocs.comGeneral Posting Setup«Table 252»General Posting SetupGen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK,NN]Sales AccountSales Line Disc. AccountSales Inv. Disc. AccountSales Pmt. Disc. Debit Acc.Purch. AccountPurch. Line Disc. AccountPurch. Inv. Disc. AccountPurch. Pmt. Disc. Credit Acc.COGS AccountInventory Adjmt. AccountSales Credit Memo AccountPurch. Credit Memo AccountSales Pmt. Disc. Credit Acc.Purch. Pmt. Disc. Debit Acc.Sales Pmt. Tol. Debit Acc.Sales Pmt. Tol. Credit Acc.Purch. Pmt. Tol. Debit Acc.Purch. Pmt. Tol. Credit Acc.Sales Prepayments AccountPurch. Prepayments AccountPurch. FA Disc. AccountInvt. Accrual Acc. [Interim]COGS Account [Interim]Direct Cost Applied AccountOverhead Applied AccountPurchase Variance Account«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...<Gen. Bus. Posting Group><Gen. Prod. Posting Group><Sales Account><Sales Line Disc. Account><Sales Inv. Disc. Account><Sales Pmt. Disc. Debit Acc.><Purch. Account><Purch. Line Disc. Account><Purch. Inv. Disc. Account><Purch. Pmt. Disc. Credit Acc.><COGS Account><Inventory Adjmt. Account><Sales Credit Memo Account><Purch. Credit Memo Account><Sales Pmt. Disc. Credit Acc.><Purch. Pmt. Disc. Debit Acc.><Sales Pmt. Tol. Debit Acc.><Sales Pmt. Tol. Credit Acc.><Purch. Pmt. Tol. Debit Acc.><Purch. Pmt. Tol. Credit Acc.><Sales Prepayments Account><Purch. Prepayments Account><Purch. FA Disc. Account><Invt. Accrual Acc. (Interim)><COGS Account (Interim)><Direct Cost Applied Account><Overhead Applied Account><Purchase Variance Account><Gen. Bus. Posting Group><Gen. Prod. Posting Group>

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

Fields

# Name Type
1 Gen. Bus. Posting Group Code10
2 Gen. Prod. Posting Group Code10 NotBlank: Yes
10 Sales Account Code20
11 Sales Line Disc. Account Code20
12 Sales Inv. Disc. Account Code20
13 Sales Pmt. Disc. Debit Acc. Code20
14 Purch. Account Code20
15 Purch. Line Disc. Account Code20
16 Purch. Inv. Disc. Account Code20
17 Purch. Pmt. Disc. Credit Acc. Code20
18 COGS Account Code20
19 Inventory Adjmt. Account Code20
27 Sales Credit Memo Account Code20
28 Purch. Credit Memo Account Code20
30 Sales Pmt. Disc. Credit Acc. Code20
31 Purch. Pmt. Disc. Debit Acc. Code20
32 Sales Pmt. Tol. Debit Acc. Code20
33 Sales Pmt. Tol. Credit Acc. Code20
34 Purch. Pmt. Tol. Debit Acc. Code20
35 Purch. Pmt. Tol. Credit Acc. Code20
36 Sales Prepayments Account Code20
37 Purch. Prepayments Account Code20
5600 Purch. FA Disc. Account Code20
5801 Invt. Accrual Acc. (Interim) Code20
5803 COGS Account (Interim) Code20
99000752 Direct Cost Applied Account Code20
99000753 Overhead Applied Account Code20
99000754 Purchase Variance Account Code20

Keys

# Fields
0 Gen. Bus. Posting Group,Gen. Prod. Posting Group Clustered: Yes
1 Gen. Prod. Posting Group,Gen. Bus. Posting Group

Table Relations To Other Tables

Field Related Table Related Field
Purchase Variance Account G/L Account No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field