Diagrams


Table

FA Journal Batch

DynamicsDocs.comFA Journal Batch«Table 5620»FA Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«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 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 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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Journal Template Name><Reason Code><No. Series><Posting No. Series><FA Jnl. Batch Name><Journal Batch Name><FA Jnl. Template Name><Journal Template Name><Reason Code><Posting No. Series><Reason Code><No. Series><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 Journal Template Name Code10 NotBlank: Yes
2 Name Code10 NotBlank: Yes
3 Description Text50
4 Reason Code Code10
5 No. Series Code10
6 Posting No. Series Code10
22 Recurring Boolean Editable: No
FlowField

Keys

# Fields
0 Journal Template Name,Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Journal Template Name FA Journal Template Name 1..n
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n

Table Relations From Other Tables

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