Diagrams

Table

FA Journal Setup

DynamicsDocs.comFA Journal Setup«Table 5605»FA Journal SetupDepreciation Book Code [PK,NN]User ID [PK]FA Jnl. Template NameFA Jnl. Batch NameGen. Jnl. Template NameGen. Jnl. Batch NameInsurance Jnl. Template NameInsurance Jnl. Batch Name«Table 5611»Depreciation BookCode [PK,NN]DescriptionG/L Integration - Acq. CostG/L Integration - DepreciationG/L Integration - Write-DownG/L Integration - AppreciationG/L Integration - Custom 1G/L Integration - Custom 2G/L Integration - DisposalG/L Integration - MaintenanceDisposal Calculation Method; [Net,Gros...Use Custom 1 DepreciationAllow Depr. below ZeroUse FA Exch. Rate in Duplic.Part of Duplication ListLast Date ModifiedAllow IndexationUse Same FA+G/L Posting DatesDefault Exchange RateUse FA Ledger CheckUse Rounding in Periodic Depr.New Fiscal Year Starting DateNo. of Days in Fiscal YearAllow Changes in Depr. FieldsDefault Final Rounding AmountDefault Ending Book ValuePeriodic Depr. Date Calc.; [Last Entry...Mark Errors as CorrectionsAdd-Curr Exch Rate - Acq. CostAdd.-Curr. Exch. Rate - Depr.Add-Curr Exch Rate -Write-Down...«Table 5619»FA Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionMaint. Posting Report IDMaint. Posting Report CaptionNo. SeriesPosting No. Series«Table 5620»FA Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«Table 80»Gen. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [General,Sales,Purchases,Cash Re...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionForce Doc. BalanceBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceCust. Receipt Report IDCust. Receipt Report CaptionVendor Receipt Report IDVendor Receipt Report Caption«Table 232»Gen. Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceAllow Payment ExportBank Statement Import FormatTemplate Type; [General,Sales,Purchase...RecurringSuggest Balancing Amount«Table 5633»Insurance Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«Table 5634»Insurance Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. Series<Depreciation Book Code><FA Jnl. Template Name><FA Jnl. Batch Name><Gen. Jnl. Template Name><Gen. Jnl. Batch Name><Insurance Jnl. Template Name><Insurance Jnl. Batch Name><Journal Template Name><Journal Template Name><Journal Template Name>

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

Fields

# Name Type
1 Depreciation Book Code (Depreciation Book Code) Code10 NotBlank: Yes
2 User ID (User ID) Code50
3 FA Jnl. Template Name (FA Jnl. Template Name) Code10 Editable: Yes
4 FA Jnl. Batch Name (FA Jnl. Batch Name) Code10
5 Gen. Jnl. Template Name (Gen. Jnl. Template Name) Code10
6 Gen. Jnl. Batch Name (Gen. Jnl. Batch Name) Code10
7 Insurance Jnl. Template Name (Insurance Jnl. Template Name) Code10
8 Insurance Jnl. Batch Name (Insurance Jnl. Batch Name) Code10

Keys

# Fields
0 Depreciation Book Code,User ID (Depreciation Book Code,User ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Depreciation Book Code (Depreciation Book Code) Depreciation Book Code (Code) 1..n
FA Jnl. Batch Name (FA Jnl. Batch Name) FA Journal Batch Name (Name) 1..n
FA Jnl. Template Name (FA Jnl. Template Name) FA Journal Template Name (Name) 1..n
Gen. Jnl. Batch Name (Gen. Jnl. Batch Name) Gen. Journal Batch Name (Name) 1..n
Gen. Jnl. Template Name (Gen. Jnl. Template Name) Gen. Journal Template Name (Name) 1..n
Insurance Jnl. Batch Name (Insurance Jnl. Batch Name) Insurance Journal Batch Name (Name) 1..n
Insurance Jnl. Template Name (Insurance Jnl. Template Name) Insurance Journal Template Name (Name) 1..n

Table Relations From Other Tables

From Table From Field