Debrief Lines
The Debrief Lines view object manages information for a service activity and the charge item details like quantity, amount and currency.
Data Store Key : FscmTopModelAM.ScmExtractAM.RclBiccExtractAM.DebriefLinesExtractPVO
Primary Keys : DebriefLineId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar1 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar10 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar11 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar12 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar13 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar14 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar15 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar16 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar17 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar18 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar19 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar2 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar20 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar3 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar4 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar5 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar6 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar7 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar8 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeChar9 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeDate1 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeDate2 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeDate3 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeDate4 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeDate5 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber1 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber10 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber2 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber3 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber4 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber5 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber6 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber7 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber8 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeNumber9 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeTimestamp1 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeTimestamp2 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeTimestamp3 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeTimestamp4 | A value that indicates the segment of the user descriptive flexfield. |
| AttributeTimestamp5 | A value that indicates the segment of the user descriptive flexfield. |
| BillToPartyId | A value that uniquely identifies the bill-to party (HZ_PARTIES). |
| BillToPartySiteId | A value that uniquely identifies the bill-to party for the debrief lines table. |
| CreatedBy | The user who created the row for the debrief lines table. |
| CreationDate | The date and time when the debrief line row was created. |
| CurrencyCode | An abbreviation that identifies the currency for the expense debrief line (FND_CURRENCIES). |
| CustAccountId | A value that uniquely identifies the customer account for the debrief lines table. |
| DebriefHeaderId | A value that uniquely identifies the debrief header record for the debrief lines table. |
| DebriefLineId | A value that uniquely identifies the debrief line record. This is the primary key of the Debrief Lines view object. |
| ErrorText | A value that describes the error. |
| ExpenseAmount | A value that indicates the expense debrief amount. |
| InventoryItemId | A value that uniquely identifies the debrief item (EGP_SYSTEM_ITEMS). The item can be material, labor, or expense item as defined in the item's billing type (MATERIAL_BILLABLE_FLAG). |
| ItemRevision | A number that identifies the item revision. |
| JobDefinitionName | The name of the process that created the debrief record for the debrief lines table. |
| JobDefinitionPackage | A value that indicates the job package name that created or last updated the row for the debrief lines table. |
| LaborEndDate | The date and time when the work ended. |
| LaborStartDate | The date and time when the work started. |
| LastUpdateDate | The date and time when the debrief transaction row was last updated for the debrief lines table. |
| LastUpdateLogin | The session login associated with the user who last updated the debrief transaction for the debrief lines table. |
| LastUpdatedBy | The user who last updated the debrief transaction row for the debrief lines table. |
| LineStatusCode | An abbreviation that identifies the status of the debrief line. A list of accepted values is defined in the lookup type ORA_RCL_DEBRIEF_STATUS. You can't add additional debrief statuses. |
| LineType | Internal code that identifies the debrief line record as material, labor, or expense line. |
| LotNumber | The number that identifies the item's lot. |
| ObjectVersionNumber | The number of times the debrief transaction row has been updated for the debrief lines table. |
| OrderLineId | A value that uniquely identifies the sales order line (DOO_LINES_ALL). |
| OrganizationId | A value that uniquely identifies the inventory organization. |
| ParentInstanceId | A value that uniquely identifies the parent instance of an asset. |
| PartyId | A value that uniquely identifies the customer party. |
| Quantity | The quantity of the debriefed item. |
| ReasonCode | This attribute isn't currently used. |
| RequestId | A value that uniquely identifies the process that created the debrief transaction for the debrief lines table. |
| ReservationId | A value that uniquely identifies the inventory reservation created for the part installation debrief line. |
| SerialNumber | A serial number that identifies the item debriefed. |
| ServiceActivityId | A value that uniquely identifies the service activity of the debrief line (RCL_SERVICE_ACTIVITIES_VL). |
| SourceId | A value that uniquely identifies the application where the debrief line was first entered. |
| SourceType | A value that identifies the application where the debrief line was first entered. |
| SubinventoryCode | The name of the subinventory that's used to install or return the debrief transaction. |
| UomCode | An abbreviation that identifies the unit of measure used in the debrief transaction. |
| UseCommonInventoryFlag | An attribute that uniquely identifies the project inventory source for debrief transactions. Values include: Null, True, or False. If True, you can issue parts from the project common inventory during the debrief material process. If False or Null, you can't issue parts from the project common inventory during the debrief material process.This attribute doesn't have a default value. |