Table "Warehouse Journal Line"
ID 7311
Namespace: Microsoft.Warehouse.Journal
Properties
Fields
| Name |
Type |
Description |
| "Journal Template Name" |
Code[10]
|
Specifies the name of the journal template, the basis of the journal batch, that the entries were posted from.
|
| "Journal Batch Name" |
Code[10]
|
Specifies the name of the journal batch, a personalized journal layout, that the entries were posted from.
|
| "Line No." |
Integer
|
Specifies the number of the warehouse journal line.
|
| "Registering Date" |
Date
|
Specifies the date the line is registered.
|
| "Location Code" |
Code[10]
|
Specifies the code of the location to which the journal line applies.
|
| "From Zone Code" |
Code[10]
|
Specifies the code of the zone from which the item on the journal line is taken.
|
| "From Bin Code" |
Code[20]
|
Specifies the code of the bin from which the item on the journal line is taken.
|
| Description |
Text[100]
|
Specifies the description of the item.
|
| "Item No." |
Code[20]
|
Specifies the number of the item on the journal line.
|
| Quantity |
Decimal
|
Specifies the number of units of the item in the adjustment (positive or negative) or the reclassification.
|
| "Qty. (Base)" |
Decimal
|
|
| "Qty. (Absolute)" |
Decimal
|
|
| "Qty. (Absolute, Base)" |
Decimal
|
|
| "Zone Code" |
Code[10]
|
Specifies the zone code where the bin on this line is located.
|
| "Bin Code" |
Code[20]
|
Specifies the bin where the items are picked or put away.
|
| "Source Type" |
Integer
|
|
| "Source Subtype" |
Option
|
|
| "Source No." |
Code[20]
|
|
| "Source Line No." |
Integer
|
|
| "Source Subline No." |
Integer
|
|
| "Source Document" |
Enum Microsoft.Warehouse.Journal."Warehouse Journal Source Document"
|
|
| "Source Code" |
Code[10]
|
|
| "To Zone Code" |
Code[10]
|
Specifies the code of the zone to which the item on the journal line will be moved.
|
| "To Bin Code" |
Code[20]
|
Specifies the code of the bin to which the item on the journal line will be moved.
|
| "Reason Code" |
Code[10]
|
Specifies the reason code for the warehouse journal line.
|
| "Registering No. Series" |
Code[20]
|
|
| "From Bin Type Code" |
Code[10]
|
|
| Cubage |
Decimal
|
Specifies the total cubage of the items on the warehouse journal line.
|
| Weight |
Decimal
|
Specifies the weight of one item unit when measured in the specified unit of measure.
|
| "Whse. Document No." |
Code[20]
|
Specifies the warehouse document number of the journal line.
|
| "Whse. Document Type" |
Enum Microsoft.Warehouse.Journal."Warehouse Journal Document Type"
|
|
| "Whse. Document Line No." |
Integer
|
|
| "Qty. (Calculated)" |
Decimal
|
|
| "Qty. (Phys. Inventory)" |
Decimal
|
|
| "Entry Type" |
Option
|
Specifies the type of transaction that will be registered from the line.
|
| "Phys. Inventory" |
Boolean
|
|
| "Reference Document" |
Enum Microsoft.Warehouse.Setup."Whse. Reference Document Type"
|
|
| "Reference No." |
Code[20]
|
|
| "User ID" |
Code[50]
|
Specifies the ID of the user who posted the entry, to be used, for example, in the change log.
|
| "Qty. (Calculated) (Base)" |
Decimal
|
|
| "Qty. (Phys. Inventory) (Base)" |
Decimal
|
|
| "Variant Code" |
Code[10]
|
Specifies the variant of the item on the line.
|
| "Qty. per Unit of Measure" |
Decimal
|
Specifies the number of base units of measure in the unit of measure specified for the item on the journal line.
|
| "Unit of Measure Code" |
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.
|
| "Qty. Rounding Precision" |
Decimal
|
|
| "Qty. Rounding Precision (Base)" |
Decimal
|
|
| "Serial No." |
Code[50]
|
Specifies the same as for the field in the Item Journal window.
|
| "Lot No." |
Code[50]
|
Specifies the same as for the field in the Item Journal window.
|
| "Warranty Date" |
Date
|
Specifies the last day of warranty for the item on the line.
|
| "Expiration Date" |
Date
|
Specifies the last date that the item on the line can be used.
|
| "New Serial No." |
Code[50]
|
|
| "New Lot No." |
Code[50]
|
|
| "New Expiration Date" |
Date
|
|
| "Package No." |
Code[50]
|
Specifies the same as for the field in the Item Journal window.
|
| "New Package No." |
Code[50]
|
|
| "Phys Invt Counting Period Code" |
Code[10]
|
Specifies a code for the physical inventory counting period, if the counting period functionality was used when the line was created.
|
| "Phys Invt Counting Period Type" |
Option
|
Specifies whether the physical inventory counting period was assigned to a stockkeeping unit or an item.
|
| SystemId |
Guid
|
|
| SystemCreatedAt |
DateTime
|
|
| SystemCreatedBy |
Guid
|
|
| SystemModifiedAt |
DateTime
|
|
| SystemModifiedBy |
Guid
|
|
| SystemCreatedByUserName |
Text[50]
|
|
| SystemCreatedByFullName |
Text[80]
|
|
| SystemModifiedByUserName |
Text[50]
|
|
| SystemModifiedByFullName |
Text[80]
|
|
| SystemRowVersion |
BigInteger
|
|
Methods
GetItem
procedure GetItem(ItemNo: Code[20]; var ItemDescription: Text[100])
Parameters
| Name |
Type |
Description |
|
ItemNo
|
Code[20] |
|
|
ItemDescription
|
Text[100] |
|
SetUpNewLine
procedure SetUpNewLine(LastWhseJnlLine: Record "Warehouse Journal Line")
Parameters
SetUpAdjustmentBin
procedure SetUpAdjustmentBin()
CalcReservEntryQuantity
procedure CalcReservEntryQuantity(): Decimal
Returns
EmptyLine
procedure EmptyLine(): Boolean
Returns
GetBinType
procedure GetBinType(LocationCode: Code[10]; BinCode: Code[20]): Code[10]
Parameters
| Name |
Type |
Description |
|
LocationCode
|
Code[10] |
|
|
BinCode
|
Code[20] |
|
Returns
| Type |
Description |
|
Code[10] |
|
TemplateSelection
procedure TemplateSelection(PageID: Integer; PageTemplate: Enum "Warehouse Journal Template Type"; var WhseJnlLine: Record "Warehouse Journal Line"): Boolean
Parameters
Returns
TemplateSelectionFromBatch
procedure TemplateSelectionFromBatch(var WhseJnlBatch: Record "Warehouse Journal Batch")
Parameters
OpenJnl
procedure OpenJnl(var CurrentJnlBatchName: Code[10]; var CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
Parameters
CheckTemplateName
procedure CheckTemplateName(CurrentJnlTemplateName: Code[10]; var CurrentLocationCode: Code[10]; var CurrentJnlBatchName: Code[10])
Parameters
| Name |
Type |
Description |
|
CurrentJnlTemplateName
|
Code[10] |
|
|
CurrentLocationCode
|
Code[10] |
|
|
CurrentJnlBatchName
|
Code[10] |
|
CheckName
procedure CheckName(CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
Parameters
SetName
procedure SetName(CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
Parameters
LookupName
procedure LookupName(var CurrentJnlBatchName: Code[10]; var CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
Parameters
OpenItemTrackingLines
procedure OpenItemTrackingLines()
ItemTrackingReclass
procedure ItemTrackingReclass(TemplateName: Code[10]; BatchName: Code[10]; LocationCode: Code[10]; LineNo: Integer): Boolean
Parameters
| Name |
Type |
Description |
|
TemplateName
|
Code[10] |
|
|
BatchName
|
Code[10] |
|
|
LocationCode
|
Code[10] |
|
|
LineNo
|
Integer |
|
Returns
LookupItemTracking
procedure LookupItemTracking(var WhseItemTrackingSetup: Record "Item Tracking Setup")
Parameters
IsReclass
procedure IsReclass(CurrentJnlTemplateName: Code[10]): Boolean
Parameters
| Name |
Type |
Description |
|
CurrentJnlTemplateName
|
Code[10] |
|
Returns
SetProposal
procedure SetProposal(NewValue: Boolean)
Parameters
| Name |
Type |
Description |
|
NewValue
|
Boolean |
|
IsOpenedFromBatch
procedure IsOpenedFromBatch(): Boolean
Returns
CheckTrackingIfRequired
procedure CheckTrackingIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
Parameters
CopyTrackingFromItemLedgEntry
procedure CopyTrackingFromItemLedgEntry(ItemLedgEntry: Record "Item Ledger Entry")
Parameters
CopyTrackingFromItemTrackingSetupIfRequired
procedure CopyTrackingFromItemTrackingSetupIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
Parameters
CopyNewTrackingFromItemTrackingSetupIfRequired
procedure CopyNewTrackingFromItemTrackingSetupIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
Parameters
CopyTrackingFromWhseActivityLine
procedure CopyTrackingFromWhseActivityLine(WhseActivityLine: Record "Warehouse Activity Line")
Parameters
CopyTrackingFromWhseEntry
procedure CopyTrackingFromWhseEntry(WhseEntry: Record "Warehouse Entry")
Parameters
IsQtyPhysInventoryBaseEditable
procedure IsQtyPhysInventoryBaseEditable(): Boolean
Returns
SetSource
procedure SetSource(SourceType: Integer; SourceSubtype: Integer; SourceNo: Code[20]; SourceLineNo: Integer; SourceSublineNo: Integer)
Parameters
| Name |
Type |
Description |
|
SourceType
|
Integer |
|
|
SourceSubtype
|
Integer |
|
|
SourceNo
|
Code[20] |
|
|
SourceLineNo
|
Integer |
|
|
SourceSublineNo
|
Integer |
|
SetTrackingFilterFromBinContent
procedure SetTrackingFilterFromBinContent(var BinContent: Record "Bin Content")
Parameters
SetWhseDocument
procedure SetWhseDocument(DocType: Enum "Warehouse Journal Document Type"; DocNo: Code[20]; DocLineNo: Integer)
Parameters
InitExpirationDate
procedure InitExpirationDate()
CheckExpirationDateExists
procedure CheckExpirationDateExists(): Boolean
Returns
Events
OnAfterCheckTrackingIfRequired
[IntegrationEvent(False,False)]
local procedure OnAfterCheckTrackingIfRequired(var WhseJnlLine: Record "Warehouse Journal Line"; WhseItemTrackingSetup: Record "Item Tracking Setup")
Parameters
OnAfterCopyTrackingFromItemLedgEntry
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromItemLedgEntry(var WhseJnlLine: Record "Warehouse Journal Line"; ItemLedgEntry: Record "Item Ledger Entry")
Parameters
OnAfterCopyTrackingFromItemTrackingSetupIfRequired
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromItemTrackingSetupIfRequired(var WhseJnlLine: Record "Warehouse Journal Line"; WhseItemTrackingSetup: Record "Item Tracking Setup")
Parameters
OnAfterCopyNewTrackingFromItemTrackingSetupIfRequired
[IntegrationEvent(False,False)]
local procedure OnAfterCopyNewTrackingFromItemTrackingSetupIfRequired(var WhseJnlLine: Record "Warehouse Journal Line"; WhseItemTrackingSetup: Record "Item Tracking Setup")
Parameters
OnAfterCopyTrackingFromWhseActivityLine
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromWhseActivityLine(var WarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseActivityLine: Record "Warehouse Activity Line")
Parameters
OnAfterCopyTrackingFromWhseEntry
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromWhseEntry(var WarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseEntry: Record "Warehouse Entry")
Parameters
OnAfterOpenItemTrackingLines
[IntegrationEvent(False,False)]
local procedure OnAfterOpenItemTrackingLines(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WhseItemTrackingLines: Page "Whse. Item Tracking Lines")
Parameters
OnAfterOpenJnl
[IntegrationEvent(False,False)]
local procedure OnAfterOpenJnl(var WarehouseJournalLine: Record "Warehouse Journal Line"; CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10])
Parameters
OnAfterSetupNewLine
[IntegrationEvent(False,False)]
local procedure OnAfterSetupNewLine(var WarehouseJournalLine: Record "Warehouse Journal Line"; var LastWhseJnlLine: Record "Warehouse Journal Line"; WarehouseJournalTemplate: Record "Warehouse Journal Template")
Parameters
OnAfterSetName
[IntegrationEvent(False,False)]
local procedure OnAfterSetName(var RecWarehouseJournalLine: Record "Warehouse Journal Line"; var WarehouseJournalLine: Record "Warehouse Journal Line")
Parameters
OnAfterSetTrackingFilterFromBinContent
[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromBinContent(var WarehouseJournalLine: Record "Warehouse Journal Line"; var BinContent: Record "Bin Content")
Parameters
OnBeforeCheckBin
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckBin(var WarehouseJournalLine: Record "Warehouse Journal Line"; LocationCode: Code[10]; BinCode: Code[20]; Inbound: Boolean; var IsHandled: Boolean; CurrentFieldNo: Integer)
Parameters
OnBeforeCheckIncreaseBin
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckIncreaseBin(WarehouseJournalLine: Record "Warehouse Journal Line"; BinCode: Code[20]; StockProposal: Boolean; var IsHandled: Boolean)
Parameters
OnBeforeCheckName
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckName(var JnlBatchName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean)
Parameters
| Name |
Type |
Description |
|
JnlBatchName
|
Code[10] |
|
|
LocationCode
|
Code[10] |
|
|
IsHandled
|
Boolean |
|
OnBeforeCheckQtyPhysInventory
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckQtyPhysInventory(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean)
Parameters
OnBeforeCheckSerialNoTrackedQuantity
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckSerialNoTrackedQuantity(var WarehouseJournalLine: Record "Warehouse Journal Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)
Parameters
OnBeforeCheckTemplateName
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckTemplateName(var JnlTemplateName: Code[10]; var JnlBatchName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean)
Parameters
| Name |
Type |
Description |
|
JnlTemplateName
|
Code[10] |
|
|
JnlBatchName
|
Code[10] |
|
|
LocationCode
|
Code[10] |
|
|
IsHandled
|
Boolean |
|
OnBeforeGetLocation
[IntegrationEvent(False,False)]
local procedure OnBeforeGetLocation(var Location: Record Location; LocationCode: Code[10]; var IsHandled: Boolean)
Parameters
OnBeforeGetWhseJnlBatch
[IntegrationEvent(False,False)]
local procedure OnBeforeGetWhseJnlBatch(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WhseJnlBatch: Record "Warehouse Journal Batch"; var IsHandled: Boolean)
Parameters
OnBeforeLookupBinCode
[IntegrationEvent(False,False)]
local procedure OnBeforeLookupBinCode(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean)
Parameters
OnBeforeLookupFromBinCode
[IntegrationEvent(False,False)]
local procedure OnBeforeLookupFromBinCode(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean)
Parameters
OnBeforeOpenItemTrackingLines
[IntegrationEvent(False,False)]
local procedure OnBeforeOpenItemTrackingLines(var WarehouseJournalLine: Record "Warehouse Journal Line")
Parameters
OnBeforeOpenJnl
[IntegrationEvent(False,False)]
local procedure OnBeforeOpenJnl(var WarehouseJournalLine: Record "Warehouse Journal Line"; var CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10])
Parameters
OnBeforeSetItemFields
[IntegrationEvent(False,False)]
local procedure OnBeforeSetItemFields(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean; xWarehouseJournalLine: Record "Warehouse Journal Line"; Item: Record Item)
Parameters
OnBeforeTemplateSelectionFromBatch
[IntegrationEvent(False,False)]
local procedure OnBeforeTemplateSelectionFromBatch(var WarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseJournalBatch: Record "Warehouse Journal Batch")
Parameters
OnBeforeValidateQtyBase
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateQtyBase(var WarehouseJournalLine: Record "Warehouse Journal Line"; xWarehouseJournalLine: Record "Warehouse Journal Line"; CallingFieldNo: Integer; var IsHandled: Boolean)
Parameters
OnCheckBinOnBeforeCheckOutboundBin
[IntegrationEvent(False,False)]
local procedure OnCheckBinOnBeforeCheckOutboundBin(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean)
Parameters
OnLookupNameOnBeforeSetName
[IntegrationEvent(False,False)]
local procedure OnLookupNameOnBeforeSetName(var WarehouseJournalLine: Record "Warehouse Journal Line"; WhseJnlBatch: Record "Warehouse Journal Batch")
Parameters
OnOpenItemTrackingLinesOnBeforeSetSource
[IntegrationEvent(False,False)]
local procedure OnOpenItemTrackingLinesOnBeforeSetSource(var WhseWorksheetLine: Record "Whse. Worksheet Line"; WarehouseJournalLine: Record "Warehouse Journal Line")
Parameters
OnSetUpNewLineOnAfterWhseJnlLineSetFilters
[IntegrationEvent(False,False)]
local procedure OnSetUpNewLineOnAfterWhseJnlLineSetFilters(var RecWarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseJournalLine: Record "Warehouse Journal Line"; LastWarehouseJournalLine: Record "Warehouse Journal Line")
Parameters
OnTemplateSelectionOnAfterSetFilters
[IntegrationEvent(False,False)]
local procedure OnTemplateSelectionOnAfterSetFilters(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WhseJnlTemplate: Record "Warehouse Journal Template"; OpenFromBatch: Boolean)
Parameters
OnValidateQuantityOnAfterCalcBaseQty
[IntegrationEvent(False,False)]
local procedure OnValidateQuantityOnAfterCalcBaseQty(var WarehouseJournalLine: Record "Warehouse Journal Line"; xWarehouseJournalLine: Record "Warehouse Journal Line")
Parameters
OnValidateUnitOfMeasureCodeOnBeforeValidateQuantity
[IntegrationEvent(False,False)]
local procedure OnValidateUnitOfMeasureCodeOnBeforeValidateQuantity(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean)
Parameters
OnValidateToBinCodeOnBeforeSetToZoneCode
[IntegrationEvent(False,False)]
local procedure OnValidateToBinCodeOnBeforeSetToZoneCode(var WarehouseJournalLine: Record "Warehouse Journal Line"; var Bin: Record Bin)
Parameters
OnAfterIsFieldEditable
[IntegrationEvent(False,False)]
local procedure OnAfterIsFieldEditable(var WarehouseJournalLine: Record "Warehouse Journal Line"; FieldId: Integer; var IsEditable: Boolean)
Parameters
OnAfterValidateQtyPhysInventoryBase
[IntegrationEvent(False,False)]
local procedure OnAfterValidateQtyPhysInventoryBase(var WarehouseJournalLine: Record "Warehouse Journal Line"; PhysInvtEntered: Boolean)
Parameters
OnBeforeCalcBaseQty
[IntegrationEvent(False,False)]
local procedure OnBeforeCalcBaseQty(var WarehouseJournalLine: Record "Warehouse Journal Line"; var Qty: Decimal; FromFieldName: Text; ToFieldName: Text)
Parameters
OnValidateQuantityOnBeforeGetWhseJnlTemplate
[IntegrationEvent(False,False)]
local procedure OnValidateQuantityOnBeforeGetWhseJnlTemplate(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean)
Parameters
OnBeforeGetBinType
[IntegrationEvent(False,False)]
local procedure OnBeforeGetBinType(LocationCode: Code[10]; BinCode: Code[20]; var BinTypeCode: Code[10]; var IsHandled: Boolean)
Parameters
| Name |
Type |
Description |
|
LocationCode
|
Code[10] |
|
|
BinCode
|
Code[20] |
|
|
BinTypeCode
|
Code[10] |
|
|
IsHandled
|
Boolean |
|
See also