Diagrams


Table

Standard Item Journal Line

DynamicsDocs.comStandard Item Journal Line«Table 753»Standard Item Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Item No.Entry Type; [Purchase,Sale,Positive Ad...DescriptionLocation CodeInventory Posting GroupQuantityUnit AmountUnit CostAmountSalespers./Purch. CodeSource CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Standard Journal Code [PK]Reason CodeTransaction TypeTransport MethodCountry/Region CodeQty. [Calculated]Qty. [Phys. Inventory]Phys. InventoryGen. Bus. Posting GroupGen. Prod. Posting GroupEntry/Exit PointAreaTransaction SpecificationPosting No. SeriesDimension Set ID...«Table 82»Item Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [Item,Transfer,Phys. Inventory,R...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. SeriesWhse. Register Report IDWhse. Register Report Caption«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 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 94»Inventory Posting GroupCode [PK,NN]Description«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %Global Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...Closed To-do Filter...«Table 230»Source CodeCode [PK,NN]Description«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 752»Standard Item JournalJournal Template Name [PK,NN]Code [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«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 282»Entry/Exit PointCode [PK,NN]Description«Table 284»AreaCode [PK,NN]Text«Table 285»Transaction SpecificationCode [PK,NN]Text«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«Table 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«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 5721»PurchasingCode [PK,NN]DescriptionDrop ShipmentSpecial Order«Table 5723»Product GroupItem Category Code [PK]Code [PK]DescriptionWarehouse Class Code«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«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 6635»Return ReasonCode [PK,NN]DescriptionDefault Location CodeInventory Value Zero<Journal Template Name><Item No.><Originally Ordered No.><Location Code><Inventory Posting Group><Salespers./Purch. Code><Source Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Standard Journal Code><Reason Code><Transaction Type><Transport Method><Country/Region Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Entry/Exit Point><Area><Transaction Specification><Posting No. Series><Dimension Set ID><Variant Code><Originally Ordered Var. Code><Bin Code><Bin Code><Unit of Measure Code><Item Category Code><Purchasing Code><Product Group Code><Item Charge No.><Work Center No.><Return Reason Code><Source Code><Reason Code><No. Series><Posting No. Series><Journal Template Name><Inventory Posting Group><Alternative Item No.><Country/Region Purchased Code><Country/Region of Origin Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Gen. Prod. Posting Group><No. Series><Serial Nos.><Lot Nos.><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Item Category Code><Product Group Code><Item No.><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Country/Region Code><Default Location Code><Location Code><Location Code><Def. Inventory Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Country/Region Code><Def. Gen. Prod. Posting Group><Gen. Prod. Posting Group><Gen. Prod. Posting Group><No. Series><Variant Code><Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Unit of Measure Code><Unit of Measure Filter><Item Category Code><Alternate Work Center>

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

Fields

# Name Type
1 Journal Template Name Code10 NotBlank: Yes
2 Line No. Integer NotBlank: Yes
Editable: No
3 Item No. Code20
5 Entry Type Option
8 Description Text50
9 Location Code Code10
10 Inventory Posting Group Code10 Editable: No
13 Quantity Decimal (0:5)
16 Unit Amount Decimal
17 Unit Cost Decimal
18 Amount Decimal
23 Salespers./Purch. Code Code10
26 Source Code Code10 Editable: No
34 Shortcut Dimension 1 Code Code20
35 Shortcut Dimension 2 Code Code20
37 Indirect Cost % Decimal (0:5)
41 Standard Journal Code Code10
42 Reason Code Code10
47 Transaction Type Code10
48 Transport Method Code10
49 Country/Region Code Code10
53 Qty. (Calculated) Decimal (0:5) Editable: No
54 Qty. (Phys. Inventory) Decimal (0:5)
56 Phys. Inventory Boolean Editable: No
57 Gen. Bus. Posting Group Code10
58 Gen. Prod. Posting Group Code10
59 Entry/Exit Point Code10
63 Area Code10
64 Transaction Specification Code10
65 Posting No. Series Code10
480 Dimension Set ID Integer Editable: No
5402 Variant Code Code10
5403 Bin Code Code20
5404 Qty. per Unit of Measure Decimal (0:5) Editable: No
5407 Unit of Measure Code Code10
5413 Quantity (Base) Decimal (0:5)
5701 Originally Ordered No. Code20
5702 Originally Ordered Var. Code Code10
5704 Item Category Code Code10
5705 Nonstock Boolean
5706 Purchasing Code Code10
5707 Product Group Code Code10
5800 Value Entry Type Option
5801 Item Charge No. Code20
5817 Correction Boolean
5839 Work Center No. Code20 Editable: No
6600 Return Reason Code Code10
99000755 Overhead Rate Decimal (0:5)

Keys

# Fields
0 Journal Template Name,Standard Journal Code,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Bin Code Bin Code 1..n
Bin Code Bin Content Bin Code 1..n
Country/Region Code Country/Region Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Entry/Exit Point Entry/Exit Point Code 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Inventory Posting Group Inventory Posting Group Code 1..n
Originally Ordered No. Item No. 1..n
Item Category Code Item Category Code 1..n
Item Charge No. Item Charge No. 1..n
Journal Template Name Item Journal Template Name 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Originally Ordered Var. Code Item Variant Code 1..n
Location Code Location Code 1..n
Posting No. Series No. Series Code 1..n
Product Group Code Product Group Code 1..n
Purchasing Code Purchasing Code 1..n
Reason Code Reason Code Code 1..n
Return Reason Code Return Reason Code 1..n
Salespers./Purch. Code Salesperson/Purchaser Code 1..n
Source Code Source Code Code 1..n
Standard Journal Code Standard Item Journal Code 1..n
Transaction Specification Transaction Specification Code 1..n
Transaction Type Transaction Type Code 1..n
Transport Method Transport Method Code 1..n
Work Center No. Work Center No. 1..n

Table Relations From Other Tables

From Table From Field