Table 753 "Standard Item Journal Line"
Base Application · Microsoft.Inventory.Journal
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC262 fields removed
- BC27unchanged
- BC2829 fields changed
- BC29-30unchanged
Neighbourhood 33 connected objects and pages
Base Application · Microsoft.Inventory.Journal · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 755 “Standard Item Journal Subform” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Standard Item Journal Line |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Journal Template Name | Code[10] | — | TableRelation Table 82 “Item Journal Template” (Item Journal Template); NotBlank |
| 2 | Line No. | Integer | — | not editable; NotBlank |
| 3 | Item No. Δ BC28 | Code[20] | Specifies the number of the item on the journal line. | TableRelation Table 27 “Item” (Item where(Blocked = const(false))) |
| 5 | Entry Type Δ BC28 | Enum “Item Ledger Entry Type” | Specifies which type of transaction that the entry is created from. | enum Enum 78 “Item Ledger Entry Type” |
| 8 | Description Δ BC28 | Text[100] | Specifies the description of the item on the line. | |
| 9 | Location Code Δ BC28 | Code[10] | Specifies the location code for the item on the line. | TableRelation Table 14 “Location” |
| 10 | Inventory Posting Group | Code[20] | — | TableRelation Table 94 “Inventory Posting Group” (Inventory Posting Group); not editable |
| 13 | Quantity Δ BC28 | Decimal | Specifies the quantity of the item in the journal line. | |
| 16 | Unit Amount Δ BC28 | Decimal | Specifies the amount of the unit in the line of the journal line. | |
| 17 | Unit Cost Δ BC28 | Decimal | Specifies the cost of one unit of the item or resource on the line. | |
| 18 | Amount Δ BC28 | Decimal | Specifies the amount of the unit in the line of the journal line. | |
| 23 | Salespers./Purch. Code Δ BC28 | Code[20] | Specifies the code for the salesperson or purchaser who is linked to the sale or purchase on the journal line. | TableRelation Table 13 “Salesperson/Purchaser” (“Salesperson/Purchaser” where(Blocked = const(false))) |
| 26 | Source Code | Code[10] | — | TableRelation Table 230 “Source Code” (Source Code); not editable |
| 34 | Shortcut Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 35 | Shortcut Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 37 | Indirect Cost % Δ BC28 | Decimal | Specifies the percentage of the item’s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item. | |
| 41 | Standard Journal Code | Code[10] | — | TableRelation Table 752 “Standard Item Journal” (“Standard Item Journal”.Code) |
| 42 | Reason Code Δ BC28 | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. | TableRelation Table 231 “Reason Code” (Reason Code) |
| 47 | Transaction Type Δ BC28 | Code[10] | Specifies the type of transaction that the document represents, for the purpose of reporting to INTRASTAT. | TableRelation Table 258 “Transaction Type” (Transaction Type) |
| 48 | Transport Method Δ BC28 | Code[10] | Specifies the transport method, for the purpose of reporting to INTRASTAT. | TableRelation Table 259 “Transport Method” (Transport Method) |
| 49 | Country/Region Code Δ BC28 | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 53 | Qty. (Calculated) Δ BC28 | Decimal | — | not editable |
| 54 | Qty. (Phys. Inventory) Δ BC28 | Decimal | — | |
| 56 | Phys. Inventory | Boolean | — | not editable |
| 57 | Gen. Bus. Posting Group Δ BC28 | Code[20] | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 58 | Gen. Prod. Posting Group Δ BC28 | Code[20] | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 59 | Entry/Exit Point | Code[10] | — | TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point) |
| 63 | Area | Code[10] | — | TableRelation Table 284 “Area” |
| 64 | Transaction Specification | Code[10] | — | TableRelation Table 285 “Transaction Specification” (Transaction Specification) |
| 65 | Posting No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 5402 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”), Blocked = const(false))) |
| 5403 | Bin Code Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | TableRelation Table 7354 “Bin” (if (“Entry Type” = filter(Purchase | “Positive Adjmt.” | Output), Quantity = filter(>= 0)) Bin.Code where(“Location Code” = field(“Location Code”), “Item Filter” = field(“Item No.”), “Variant Filter” = field(“Variant Code”)) else if (“Entry Type” = filter(Purchase | “Positive Adjmt.” | Output), Quan…) |
| 5404 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
| 5407 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))) |
| 5410 | Qty. Rounding Precision Δ BC28 | Decimal | — | not editable |
| 5411 | Qty. Rounding Precision (Base) Δ BC28 | Decimal | — | not editable |
| 5413 | Quantity (Base) Δ BC28 | Decimal | — | |
| 5701 | Originally Ordered No. | Code[20] | — | TableRelation Table 27 “Item” |
| 5702 | Originally Ordered Var. Code | Code[10] | — | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Originally Ordered No.”))) |
| 5704 | Item Category Code | Code[20] | — | TableRelation Table 5722 “Item Category” (Item Category) |
| 5705 | Nonstock | Boolean | Catalog caption | |
| 5706 | Purchasing Code | Code[10] | — | TableRelation Table 5721 “Purchasing” |
| 5800 | Value Entry Type | Enum “Cost Entry Type” | — | enum Enum 104 “Cost Entry Type” |
| 5801 | Item Charge No. | Code[20] | — | TableRelation Table 5800 “Item Charge” (Item Charge) |
| 5817 | Correction | Boolean | — | |
| 6600 | Return Reason Code | Code[10] | — | TableRelation Table 6635 “Return Reason” (Return Reason) |
| 7000 | Price Calculation Method Δ BC28 | Enum “Price Calculation Method” | Specifies the method that will be used for price calculation in the journal line. | enum Enum 7000 “Price Calculation Method” |
| 99000755 | Overhead Rate Δ BC28 | Decimal | — |
Keys
- Key1: Journal Template Name, Standard Journal Code, Line No. (clustered)
Events published
OnAfterInitDefaultDimensionSources(var StandardItemJournalLine: Record "Standard Item Journal Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer)(integration)- subscribers: Codeunit 99000762 “Mfg. Item Journal Mgt.” StandardItemJournalLineOnAfterInitDefaultDimensionSources
OnAfterGetLineWithPrice(var LineWithPrice: Interface "Line With Price")(integration)OnAfterGetItem(var Item: Record Item; var StandardItemJournalLine: Record "Standard Item Journal Line")(integration)OnAfterGetSKU(StandardItemJournalLine: Record "Standard Item Journal Line"; var Result: Boolean)(integration)OnAfterShowDimensions(StandardItemJournalLine: Record "Standard Item Journal Line")(integration)OnAfterValidateShortcutDimCode(var StandardItemJournalLine: Record "Standard Item Journal Line"; var xStandardItemJournalLine: Record "Standard Item Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnAfterCreateDim(var StandardItemJournalLine: Record "Standard Item Journal Line"; CallingFieldNo: Integer; xStandardItemJournalLine: Record "Standard Item Journal Line"; OldDimSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnAfterRetriveCosts(var StandardItemJournalLine: Record "Standard Item Journal Line"; Item: Record Item; StockkeepingUnit: Record "Stockkeeping Unit"; var UnitCost: Decimal)(integration)OnBeforeValidateShortcutDimCode(var StandardItemJournalLine: Record "Standard Item Journal Line"; var xStandardItemJournalLine: Record "Standard Item Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnValidateItemNoOnAfterCopyItemValues(var StandardItemJournalLine: Record "Standard Item Journal Line"; Item: Record Item)(integration)OnBeforeApplyPrice(var StandardItemJournalLine: Record "Standard Item Journal Line")(integration)OnBeforeCreateDim(var StandardItemJournalLine: Record "Standard Item Journal Line"; CurrentFieldNo: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; var IsHandled: Boolean)(integration)
Procedures
GetPriceCalculationHandler(PriceType: Enum "Price Type"; var PriceCalculation: Interface "Price Calculation")GetLineWithPrice(var LineWithPrice: Interface "Line With Price")ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])ShowDimensions()CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])CreateDimFromDefaultDim(FieldNo: Integer)
Plus 11 local procedures.
Triggers
OnRename
Relations
- Salespers./Purch. Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Transaction Type: TableRelation Table 258 “Transaction Type”
- Transport Method: TableRelation Table 259 “Transport Method”
- Item No.: TableRelation Table 27 “Item”
- Originally Ordered No.: TableRelation Table 27 “Item”
- Entry/Exit Point: TableRelation Table 282 “Entry/Exit Point”
- Area: TableRelation Table 284 “Area”
- Transaction Specification: TableRelation Table 285 “Transaction Specification”
- Posting No. Series: TableRelation Table 308 “No. Series”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Originally Ordered Var. Code: TableRelation Table 5401 “Item Variant”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Purchasing Code: TableRelation Table 5721 “Purchasing”
- Item Category Code: TableRelation Table 5722 “Item Category”
- Item Charge No.: TableRelation Table 5800 “Item Charge”
- Return Reason Code: TableRelation Table 6635 “Return Reason”
- Bin Code: TableRelation Table 7354 “Bin” (conditional)
- Standard Journal Code: TableRelation Table 752 “Standard Item Journal”
- Journal Template Name: TableRelation Table 82 “Item Journal Template”
- Country/Region Code: TableRelation Table 9 “Country/Region”
- Inventory Posting Group: TableRelation Table 94 “Inventory Posting Group”
Pages and codeunits on this table
- Page 755 “Standard Item Journal Subform” (source table)
Extended by
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 408 “DimensionManagement” (7 calls:
CreateDim → GetRecDefaultDimID,InitDefaultDimensionSources → AddDimSource,LookupShortcutDimCode → LookupDimValueCode, …) - Codeunit 5402 “Unit of Measure Management” (1 call:
GetUnitAmount → GetQtyPerUnitOfMeasure) - Codeunit 7001 “Price Calculation Mgt.” (1 call:
GetPriceCalculationHandler → GetHandler)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Standard Item Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.