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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |