Diagrams


Table

Gen. Business Posting Group

DynamicsDocs.comGen. Business Posting Group«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 1300»Mini Customer TemplateKey [PK]Code [NN]Template Name [NN]CityDocument Sending ProfileCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodePayment Terms CodeFin. Charge Terms CodeCustomer Disc. GroupCountry/Region CodePrint StatementsPayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyReminder Terms CodeVAT Bus. Posting GroupBlock Payment ToleranceAllow Line Disc.«Table 1303»Mini Vendor TemplateKey [PK]Code [NN]Template Name [NN]CityVendor Posting GroupCurrency CodeLanguage CodePayment Terms CodeFin. Charge Terms CodeInvoice Disc. CodeCountry/Region CodePayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyVAT Bus. Posting GroupBlock Payment Tolerance«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 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 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 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 AccountPurch. FA Disc. AccountInvt. Accrual Acc. [Interim]COGS Account [Interim]Direct Cost Applied AccountOverhead Applied AccountPurchase Variance Account«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 5105»Customer TemplateCode [PK,NN]DescriptionTerritory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeCustomer Posting GroupCurrency CodeCustomer Price GroupPayment Terms CodeShipment Method CodeInvoice Disc. CodeCustomer Disc. GroupCountry/Region CodePayment Method CodeGen. Bus. Posting GroupVAT Bus. Posting GroupAllow Line Disc.«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 323»VAT Business Posting GroupCode [PK,NN]Description<Def. VAT Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><VAT Bus. Posting Group><Invoice Disc. Code><VAT Bus. Posting Group><VAT Bus. Posting Group><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><No.><Bill-to Customer No.><VAT Bus. Posting Group><VAT Bus. Posting Group><Pay-to Vendor No.><VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Bus. Posting Group>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50
3 Def. VAT Bus. Posting Group Code10
4 Auto Insert Default Boolean

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Def. VAT Bus. Posting Group VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Customer Gen. Bus. Posting Group 1..n
Customer Template Gen. Bus. Posting Group 1..n
Deferral Post. Buffer Gen. Bus. Posting Group 1..n
Detailed CV Ledg. Entry Buffer Gen. Bus. Posting Group 1..n
Detailed Cust. Ledg. Entry Gen. Bus. Posting Group 1..n
Detailed Vendor Ledg. Entry Gen. Bus. Posting Group 1..n
FA Ledger Entry Gen. Bus. Posting Group 1..n
Finance Charge Memo Header Gen. Bus. Posting Group 1..n
G/L Account Gen. Bus. Posting Group 1..n
G/L Account (Analysis View) Gen. Bus. Posting Group 1..n
G/L Entry Gen. Bus. Posting Group 1..n
Gen. Jnl. Allocation Gen. Bus. Posting Group 1..n
Gen. Journal Line Bal. Gen. Bus. Posting Group 1..n
General Posting Setup Gen. Bus. Posting Group 1..n
Invoice Post. Buffer Gen. Bus. Posting Group 1..n
Invt. Post to G/L Test Buffer Gen. Bus. Posting Group 1..n
Issued Fin. Charge Memo Header Gen. Bus. Posting Group 1..n
Issued Reminder Header Gen. Bus. Posting Group 1..n
Item Journal Line Gen. Bus. Posting Group 1..n
Job Journal Line Gen. Bus. Posting Group 1..n
Job Ledger Entry Gen. Bus. Posting Group 1..n
Job Planning Line Gen. Bus. Posting Group 1..n
Job Posting Buffer Gen. Bus. Posting Group 1..n
Maintenance Ledger Entry Gen. Bus. Posting Group 1..n
Mini Customer Template Gen. Bus. Posting Group 1..n
Mini Vendor Template Gen. Bus. Posting Group 1..n
Prepayment Inv. Line Buffer Gen. Bus. Posting Group 1..n
Production Order Gen. Bus. Posting Group 1..n
Purch. Cr. Memo Hdr. Gen. Bus. Posting Group 1..n
Purch. Cr. Memo Line Gen. Bus. Posting Group 1..n
Purch. Inv. Header Gen. Bus. Posting Group 1..n
Purch. Inv. Line Gen. Bus. Posting Group 1..n
Purch. Rcpt. Header Gen. Bus. Posting Group 1..n
Purch. Rcpt. Line Gen. Bus. Posting Group 1..n
Purchase Header Gen. Bus. Posting Group 1..n
Purchase Header Archive Gen. Bus. Posting Group 1..n
Purchase Line Gen. Bus. Posting Group 1..n
Purchase Line Archive Gen. Bus. Posting Group 1..n
Reminder Header Gen. Bus. Posting Group 1..n
Requisition Line Gen. Business Posting Group 1..n
Res. Journal Line Gen. Bus. Posting Group 1..n
Res. Ledger Entry Gen. Bus. Posting Group 1..n
Return Receipt Header Gen. Bus. Posting Group 1..n
Return Receipt Line Gen. Bus. Posting Group 1..n
Return Shipment Header Gen. Bus. Posting Group 1..n
Return Shipment Line Gen. Bus. Posting Group 1..n
Sales Cr.Memo Header Gen. Bus. Posting Group 1..n
Sales Cr.Memo Line Gen. Bus. Posting Group 1..n
Sales Header Gen. Bus. Posting Group 1..n
Sales Header Archive Gen. Bus. Posting Group 1..n
Sales Invoice Header Gen. Bus. Posting Group 1..n
Sales Invoice Line Gen. Bus. Posting Group 1..n
Sales Line Gen. Bus. Posting Group 1..n
Sales Line Archive Gen. Bus. Posting Group 1..n
Sales Shipment Header Gen. Bus. Posting Group 1..n
Sales Shipment Line Gen. Bus. Posting Group 1..n
Service Cr.Memo Header Gen. Bus. Posting Group 1..n
Service Cr.Memo Line Gen. Bus. Posting Group 1..n
Service Header Gen. Bus. Posting Group 1..n
Service Invoice Header Gen. Bus. Posting Group 1..n
Service Invoice Line Gen. Bus. Posting Group 1..n
Service Ledger Entry Gen. Bus. Posting Group 1..n
Service Line Gen. Bus. Posting Group 1..n
Service Order Posting Buffer Gen. Bus. Posting Group 1..n
Service Shipment Header Gen. Bus. Posting Group 1..n
Service Shipment Line Gen. Bus. Posting Group 1..n
Standard General Journal Line Bal. Gen. Bus. Posting Group 1..n
Standard Item Journal Line Gen. Bus. Posting Group 1..n
VAT Entry Gen. Bus. Posting Group 1..n
VAT Report Line Gen. Bus. Posting Group 1..n
Value Entry Gen. Bus. Posting Group 1..n
Vendor Gen. Bus. Posting Group 1..n
Warranty Ledger Entry Gen. Bus. Posting Group 1..n