CST_RCL_COST_REC_TXNS
This table will store the service cost recognition and service cost recognition reversal transactions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_RCL_COST_REC_TXNS_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Value that uniquely identifies the service cost recognition or service cost recognition reversal transaction in costing. | |
| CST_TRANSACTION_ID | NUMBER | 18 | Yes | Stores the source transaction identifier against which the service cost recognition or service cost recognition reversal transaction is created. | |
| SOURCE_TABLE | VARCHAR2 | 100 | Yes | Identifies the table name of the source transaction against which the service cost recognition or service cost recognition reversal transaction is created. Possible values are: cst_transactions, cst_resource_transactions. | |
| COST_ORG_ID | NUMBER | 18 | The unique identifier for the cost organization. | ||
| COST_BOOK_ID | NUMBER | 18 | The unique identifier for the cost book. | ||
| REV_REC_TXN_ID | NUMBER | 18 | Yes | The unique identifier for the service revenue transaction. | |
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | Indicates the charge posting date for the service cost line against which the service cost recognition or service cost recognition reversal transaction is created. | ||
| COST_PERCENTAGE | NUMBER | Yes | Indicates the service cost recognition percentage. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | The unique identifier for the inventory organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | The unique identifier for the inventory item. | ||
| RESOURCE_ID | NUMBER | 18 | The unique identifier for the resource. | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | The unique identifier for the work order in Costing. | ||
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | The unique identifier for the work order operation associated with the transaction. | ||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Transaction type identifier. Possible values are: 48 : Service Cost Recognition 49 : Service Cost Recognition Reversal | ||
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | 18 | Transaction source type identifier. This will always be zero for both service cost recognition and service cost recognition reversal transactions. | ||
| TRANSACTION_ACTION_ID | NUMBER | 18 | Transaction action identifier. Possible values are: 48 : Service Cost Recognition 49 : Service Cost Recognition Reversal | ||
| DEBRIEF_LINE_ID | NUMBER | 18 | Yes | The unique identifier for the debrief line. | |
| POSTED_FLAG | VARCHAR2 | 5 | Indicates if the cost row is created for the service cost recognition or service cost recognition reversal transaction. Possible values are: N-Not Processed, Y-Cost row is created, E-Error. | ||
| VARIANCE_POSTED_FLAG | VARCHAR2 | 5 | A flag that indicates whether variance cost is created for the service cost recognition or service cost recognition reversal transaction. Possible values are: NULL or X: Variance cost is not expected, N : Variance cost is expected and is yet to be created by the distribution processor, Y : Variance cost is created by the distribution processor, E : Variance cost is expected. The flag is updated to E (error) so that the transaction is picked up again for processing by the distribution processor in subsequent execution. | ||
| COST_STATUS | VARCHAR2 | 1 | Indicates the cost status of the transaction. Possible values are: N-Not Processed, P-Partially Processed, C-Fully Costed, E-Error, X-Excluded from Costing. | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Indicates the accounting status of the transaction. Possible values are: N-Not Processed, D-Draft Accounted, F-Final Accounted, E-Error, X-Excluded from Accounting. | ||
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | Value that identifies the legal entity time zone. If NULL, then legal entity time zone is not enabled for the data in the row and the dates are assumed to be in database time zone. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_RCL_COST_REC_TXNS_N1 | Non Unique | Default | SOURCE_TABLE, CST_TRANSACTION_ID |
| CST_RCL_COST_REC_TXNS_N2 | Non Unique | Default | POSTED_FLAG |
| CST_RCL_COST_REC_TXNS_N3 | Non Unique | Default | VARIANCE_POSTED_FLAG |
| CST_RCL_COST_REC_TXNS_N4 | Non Unique | Default | COST_STATUS |
| CST_RCL_COST_REC_TXNS_N5 | Non Unique | Default | TRANSACTION_DATE |
| CST_RCL_COST_REC_TXNS_N6 | Non Unique | Default | INVENTORY_ITEM_ID, COST_ORG_ID, COST_BOOK_ID, TRUNC("TRANSACTION_DATE") |
| CST_RCL_COST_REC_TXNS_N7 | Non Unique | Default | ACCOUNTING_STATUS |
| CST_RCL_COST_REC_TXNS_U1 | Unique | Default | TRANSACTION_ID |
| CST_RCL_COST_REC_TXNS_U2 | Unique | Default | CST_TRANSACTION_ID, REV_REC_TXN_ID |