Diagrams

Table

G/L Account

DynamicsDocs.comG/L Account«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 1014»Job G/L Account PriceJob No. [PK,NN]Job Task No. [PK]G/L Account No. [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %Unit CostDescription«Table 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«Table 1661»Import G/L TransactionApp ID [PK]External AccountG/L AccountG/L Account NameEntry No. [PK]Transaction DateAmountDescription«Table 1700»Deferral TemplateDeferral Code [PK,NN]DescriptionDeferral Account [NN]Deferral %Calc. Method; [Straight-Line,Equal per...Start Date; [Posting Date,Beginning of...No. of PeriodsPeriod Description«Table 1828»Business Unit InformationCode [PK]NameCompany NameCurrency CodeCurrency Exchange Rate Table; [Local,B...Starting DateEnding DateExch. Rate Gains Acc.Exch. Rate Losses Acc.Residual AccountComp. 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«Table 1877»VAT Setup Posting GroupsVAT Prod. Posting Group [PK,NN]VAT %Sales VAT AccountPurchase VAT AccountReverse Chrg. VAT Acc.VAT Prod. Posting Grp Desc.VAT Clause DescSelectedApplication Type; [,Items,Services]«Table 208»Job Posting GroupCode [PK,NN]WIP Costs AccountWIP Accrued Costs AccountJob Costs Applied AccountJob Costs Adjustment AccountG/L Expense Acc. [Contract]Job Sales Adjustment AccountWIP Accrued Sales AccountWIP Invoiced Sales AccountJob Sales Applied AccountRecognized Costs AccountRecognized Sales AccountItem Costs Applied AccountResource Costs Applied AccountG/L Costs Applied AccountDescriptionUsed in JobsUsed in Ledger Entries«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 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 252»General Posting SetupGen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK,NN]Sales AccountSales Line Disc. AccountSales Inv. Disc. AccountSales Pmt. Disc. Debit Acc.Purch. AccountPurch. Line Disc. AccountPurch. Inv. Disc. AccountPurch. Pmt. Disc. Credit Acc.COGS AccountInventory Adjmt. AccountSales Credit Memo AccountPurch. Credit Memo AccountSales Pmt. Disc. Credit Acc.Purch. Pmt. Disc. Debit Acc.Sales Pmt. Tol. Debit Acc.Sales Pmt. Tol. Credit Acc.Purch. Pmt. Tol. Debit Acc.Purch. Pmt. Tol. Credit Acc.Sales Prepayments AccountPurch. Prepayments AccountUsed in Ledger EntriesDescriptionPurch. FA Disc. AccountInvt. Accrual Acc. [Interim]COGS Account [Interim]Direct Cost Applied AccountOverhead Applied AccountPurchase Variance Account«Table 277»Bank Account Posting GroupCode [PK,NN]G/L Bank Account No.«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 311»Sales & Receivables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Credit Warnings; [Both Warnings,Credit...Stockout WarningShipment on InvoiceInvoice RoundingExt. Doc. No. MandatoryCustomer Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Shipment Nos.Reminder Nos.Issued Reminder Nos.Fin. Chrg. Memo Nos.Issued Fin. Chrg. M. Nos.Posted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to Shpt.Allow VAT DifferenceCalc. Inv. Disc. per VAT IDLogo Position on Documents; [No Logo,L...Check Prepmt. when Posting...«Table 312»Purchases & Payables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Receipt on InvoiceInvoice RoundingExt. Doc. No. MandatoryVendor Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Receipt Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to ReceiptAllow VAT DifferenceCalc. Inv. Disc. per VAT IDPosted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Check Prepmt. when PostingDefault Posting Date; [Work Date,No Da...Default Qty. to Receive; [Remainder,Bl...Archive Quotes and OrdersPost with Job QueueJob Queue Category CodeJob Queue Priority for PostPost & Print with Job Queue...«Table 320»Tax JurisdictionCode [PK,NN]DescriptionTax Account [Sales]Tax Account [Purchases]Report-to JurisdictionDate FilterTax Group FilterUnreal. Tax Acc. [Sales]Unreal. Tax Acc. [Purchases]Reverse Charge [Purchases]Unreal. Rev. Charge [Purch.]Unrealized VAT Type; [,Percentage,Firs...Calculate Tax on TaxAdjust for Payment Discount«Table 325»VAT Posting SetupVAT Bus. Posting Group [PK]VAT Prod. Posting Group [PK]VAT Calculation Type; [Normal VAT,Reve...VAT %Unrealized VAT Type; [,Percentage,Firs...Adjust for Payment DiscountSales VAT AccountSales VAT Unreal. AccountPurchase VAT AccountPurch. VAT Unreal. AccountReverse Chrg. VAT Acc.Reverse Chrg. VAT Unreal. Acc.VAT IdentifierEU ServiceVAT Clause CodeCertificate of Supply RequiredTax CategoryDescriptionUsed in Ledger Entries«Table 326»Tax SetupPrimary Key [PK]Auto. Create Tax DetailsNon-Taxable Tax Group CodeTax Account [Sales]Tax Account [Purchases]Unreal. Tax Acc. [Sales]Unreal. Tax Acc. [Purchases]Reverse Charge [Purchases]Unreal. Rev. Charge [Purch.]«Table 376»G/L Account (Analysis View)No. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Account Source; [G/L Account,Cash Flow...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 ModifiedCash Flow Forecast FilterDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudgeted at DateConsol. Debit Acc.Consol. Credit Acc....«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 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 5221»Employee Posting GroupCode [PK]Payables Account«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 5615»FA AllocationCode [PK,NN]Line No. [PK]DescriptionAccount No.Global Dimension 1 CodeGlobal Dimension 2 CodeAllocation %Allocation Type; [Acquisition,Deprecia...Account NameDimension Set ID«Table 5813»Inventory Posting SetupLocation Code [PK]Invt. Posting Group Code [PK,NN]Inventory AccountDescriptionUsed in Ledger EntriesInventory Account [Interim]WIP AccountMaterial Variance AccountCapacity Variance AccountMfg. Overhead Variance AccountCap. Overhead Variance AccountSubcontracted Variance Account«Table 5905»Service CostCode [PK,NN]DescriptionAccount No.Default Unit PriceDefault QuantityUnit of Measure CodeCost Type; [Travel,Support,Other]Service Zone CodeDefault Unit Cost«Table 5973»Service Contract Account GroupCode [PK]DescriptionNon-Prepaid Contract Acc.Prepaid Contract Acc.«Table 6083»Serv. Price Adjustment DetailServ. Price Adjmt. Gr. Code [PK,NN]Type; [Item,Resource,Resource Group,Se...No. [PK]Work Type [PK]Gen. Prod. Posting Group [PK]Description«Table 843»Cash Flow SetupPrimary Key [PK]Cash Flow Forecast No. SeriesReceivables CF Account No.Payables CF Account No.Sales Order CF Account No.Purch. Order CF Account No.FA Budget CF Account No.FA Disposal CF Account No.Service CF Account No.CF No. on Chart in Role CenterJob CF Account No.Automatic Update Frequency; [Never,Dai...Tax CF Account No.Taxable Period; [Monthly,Quarterly,Acc...Tax Payment WindowTax Bal. Account Type; [,Vendor,G/L Ac...Tax Bal. Account No.API KeyAPI URLVariance %Historical PeriodsHorizonPeriod Type; [Day,Week,Month,Quarter,Y...TimeOutService Pass API Key IDCortana Intelligence EnabledShow Cortana NotificationTime Series Model; [ARIMA,ETS,STL,ETS+...«Table 9153»My AccountUser ID [PK]Account No. [PK,NN]NameBalance«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 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 95»G/L Budget NameName [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 Code«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 570»G/L Account CategoryEntry No. [PK]Parent Entry No.Sibling Sequence No.Presentation OrderIndentationDescriptionAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Additional Report Definition; [,Operat...System GeneratedHas Children<Budget Filter><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.><Account Subcategory Entry No.><Default Deferral Template Code><Deferral Account><G/L Account No.><Account No.><G/L Account><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><Sales VAT Account><Purchase VAT Account><Reverse Chrg. VAT Acc.><WIP Costs Account><WIP Accrued Costs Account><Job Costs Applied Account><Job Costs Adjustment Account><G/L Expense Acc. (Contract)><Job Sales Adjustment Account><WIP Accrued Sales Account><WIP Invoiced Sales Account><Job Sales Applied Account><Recognized Costs Account><Recognized Sales Account><Item Costs Applied Account><Resource Costs Applied Account><G/L Costs Applied Account><Account No.><Sales Account><Sales Line Disc. Account><Sales Inv. Disc. Account><Sales Pmt. Disc. Debit Acc.><Purch. Account><Purch. Line Disc. Account><Purch. Inv. Disc. Account><Purch. Pmt. Disc. Credit Acc.><COGS Account><Inventory Adjmt. Account><Sales Credit Memo Account><Purch. Credit Memo Account><Sales Pmt. Disc. Credit Acc.><Purch. Pmt. Disc. Debit Acc.><Sales Pmt. Tol. Debit Acc.><Sales Pmt. Tol. Credit Acc.><Purch. Pmt. Tol. Debit Acc.><Purch. Pmt. Tol. Credit Acc.><Sales Prepayments Account><Purch. Prepayments Account><Purch. FA Disc. Account><Invt. Accrual Acc. (Interim)><COGS Account (Interim)><Direct Cost Applied Account><Overhead Applied Account><Purchase Variance Account><G/L Bank Account No.><Bal. Account No.><Freight G/L Acc. No.><Debit Acc. for Non-Item Lines><Credit Acc. for Non-Item Lines><Tax Account (Sales)><Tax Account (Purchases)><Unreal. Tax Acc. (Sales)><Unreal. Tax Acc. (Purchases)><Reverse Charge (Purchases)><Unreal. Rev. Charge (Purch.)><Sales VAT Account><Sales VAT Unreal. Account><Purchase VAT Account><Purch. VAT Unreal. Account><Reverse Chrg. VAT Acc.><Reverse Chrg. VAT Unreal. Acc.><Tax Account (Sales)><Tax Account (Purchases)><Unreal. Tax Acc. (Sales)><Unreal. Tax Acc. (Purchases)><Reverse Charge (Purchases)><Unreal. Rev. Charge (Purch.)><No.><Receivables Account><Payables 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)><Account No.><Inventory Account><Inventory Account (Interim)><WIP Account><Material Variance Account><Capacity Variance Account><Mfg. Overhead Variance Account><Cap. Overhead Variance Account><Subcontracted Variance Account><Account No.><Non-Prepaid Contract Acc.><Prepaid Contract Acc.><No.><Tax Bal. Account No.><Account No.><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.><Bal. Account No.><Account No.><Business Unit Filter><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Gen. Bus. Posting Group><Gen. Prod. Posting Group><VAT Bus. Posting Gr. (Price)><Report-to Jurisdiction><Tax Group Filter><VAT Bus. Posting Group><VAT Prod. Posting Group><Non-Taxable Tax Group Code><Budget Filter><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Code><No.><Gen. Prod. Posting Group><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group>

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

Fields

# Name Type
1 No. (No.) Code20 NotBlank: Yes
2 Name (Name) Text50
3 Search Name (Search Name) Code50
4 Account Type (Account Type) Option
6 Global Dimension 1 Code (Global Dimension 1 Code) Code20
7 Global Dimension 2 Code (Global Dimension 2 Code) Code20
8 Account Category (Account Category) Option BlankZero: Yes
9 Income/Balance (Income/Balance) Option
10 Debit/Credit (Debit/Credit) Option
11 No. 2 (No. 2) Code20
12 Comment (Comment) Boolean Editable: No
FlowField
13 Blocked (Blocked) Boolean
14 Direct Posting (Direct Posting) Boolean
16 Reconciliation Account (Reconciliation Account) Boolean
17 New Page (New Page) Boolean
18 No. of Blank Lines (No. of Blank Lines) Integer
19 Indentation (Indentation) Integer
25 Last Modified Date Time (Last Modified Date Time) DateTime Editable: No
26 Last Date Modified (Last Date Modified) Date Editable: No
28 Date Filter (Date Filter) Date FlowFilter
29 Global Dimension 1 Filter (Global Dimension 1 Filter) Code20 FlowFilter
30 Global Dimension 2 Filter (Global Dimension 2 Filter) Code20 FlowFilter
31 Balance at Date (Balance at Date) Decimal Editable: No
FlowField
32 Net Change (Net Change) Decimal Editable: No
FlowField
33 Budgeted Amount (Budgeted Amount) Decimal FlowField
34 Totaling (Totaling) Text250
35 Budget Filter (Budget Filter) Code10 FlowFilter
36 Balance (Balance) Decimal Editable: No
FlowField
37 Budget at Date (Budget at Date) Decimal Editable: No
FlowField
39 Consol. Translation Method (Consol. Translation Method) Option
40 Consol. Debit Acc. (Consol. Debit Acc.) Code20
41 Consol. Credit Acc. (Consol. Credit Acc.) Code20
42 Business Unit Filter (Business Unit Filter) Code20 FlowFilter
43 Gen. Posting Type (Gen. Posting Type) Option
44 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code20
45 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code20
46 Picture (Picture) BLOB [Bitmap]
47 Debit Amount (Debit Amount) Decimal BlankZero: Yes
Editable: No
FlowField
48 Credit Amount (Credit Amount) Decimal BlankZero: Yes
Editable: No
FlowField
49 Automatic Ext. Texts (Automatic Ext. Texts) Boolean
52 Budgeted Debit Amount (Budgeted Debit Amount) Decimal BlankNumbers: BlankNegAndZero
FlowField
53 Budgeted Credit Amount (Budgeted Credit Amount) Decimal BlankNumbers: BlankNegAndZero
FlowField
54 Tax Area Code (Tax Area Code) Code20
55 Tax Liable (Tax Liable) Boolean
56 Tax Group Code (Tax Group Code) Code20
57 VAT Bus. Posting Group (VAT Bus. Posting Group) Code20
58 VAT Prod. Posting Group (VAT Prod. Posting Group) Code20
60 Additional-Currency Net Change (Additional-Currency Net Change) Decimal Editable: No
FlowField
61 Add.-Currency Balance at Date (Add.-Currency Balance at Date) Decimal Editable: No
FlowField
62 Additional-Currency Balance (Additional-Currency Balance) Decimal Editable: No
FlowField
63 Exchange Rate Adjustment (Exchange Rate Adjustment) Option
64 Add.-Currency Debit Amount (Add.-Currency Debit Amount) Decimal Editable: No
FlowField
65 Add.-Currency Credit Amount (Add.-Currency Credit Amount) Decimal Editable: No
FlowField
66 Default IC Partner G/L Acc. No (Default IC Partner G/L Acc. No) Code20
70 Omit Default Descr. in Jnl. (Omit Default Descr. in Jnl.) Boolean
80 Account Subcategory Entry No. (Account Subcategory Entry No.) Integer
81 Account Subcategory Descript. (Account Subcategory Descript.) Text80 Editable: No
FlowField
400 Dimension Set ID Filter (Dimension Set ID Filter) Integer FlowFilter
1100 Cost Type No. (Cost Type No.) Code20 Editable: No
1700 Default Deferral Template Code (Default Deferral Template Code) Code10
8000 Id (Id) GUID

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Search Name (Search Name)
2 Reconciliation Account (Reconciliation Account)
3 Gen. Bus. Posting Group (Gen. Bus. Posting Group)
4 Gen. Prod. Posting Group (Gen. Prod. Posting Group)
5 Consol. Debit Acc.,Consol. Translation Method (Consol. Debit Acc.,Consol. Translation Method)
6 Consol. Credit Acc.,Consol. Translation Method (Consol. Credit Acc.,Consol. Translation Method)
7 Name (Name)
8 Account Type (Account Type)
9 Account Category (Account Category)

Table Relations To Other Tables

Field Related Table Related Field
Business Unit Filter (Business Unit Filter) Business Unit Code (Code) 1..n
Default Deferral Template Code (Default Deferral Template Code) Deferral Template Deferral Code (Deferral Code) 1..n
Global Dimension 2 Filter (Global Dimension 2 Filter) Dimension Value Code (Code) 1..n
Account Subcategory Entry No. (Account Subcategory Entry No.) G/L Account Category Entry No. (Entry No.) 1..n
Budget Filter (Budget Filter) G/L Budget Name Name (Name) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Default IC Partner G/L Acc. No (Default IC Partner G/L Acc. No) IC G/L Account No. (No.) 1..n
Tax Area Code (Tax Area Code) Tax Area Code (Code) 1..n
Tax Group Code (Tax Group Code) Tax Group Code (Code) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Analysis View Budget Entry G/L Account No. (G/L Account No.) 1..n
Analysis View Entry Account No. (Account No.) 1..n
Applied Payment Entry Account No. (Account No.) 1..n
Bank Acc. Reconciliation Line Account No. (Account No.) 1..n
Bank Account Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Bank Account Posting Group G/L Bank Account No. (G/L Bank Account No.) 1..n
Budget Buffer G/L Account No. (G/L Account No.) 1..n
Business Unit Minority Exch. Rate Losses Acc (Minority Exch. Rate Losses Acc) 1..n
Business Unit Information Minority Exch. Rate Losses Acc (Minority Exch. Rate Losses Acc) 1..n
CV Ledger Entry Buffer Bal. Account No. (Bal. Account No.) 1..n
Cash Flow Forecast Entry Source No. (Source No.) 1..n
Cash Flow Setup Tax Bal. Account No. (Tax Bal. Account No.) 1..n
Check Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Close Income Statement Buffer G/L Account No. (G/L Account No.) 1..n
Comment Line No. (No.) 1..n
Cost Entry G/L Account (G/L Account) 1..n
Currency Conv. LCY Rndg. Credit Acc. (Conv. LCY Rndg. Credit Acc.) 1..n
Cust. Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Customer Posting Group Add. Fee per Line Account (Add. Fee per Line Account) 1..n
Default Dimension No. (No.) 1..n
Deferral Post. Buffer G/L Account (G/L Account) 1..n
Deferral Template Deferral Account (Deferral Account) 1..n
Dimension Selection Buffer New Dimension Value Code (New Dimension Value Code) 1..n
Employee Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Employee Posting Group Payables Account (Payables Account) 1..n
Extended Text Header No. (No.) 1..n
Extended Text Line No. (No.) 1..n
FA Allocation Account No. (Account No.) 1..n
FA G/L Posting Buffer Account No. (Account No.) 1..n
FA Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
FA Posting Group Book Val. Acc. on Disp. (Loss) (Book Val. Acc. on Disp. (Loss)) 1..n
Finance Charge Memo Line No. (No.) 1..n
G/L Account (Analysis View) No. (No.) 1..n
G/L Budget Entry G/L Account No. (G/L Account No.) 1..n
G/L Entry Account Id (Account Id) 1..n
Gen. Jnl. Allocation Account No. (Account No.) 1..n
Gen. Journal Batch Bal. Account No. (Bal. Account No.) 1..n
Gen. Journal Line Account Id (Account Id) 1..n
Gen. Journal Template Bal. Account No. (Bal. Account No.) 1..n
General Posting Setup Purchase Variance Account (Purchase Variance Account) 1..n
IC G/L Account Map-to G/L Acc. No. (Map-to G/L Acc. No.) 1..n
IC Partner Payables Account (Payables Account) 1..n
Import G/L Transaction G/L Account (G/L Account) 1..n
Inventory Posting Setup Subcontracted Variance Account (Subcontracted Variance Account) 1..n
Invoice Post. Buffer G/L Account (G/L Account) 1..n
Invt. Post to G/L Test Buffer Account No. (Account No.) 1..n
Issued Fin. Charge Memo Line No. (No.) 1..n
Issued Reminder Line No. (No.) 1..n
Job G/L Account Price G/L Account No. (G/L Account No.) 1..n
Job Journal Line No. (No.) 1..n
Job Ledger Entry No. (No.) 1..n
Job Planning Line No. (No.) 1..n
Job Posting Group G/L Costs Applied Account (G/L Costs Applied Account) 1..n
Job WIP Buffer Bal. G/L Account No. (Bal. G/L Account No.) 1..n
Job WIP Entry G/L Bal. Account No. (G/L Bal. Account No.) 1..n
Job WIP G/L Entry G/L Bal. Account No. (G/L Bal. Account No.) 1..n
Maintenance Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
My Account Account No. (Account No.) 1..n
Payment Application Proposal Account No. (Account No.) 1..n
Payment Method Bal. Account No. (Bal. Account No.) 1..n
Payment Registration Buffer Bal. Account No. (Bal. Account No.) 1..n
Payment Registration Setup Bal. Account No. (Bal. Account No.) 1..n
Posted Deferral Header Deferral Account (Deferral Account) 1..n
Posted Deferral Line Deferral Account (Deferral Account) 1..n
Posted Payment Recon. Line Account No. (Account No.) 1..n
Prepayment Inv. Line Buffer G/L Account No. (G/L Account No.) 1..n
Purch. Cr. Memo Hdr. Bal. Account No. (Bal. Account No.) 1..n
Purch. Cr. Memo Line No. (No.) 1..n
Purch. Inv. Header Bal. Account No. (Bal. Account No.) 1..n
Purch. Inv. Line No. (No.) 1..n
Purch. Rcpt. Header Bal. Account No. (Bal. Account No.) 1..n
Purch. Rcpt. Line No. (No.) 1..n
Purchase Header Bal. Account No. (Bal. Account No.) 1..n
Purchase Header Archive Bal. Account No. (Bal. Account No.) 1..n
Purchase Line Archive No. (No.) 1..n
Purchases & Payables Setup Credit Acc. for Non-Item Lines (Credit Acc. for Non-Item Lines) 1..n
Reconcile CV Acc Buffer G/L Account No. (G/L Account No.) 1..n
Reminder Line No. (No.) 1..n
Requisition Line No. (No.) 1..n
Return Receipt Header Bal. Account No. (Bal. Account No.) 1..n
Return Receipt Line No. (No.) 1..n
Return Shipment Header Bal. Account No. (Bal. Account No.) 1..n
Return Shipment Line No. (No.) 1..n
Reversal Entry Bal. Account No. (Bal. Account No.) 1..n
Sales & Receivables Setup Freight G/L Acc. No. (Freight G/L Acc. No.) 1..n
Sales Cr.Memo Header Bal. Account No. (Bal. Account No.) 1..n
Sales Cr.Memo Line No. (No.) 1..n
Sales Header Bal. Account No. (Bal. Account No.) 1..n
Sales Header Archive Bal. Account No. (Bal. Account No.) 1..n
Sales Invoice Header Bal. Account No. (Bal. Account No.) 1..n
Sales Invoice Line No. (No.) 1..n
Sales Line Archive No. (No.) 1..n
Sales Shipment Buffer No. (No.) 1..n
Sales Shipment Header Bal. Account No. (Bal. Account No.) 1..n
Sales Shipment Line No. (No.) 1..n
Serv. Price Adjustment Detail No. (No.) 1..n
Service Contract Account Group Prepaid Contract Acc. (Prepaid Contract Acc.) 1..n
Service Cost Account No. (Account No.) 1..n
Service Cr.Memo Header Bal. Account No. (Bal. Account No.) 1..n
Service Cr.Memo Line No. (No.) 1..n
Service Header Bal. Account No. (Bal. Account No.) 1..n
Service Invoice Header Bal. Account No. (Bal. Account No.) 1..n
Service Invoice Line No. (No.) 1..n
Service Ledger Entry No. (No.) 1..n
Service Line No. (No.) 1..n
Service Shipment Buffer No. (No.) 1..n
Service Shipment Header Bal. Account No. (Bal. Account No.) 1..n
Service Shipment Line No. (No.) 1..n
Standard General Journal Line Bal. Account No. (Bal. Account No.) 1..n
Standard Purchase Line No. (No.) 1..n
Standard Sales Line No. (No.) 1..n
Standard Service Line No. (No.) 1..n
Tax Jurisdiction Unreal. Rev. Charge (Purch.) (Unreal. Rev. Charge (Purch.)) 1..n
Tax Setup Unreal. Rev. Charge (Purch.) (Unreal. Rev. Charge (Purch.)) 1..n
Text-to-Account Mapping Bal. Source No. (Bal. Source No.) 1..n
Trial Balance Entity Buffer Account Id (Account Id) 1..n
VAT Posting Setup Reverse Chrg. VAT Unreal. Acc. (Reverse Chrg. VAT Unreal. Acc.) 1..n
VAT Setup Posting Groups Reverse Chrg. VAT Acc. (Reverse Chrg. VAT Acc.) 1..n
Vendor Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Vendor Posting Group Payment Tolerance Credit Acc. (Payment Tolerance Credit Acc.) 1..n