Diagrams


Table

Standard General Journal Line

DynamicsDocs.comStandard General Journal Line«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 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 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCYAuto. Accept Transactions«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line AccountDescriptionUsed in CustomersUsed in Ledger Entries«Table 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.DescriptionUsed in VendorsUsed in Ledger Entries«Table 5606»FA Posting GroupCode [PK,NN]Acquisition Cost AccountAccum. Depreciation AccountWrite-Down AccountAppreciation AccountCustom 1 AccountCustom 2 AccountAcq. Cost Acc. on DisposalAccum. Depr. Acc. on DisposalWrite-Down Acc. on DisposalAppreciation Acc. on DisposalCustom 1 Account on DisposalCustom 2 Account on DisposalGains Acc. on DisposalLosses Acc. on DisposalBook Val. Acc. on Disp. [Gain]Sales Acc. on Disp. [Gain]Write-Down Bal. Acc. on Disp.Apprec. Bal. Acc. on Disp.Custom 1 Bal. Acc. on DisposalCustom 2 Bal. Acc. on DisposalMaintenance Expense AccountMaintenance Bal. Acc.Acquisition Cost Bal. Acc.Depreciation Expense Acc.Write-Down Expense Acc.Appreciation Bal. AccountCustom 1 Expense Acc.Custom 2 Expense Acc.Sales Bal. Acc.Allocated Acquisition Cost %...«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 220»Business UnitCode [PK,NN]ConsolidateConsolidation %Starting DateEnding DateIncome Currency FactorBalance Currency FactorExch. Rate Losses Acc.Exch. Rate Gains Acc.Residual AccountLast Balance Currency FactorNameCompany NameCurrency CodeComp. Exch. Rate Gains Acc.Comp. Exch. Rate Losses Acc.Equity Exch. Rate Gains Acc.Equity Exch. Rate Losses Acc.Minority Exch. Rate Gains Acc.Minority Exch. Rate Losses AccCurrency Exchange Rate Table; [Local,B...Data Source; [Local Curr. <LCY>,Add. R...File Format; [Version 4.00 or Later <....Last Run«Table 750»Standard General JournalJournal Template Name [PK,NN]Code [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 318»Tax AreaCode [PK,NN]DescriptionLast Modified Date TimeId«Table 321»Tax GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 224»Order AddressVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Country/Region CodeLast Date ModifiedFax No.Telex Answer BackPost CodeCountyE-MailHome Page«Table 410»IC G/L AccountNo. [PK,NN]NameAccount Type; [Posting,Heading,Total,B...Income/Balance; [Income Statement,Bala...BlockedMap-to G/L Acc. No.Indentation«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTask Status Filter; [Not Started,In Pr...Task Closed Filter...<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.><Account No.><Bal. Account No.><IC Partner Code><Posting Group><Posting Group><Posting Group><Job No.><Payment Terms Code><Business Unit Code><Standard Journal Code><Reason Code><Gen. Bus. Posting Group><Bal. Gen. Bus. Posting Group><Gen. Prod. Posting Group><Bal. Gen. Prod. Posting Group><Tax Area Code><Bal. Tax Area Code><Tax Group Code><Bal. Tax Group Code><VAT Bus. Posting Group><Bal. VAT Bus. Posting Group><VAT Prod. Posting Group><Bal. VAT Prod. Posting Group><Ship-to/Order Address Code><Ship-to/Order Address Code><IC Partner G/L Acc. No.><Campaign No.><Business Unit Filter><Exch. Rate Losses Acc.><Exch. Rate Gains Acc.><Residual Account><Comp. Exch. Rate Gains Acc.><Comp. Exch. Rate Losses Acc.><Equity Exch. Rate Gains Acc.><Equity Exch. Rate Losses Acc.><Minority Exch. Rate Gains Acc.><Minority Exch. Rate Losses Acc><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Default IC Partner G/L Acc. No><Map-to G/L Acc. No.><Receivables Account><Payables Account><Acquisition Cost Account><Accum. Depreciation Account><Write-Down Account><Appreciation Account><Custom 1 Account><Custom 2 Account><Acq. Cost Acc. on Disposal><Accum. Depr. Acc. on Disposal><Write-Down Acc. on Disposal><Appreciation Acc. on Disposal><Custom 1 Account on Disposal><Custom 2 Account on Disposal><Gains Acc. on Disposal><Losses Acc. on Disposal><Book Val. Acc. on Disp. (Gain)><Sales Acc. on Disp. (Gain)><Write-Down Bal. Acc. on Disp.><Apprec. Bal. Acc. on Disp.><Custom 1 Bal. Acc. on Disposal><Custom 2 Bal. Acc. on Disposal><Maintenance Expense Account><Maintenance Bal. Acc.><Acquisition Cost Bal. Acc.><Depreciation Expense Acc.><Write-Down Expense Acc.><Appreciation Bal. Account><Custom 1 Expense Acc.><Custom 2 Expense Acc.><Sales Bal. Acc.><Sales Acc. on Disp. (Loss)><Book Val. Acc. on Disp. (Loss)><Receivables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Additional Fee Account><Interest Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Add. Fee per Line Account><Payables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Customer Posting Group><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Bill-to Customer No.><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Customer No.><Ship-to Filter><Customer No.><Bill-to Customer No.><Vendor Posting Group><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Pay-to Vendor No.><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Vendor No.><Vendor No.><Vendor No.><Maintenance Vendor No.><Component of Main Asset><FA Posting Group><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Tax Area Code>

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
Editable: No
2 Line No. Integer NotBlank: Yes
Editable: No
3 Account Type Option
4 Account No. Code20
6 Document Type Option
8 Description Text50
10 VAT % Decimal (0:5) Editable: No
11 Bal. Account No. Code20
12 Currency Code Code10
13 Amount Decimal
14 Debit Amount Decimal BlankZero: Yes
15 Credit Amount Decimal BlankZero: Yes
16 Amount (LCY) Decimal
17 Balance (LCY) Decimal Editable: No
18 Currency Factor Decimal (0:15) Editable: No
19 Sales/Purch. (LCY) Decimal
20 Profit (LCY) Decimal
21 Inv. Discount (LCY) Decimal
22 Bill-to/Pay-to No. Code20
23 Posting Group Code20 Editable: No
24 Shortcut Dimension 1 Code Code20
25 Shortcut Dimension 2 Code Code20
26 Salespers./Purch. Code Code20
29 Source Code Code10 Editable: No
34 On Hold Code3
35 Applies-to Doc. Type Option
40 Payment Discount % Decimal (0:5)
42 Job No. Code20 Editable: No
43 Quantity Decimal (0:5)
44 VAT Amount Decimal
47 Payment Terms Code Code10
50 Business Unit Code Code20
51 Standard Journal Code Code10
52 Reason Code Code10
57 Gen. Posting Type Option
58 Gen. Bus. Posting Group Code20
59 Gen. Prod. Posting Group Code20
60 VAT Calculation Type Option Editable: No
63 Bal. Account Type Option
64 Bal. Gen. Posting Type Option
65 Bal. Gen. Bus. Posting Group Code20
66 Bal. Gen. Prod. Posting Group Code20
67 Bal. VAT Calculation Type Option Editable: No
68 Bal. VAT % Decimal (0:5) Editable: No
69 Bal. VAT Amount Decimal
70 Bank Payment Type Option
71 VAT Base Amount Decimal
72 Bal. VAT Base Amount Decimal
73 Correction Boolean
78 Source Type Option
79 Source No. Code20
80 Posting No. Series Code20
82 Tax Area Code Code20
83 Tax Liable Boolean
84 Tax Group Code Code20
85 Use Tax Boolean
86 Bal. Tax Area Code Code20
87 Bal. Tax Liable Boolean
88 Bal. Tax Group Code Code20
89 Bal. Use Tax Boolean
90 VAT Bus. Posting Group Code20
91 VAT Prod. Posting Group Code20
92 Bal. VAT Bus. Posting Group Code20
93 Bal. VAT Prod. Posting Group Code20
110 Ship-to/Order Address Code Code10
111 VAT Difference Decimal Editable: No
112 Bal. VAT Difference Decimal Editable: No
113 IC Partner Code Code20 Editable: No
116 IC Partner G/L Acc. No. Code20
118 Sell-to/Buy-from No. Code20
480 Dimension Set ID Integer Editable: No
5050 Campaign No. Code20
5616 Index Entry Boolean

Keys

# Fields
0 Journal Template Name,Standard Journal Code,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Source No. Bank Account No. 1..n
Business Unit Code Business Unit Code 1..n
Campaign No. Campaign No. 1..n
Currency Code Currency Code 1..n
Sell-to/Buy-from No. Customer No. 1..n
Posting Group Customer Posting Group Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Posting Group FA Posting Group Code 1..n
Source No. Fixed Asset No. 1..n
Bal. Account No. G/L Account No. 1..n
Bal. Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Journal Template Name Gen. Journal Template Name 1..n
Bal. Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
IC Partner G/L Acc. No. IC G/L Account No. 1..n
IC Partner Code IC Partner Code 1..n
Job No. Job No. 1..n
Posting No. Series No. Series Code 1..n
Ship-to/Order Address Code Order Address Code 1..n
Payment Terms Code Payment Terms Code 1..n
Reason Code Reason Code Code 1..n
Salespers./Purch. Code Salesperson/Purchaser Code 1..n
Ship-to/Order Address Code Ship-to Address Code 1..n
Source Code Source Code Code 1..n
Standard Journal Code Standard General Journal Code 1..n
Bal. Tax Area Code Tax Area Code 1..n
Bal. Tax Group Code Tax Group Code 1..n
Bal. VAT Bus. Posting Group VAT Business Posting Group Code 1..n
Bal. VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Sell-to/Buy-from No. Vendor No. 1..n
Posting Group Vendor Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field