Diagrams


Table

Gen. Journal Batch

DynamicsDocs.comGen. Journal Batch«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 1104»Cost EntryEntry No. [PK]Cost Type No.Posting DateDocument No.DescriptionAmountDebit AmountCredit AmountCost Center CodeCost Object CodeReason CodeG/L AccountG/L Entry No.Source CodeSystem-Created EntryAllocatedAllocated with Journal No.User IDBatch NameAllocation DescriptionAllocation IDAdditional-Currency AmountAdd.-Currency Debit AmountAdd.-Currency Credit Amount«Table 1226»Payment Export DataEntry No. [PK]Data Exch Entry No.Line No.Data Exch. Line Def CodeGeneral Journal TemplateGeneral Journal Batch NameGeneral Journal Line No.Sender Bank Name - Data Conv.Sender Bank NameSender Bank Account CodeSender Bank Account No.Sender Bank Account CurrencySender Bank Country/RegionSender Bank BICSender Bank Clearing Std.Sender Bank Clearing CodeSender Bank AddressSender Bank CitySender Bank Post CodeRecipient NameRecipient AddressRecipient CityRecipient Post CodeRecipient Country/Region CodeRecipient Email AddressRecipient IDRecipient Bank Clearing Std.Recipient Bank Clearing CodeRecipient Reg. No.Recipient Acc. No.Recipient Bank Acc. No....«Table 1228»Payment Jnl. Export Error TextJournal Template Name [PK]Journal Batch Name [PK]Journal Line No. [PK]Line No. [PK]Error TextDocument No. [PK]Additional InformationSupport URL«Table 131»Incoming Documents SetupPrimary Key [PK]General Journal Template NameGeneral Journal Batch NameRequire Approval To CreateRequire Approval To Post«Table 1523»Workflow Step ArgumentID [PK]Type; [Event,Response]General Journal Template NameGeneral Journal Batch NameNotification User IDNotification User License Type; [Full...Response Function NameLink Target PageCustom LinkEvent ConditionsApprover Type; [Salesperson/Purchaser,...Approver Limit Type; [Approver Chain,D...Workflow User Group CodeDue Date FormulaMessageDelegate After; [Never,1 day,2 days,5...Show Confirmation MessageTable No.Field No.Field CaptionApprover User IDResponse Option Group«Table 1660»Payroll SetupPrimary Key [PK]General Journal Template NameGeneral Journal Batch NameUser Name«Table 1804»Approval Workflow WizardPrimary Key [PK]Approver IDSales Invoice App. WorkflowSales Amount Approval LimitPurch Invoice App. WorkflowPurch Amount Approval LimitUse Exist. Approval User SetupFieldTableNoField CaptionCustom MessageApp. Trigger; [The user sends an appro...Field Operator; [Increased,Decreased,C...Journal Batch NameFor All BatchesJournal Template Name«Table 2110»O365 Sales Initial SetupPrimary Key [PK]Payment Reg. Template NamePayment Reg. Batch NameIs initializedDefault Customer TemplateDefault Item TemplateDefault Payment Terms CodeDefault Payment Method CodeSales Invoice No. SeriesPosted Sales Inv. No. Series«Table 221»Gen. Jnl. AllocationJournal Template Name [PK]Journal Batch Name [PK]Journal Line No. [PK]Line No. [PK]Account No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeAllocation QuantityAllocation %AmountGen. Posting Type; [,Purchase,Sale]Gen. Bus. Posting GroupGen. Prod. Posting GroupVAT Calculation Type; [Normal VAT,Reve...VAT AmountVAT %Account NameTax Area CodeTax LiableTax Group CodeUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupAdditional-Currency AmountDimension Set ID«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 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«Table 980»Payment Registration SetupUser ID [PK]Journal Template NameJournal Batch NameBal. Account Type; [,G/L Account,Bank...Bal. Account No.Use this Account as Def.Auto Fill Date Received«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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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 Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 1200»Bank Export/Import SetupCode [PK,NN]NameDirection; [Export,Import,Export-Posit...Processing Codeunit IDProcessing Codeunit NameProcessing XMLport IDProcessing XMLport NameData Exch. Def. CodeData Exch. Def. NamePreserve Non-Latin CharactersCheck Export CodeunitCheck Export Codeunit Name<Journal Template Name><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><Posting No. Series><Bank Statement Import Format><Batch Name><General Journal Batch Name><Journal Batch Name><General Journal Batch Name><General Journal Batch Name><General Journal Batch Name><Journal Batch Name><Payment Reg. Batch Name><Journal Batch Name><Gen. Jnl. Batch Name><Journal Batch Name><Journal Batch Name><Reason Code><G/L Account><General Journal Template><Sender Bank Account Code><Journal Template Name><General Journal Template Name><General Journal Template Name><General Journal Template Name><Payment Reg. Template Name><Sales Invoice No. Series><Posted Sales Inv. No. Series><Journal Template Name><Journal Line No.><Account No.><Gen. Jnl. Template Name><Journal Template Name><Account No.><Bal. Account No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Source No.><Account No.><Bal. Account No.><Source No.><Budgeted FA No.><Reason Code><Posting No. Series><Journal Template Name><Bal. Account No.><Bal. Account No.><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><Posting No. Series><Bill-to Customer No.><No. Series><Pay-to Vendor No.><No. Series><Vendor No.><Maintenance Vendor No.><No. Series><Credit Transfer Msg. Nos.><Direct Debit Msg. Nos.><Bank Statement Import Format><SEPA Direct Debit Exp. Format><Payment Export Format><Positive Pay Export Code><Component of Main Asset><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 Bal. Account Type Option
6 Bal. Account No. Code20
7 No. Series Code10
8 Posting No. Series Code10
9 Copy VAT Setup to Jnl. Lines Boolean
10 Allow VAT Difference Boolean
11 Allow Payment Export Boolean
12 Bank Statement Import Format Code20
21 Template Type Option Editable: No
FlowField
22 Recurring Boolean Editable: No
FlowField
23 Suggest Balancing Amount Boolean

Keys

# Fields
0 Journal Template Name,Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. Bank Account No. 1..n
Bank Statement Import Format Bank Export/Import Setup Code 1..n
Bal. Account No. Customer No. 1..n
Bal. Account No. Fixed Asset No. 1..n
Bal. Account No. G/L Account No. 1..n
Journal Template Name Gen. Journal Template Name 1..n
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Bal. Account No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Approval Workflow Wizard Journal Batch Name 1..n
Cost Entry Batch Name 1..n
FA Journal Setup Gen. Jnl. Batch Name 1..n
Gen. Jnl. Allocation Journal Batch Name 1..n
Gen. Journal Line Journal Batch Name 1..n
Incoming Documents Setup General Journal Batch Name 1..n
O365 Sales Initial Setup Payment Reg. Batch Name 1..n
Payment Export Data General Journal Batch Name 1..n
Payment Jnl. Export Error Text Journal Batch Name 1..n
Payment Registration Setup Journal Batch Name 1..n
Payroll Setup General Journal Batch Name 1..n
Workflow Step Argument General Journal Batch Name 1..n