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 (Name) Code10 NotBlank: Yes
2 Description (Description) Text80
5 Test Report ID (Test Report ID) Integer
6 Page ID (Page ID) Integer
7 Posting Report ID (Posting Report ID) Integer
8 Force Posting Report (Force Posting Report) Boolean
10 Source Code (Source Code) Code10
11 Reason Code (Reason Code) Code10
12 Recurring (Recurring) Boolean
13 Test Report Caption (Test Report Caption) Text250 Editable: No
FlowField
14 Page Caption (Page Caption) Text250 Editable: No
FlowField
15 Posting Report Caption (Posting Report Caption) Text250 Editable: No
FlowField
16 Maint. Posting Report ID (Maint. Posting Report ID) Integer
17 Maint. Posting Report Caption (Maint. Posting Report Caption) Text250 Editable: No
FlowField
18 No. Series (No. Series) Code20
19 Posting No. Series (Posting No. Series) Code20

Keys

# Fields
0 Name (Name) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

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