CST_RCL_SCR_REPORT_GT
This table is used for storing all the transactions that are resulted for the given search parameters for Service Cost Recognition BIP Report.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Transaction identifier which uniquely identifies a service cost recognition transaction in costing. | ||
| CST_TRANSACTION_ID | NUMBER | 18 | Stores the source transaction identifier against which the service cost recognition or service cost recognition reversal transaction is created. | ||
| COST_ORG_NAME | VARCHAR2 | 240 | Denotes the translated name for the Cost Organization Unit. | ||
| COST_ORG_ID | NUMBER | 18 | Yes | The unique identifier for the cost organization. | |
| COST_BOOK_CODE | VARCHAR2 | 30 | A unique code given for a particular cost book. Usually named to indicate the purpose of that cost book. | ||
| COST_BOOK_ID | NUMBER | 18 | Yes | The unique identifier for the cost book. | |
| INVENTORY_ORG_NAME | VARCHAR2 | 240 | Denotes the translated name for the Inventory Organization Unit. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the inventory organization to which the item belongs. | ||
| SVC_REQUEST_NUMBER | VARCHAR2 | 30 | The unique number for the service request. | ||
| SVC_DOCUMENT_NUMBER | VARCHAR2 | 30 | The document number used to create work order charges in Service Logistics application. | ||
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Work Order Number in manufacturing. The uniqueness of which will be controlled by user at the work method level or at the plant level. | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | The unique identifier for the work order in Costing. | |
| RELEASED_DATE | TIMESTAMP | Date when the work order is released. | |||
| BASE_TXN_TYPE_NAME | VARCHAR2 | 80 | Transaction type name translated to the language. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Value that identifies the inventory item associated with the transaction. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | The unique identifier for the inventory item. | ||
| RESOURCE_NAME | VARCHAR2 | 120 | Indicates the name of the resource. | ||
| RESOURCE_ID | NUMBER | 18 | The unique identifier for the resource. | ||
| SUBSCRIPTION_TYPE | VARCHAR2 | 240 | Value that indicates the subscription type. | ||
| SUBSCRIPTION_NUMBER | VARCHAR2 | 120 | Subscription number for new subscriptions. For Migration appended by the contract modifier for renewed contracts. | ||
| RECOGNITION_PERCENTAGE | NUMBER | Percentage of the service cost recognized. | |||
| CURRENCY_CODE | VARCHAR2 | 20 | Currency code in which the cost is recorded. | ||
| UNRECOGNIZED_SVC_COST_FLAG | VARCHAR2 | 1 | A flag that indicates whether the record for service cost recognition or service cost recognition reversal transaction is unrecognized. Possible values are: NULL : Recognition is done or not eligible for recognition, Y : Unrecognized. | ||
| UNRECOGNIZED_SVC_COST_PCT | NUMBER | Indicates the percentage of the unrecognized service cost. | |||
| TOTAL_COST | NUMBER | Indicates the total cost incurred on a WIP transaction or a maintenance work order related to the field service flow. | |||
| RECOGNIZED_COST | NUMBER | Indicates the recognized service cost for a WIP transaction or a maintenance work order related to the field service flow. | |||
| UNRECOGNIZED_COST | NUMBER | Indicates the unrecognized service cost for a WIP transaction or a maintenance work order related to the field service flow. |