Diagrams


Table

Inventory Posting Group

DynamicsDocs.comInventory Posting Group«Table 94»Inventory Posting GroupCode [PK,NN]Description«Table 1301»Mini 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. TextsVAT Prod. Posting Group«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 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 5722»Item CategoryCode [PK,NN]DescriptionDef. Gen. Prod. Posting GroupDef. Inventory Posting GroupDef. Tax Group CodeDef. Costing Method; [FIFO,LIFO,Specif...Def. VAT Prod. Posting Group«Table 5813»Inventory Posting SetupLocation Code [PK]Invt. Posting Group Code [PK,NN]Inventory AccountInventory Account [Interim]WIP AccountMaterial Variance AccountCapacity Variance AccountMfg. Overhead Variance AccountCap. Overhead Variance AccountSubcontracted Variance Account<Inventory Posting Group><Inventory Posting Group><Inventory Posting Group><Def. Inventory Posting Group><Invt. Posting Group Code><Alternative Item No.><Item Category Code><Source No.>

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

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Assembly Header Inventory Posting Group 1..n
Assembly Line Inventory Posting Group 1..n
Inventory Posting Setup Invt. Posting Group Code 1..n
Invt. Post to G/L Test Buffer Invt. Posting Group Code 1..n
Item Inventory Posting Group 1..n
Item Category Def. Inventory Posting Group 1..n
Item Journal Line Source Posting Group 1..n
Job Journal Line Posting Group 1..n
Job Ledger Entry Job Posting Group 1..n
Mini Item Template Inventory Posting Group 1..n
Phys. Inventory Ledger Entry Inventory Posting Group 1..n
Posted Assembly Header Inventory Posting Group 1..n
Posted Assembly Line Inventory Posting Group 1..n
Prod. Order Line Inventory Posting Group 1..n
Production Order Inventory Posting Group 1..n
Purch. Cr. Memo Line Posting Group 1..n
Purch. Inv. Line Posting Group 1..n
Purch. Rcpt. Line Posting Group 1..n
Purchase Line Posting Group 1..n
Purchase Line Archive Posting Group 1..n
Return Receipt Line Posting Group 1..n
Return Shipment Line Posting Group 1..n
Sales Cr.Memo Line Posting Group 1..n
Sales Invoice Line Posting Group 1..n
Sales Line Posting Group 1..n
Sales Line Archive Posting Group 1..n
Sales Shipment Line Posting Group 1..n
Service Cr.Memo Line Posting Group 1..n
Service Invoice Line Posting Group 1..n
Service Line Posting Group 1..n
Service Shipment Line Posting Group 1..n
Standard Item Journal Line Inventory Posting Group 1..n
Transfer Line Inventory Posting Group 1..n
Transfer Receipt Line Inventory Posting Group 1..n
Transfer Shipment Line Inventory Posting Group 1..n
Value Entry Source Posting Group 1..n