Table 5950 "Service Order Allocation"
Base Application · Microsoft.Service.Document
Across versions
- BC23present
- BC243 fields changed
- BC25-27unchanged
- BC2816 fields changed
- BC29-30unchanged
Neighbourhood 20 connected objects and pages
Base Application · Microsoft.Service.Document · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Service Order Allocation |
| 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 | Entry No. Δ BC28 | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | |
| 2 | Status Δ BC28 | Option | Specifies the status of the entry, such as active, non-active, or cancelled. | OptionCaption: Nonactive,Active,Finished,Canceled,Reallocation Needed; not editable |
| 3 | Document No. Δ BC28 | Code[20] | Specifies the number of the service order associated with this entry. | not editable |
| 4 | Allocation Date Δ BC28 | Date | Specifies the date when the resource allocation should start. | |
| 5 | Resource No. Δ BC28 | Code[20] | Specifies the number of the resource allocated to the service task in this entry. | TableRelation Table 156 “Resource” |
| 6 | Resource Group No. Δ BC28 | Code[20] | Specifies the number of the resource group allocated to the service task in this entry. | TableRelation Table 152 “Resource Group” (Resource Group) |
| 7 | Service Item Line No. Δ BC28 | Integer | Specifies the number of the service item line linked to this entry. | TableRelation Table 5901 “Service Item Line” (“Service Item Line”.“Line No.” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”))) |
| 8 | Allocated Hours Δ BC28 | Decimal | Specifies the hours allocated to the resource or resource group for the service task in this entry. | |
| 9 | Starting Time Δ BC28 | Time | Specifies the time when you want the allocation to start. | |
| 10 | Finishing Time Δ BC28 | Time | Specifies the time when you want the allocation to finish. | |
| 11 | Description Δ BC28 | Text[100] | Specifies a description for the service order allocation. | |
| 12 | 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) |
| 13 | Service Item No. Δ BC24 Δ BC28 | Code[20] | Specifies the number of the service item. | TableRelation Table 5940 “Service Item” (if (“Document Type” = filter(<> “Credit Memo”)) “Service Item”.“No.” where(Blocked = filter(<> All)) else if (“Document Type” = filter(“Credit Memo”)) “Service Item”.“No.”) |
| 14 | Posted | Boolean | — | |
| 15 | Service Item Description Δ BC24 Δ BC28 | Text[100] | Specifies a description of the service item in this entry. | FlowField: lookup(“Service Item Line”.Description where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”), “Line No.” = field(“Service Item Line No.”))); not editable |
| 16 | Service Item Serial No. Δ BC28 | Code[50] | Specifies the serial number of the service item in this entry. | |
| 17 | Repair Status Δ BC24 | Code[20] | — | FlowField: lookup(“Service Item Line”.“Repair Status Code” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”), “Line No.” = field(“Service Item Line No.”))); not editable |
| 18 | Service Started | Boolean | — | |
| 19 | Document Type Δ BC28 | Enum “Service Document Type” | Specifies the type of the document (Order or Quote) from which the allocation entry was created. | enum Enum 5900 “Service Document Type”; not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Status, Document Type, Document No., Service Item Line No., Allocation Date, Starting Time, Posted
- Key3: Document Type, Document No., Status, Resource Group No., Allocation Date, Starting Time, Posted
- Key4: Status, Document Type, Document No., Service Item Line No., Resource No., Allocation Date, Starting Time, Posted
- Key5: Document Type, Document No., Service Item Line No., Allocation Date, Starting Time, Posted
- Key6: Resource No., Document Type, Allocation Date, Status, Posted
Events published
OnBeforeCheckAllocationEntry(var ServiceOrderAllocation: Record "Service Order Allocation"; var IsHandled: Boolean)(integration)OnBeforeCreateReallocationEntry(var ServiceOrderAllocation: Record "Service Order Allocation"; var IsHandled: Boolean)(integration)OnBeforeValidateStartEndTime(var ServiceOrderAllocation: Record "Service Order Allocation"; var IsHandled: Boolean)(integration)OnCreateReallocationEntryOnBeforeResetRepairStatus(var ServiceOrderAllocation: Record "Service Order Allocation")(integration)
Trigger event subscribers
- OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceOrderAllocation
Procedures
GetHideDialog(): BooleanSetHideDialog(HideDialog1: Boolean)SetFilters(ServiceItemLine: Record "Service Item Line")
Plus 3 local procedures.
Triggers
OnDelete, OnInsert, OnModify
Relations
- drill-down page Page 6001 “Service Order Allocations”
- lookup page Page 6001 “Service Order Allocations”
- Resource Group No.: TableRelation Table 152 “Resource Group”
- Resource No.: TableRelation Table 156 “Resource”
- Reason Code: TableRelation Table 231 “Reason Code”
- Repair Status: CalcFormula Table 5901 “Service Item Line”
- Service Item Description: CalcFormula Table 5901 “Service Item Line”
- Service Item Line No.: TableRelation Table 5901 “Service Item Line”
- Service Item No.: TableRelation Table 5940 “Service Item” (conditional)
Referenced by
17 fields in 8 objects relate to this table (TableRelation or CalcFormula).
- Table 5900 “Service Header”: Allocated Hours, No. of Allocations, Reallocation Needed
- Table 5990 “Service Shipment Header”: Allocated Hours, No. of Allocations, Reallocation Needed
- Table 5992 “Service Invoice Header”: Allocated Hours, No. of Allocations, Reallocation Needed
- Table 5994 “Service Cr.Memo Header”: Allocated Hours, No. of Allocations, Reallocation Needed
- Table 5901 “Service Item Line”: No. of Active/Finished Allocs, No. of Allocations
- Table 5989 “Service Shipment Item Line”: No. of Active/Finished Allocs
- Table extension 6456 “Serv. Resource”: Qty. on Service Order
- Table extension 6457 “Serv. Resource Group”: Qty. on Service Order
Pages and codeunits on this table
- Page 6001 “Service Order Allocations” (source table)
- Page 6002 “Cancelled Allocation Reasons” (source table)
- Page 6003 “Cancelled Allocation Entries” (source table)
- Page 6005 “Resource Allocations” (source table)
- Page 6022 “Reallocation Entry Reasons” (source table)
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 5930 “ServAllocationManagement” (3 calls:
OnDelete → CheckServiceItemLineFinished,OnInsert → CheckServiceItemLineFinished,OnModify → CheckServiceItemLineFinished)
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: "Service Order Allocation"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.