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]Gen. Posting Type; [,Purchase,Sale,Set...Partial Deferral [PK]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 CodeAccount Category; [,Assets,Liabilities...Income/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....«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,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 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 (Type) Option
2 G/L Account (G/L Account) Code20 NotBlank: Yes
3 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
4 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
5 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
6 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
7 Tax Area Code (Tax Area Code) Code20
8 Tax Group Code (Tax Group Code) Code10
9 Tax Liable (Tax Liable) Boolean
10 Use Tax (Use Tax) Boolean
11 Job No. (Job No.) Code20
12 Posting Date (Posting Date) Date
13 Amount (Amount) Decimal
14 Amount (LCY) (Amount (LCY)) Decimal
15 System-Created Entry (System-Created Entry) Boolean
16 Global Dimension 1 Code (Global Dimension 1 Code) Code20
17 Global Dimension 2 Code (Global Dimension 2 Code) Code20
18 Description (Description) Text50
19 Deferral Account (Deferral Account) Code20
20 Period Description (Period Description) Text50
21 Deferral Doc. Type (Deferral Doc. Type) Option
22 Document No. (Document No.) Code20
24 Sales/Purch Amount (Sales/Purch Amount) Decimal
25 Sales/Purch Amount (LCY) (Sales/Purch Amount (LCY)) Decimal
26 Gen. Posting Type (Gen. Posting Type) Option
27 Partial Deferral (Partial Deferral) Boolean
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
1700 Deferral Code (Deferral Code) Code10
1701 Deferral Line No. (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,Partial Deferral (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,Partial Deferral) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field