Diagrams


Table

Gen. Journal Template

DynamicsDocs.comGen. Journal Template«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 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 Type; [Not Expected,User ID]Response User IDResponse Option Group«Table 1660»Payroll SetupPrimary Key [PK]General Journal Template NameGeneral Journal Batch NameUser 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. SeriesTax Type; [VAT,Sales Tax]Default VAT Bus. Posting GroupNormal VAT Prod. Posting Gr.Reduced VAT Prod. Posting Gr.Zero VAT Prod. Posting Gr.C2Graph EndpointSales Quote No. SeriesEngage EndpointCoupons Integration EnabledGraph Enablement Reminder«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 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 AmountIdLast Modified DateTime«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 750»Standard General JournalJournal Template Name [PK,NN]Code [PK,NN]Description«Table 751»Standard General Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Account Type; [G/L Account,Customer,Ve...Account No.Document Type; [,Payment,Invoice,Credi...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 CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Payment Discount %Job No.QuantityVAT AmountPayment Terms Code...«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 230»Source CodeCode [PK,NN]Description«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 Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit 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<Source Code><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><Posting No. Series><General Journal Template><Journal Template Name><General Journal Template Name><General Journal Template Name><General Journal Template Name><Payment Reg. Template Name><Journal Template Name><Journal Template Name><Gen. Jnl. Template Name><Journal Template Name><Journal Template Name><Journal Template Name><Journal Template Name><General Journal Batch Name><Sender Bank Account Code><Journal Batch Name><General Journal Batch Name><General Journal Batch Name><General Journal Batch Name><Payment Reg. Batch Name><Sales Invoice No. Series><Posted Sales Inv. No. Series><Sales Quote No. Series><Journal Batch Name><Journal Line No.><Account No.><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><Posting No. Series><Gen. Jnl. Batch Name><Journal Batch Name><Journal Batch Id><Journal Batch Name><Standard Journal Code><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.><Source Code><Reason Code><Posting No. Series><Account No.><Bal. Account No.><Account Id><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Customer Id><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.><Source Code><Reason Code><Posting No. Series><Bal. Account No.><Bal. Account No.><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.><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 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
9 Type Option
10 Source Code Code10
11 Reason Code Code10
12 Recurring Boolean
15 Test Report Caption Text250 Editable: No
FlowField
16 Page Caption Text250 Editable: No
FlowField
17 Posting Report Caption Text250 Editable: No
FlowField
18 Force Doc. Balance Boolean
19 Bal. Account Type Option
20 Bal. Account No. Code20
21 No. Series Code20
22 Posting No. Series Code20
23 Copy VAT Setup to Jnl. Lines Boolean
24 Allow VAT Difference Boolean
25 Cust. Receipt Report ID Integer
26 Cust. Receipt Report Caption Text250 Editable: No
FlowField
27 Vendor Receipt Report ID Integer
28 Vendor Receipt Report Caption Text250 Editable: No
FlowField

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Vendor Receipt Report ID AllObjWithCaption Object ID 1..n
Bal. Account No. Bank Account No. 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
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n
Bal. Account No. Vendor No. 1..n

Table Relations From Other Tables

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