Diagrams

Table

Gen. Product Posting Group

DynamicsDocs.comGen. Product Posting Group«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 1301»Item TemplateKey [PK]Code [NN]Template Name [NN]Base Unit of MeasureType; [Inventory,Service]Inventory Posting GroupItem Disc. GroupAllow Invoice Disc.Price/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Indirect Cost %Price Includes VATGen. Prod. Posting GroupAutomatic Ext. TextsTax Group CodeVAT Prod. Posting GroupItem Category CodeService Item GroupWarehouse Class Code«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«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 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 AccountPurch. FA Disc. AccountInvt. Accrual Acc. [Interim]COGS Account [Interim]Direct Cost Applied AccountOverhead Applied AccountPurchase Variance Account«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«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 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 551»VAT Rate Change ConversionType; [VAT Prod. Posting Group,Gen. Pr...From Code [PK,NN]To Code [NN]Converted Date«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«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 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 324»VAT Product Posting GroupCode [PK,NN]Description<Def. VAT Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><From Code><To Code><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><VAT Prod. Posting Group><VAT Prod. Posting Group><No.><VAT Prod. 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.><No.><VAT Prod. Posting Group><Alternative Item No.><VAT Prod. Posting Group><Source No.><No.><Item Filter><VAT Prod. Posting Group><Work Center Filter><Capacity No. Filter><Capacity No. Filter><From Code><To Code><VAT Prod. Posting Group><Alternate Work Center><Work Center No.>

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

Fields

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

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Def. VAT Prod. Posting Group (Def. VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Assembly Header Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Assembly Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Deferral Post. Buffer Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Detailed CV Ledg. Entry Buffer Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Detailed Cust. Ledg. Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Detailed Vendor Ledg. Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
FA Ledger Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Finance Charge Memo Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
G/L Account Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
G/L Account (Analysis View) Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
G/L Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Gen. Jnl. Allocation Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Gen. Journal Line Bal. Gen. Prod. Posting Group (Bal. Gen. Prod. Posting Group) 1..n
General Posting Setup Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Invoice Post. Buffer Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Invt. Post to G/L Test Buffer Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Issued Fin. Charge Memo Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Issued Reminder Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Item Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Item Charge Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Item Journal Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Item Template Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Job Journal Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Job Ledger Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Job Planning Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Job Posting Buffer Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Machine Center Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Maintenance Ledger Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Posted Assembly Header Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Posted Assembly Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Prepayment Inv. Line Buffer Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Production Order Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Purch. Cr. Memo Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Purch. Inv. Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Purch. Rcpt. Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Purchase Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Purchase Line Archive Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Reminder Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Requisition Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Res. Journal Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Res. Ledger Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Resource Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Return Receipt Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Return Shipment Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Sales Cr.Memo Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Sales Invoice Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Sales Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Sales Line Archive Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Sales Shipment Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Serv. Price Adjustment Detail Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Service Cr.Memo Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Service Invoice Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Service Ledger Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Service Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Service Order Posting Buffer Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Service Shipment Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Standard General Journal Line Bal. Gen. Prod. Posting Group (Bal. Gen. Prod. Posting Group) 1..n
Standard Item Journal Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Transfer Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Transfer Receipt Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Transfer Shipment Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
VAT Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
VAT Rate Change Conversion To Code (To Code) 1..n
VAT Report Line Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Value Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Warranty Ledger Entry Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n
Work Center Gen. Prod. Posting Group (Gen. Prod. Posting Group) 1..n