Diagrams


Table

Deferral Post. Buffer

DynamicsDocs.comDeferral Post. Buffer«Table 1703»Deferral Post. BufferType; [Prepmt. Exch. Rate Difference,G...G/L Account [PK,NN]Gen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK]VAT Bus. Posting Group [PK]VAT Prod. Posting Group [PK]Tax Area Code [PK]Tax Group Code [PK]Tax Liable [PK]Use Tax [PK]Job No. [PK]Posting Date [PK]AmountAmount [LCY]System-Created EntryGlobal Dimension 1 CodeGlobal Dimension 2 CodeDescriptionDeferral AccountPeriod DescriptionDeferral Doc. Type; [Purchase,Sales,G/...Document No.Sales/Purch AmountSales/Purch Amount [LCY]Dimension Set ID [PK]Deferral Code [PK]Deferral Line No.«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...«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 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 318»Tax AreaCode [PK,NN]Description«Table 321»Tax GroupCode [PK,NN]Description«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 1700»Deferral TemplateDeferral Code [PK,NN]DescriptionDeferral Account [NN]Deferral %Calc. Method; [Straight-Line,Equal per...Start Date; [Posting Date,Beginning of...No. of PeriodsPeriod Description<G/L Account><Gen. Bus. Posting Group><Gen. Prod. Posting Group><VAT Bus. Posting Group><VAT Prod. Posting Group><Tax Area Code><Tax Group Code><Job No.><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Set ID><Deferral Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Default Deferral Template Code><Deferral Account><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code>

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

Fields

# Name Type
1 Type Option
2 G/L Account Code20 NotBlank: Yes
3 Gen. Bus. Posting Group Code10
4 Gen. Prod. Posting Group Code10
5 VAT Bus. Posting Group Code10
6 VAT Prod. Posting Group Code10
7 Tax Area Code Code20
8 Tax Group Code Code10
9 Tax Liable Boolean
10 Use Tax Boolean
11 Job No. Code20
12 Posting Date Date
13 Amount Decimal
14 Amount (LCY) Decimal
15 System-Created Entry Boolean
16 Global Dimension 1 Code Code20
17 Global Dimension 2 Code Code20
18 Description Text50
19 Deferral Account Code20
20 Period Description Text50
21 Deferral Doc. Type Option
22 Document No. Code20
24 Sales/Purch Amount Decimal
25 Sales/Purch Amount (LCY) Decimal
480 Dimension Set ID Integer Editable: No
1700 Deferral Code Code10
1701 Deferral Line No. Integer

Keys

# Fields
0 Type,G/L Account,Gen. Bus. Posting Group,Gen. Prod. Posting Group,VAT Bus. Posting Group,VAT Prod. Posting Group,Tax Area Code,Tax Group Code,Tax Liable,Use Tax,Dimension Set ID,Job No.,Deferral Code,Posting Date Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Deferral Code Deferral Template Deferral Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
G/L Account G/L Account 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Job No. Job No. 1..n
Tax Area Code Tax Area Code 1..n
Tax Group Code Tax Group Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field