Debriefslines
Tracks service line details such as labor, materials, expenses, and activity durations.
Columns
| Name | Type | Description |
| DebriefsDebriefHeaderId [KEY] | Long | The unique identifier for the debrief header, linking it to the specific debrief line records. |
| BillToPartyId | Long | The unique identifier of the bill-to party (HZ_PARTIES) associated with the debrief transaction. |
| CurrencyCode | String | The currency code used for the expense amount in the debrief line (referenced from FND_CURRENCIES). |
| DebriefHeaderId | Long | The unique identifier for the debrief header record, linking it to the overall debrief process. |
| DebriefLineId [KEY] | Long | The unique identifier for each debrief line, used to reference individual entries in the debrief. |
| ExpenseAmount | Decimal | The amount associated with the expense in the debrief line. |
| InventoryItemId | Long | The unique identifier for the inventory item (EGP_SYSTEM_ITEMS), which could be a material, labor, or expense item, depending on the billing type. |
| ItemRevision | String | The revision number associated with the product item being debriefed. |
| LaborEndDate | Datetime | The date and time when labor activities related to the debrief line were completed. |
| LaborStartDate | Datetime | The date and time when labor activities related to the debrief line began. |
| LineStatusCode | String | The status of the debrief line, indicating its current state. Valid statuses are defined in the lookup type ORA_RCL_DEBRIEF_STATUS. |
| LineType | String | An internal code identifying whether the debrief line is related to material, labor, or expense. |
| LotNumber | String | The lot number of the item being debriefed, used for tracking inventory batches. |
| OrderLineId | Long | The unique identifier for the order line related to the debrief (DOO_LINES_ALL). |
| OrganizationId | Long | The unique identifier of the organization handling the inventory for the debrief. |
| ParentInstanceId | Long | The unique identifier for the parent instance of an asset associated with the debrief. |
| Quantity | Decimal | The quantity of the item being debriefed. |
| ReasonCode | String | This attribute is not currently in use but could serve as a reason for adjustments or corrections in the debrief. |
| SerialNumber | String | The serial number of the item being debriefed, used for tracking specific units. |
| ServiceActivityId | Long | The identifier for the service activity associated with the debrief line (RCL_SERVICE_ACTIVITIES_VL). |
| SourceId | String | The unique identifier for the application from which the debrief line originated. |
| SourceType | String | The type of application where the debrief line was first entered. |
| SubinventoryCode | String | The subinventory name used for installation or return of items in the debrief transaction. |
| UOMCode | String | The unit of measure code used in the debrief transaction, such as 'EA' for each or 'KG' for kilograms. |
| OrganizationCode | String | The code identifying the inventory organization related to the debrief line. |
| InventoryItemNumber | String | The unique number identifying the item associated with the debrief line (EGP_SYSTEM_ITEMS). |
| BillToPartyName | String | The name of the bill-to party or customer associated with the debrief. |
| UnitOfMeasure | String | The unit of measure used for the item in the debrief line, such as quantity or weight. |
| ServiceActivityCode | String | The abbreviation that identifies the service activity associated with the debrief (RCL_SERVICE_ACTIVITIES_VL). |
| ReservationId | Long | The unique identifier for the inventory reservation created for part installation in the debrief process. |
| CommonInventoryFlag | Bool | Indicates whether the project inventory is considered common inventory during the debrief material process. 'True' allows issuing parts from the common inventory. |
| PartyId | Long | The unique identifier for the customer party (associated with the debrief). |
| PartyName | String | The name of the customer associated with the debrief. |
| CustomerAccountId | Long | The unique identifier of the customer account involved in the debrief transaction. |
| CustomerAccountNumber | String | The account number of the customer associated with the debrief. |
| BillToPartySiteId | Long | The unique identifier of the bill-to party site where the debrief is directed. |
| BillToAddress | String | The billing address of the customer associated with the debrief. |
| ServiceActivity | String | A general description of the service activity associated with the debrief line. |
| ServiceActivityDescription | String | A detailed description of the service activity for the debrief line. |
| LineCategoryCode | String | The category code assigned to the debrief line. |
| ZeroChargeFlag | Bool | Indicates whether the debrief line has zero charges. If true, the line is treated as non-billable. |
| OmInterfaceFlag | Bool | Indicates whether the debrief line has been interfaced with the Oracle Manufacturing system. |
| InventoryItemDescription | String | A description of the inventory item associated with the debrief line. |
| LineStatus | String | The current status of the debrief line, such as 'Pending', 'Completed', 'Cancelled'. |
| ErrorText | String | Text field used for detailing errors encountered during the processing of the debrief line. |
| LineTypeMeaning | String | A description of the line type, explaining whether it is for material, labor, or expense. |
| PricingSegmentCode | String | The code for the pricing segment associated with the debrief line. |
| PricingSegmentExplanation | String | A detailed explanation of the pricing segment applied to the debrief line. |
| PricingStrategyExplanation | String | A detailed explanation of the pricing strategy applied to the debrief line. |
| PricingStrategyId | Long | The unique identifier for the pricing strategy applied to the debrief line. |
| AppliedCurrencyCode | String | The currency code used for applying pricing to the debrief line. |
| CreationDate | Datetime | The date when the debrief line was created. |
| CreatedBy | String | The user who created the debrief line record. |
| LastUpdateDate | Datetime | The date when the debrief line was last updated. |
| LastUpdatedBy | String | The user who last updated the debrief line record. |
| LastUpdateLogin | String | The login information of the user who last updated the debrief line. |
| OriginalOrderLineId | Long | The reference to the original order line for which the debrief correction is created. |
| OrderNumber | String | The order number associated with the debrief line. |
| RepairOrderId | Long | The repair order ID related to the debrief line. |
| RepairOrderNumber | String | The repair order number associated with the debrief line. |
| BillingTypeCode | String | The billing type code associated with the debrief line. |
| BillingType | String | A description of the billing type for the debrief line. |
| UOMClass | String | The class of unit of measure used in the debrief transaction. |
| PricingSegment | String | The pricing segment associated with the debrief line. |
| PricingStrategy | String | The pricing strategy applied to the debrief line. |
| InvoiceId | Long | The invoice ID related to the debrief line. |
| InvoiceNumber | String | The invoice number related to the debrief line. |
| RepriceFlag | Bool | A flag indicating whether the debrief line should be repriced after manual adjustments are applied. |
| StockLocationId | Long | The unique identifier for the inventory stocking location used in the debrief transaction (RCL_STOCK_LOCATIONS). |
| Finder | String | A generic search term used for locating debrief line records in the system. |