Diagrams


Table

Reversal Entry

DynamicsDocs.comReversal Entry«Table 179»Reversal EntryLine No. [PK]Entry Type; [,G/L Account,Customer,Ven...Entry No.G/L Register No.Source CodeJournal Batch NameTransaction No.Source Type; [,Customer,Vendor,Bank Ac...Source No.Currency CodeDescriptionAmountDebit AmountCredit AmountAmount [LCY]Debit Amount [LCY]Credit Amount [LCY]VAT AmountPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.Account No.Account NameBal. Account Type; [G/L Account,Custom...Bal. Account No.FA Posting Category; [,Disposal,Bal. D...FA Posting Type; [,Acquisition Cost,De...Reversal Type; [Transaction,Register]«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«Table 21»Cust. Ledger EntryEntry No. [PK]Customer No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales [LCY]Profit [LCY]Inv. Discount [LCY]Sell-to Customer No.Customer Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«Table 25»Vendor Ledger EntryEntry No. [PK]Vendor No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Purchase [LCY]Inv. Discount [LCY]Buy-from Vendor No.Vendor Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodePurchaser CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Rcd.[LCY]PositiveClosed by Entry No....«Table 271»Bank Account Ledger EntryEntry No. [PK]Bank Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountAmount [LCY]Bank Acc. Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeOur Contact CodeUser IDSource CodeOpenPositiveClosed by Entry No.Closed at DateJournal Batch NameReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.Transaction No.Statement Status; [Open,Bank Acc. Entr...Statement No.Statement Line No.Debit AmountCredit AmountDebit Amount [LCY]...«Table 5601»FA Ledger EntryEntry No. [PK]G/L Entry No.FA No.FA Posting DatePosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.DescriptionDepreciation Book CodeFA Posting Category; [,Disposal,Bal. D...FA Posting Type; [Acquisition Cost,Dep...AmountDebit AmountCredit AmountReclassification EntryPart of Book ValuePart of Depreciable BasisDisposal Calculation Method; [,Net,Gro...Disposal Entry No.No. of Depreciation DaysQuantityFA No./Budgeted FA No.FA Subclass CodeFA Location CodeFA Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser ID...«Table 5625»Maintenance Ledger EntryEntry No. [PK]G/L Entry No.FA No.FA Posting DatePosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.DescriptionAmountDebit AmountCredit AmountQuantityFA No./Budgeted FA No.FA Subclass CodeFA Location CodeFA Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser IDJournal Batch NameSource CodeReason CodeTransaction No.Bal. Account Type; [G/L Account,Custom...Bal. Account No.VAT AmountGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting Group...«Table 254»VAT EntryEntry No. [PK]Gen. Bus. Posting GroupGen. Prod. Posting GroupPosting DateDocument No.Document Type; [,Payment,Invoice,Credi...Type; [,Purchase,Sale,Settlement]BaseAmountVAT Calculation Type; [Normal VAT,Reve...Bill-to/Pay-to No.EU 3-Party TradeUser IDSource CodeReason CodeClosed by Entry No.ClosedCountry/Region CodeInternal Ref. No.Transaction No.Unrealized AmountUnrealized BaseRemaining Unrealized AmountRemaining Unrealized BaseExternal Document No.No. SeriesTax Area CodeTax LiableTax Group CodeUse TaxTax Jurisdiction Code...«Table 45»G/L RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom VAT Entry No.To VAT Entry No.Reversed«Table 230»Source CodeCode [PK,NN]Description«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 Group«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/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.Business Unit Filter...<Entry No.><Entry No.><Entry No.><Entry No.><Entry No.><Entry No.><Entry No.><G/L Register No.><Source Code><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Currency Code><Bal. Account No.><G/L Account No.><Bal. Account No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Source Code><Reversed by Entry No.><Reversed Entry No.><FA Entry No.><G/L Entry No.><FA Entry No.><G/L Entry No.><From Entry No.><To Entry No.><Customer No.><Sell-to Customer No.><Bal. Account No.><Currency Code><Closed by Currency Code><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Currency Code><Closed by Currency Code><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bank Account No.><Bal. Account No.><Currency Code><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><FA No.><FA No./Budgeted FA No.><Bal. Account No.><Canceled from FA No.><Source Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Reversed by Entry No.><Reversed Entry No.><FA No.><FA No./Budgeted FA No.><Bal. Account No.><Source Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Reversed by Entry No.><Reversed Entry No.><Bill-to/Pay-to No.><Bill-to/Pay-to No.><Source Code><Closed by Entry No.><Unrealized VAT Entry No.><Reversed by Entry No.><Reversed Entry No.><From VAT Entry No.><To VAT Entry No.><Source Code><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><Currency Code><Currency Filter><Vendor Filter><Pay-to Vendor No.><Vendor No.><Maintenance Vendor No.><Currency Code><Component of Main Asset><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Line No. Integer
2 Entry Type Option
3 Entry No. Integer
4 G/L Register No. Integer
5 Source Code Code10
6 Journal Batch Name Code10
7 Transaction No. Integer
8 Source Type Option
9 Source No. Code20
10 Currency Code Code10
11 Description Text50
12 Amount Decimal
13 Debit Amount Decimal
14 Credit Amount Decimal
15 Amount (LCY) Decimal
16 Debit Amount (LCY) Decimal
17 Credit Amount (LCY) Decimal
18 VAT Amount Decimal
19 Posting Date Date
20 Document Type Option
21 Document No. Code20
22 Account No. Code20
23 Account Name Text50
25 Bal. Account Type Option
26 Bal. Account No. Code20
27 FA Posting Category Option
28 FA Posting Type Option
30 Reversal Type Option

Keys

# Fields
0 Line No. Clustered: Yes
1 Entry Type
2 Document No.,Posting Date,Entry Type,Entry No.

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. Bank Account No. 1..n
Entry No. Bank Account Ledger Entry Entry No. 1..n
Currency Code Currency Code 1..n
Entry No. Cust. Ledger Entry Entry No. 1..n
Bal. Account No. Customer No. 1..n
Entry No. FA Ledger Entry Entry No. 1..n
Bal. Account No. Fixed Asset No. 1..n
Bal. Account No. G/L Account No. 1..n
Entry No. G/L Entry Entry No. 1..n
G/L Register No. G/L Register No. 1..n
Entry No. Maintenance Ledger Entry Entry No. 1..n
Source Code Source Code Code 1..n
Entry No. VAT Entry Entry No. 1..n
Bal. Account No. Vendor No. 1..n
Entry No. Vendor Ledger Entry Entry No. 1..n

Table Relations From Other Tables

From Table From Field