Diagrams

Table

FA Allocation

DynamicsDocs.comFA Allocation«Table 5615»FA AllocationCode [PK,NN]Line No. [PK]DescriptionAccount No.Global Dimension 1 CodeGlobal Dimension 2 CodeAllocation %Allocation Type; [Acquisition,Deprecia...Account NameDimension Set ID«Table 5606»FA Posting GroupCode [PK,NN]Acquisition Cost AccountAccum. Depreciation AccountWrite-Down AccountAppreciation AccountCustom 1 AccountCustom 2 AccountAcq. Cost Acc. on DisposalAccum. Depr. Acc. on DisposalWrite-Down Acc. on DisposalAppreciation Acc. on DisposalCustom 1 Account on DisposalCustom 2 Account on DisposalGains Acc. on DisposalLosses Acc. on DisposalBook Val. Acc. on Disp. [Gain]Sales Acc. on Disp. [Gain]Write-Down Bal. Acc. on Disp.Apprec. Bal. Acc. on Disp.Custom 1 Bal. Acc. on DisposalCustom 2 Bal. Acc. on DisposalMaintenance Expense AccountMaintenance Bal. Acc.Acquisition Cost Bal. Acc.Depreciation Expense Acc.Write-Down Expense Acc.Appreciation Bal. AccountCustom 1 Expense Acc.Custom 2 Expense Acc.Sales Bal. Acc.Allocated Acquisition 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 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 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<Code><Account No.><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Set ID><Acquisition Cost Account><Accum. Depreciation Account><Write-Down Account><Appreciation Account><Custom 1 Account><Custom 2 Account><Acq. Cost Acc. on Disposal><Accum. Depr. Acc. on Disposal><Write-Down Acc. on Disposal><Appreciation Acc. on Disposal><Custom 1 Account on Disposal><Custom 2 Account on Disposal><Gains Acc. on Disposal><Losses Acc. on Disposal><Book Val. Acc. on Disp. (Gain)><Sales Acc. on Disp. (Gain)><Write-Down Bal. Acc. on Disp.><Apprec. Bal. Acc. on Disp.><Custom 1 Bal. Acc. on Disposal><Custom 2 Bal. Acc. on Disposal><Maintenance Expense Account><Maintenance Bal. Acc.><Acquisition Cost Bal. Acc.><Depreciation Expense Acc.><Write-Down Expense Acc.><Appreciation Bal. Account><Custom 1 Expense Acc.><Custom 2 Expense Acc.><Sales Bal. Acc.><Sales Acc. on Disp. (Loss)><Book Val. Acc. on Disp. (Loss)><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><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 Code (Code) Code10 NotBlank: Yes
2 Line No. (Line No.) Integer
3 Description (Description) Text50
4 Account No. (Account No.) Code20
5 Global Dimension 1 Code (Global Dimension 1 Code) Code20
6 Global Dimension 2 Code (Global Dimension 2 Code) Code20
7 Allocation % (Allocation %) Decimal (1:1)
8 Allocation Type (Allocation Type) Option
9 Account Name (Account Name) Text50 Editable: No
FlowField
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Code,Allocation Type,Line No. (Code,Allocation Type,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
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
Code (Code) FA Posting Group Code (Code) 1..n
Account No. (Account No.) G/L Account No. (No.) 1..n

Table Relations From Other Tables

From Table From Field