Diagrams


Table

FA Journal Template

DynamicsDocs.comFA Journal Template«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 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 5620»FA Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«Table 5621»FA Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Depreciation Book CodeFA Posting Type; [Acquisition Cost,Dep...FA No.FA Posting DatePosting DateDocument Type; [,,Invoice,Credit Memo]Document DateDocument No.External Document No.DescriptionAmountDebit AmountCredit AmountSalvage ValueQuantityCorrectionNo. of Depreciation DaysDepr. until FA Posting DateDepr. Acquisition CostFA Posting GroupMaintenance CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeInsurance No.Budgeted FA No.Use Duplication ListDuplicate in Depreciation BookFA Reclassification Entry...«Table 230»Source CodeCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Source Code><Reason Code><No. Series><Posting No. Series><FA Jnl. Template Name><Journal Template Name><Journal Template Name><FA Jnl. Batch Name><Reason Code><No. Series><Posting No. Series><Journal Batch Name><Reason Code><Source Code><Posting No. Series>

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

Fields

# Name Type
1 Name Code10 NotBlank: Yes
2 Description Text80
5 Test Report ID Integer
6 Page ID Integer
7 Posting Report ID Integer
8 Force Posting Report Boolean
10 Source Code Code10
11 Reason Code Code10
12 Recurring Boolean
13 Test Report Caption Text250 Editable: No
FlowField
14 Page Caption Text250 Editable: No
FlowField
15 Posting Report Caption Text250 Editable: No
FlowField
16 Maint. Posting Report ID Integer
17 Maint. Posting Report Caption Text250 Editable: No
FlowField
18 No. Series Code10
19 Posting No. Series Code10

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Maint. Posting Report ID AllObjWithCaption Object ID 1..n
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n

Table Relations From Other Tables

From Table From Field
FA Journal Batch Journal Template Name 1..n
FA Journal Line Journal Template Name 1..n
FA Journal Setup FA Jnl. Template Name 1..n