Debriefs
Maintains detailed records for service events, including technician data, customer accounts, and service outcomes.
Columns
Name | Type | Description |
AssetId | Long | The unique identifier assigned to the asset involved in the service logistics debrief. |
BillToPartySiteId | Long | The unique identifier of the bill-to party site, specifying where the customer’s bill is directed. |
BUOrgId | Long | The unique identifier of the business unit that is responsible for creating and managing the sales order. |
CustomerAccountId | Long | The unique identifier of the customer account associated with the debrief record, used for tracking customer-related transactions. |
DebriefHeaderId [KEY] | Long | The unique identifier of the debrief header record, linking to the detailed service or repair activities. |
DebriefNumber | String | A unique identifier for the debrief header record, typically assigned sequentially. |
DebriefStatusCode | String | An abbreviation identifying the current status of the debrief header, which can be one of several predefined statuses from the 'ORA_RCL_DEBRIEF_STATUS' lookup. |
FreezePrice | String | Indicates whether the price is fixed (frozen) when creating the sales order. This option ensures the price does not change after the debrief is processed. |
ObjectVersionNumber | Int | A number used for optimistic locking to prevent simultaneous updates to the same record by different sessions. It is incremented every time the record is updated. |
ParentEntityCode | String | An abbreviation that identifies the parent entity type for the debrief, such as a work order or service request. |
ParentEntityId | Long | The unique identifier of the parent entity (such work order or service request) related to the debrief header. |
ParentEntityName | String | The name of the parent entity associated with the debrief, such as a specific work order or service request. |
PartyId | Long | The unique identifier of the customer party (from the HZ_PARTIES table) associated with the service logistics debrief record. |
ProductItemId | Long | The unique identifier of the product (from the EGP_SYSTEM_ITEMS table) associated with the service logistics debrief record. |
ProductSerialNumber | String | The serial number of the product involved in the debrief, used for identifying individual product instances. |
TechnicianPartyId | Long | The unique identifier of the technician resource (from the HZ_PARTIES table) associated with the debrief record. |
ProductItemNumber | String | The product number that uniquely identifies the item involved in the service logistics debrief. |
BUName | String | The name of the business unit where the sales order for the debrief is created. |
TechnicianPartyName | String | The name of the technician assigned to the service task associated with the debrief. |
CustomerName | String | The name of the customer involved in the service request or debrief. |
CustomerAccountNumber | String | The account number associated with the customer for billing and transaction tracking. |
AssetNumber | String | The unique asset number that identifies the asset involved in the service logistics process. |
ParentEntityCodeMeaning | String | The detailed meaning of the parent entity code, referring to the entity type such as work order or service request. |
ParentEntityNumber | String | The identification number of the parent document associated with the service logistics debrief record. |
CostOrganizationName | String | The name of the cost organization managing the maintenance and service tasks for the debrief. |
CostOrganizationCode | String | The abbreviation or code identifying the maintenance organization handling the debrief. |
CostOrganizationId | Long | The unique identifier of the maintenance organization responsible for processing the debrief. |
WorkOrderSubTypeMeaning | String | The description of the work order subtype used for categorizing debrief-related work orders. |
WorkOrderSubTypeCode | String | An abbreviation identifying the work order subtype related to the service or maintenance task for the debrief. |
ProductItemDescription | String | The description of the product involved in the debrief, detailing the item or service being worked on. |
BillToAddress | String | The billing address associated with the debrief, indicating where the invoice will be sent. |
PurchaseOrder | String | The purchase order number associated with the service request for the debrief header. |
ServiceRequestId | Long | The unique identifier of the service request that initiated the debrief. |
ServiceRequestNumber | String | The number associated with the service request, used for tracking and referencing the request in the system. |
DebriefStatus | String | The status of the debrief, indicating whether the service task has been completed, is in progress, or other statuses. |
CreationDate | Datetime | The date and time when the debrief record was created in the system. |
CreatedBy | String | The user who created the debrief record, typically the technician or system administrator. |
LastUpdateDate | Datetime | The date and time when the debrief record was last updated or modified. |
LastUpdatedBy | String | The user who last updated the debrief record, typically a technician or manager. |
LastUpdateLogin | String | The login identifier of the user who last updated the debrief record. |
RepriceFlag | Bool | Indicates whether the debrief should trigger a repricing process. If true, the system will initiate repricing for the debrief. |
CurrencyCode | String | The currency code used for repricing the debrief, such as USD or EUR. |
TechnicianPartyNumber | String | The technician’s unique party number in the debriefing system, used for identifying the technician. |
TechnicianEmailAddress | String | The email address of the technician assigned to the debrief, used for communication purposes. |
OrderId | Decimal | The unique order ID related to the debriefing process, used for tracking. |
OrderNumber | String | The order number associated with the debrief, used for referencing the specific transaction. |
CreateChargesFlag | Bool | Indicates whether charges created for maintenance work orders should be included in the debrief transaction. |
Quantity | Decimal | The quantity of items or units involved in the debrief process. |
ReceivedQuantity | Decimal | The quantity of items that have been received or processed in the debrief. |
ShipToPartySiteId | Long | The unique identifier for the ship-to party site where the debrief service was performed. |
ShipToAddress | String | The shipping address associated with the debrief, where items or services are delivered. |
Finder | String | A generic search term used for locating debrief records in the system. |