Diagrams

Table

Planning Error Log

DynamicsDocs.comPlanning Error Log«Table 5430»Planning Error LogWorksheet Template Name [PK]Journal Batch Name [PK]Entry No. [PK]Item No.Error DescriptionTable IDTable Position«Table 244»Req. Wksh. TemplateName [PK,NN]DescriptionPage IDRecurringPage CaptionType; [Req.,For. Labor,Planning]«Table 245»Requisition Wksh. NameWorksheet Template Name [PK,NN]Name [PK,NN]DescriptionTemplate Type; [Req.,For. Labor,Planni...Recurring«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...<Worksheet Template Name><Journal Batch Name><Item No.><Worksheet Template Name><Alternative Item No.>

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

Fields

# Name Type
1 Worksheet Template Name (Worksheet Template Name) Code10
2 Journal Batch Name (Journal Batch Name) Code10
3 Entry No. (Entry No.) Integer
4 Item No. (Item No.) Code20
5 Error Description (Error Description) Text250
6 Table ID (Table ID) Integer
7 Table Position (Table Position) Text250

Keys

# Fields
0 Worksheet Template Name,Journal Batch Name,Entry No. (Worksheet Template Name,Journal Batch Name,Entry No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Table ID (Table ID) AllObjWithCaption Object ID (Object ID) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Worksheet Template Name (Worksheet Template Name) Req. Wksh. Template Name (Name) 1..n
Journal Batch Name (Journal Batch Name) Requisition Wksh. Name Name (Name) 1..n

Table Relations From Other Tables

From Table From Field