Table 1003 Job Planning Line in 21
- App
- Base Application
Fields, 97Keys, 14Procedures, 49Events, 57
Versions171819202122232425262728latest
Source29
Fields, 97
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Line No. | Integer | - |
| 2 | Job No. | Code[20] | - |
| 3 | Planning Date | Date | - |
| 4 | Document No. | Code[20] | - |
| 5 | Type | Enum Job Planning Line Type | - |
| 7 | No. | Code[20] | - |
| 8 | Description | Text[100] | - |
| 9 | Quantity | Decimal | - |
| 11 | Direct Unit Cost (LCY) | Decimal | - |
| 12 | Unit Cost (LCY) | Decimal | - |
| 13 | Total Cost (LCY) | Decimal | - |
| 14 | Unit Price (LCY) | Decimal | - |
| 15 | Total Price (LCY) | Decimal | - |
| 16 | Resource Group No. | Code[20] | - |
| 17 | Unit of Measure Code | Code[10] | - |
| 18 | Qty. Rounding Precision | Decimal | - |
| 19 | Qty. Rounding Precision (Base) | Decimal | - |
| 20 | Location Code | Code[10] | - |
| 29 | Last Date Modified | Date | - |
| 30 | User ID | Code[50] | - |
| 32 | Work Type Code | Code[10] | - |
| 33 | Customer Price Group | Code[10] | - |
| 79 | Country/Region Code | Code[10] | - |
| 80 | Gen. Bus. Posting Group | Code[20] | - |
| 81 | Gen. Prod. Posting Group | Code[20] | - |
| 83 | Document Date | Date | - |
| 84 | Planning Due Date | Date | - |
| 1000 | Job Task No. | Code[20] | - |
| 1001 | Line Amount (LCY) | Decimal | - |
| 1002 | Unit Cost | Decimal | - |
| 1003 | Total Cost | Decimal | - |
| 1004 | Unit Price | Decimal | - |
| 1005 | Total Price | Decimal | - |
| 1006 | Line Amount | Decimal | - |
| 1007 | Line Discount Amount | Decimal | - |
| 1008 | Line Discount Amount (LCY) | Decimal | - |
| 1015 | Cost Factor | Decimal | - |
| 1019 | Serial No. | Code[50] | - |
| 1020 | Lot No. | Code[50] | - |
| 1021 | Line Discount % | Decimal | - |
| 1022 | Line Type | Enum Job Planning Line Line Type | - |
| 1023 | Currency Code | Code[10] | - |
| 1024 | Currency Date | Date | - |
| 1025 | Currency Factor | Decimal | - |
| 1026 | Schedule Line | Boolean | - |
| 1027 | Contract Line | Boolean | - |
| 1030 | Job Contract Entry No. | Integer | - |
| 1035 | Invoiced Amount (LCY) | Decimal | - |
| 1036 | Invoiced Cost Amount (LCY) | Decimal | - |
| 1037 | VAT Unit Price | Decimal | - |
| 1038 | VAT Line Discount Amount | Decimal | - |
| 1039 | VAT Line Amount | Decimal | - |
| 1041 | VAT % | Decimal | - |
| 1042 | Description 2 | Text[50] | - |
| 1043 | Job Ledger Entry No. | Integer | - |
| 1048 | Status | Enum Job Planning Line Status | - |
| 1050 | Ledger Entry Type | Enum Job Ledger Entry Type | - |
| 1051 | Ledger Entry No. | Integer | - |
| 1052 | System-Created Entry | Boolean | - |
| 1053 | Usage Link | Boolean | - |
| 1060 | Remaining Qty. | Decimal | - |
| 1061 | Remaining Qty. (Base) | Decimal | - |
| 1062 | Remaining Total Cost | Decimal | - |
| 1063 | Remaining Total Cost (LCY) | Decimal | - |
| 1064 | Remaining Line Amount | Decimal | - |
| 1065 | Remaining Line Amount (LCY) | Decimal | - |
| 1070 | Qty. Posted | Decimal | - |
| 1071 | Qty. to Transfer to Journal | Decimal | - |
| 1072 | Posted Total Cost | Decimal | - |
| 1073 | Posted Total Cost (LCY) | Decimal | - |
| 1074 | Posted Line Amount | Decimal | - |
| 1075 | Posted Line Amount (LCY) | Decimal | - |
| 1080 | Qty. Transferred to Invoice | Decimal | - |
| 1081 | Qty. to Transfer to Invoice | Decimal | - |
| 1090 | Qty. Invoiced | Decimal | - |
| 1091 | Qty. to Invoice | Decimal | - |
| 1100 | Reserved Quantity | Decimal | - |
| 1101 | Reserved Qty. (Base) | Decimal | - |
| 1102 | Reserve | Enum Reserve Method | - |
| 1103 | Planned | Boolean | - |
| 5402 | Variant Code | Code[10] | - |
| 5403 | Bin Code | Code[20] | - |
| 5404 | Qty. per Unit of Measure | Decimal | - |
| 5410 | Quantity (Base) | Decimal | - |
| 5790 | Requested Delivery Date | Date | - |
| 5791 | Promised Delivery Date | Date | - |
| 5794 | Planned Delivery Date | Date | - |
| 5900 | Service Order No. | Code[20] | - |
| 6515 | Package No. | Code[50] | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | - |
| 7001 | Cost Calculation Method | Enum Price Calculation Method | - |
| 7300 | Pick Qty. | Decimal | - |
| 7301 | Qty. Picked | Decimal | - |
| 7302 | Qty. Picked (Base) | Decimal | - |
| 7303 | Completely Picked | Boolean | - |
| 7304 | Pick Qty. (Base) | Decimal | - |
| 7305 | Qty. on Journal | Decimal | - |
Keys, 14
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Job No., Job Task No., Line No. | - |
| Key2 | Job No., Job Task No., Schedule Line, Planning Date | - |
| Key3 | Job No., Job Task No., Contract Line, Planning Date | - |
| Key4 | Job No., Job Task No., Schedule Line, Currency Date | - |
| Key5 | Job No., Job Task No., Contract Line, Currency Date | - |
| Key6 | Job No., Schedule Line, Type, No., Planning Date | - |
| Key7 | Job No., Schedule Line, Type, Resource Group No., Planning Date | - |
| Key8 | Status, Schedule Line, Type, No., Planning Date | - |
| Key9 | Status, Schedule Line, Type, Resource Group No., Planning Date | - |
| Key10 | Job No., Contract Line | - |
| Key11 | Job Contract Entry No. | - |
| Key12 | Type, No., Job No., Job Task No., Usage Link, System-Created Entry | - |
| Key13 | Status, Type, No., Variant Code, Location Code, Planning Date | - |
| Key14 | Job No., Planning Date, Document No. | - |
Procedures, 49
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| UpdateCurrencyFactor | () | public | - | ||||
| Caption | () | Text | public | - | |||
| SetUpNewLine | (Record Job Planning Line) | public | - | ||||
| InitJobPlanningLine | () | public | - | ||||
| GetRemainingQty | (var Decimal, var Decimal) | public | - | ||||
| GetReservationQty | (var Decimal, var Decimal, var Decimal, var Decimal) | Decimal | public | - | |||
| GetSourceCaption | () | Text | public | - | |||
| SetReservationEntry | (var Record Reservation Entry) | public | - | ||||
| SetReservationFilters | (var Record Reservation Entry) | public | - | ||||
| ReservEntryExist | () | Boolean | 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 | - | ||||
| Use | (Decimal, Decimal, Decimal, Date, Decimal) | public | - | ||||
| UpdateQtyToTransfer | () | public | - | ||||
| UpdateQtyToInvoice | () | public | - | ||||
| UpdatePostedTotalCost | (Decimal, Decimal) | public | - | ||||
| Overdue | () | Boolean | public | - | |||
| SetBypassQtyValidation | (Boolean) | public | - | ||||
| ShowReservation | () | public | - | ||||
| ShowReservationEntries | (Boolean) | public | - | ||||
| AutoReserve | () | public | - | ||||
| ShowTracking | () | public | - | ||||
| ShowOrderPromisingLine | () | public | - | ||||
| FilterLinesWithItemToPlan | (var Record Item) | public | - | ||||
| FindLinesWithItemToPlan | (var Record Item) | Boolean | public | - | |||
| LinesWithItemToPlanExist | (var Record Item) | Boolean | public | - | |||
| FilterLinesForReservation | (Record Reservation Entry, Option, Text, Boolean) | public | - | ||||
| DrillDownJobInvoices | () | public | - | ||||
| RowID1 | () | Text[250] | public | - | |||
| UpdatePlanned | () | Boolean | public | - | |||
| ClearValues | () | public | - | ||||
| InitFromJobPlanningLine | (Record Job Planning Line, Decimal) | public | - | ||||
| IsNonInventoriableItem | () | Boolean | public | - | |||
| CopyTrackingFromJobJnlLine | (Record Job Journal Line) | public | - | ||||
| CopyTrackingFromJobLedgEntry | (Record Job Ledger Entry) | public | - | ||||
| InitRoundingPrecisions | () | public | - | ||||
| UpdatePlannedDueDate | () | Boolean | public | - | |||
| ClearTracking | () | public | - | ||||
| ConvertToJobLineType | () | Enum Job Line Type | public | - | |||
| ConvertFromJobLineType | (Enum Job Line Type) | Enum Job Planning Line Line Type | public | - | |||
| CheckItemAvailable | (Integer) | public | - | ||||
| UpdateReservation | (Integer) | public | - | ||||
| GetNextJobLineNo | (Record Job Planning Line) | Integer | protected | - | |||
| CreateWarehouseRequest | () | internal | - | ||||
| OpenItemTrackingLines | () | internal | - | ||||
| IsInbound | () | Boolean | internal | - | |||
| RowID2 | () | Text[250] | internal | - | |||
| TestStatusOpen | () | public | - | ||||
Events, 57
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnAfterCopyFromItem | (var Record Job Planning Line, Record Job, Record Item) | - | ||||
| Integration event | OnAfterCopyTrackingFromJobJnlLine | (var Record Job Planning Line, Record Job Journal Line) | - | ||||
| Integration event | OnAfterCopyTrackingFromJobLedgEntry | (var Record Job Planning Line, Record Job Ledger Entry) | - | ||||
| Integration event | OnAfterDeleteAmounts | (var Record Job Planning Line) | - | ||||
| Integration event | OnAfterGetSKU | (Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnAfterGetRemainingQty | (Record Job Planning Line, var Decimal, var Decimal) | - | ||||
| Integration event | OnAfterFilterLinesWithItemToPlan | (var Record Job Planning Line, var Record Item) | - | ||||
| Integration event | OnAfterGetLineWithPrice | (var Interface Line With Price) | - | ||||
| Integration event | OnAfterHandleCostFactor | (var Record Job Planning Line, Record Job Planning Line, Record Item) | - | ||||
| Integration event | OnAfterInitJobPlanningLine | (var Record Job Planning Line) | - | ||||
| Integration event | OnAfterInitFromJobPlanningLine | (var Record Job Planning Line, Record Job Planning Line) | - | ||||
| Integration event | OnAfterResourceFindCost | (var Record Job Planning Line, var Record Resource Cost) | Pending 17.0 | ||||
| Replaced by the new implementation (V16) of price calculation. | |||||||
| Integration event | OnAfterSetReservationFilters | (var Record Reservation Entry, Record Job Planning Line) | - | ||||
| Integration event | OnAfterSetupNewLine | (var Record Job Planning Line, Record Job Planning Line) | - | ||||
| Integration event | OnAfterUpdateTotalPrice | (var Record Job Planning Line) | - | ||||
| Integration event | OnBeforeCalcQuantityBase | (var Record Job Planning Line, Record Job Planning Line, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeCopyFromResource | (var Record Job Planning Line, Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeHandleCostFactor | (var Record Job Planning Line, var Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeRecalculateAmounts | (var Record Job Planning Line, var Record Job Planning Line) | - | ||||
| Integration event | OnBeforeUpdateAmountsAndDiscounts | (var Record Job Planning Line, Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeValidateWorkTypeCode | (var Record Job Planning Line, Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateAllAmounts | (var Record Job Planning Line, var Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateUnitCost | (Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeValidateQtyToTransferToInvoice | (var Record Job Planning Line, var Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnControlUsageLinkOnAfterGetJob | (var Record Job Planning Line, Record Job, Integer, var Boolean) | - | ||||
| Integration event | OnAfterCopyFromGLAccount | (var Record Job Planning Line, Record Job, Record G/L Account) | - | ||||
| Integration event | OnAfterClearTracking | (var Record Job Planning Line) | - | ||||
| Integration event | OnAfterFilterLinesForReservation | (var Record Job Planning Line, Record Reservation Entry, Option, Text, Boolean) | - | ||||
| Integration event | OnAfterUpdateAllAmounts | (var Record Job Planning Line, var Record Job Planning Line) | - | ||||
| Integration event | OnBeforeCheckQuantityPosted | (var Record Job Planning Line, Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeFindPriceAndDiscount | (Integer, var Boolean, var Record Job Planning Line, Record Job Planning Line) | - | ||||
| Integration event | OnBeforeUpdateRemainingQuantity | (var Record Job Planning Line, Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnUpdateCurrencyFactorOnBeforeGetExchangeRate | (Record Job Planning Line, var Record Currency Exchange Rate) | - | ||||
| Integration event | OnValidateNoOnAfterCopyFromAccount | (var Record Job Planning Line, var Record Job Planning Line, var Record Job) | - | ||||
| Integration event | OnBeforeEnsureDirectedPutawayandPickFalse | (var Record Job Planning Line, Record Location, var Boolean) | - | ||||
| Integration event | OnBeforeValidateQuantityBase | (var Record Job Planning Line, Record Job Planning Line, Integer, var Boolean) | - | ||||
| Integration event | OnAfterConvertToJobLineType | (var Record Job Planning Line, var Enum Job Line Type) | - | ||||
| Integration event | OnAfterConvertFromJobLineType | (var Record Job Planning Line, var Enum Job Line Type, var Enum Job Planning Line Line Type) | - | ||||
| Integration event | OnBeforeRetrieveCostPrice | (var Record Job Planning Line, Record Job Planning Line, var Boolean, var Boolean, Integer) | - | ||||
| Integration event | OnBeforeUpdateRemainingQuantityFromUse | (var Record Job Planning Line, Record Job Planning Line, Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateReservation | (var Record Job Planning Line, var Record Job Planning Line, Integer, var Boolean, Integer) | - | ||||
| Integration event | OnUseOnBeforeModify | (var Record Job Planning Line, Record Job Planning Line) | - | ||||
| Integration event | OnAfterCalculateRetrievedCost | (var Record Job Planning Line, Record Job Planning Line, Record Stockkeeping Unit, Record Item, var Decimal) | - | ||||
| Integration event | OnAfterCopyFieldsFromJob | (var Record Job Planning Line, Record Job Planning Line, Record Job) | - | ||||
| Integration event | OnAfterGetJob | (var Record Job Planning Line, var Record Job) | - | ||||
| Integration event | OnAfterUpdateCurrencyFactor | (var Record Job Planning Line) | - | ||||
| Integration event | OnAfterUpdateUnitPrice | (var Record Job Planning Line, Record Job Planning Line, var Decimal, var Decimal) | - | ||||
| Integration event | OnAfterUpdateAmountsAndDiscounts | (var Record Job Planning Line, Record Job Planning Line) | - | ||||
| Integration event | OnAfterValidateModification | (var Record Job Planning Line, Boolean, Integer) | - | ||||
| Integration event | OnBeforeCheckRelatedJobPlanningLineInvoice | (Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeInitJobPlanningLine | (var Record Job Planning Line, Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeInitRoundingPrecisions | (Record Job Planning Line, var Decimal, var Decimal, var Decimal, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeUpdatePlannedDueDate | (var Record Job Planning Line, var Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeOnInsert | (var Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateDescription | (var Record Job Planning Line, Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeValidateModification | (var Record Job Planning Line, var Boolean, Record Job Planning Line, Integer) | - | ||||
| Integration event | OnBeforeValidatePlanningDate | (var Record Job Planning Line, Record Job Planning Line, var Boolean) | - | ||||