Debriefs
Debriefs
Columns
Name | Type | Description |
AssetId | Long | Value that uniquely identifies the asset. |
BillToPartySiteId | Long | Value that uniquely identifies the bill-to party. |
BUOrgId | Long | Value that uniquely identifies the business unit. |
CustomerAccountId | Long | Value that uniquely identifies the customer account. |
DebriefHeaderId [KEY] | Long | Value that uniquely identifies the debrief header record. |
DebriefNumber | String | Number that uniquely identifies the debrief header record. |
DebriefStatusCode | String | Abbreviation that identifies the status of the debrief header. A list of accepted values is defined in the lookup type ORA_RCL_DEBRIEF_STATUS. You cannot add additional debrief statuses. |
FreezePrice | String | Value that indicates whether or not the price is frozen when creating the sales order. |
ObjectVersionNumber | Int | Number that is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was most recently queried. |
ParentEntityCode | String | Abbreviation that identifies the parent entity of the debrief header. |
ParentEntityId | Long | Value that uniquely identifies the parent entity of the debrief header. |
ParentEntityName | String | Name of the parent entity associated with the debrief. |
PartyId | Long | Value that uniquely identifies the customer party (HZ_PARTIES) associated with the service logistics debrief record (RCL_DEBRIEF_HEADERS). |
ProductItemId | Long | Value that uniquely identifies the product (EGP_SYSTEM_ITEMS) associated with the service logistics debrief record (RCL_DEBRIEF_HEADERS). |
ProductSerialNumber | String | Serial number that identifies the product. |
TechnicianPartyId | Long | Value that uniquely identifies the technician resource (HZ_PARTIES) associated with the service logistics debrief record (RCL_DEBRIEF_HEADERS). |
ProductItemNumber | String | Number that uniquely identifies the product (EGP_SYSTEM_ITEMS) associated with the service logistics debrief record (RCL_DEBRIEF_HEADERS). |
BUName | String | Name of the business unit where the sales order is created. |
TechnicianPartyName | String | Name of the technician. |
CustomerName | String | Name of the customer. |
CustomerAccountNumber | String | Number that identifies the customer account. |
AssetNumber | String | Number that identifies the asset. |
ParentEntityCodeMeaning | String | Meaning of the parent entity code. A list of accepted values is defined in the lookup type ORA_RCL_SOURCE_DOC_TYPE. |
ParentEntityNumber | String | Number that identifies the parent document associated with the service logistics debrief record. |
CostOrganizationName | String | CostOrganizationName of Debriefs |
CostOrganizationCode | String | Abbreviation that identifies the maintenance organization. |
CostOrganizationId | Long | Value that uniquely identifies the maintenance organization. |
WorkOrderSubTypeMeaning | String | WorkOrderSubTypeMeaning of Debriefs |
WorkOrderSubTypeCode | String | Abbreviation that identifies the work order subtype. |
ProductItemDescription | String | ProductItemDescription of Debriefs |
BillToAddress | String | BillToAddress of Debriefs |
PurchaseOrder | String | Value that defines the purchase order number from the service request for the debrief header. |
ServiceRequestId | Long | ServiceRequestId of Debriefs |
ServiceRequestNumber | String | ServiceRequestNumber of Debriefs |
DebriefStatus | String | DebriefStatus of Debriefs |
CreationDate | Datetime | CreationDate of Debriefs |
CreatedBy | String | CreatedBy of Debriefs |
LastUpdateDate | Datetime | LastUpdateDate of Debriefs |
LastUpdatedBy | String | LastUpdatedBy of Debriefs |
LastUpdateLogin | String | LastUpdateLogin of Debriefs |
RepriceFlag | Bool | Value that identifies the repricing of the debrief. Contains one of the following values: true or false. If true, initiates repricing for the debrief. If false, doesn't initiate repricing for the debrief. |
CurrencyCode | String | Abbreviation that identifies the currency for repricing the debrief. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Finder | String | finder |