Table 7311 Warehouse Journal Line in 20
- App
- Base Application
Fields, 57Keys, 7Procedures, 31Events, 36
Versions171819202122232425262728latest
Source29
Fields, 57
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Journal Template Name | Code[10] | - |
| 2 | Journal Batch Name | Code[10] | - |
| 3 | Line No. | Integer | - |
| 4 | Registering Date | Date | - |
| 5 | Location Code | Code[10] | - |
| 6 | From Zone Code | Code[10] | - |
| 7 | From Bin Code | Code[20] | - |
| 8 | Description | Text[100] | - |
| 9 | Item No. | Code[20] | - |
| 10 | Quantity | Decimal | - |
| 11 | Qty. (Base) | Decimal | - |
| 12 | Qty. (Absolute) | Decimal | - |
| 13 | Qty. (Absolute, Base) | Decimal | - |
| 14 | Zone Code | Code[10] | - |
| 15 | Bin Code | Code[20] | - |
| 20 | Source Type | Integer | - |
| 21 | Source Subtype | Option | - |
| 22 | Source No. | Code[20] | - |
| 23 | Source Line No. | Integer | - |
| 24 | Source Subline No. | Integer | - |
| 25 | Source Document | Enum Warehouse Journal Source Document | - |
| 26 | Source Code | Code[10] | - |
| 27 | To Zone Code | Code[10] | - |
| 28 | To Bin Code | Code[20] | - |
| 29 | Reason Code | Code[10] | - |
| 33 | Registering No. Series | Code[20] | - |
| 35 | From Bin Type Code | Code[10] | - |
| 40 | Cubage | Decimal | - |
| 41 | Weight | Decimal | - |
| 50 | Whse. Document No. | Code[20] | - |
| 51 | Whse. Document Type | Enum Warehouse Journal Document Type | - |
| 52 | Whse. Document Line No. | Integer | - |
| 53 | Qty. (Calculated) | Decimal | - |
| 54 | Qty. (Phys. Inventory) | Decimal | - |
| 55 | Entry Type | Option | - |
| 56 | Phys. Inventory | Boolean | - |
| 60 | Reference Document | Option | - |
| 61 | Reference No. | Code[20] | - |
| 67 | User ID | Code[50] | - |
| 68 | Qty. (Calculated) (Base) | Decimal | - |
| 69 | Qty. (Phys. Inventory) (Base) | Decimal | - |
| 5402 | Variant Code | Code[10] | - |
| 5404 | Qty. per Unit of Measure | Decimal | - |
| 5407 | Unit of Measure Code | Code[10] | - |
| 5408 | Qty. Rounding Precision | Decimal | - |
| 5409 | Qty. Rounding Precision (Base) | Decimal | - |
| 6500 | Serial No. | Code[50] | - |
| 6501 | Lot No. | Code[50] | - |
| 6502 | Warranty Date | Date | - |
| 6503 | Expiration Date | Date | - |
| 6504 | New Serial No. | Code[50] | - |
| 6505 | New Lot No. | Code[50] | - |
| 6506 | New Expiration Date | Date | - |
| 6515 | Package No. | Code[50] | - |
| 6516 | New Package No. | Code[50] | - |
| 7380 | Phys Invt Counting Period Code | Code[10] | - |
| 7381 | Phys Invt Counting Period Type | Option | - |
Keys, 7
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Journal Template Name, Journal Batch Name, Location Code, Line No. | - |
| Key2 | Item No., Location Code, Entry Type, From Bin Type Code, Variant Code, Unit of Measure Code | - |
| Key3 | Item No., From Bin Code, Location Code, Entry Type, Variant Code, Unit of Measure Code, Lot No., Serial No., Package No. | - |
| Key4 | Item No., To Bin Code, Location Code, Variant Code, Unit of Measure Code, Lot No., Serial No., Package No. | - |
| Key5 | To Bin Code, Location Code | - |
| Key6 | Location Code, Item No., Variant Code | - |
| Key7 | Location Code, Bin Code, Item No., Variant Code | - |
Procedures, 31
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| GetItem | (Code[20], var Text[100]) | public | - | ||||
| SetUpNewLine | (Record Warehouse Journal Line) | public | - | ||||
| SetUpAdjustmentBin | () | public | - | ||||
| EmptyLine | () | Boolean | public | - | |||
| GetBinType | (Code[10], Code[20]) | Code[10] | public | - | |||
| TemplateSelection | (Integer, Option, var Record Warehouse Journal Line, var Boolean) | public | Pending 19.0 | ||||
| Replaced by TemplateSelection() with return value JnlSelected. | |||||||
| TemplateSelectionFromBatch | (var Record Warehouse Journal Batch) | public | - | ||||
| OpenJnl | (var Code[10], var Code[10], var Record Warehouse Journal Line) | public | - | ||||
| CheckTemplateName | (Code[10], var Code[10], var Code[10]) | public | - | ||||
| CheckName | (Code[10], Code[10], var Record Warehouse Journal Line) | public | - | ||||
| SetName | (Code[10], Code[10], var Record Warehouse Journal Line) | public | - | ||||
| LookupName | (var Code[10], var Code[10], var Record Warehouse Journal Line) | public | - | ||||
| OpenItemTrackingLines | () | public | - | ||||
| ItemTrackingReclass | (Code[10], Code[10], Code[10], Integer) | Boolean | public | - | |||
| LookupItemTracking | (var Record Item Tracking Setup) | public | - | ||||
| IsReclass | (Code[10]) | Boolean | public | - | |||
| SetProposal | (Boolean) | public | - | ||||
| IsOpenedFromBatch | () | Boolean | public | - | |||
| CheckTrackingIfRequired | (Record Item Tracking Setup) | public | - | ||||
| CopyTrackingFromItemLedgEntry | (Record Item Ledger Entry) | public | - | ||||
| CopyTrackingFromItemTrackingSetupIfRequired | (Record Item Tracking Setup) | public | - | ||||
| CopyTrackingFromWhseActivityLine | (Record Warehouse Activity Line) | public | - | ||||
| CopyTrackingFromWhseEntry | (Record Warehouse Entry) | public | - | ||||
| SetSource | (Integer, Integer, Code[20], Integer, Integer) | public | - | ||||
| SetTrackingFilterFromBinContent | (var Record Bin Content) | public | - | ||||
| SetWhseDoc | (Option, Code[20], Integer) | public | Pending 19.0 | ||||
| Replaced by SetWhseDocument(). | |||||||
| CalcReservEntryQuantity | () | Decimal | public | - | |||
| CopyNewTrackingFromItemTrackingSetupIfRequired | (Record Item Tracking Setup) | public | - | ||||
| TemplateSelection | (Integer, Enum Warehouse Journal Template Type, var Record Warehouse Journal Line) | Boolean | public | - | |||
| SetWhseDocument | (Enum Warehouse Journal Document Type, Code[20], Integer) | public | - | ||||
| IsQtyPhysInventoryBaseEditable | () | Boolean | public | - | |||
Events, 36
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCheckTrackingIfRequired | (var Record Warehouse Journal Line, Record Item Tracking Setup) | - |
| Integration event | OnAfterCopyTrackingFromItemLedgEntry | (var Record Warehouse Journal Line, Record Item Ledger Entry) | - |
| Integration event | OnAfterCopyTrackingFromItemTrackingSetupIfRequired | (var Record Warehouse Journal Line, Record Item Tracking Setup) | - |
| Integration event | OnAfterCopyTrackingFromWhseActivityLine | (var Record Warehouse Journal Line, Record Warehouse Activity Line) | - |
| Integration event | OnAfterCopyTrackingFromWhseEntry | (var Record Warehouse Journal Line, Record Warehouse Entry) | - |
| Integration event | OnAfterOpenItemTrackingLines | (var Record Warehouse Journal Line, var Page Whse. Item Tracking Lines) | - |
| Integration event | OnAfterOpenJnl | (var Record Warehouse Journal Line, Code[10], Code[10]) | - |
| Integration event | OnAfterSetupNewLine | (var Record Warehouse Journal Line, var Record Warehouse Journal Line, Record Warehouse Journal Template) | - |
| Integration event | OnAfterSetName | (var Record Warehouse Journal Line, var Record Warehouse Journal Line) | - |
| Integration event | OnAfterSetTrackingFilterFromBinContent | (var Record Warehouse Journal Line, var Record Bin Content) | - |
| Integration event | OnBeforeCheckBin | (var Record Warehouse Journal Line, Code[10], Code[20], Boolean, var Boolean, Integer) | - |
| Integration event | OnBeforeCheckIncreaseBin | (Record Warehouse Journal Line, Code[20], Boolean, var Boolean) | - |
| Integration event | OnBeforeCheckName | (var Code[10], var Code[10], var Boolean) | - |
| Integration event | OnBeforeCheckQtyPhysInventory | (var Record Warehouse Journal Line, var Boolean) | - |
| Integration event | OnBeforeCheckTemplateName | (var Code[10], var Code[10], var Code[10], var Boolean) | - |
| Integration event | OnBeforeGetLocation | (var Record Location, Code[10], var Boolean) | - |
| Integration event | OnBeforeGetWhseJnlBatch | (var Record Warehouse Journal Line, var Record Warehouse Journal Batch, var Boolean) | - |
| Integration event | OnBeforeLookupBinCode | (var Record Warehouse Journal Line, var Boolean) | - |
| Integration event | OnBeforeOpenItemTrackingLines | (var Record Warehouse Journal Line) | - |
| Integration event | OnBeforeOpenJnl | (var Record Warehouse Journal Line, var Code[10], Code[10]) | - |
| Integration event | OnBeforeTemplateSelectionFromBatch | (var Record Warehouse Journal Line, Record Warehouse Journal Batch) | - |
| Integration event | OnCheckBinOnBeforeCheckOutboundBin | (var Record Warehouse Journal Line, var Boolean) | - |
| Integration event | OnLookupNameOnBeforeSetName | (var Record Warehouse Journal Line, Record Warehouse Journal Batch) | - |
| Integration event | OnOpenItemTrackingLinesOnBeforeSetSource | (var Record Whse. Worksheet Line, Record Warehouse Journal Line) | - |
| Integration event | OnSetUpNewLineOnAfterWhseJnlLineSetFilters | (var Record Warehouse Journal Line, Record Warehouse Journal Line, Record Warehouse Journal Line) | - |
| Integration event | OnTemplateSelectionOnAfterSetFilters | (var Record Warehouse Journal Line, var Record Warehouse Journal Template, Boolean) | - |
| Integration event | OnValidateUnitOfMeasureCodeOnBeforeValidateQuantity | (var Record Warehouse Journal Line, var Boolean) | - |
| Integration event | OnAfterCopyNewTrackingFromItemTrackingSetupIfRequired | (var Record Warehouse Journal Line, Record Item Tracking Setup) | - |
| Integration event | OnBeforeCheckSerialNoTrackedQuantity | (var Record Warehouse Journal Line, Integer, var Boolean) | - |
| Integration event | OnBeforeLookupFromBinCode | (var Record Warehouse Journal Line, var Boolean) | - |
| Integration event | OnBeforeSetItemFields | (var Record Warehouse Journal Line, var Boolean, Record Warehouse Journal Line, Record Item) | - |
| Integration event | OnValidateToBinCodeOnBeforeSetToZoneCode | (var Record Warehouse Journal Line, var Record Bin) | - |
| Integration event | OnBeforeValidateQtyBase | (var Record Warehouse Journal Line, Record Warehouse Journal Line, Integer, var Boolean) | - |
| Integration event | OnValidateQuantityOnAfterCalcBaseQty | (var Record Warehouse Journal Line, Record Warehouse Journal Line) | - |
| Integration event | OnAfterIsFieldEditable | (var Record Warehouse Journal Line, Integer, var Boolean) | - |
| Integration event | OnAfterValidateQtyPhysInventoryBase | (var Record Warehouse Journal Line, Boolean) | - |