Table 210 Job Journal Line in 17
- App
- Base Application
Fields, 84Keys, 3Procedures, 30Events, 43
Versions171819202122232425262728latest
Source29
Fields, 84
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Journal Template Name | Code[10] | - |
| 2 | Line No. | Integer | - |
| 3 | Job No. | Code[20] | - |
| 4 | Posting Date | Date | - |
| 5 | Document No. | Code[20] | - |
| 6 | Type | Enum Job Journal Line Type | - |
| 8 | No. | Code[20] | - |
| 9 | Description | Text[100] | - |
| 10 | Quantity | Decimal | - |
| 12 | Direct Unit Cost (LCY) | Decimal | - |
| 13 | Unit Cost (LCY) | Decimal | - |
| 14 | Total Cost (LCY) | Decimal | - |
| 15 | Unit Price (LCY) | Decimal | - |
| 16 | Total Price (LCY) | Decimal | - |
| 17 | Resource Group No. | Code[20] | - |
| 18 | Unit of Measure Code | Code[10] | - |
| 21 | Location Code | Code[10] | - |
| 22 | Chargeable | Boolean | - |
| 30 | Posting Group | Code[20] | - |
| 31 | Shortcut Dimension 1 Code | Code[20] | - |
| 32 | Shortcut Dimension 2 Code | Code[20] | - |
| 33 | Work Type Code | Code[10] | - |
| 34 | Customer Price Group | Code[10] | - |
| 37 | Applies-to Entry | Integer | - |
| 40 | Shpt. Method Code | Code[10] | - |
| 61 | Entry Type | Enum Job Journal Line Entry Type | - |
| 62 | Source Code | Code[10] | - |
| 73 | Journal Batch Name | Code[10] | - |
| 74 | Reason Code | Code[10] | - |
| 75 | Recurring Method | Option | - |
| 76 | Expiration Date | Date | - |
| 77 | Recurring Frequency | DateFormula | - |
| 79 | Gen. Bus. Posting Group | Code[20] | - |
| 80 | Gen. Prod. Posting Group | Code[20] | - |
| 81 | Transaction Type | Code[10] | - |
| 82 | Transport Method | Code[10] | - |
| 83 | Country/Region Code | Code[10] | - |
| 86 | Entry/Exit Point | Code[10] | - |
| 87 | Document Date | Date | - |
| 88 | External Document No. | Code[35] | - |
| 89 | Area | Code[10] | - |
| 90 | Transaction Specification | Code[10] | - |
| 91 | Serial No. | Code[50] | - |
| 92 | Posting No. Series | Code[20] | - |
| 93 | Source Currency Code | Code[10] | - |
| 94 | Source Currency Total Cost | Decimal | - |
| 95 | Source Currency Total Price | Decimal | - |
| 96 | Source Currency Line Amount | Decimal | - |
| 480 | Dimension Set ID | Integer | - |
| 950 | Time Sheet No. | Code[20] | - |
| 951 | Time Sheet Line No. | Integer | - |
| 952 | Time Sheet Date | Date | - |
| 1000 | Job Task No. | Code[20] | - |
| 1001 | Total Cost | Decimal | - |
| 1002 | Unit Price | Decimal | - |
| 1003 | Line Type | Option | - |
| 1004 | Applies-from Entry | Integer | - |
| 1005 | Job Posting Only | Boolean | - |
| 1006 | Line Discount % | Decimal | - |
| 1007 | Line Discount Amount | Decimal | - |
| 1008 | Currency Code | Code[10] | - |
| 1009 | Line Amount | Decimal | - |
| 1010 | Currency Factor | Decimal | - |
| 1011 | Unit Cost | Decimal | - |
| 1012 | Line Amount (LCY) | Decimal | - |
| 1013 | Line Discount Amount (LCY) | Decimal | - |
| 1014 | Total Price | Decimal | - |
| 1015 | Cost Factor | Decimal | - |
| 1016 | Description 2 | Text[50] | - |
| 1017 | Ledger Entry Type | Enum Job Ledger Entry Type | - |
| 1018 | Ledger Entry No. | Integer | - |
| 1019 | Job Planning Line No. | Integer | - |
| 1030 | Remaining Qty. | Decimal | - |
| 1031 | Remaining Qty. (Base) | Decimal | - |
| 5402 | Variant Code | Code[10] | - |
| 5403 | Bin Code | Code[20] | - |
| 5404 | Qty. per Unit of Measure | Decimal | - |
| 5410 | Quantity (Base) | Decimal | - |
| 5468 | Reserved Qty. (Base) | Decimal | - |
| 5900 | Service Order No. | Code[20] | - |
| 5901 | Posted Service Shipment No. | Code[20] | - |
| 6501 | Lot No. | Code[50] | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | - |
| 7001 | Cost Calculation Method | Enum Price Calculation Method | - |
Keys, 3
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Journal Template Name, Journal Batch Name, Line No. | - |
| Key2 | Journal Template Name, Journal Batch Name, Type, No., Unit of Measure Code, Work Type Code | - |
| Key3 | Type, No., Variant Code | - |
Procedures, 30
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| EmptyLine | () | Boolean | public | - | |||
| SetUpNewLine | (Record Job Journal Line) | public | - | ||||
| CreateDim | (Integer, Code[20], Integer, Code[20], Integer, Code[20]) | public | - | ||||
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| LookupShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| ShowShortcutDimCode | (var Code[20]) | public | - | ||||
| IsInbound | () | Boolean | public | - | |||
| OpenItemTrackingLines | (Boolean) | public | - | ||||
| InitRoundingPrecisions | () | public | - | ||||
| DontCheckStdCost | () | public | - | ||||
| DeleteAmounts | () | public | - | ||||
| SetCurrencyFactor | (Decimal) | public | - | ||||
| GetItemTranslation | () | public | - | ||||
| SetReservationEntry | (var Record Reservation Entry) | public | - | ||||
| SetReservationFilters | (var Record Reservation Entry) | public | - | ||||
| ReservEntryExist | () | Boolean | public | - | |||
| UpdateAllAmounts | () | public | - | ||||
| UpdateUnitCost | () | public | - | ||||
| UpdateTotalCost | () | public | - | ||||
| AfterResourceFindCost | (var Record Resource Cost) | public | Pending 17.0 | ||||
| Replaced by the new implementation (V16) of price calculation. | |||||||
| ApplyPrice | (Enum Price Type, Integer) | public | - | ||||
| GetLineWithPrice | (var Interface Line With Price) | public | - | ||||
| ShowDimensions | () | public | - | ||||
| UpdateDimensions | () | public | - | ||||
| IsOpenedFromBatch | () | Boolean | public | - | |||
| IsNonInventoriableItem | () | Boolean | public | - | |||
| IsInventoriableItem | () | Boolean | public | - | |||
| RowID1 | () | Text[250] | public | - | |||
| CopyTrackingFromItemLedgEntry | (Record Item Ledger Entry) | public | - | ||||
| CopyTrackingFromJobPlanningLine | (Record Job Planning Line) | public | - | ||||
Events, 43
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnAfterAssignGLAccountValues | (var Record Job Journal Line, Record G/L Account) | - | ||||
| Integration event | OnAfterAssignItemValues | (var Record Job Journal Line, Record Item) | - | ||||
| Integration event | OnAfterAssignResourceValues | (var Record Job Journal Line, Record Resource, Integer) | - | ||||
| Integration event | OnAfterAssignItemUoM | (var Record Job Journal Line, Record Item) | - | ||||
| Integration event | OnAfterAssignResourceUoM | (var Record Job Journal Line, Record Resource) | - | ||||
| Integration event | OnAfterAssignGLAccountUoM | (var Record Job Journal Line) | - | ||||
| Integration event | OnAfterCopyTrackingFromItemLedgEntry | (var Record Job Journal Line, Record Item Ledger Entry) | - | ||||
| Integration event | OnAfterCopyTrackingFromJobPlanningLine | (var Record Job Journal Line, Record Job Planning Line) | - | ||||
| Integration event | OnAfterDeleteAmounts | (var Record Job Journal Line) | - | ||||
| Integration event | OnAfterGetLineWithPrice | (var Interface Line With Price) | - | ||||
| Integration event | OnAfterGetSKU | (Record Job Journal Line, var Boolean) | - | ||||
| Integration event | OnAfterResourceFindCost | (var Record Job Journal Line, var Record Resource Cost) | Pending 17.0 | ||||
| Replaced by the new implementation (V16) of price calculation. | |||||||
| Integration event | OnAfterSetUpNewLine | (var Record Job Journal Line, Record Job Journal Line, Record Job Journal Template, Record Job Journal Batch) | - | ||||
| Integration event | OnAfterUpdateDimensions | (var Record Job Journal Line, var Integer) | - | ||||
| Integration event | OnAfterUpdateTotalCost | (var Record Job Journal Line) | - | ||||
| Integration event | OnAfterUpdateTotalPrice | (var Record Job Journal Line) | - | ||||
| Integration event | OnAfterUpdateAmountsAndDiscounts | (var Record Job Journal Line) | - | ||||
| Integration event | OnAfterUpdateUnitPrice | (var Record Job Journal Line) | - | ||||
| Integration event | OnAfterCreateDimTableIDs | (var Record Job Journal Line, var Integer, var Integer, var Code[20]) | - | ||||
| Integration event | OnAfterUpdateUnitCost | (var Record Job Journal Line, Decimal, Integer) | - | ||||
| Integration event | OnBeforeCheckItemAvailable | (var Record Job Journal Line, var Record Item Journal Line) | - | ||||
| Integration event | OnBeforeCheckPostingDateNotEmpty | (var Record Job Journal Line, var Boolean) | - | ||||
| Integration event | OnBeforeFindPriceAndDiscount | (var Record Job Journal Line, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeEmptyLine | (var Record Job Journal Line, var Boolean) | - | ||||
| Integration event | OnBeforeRetrieveCostPrice | (Record Job Journal Line, Record Job Journal Line, var Boolean) | - | ||||
| Integration event | OnBeforeSetUpNewLine | (var Record Job Journal Line, var Record Job Journal Line, Record Job Journal Line, var Boolean) | - | ||||
| Integration event | OnBeforeValidateWorkTypeCodeQty | (var Record Job Journal Line, Record Job Journal Line, Record Resource, Record Work Type) | - | ||||
| Integration event | OnBeforeUpdateAllAmounts | (var Record Job Journal Line, Record Job Journal Line, Integer) | - | ||||
| Integration event | OnAfterSetReservationFilters | (var Record Reservation Entry, Record Job Journal Line) | - | ||||
| Integration event | OnAfterUpdateAllAmounts | (var Record Job Journal Line, Record Job Journal Line) | - | ||||
| Integration event | OnAfterValidateShortcutDimCode | (var Record Job Journal Line, var Record Job Journal Line, Integer, var Code[20]) | - | ||||
| Integration event | OnBeforeCheckResource | (var Record Job Journal Line, Record Resource, var Boolean) | - | ||||
| Integration event | OnBeforeCreateDim | (var Record Job Journal Line, var Boolean, Integer) | - | ||||
| Integration event | OnBeforeTestUnitOfMeasureCode | (var Record Job Journal Line, Record Work Type, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateAmountsAndDiscounts | (var Record Job Journal Line, Record Job Journal Line, var Boolean) | - | ||||
| Integration event | OnBeforeValidateChargeable | (var Record Job Journal Line, var Boolean, Record Job Journal Line) | - | ||||
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Job Journal Line, var Record Job Journal Line, Integer, var Code[20]) | - | ||||
| Integration event | OnBeforeValidateWorkTypeCode | (var Record Job Journal Line, var Record Job Journal Line, var Boolean, var Boolean) | - | ||||
| Integration event | OnSelectItemEntryOnAfterSetItemLedgerEntryFilters | (var Record Item Ledger Entry, Integer, var Record Job Journal Line) | - | ||||
| Integration event | OnValidateJobNoOnBeforeCheckJob | (var Record Job Journal Line, Record Job Journal Line, var Record Customer, var Boolean) | - | ||||
| Integration event | OnBeforeValidateJobTaskNo | (var Record Job Journal Line, var Record Job Journal Line, var Boolean) | - | ||||
| Integration event | OnValidateLocationCodeOnBeforeGetLocation | (var Record Job Journal Line) | - | ||||
| Integration event | OnValidateVariantCodeOnBeforeValidateQuantity | (var Record Job Journal Line, Record Job Journal Line, var Boolean) | - | ||||