Diagrams


Table

FA G/L Posting Buffer

DynamicsDocs.comFA G/L Posting Buffer«Table 5637»FA G/L Posting BufferEntry No. [PK]Account No.AmountCorrectionGlobal Dimension 1 CodeGlobal Dimension 2 CodeFA Entry Type; [,Fixed Asset,Maintenan...FA Entry No.Automatic EntryFA Posting GroupFA Allocation Type; [Acquisition,Depre...FA Allocation Line No.Original General Journal LineNet DisposalDimension Set ID«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....«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 IDIdLast Modified Date Time«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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Account No.><Global Dimension 1 Code><Global Dimension 2 Code><FA Posting Group><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><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)><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 Entry No. Integer
2 Account No. Code20
3 Amount Decimal
4 Correction Boolean
5 Global Dimension 1 Code Code20
6 Global Dimension 2 Code Code20
7 FA Entry Type Option
8 FA Entry No. Integer
9 Automatic Entry Boolean
10 FA Posting Group Code20
11 FA Allocation Type Option
12 FA Allocation Line No. Integer
15 Original General Journal Line Boolean
16 Net Disposal Boolean
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
FA Posting Group FA Posting Group Code 1..n
Account No. G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field