CST_RESOURCE_TRANSACTIONS_S_GT
This table is used to temporarily store a subset of the data from cst_resource_transactions table for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_RESOURCE_TXNS_S_GT_PK |
RESOURCE_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_TRANSACTION_ID | NUMBER | 18 | Yes | Primary Key that identifies a resource transaction. It shares the same sequence as the one used for Transaction ID in the Cost Transaction entity. This ensures that the transaction_id is unique across all transactions tables. | |
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | Indicates Legal Entity time zone for the resource transaction | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization which is associated to the plant/inventory organization of the resource transaction. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book to which this transaction belongs. | |
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | The plant where the resource was consumed. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Surrogate ID identifying the resource which was consumed. This attribute along with the plant, cost organization and cost book combination is used to derive the resource rate. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the primary product associated to the work order where the resource was consumed. | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Identifies the item cost profile of the primary product of the Work Order associated to the resource transaction. | ||
| COST_PROFILE_ID | NUMBER | 18 | Identifies the Asset Cost Profile linked to the item cost profile. This cost profile is used to get the cost component mapping, which is needed to map the resource rate cost components to the cost elements. | ||
| CST_WO_RESOURCE_TXN_ID | NUMBER | 18 | Surrogate ID identifying the resource transaction interfaced to costing from manufacturing. | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order where the resource was consumed. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order operation where the resource was consumed. | |
| WORK_CENTER_ID | NUMBER | 18 | Surrogate ID identifying the work center where the resource was consumed. | ||
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | Surrogate ID identifying the resource association to a work order operation. This association can be used to derive resource sequence etc. | ||
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | The Activity associated to this resource transaction. This attribute will be used to derive resource rates post R11. Activity in the first release of fusion will be used to define any intra operation steps + any other custom run steps that the customer would like to track at the resource level. | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Identifies the cost transaction type such as RECEIPT or ISSUE. | |
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 20 | Additional Processing Code is an optional further definition of the Cost Transaction Type. It is used on adjustment transactions (Cost Transaction Type is set to 'ADJUST') and is set to 'WIP_STD_RESOURCE' when the adjustment was triggered by cost change; otherwise, it is set to null. | ||
| TXN_SOURCE_DOC_TYPE | VARCHAR2 | 50 | Document Type of the transaction. E.g. "WO" indicating a Work Order | ||
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | Document Number of the transaction. This is the Work Order Number. | ||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | For R11, this is the same as the Transaction Source Doc Type. In later release this can be a FPO linked to a WO. | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | For R11, this is the same as the Transaction Source Doc Number. In later release this can be a FPO Number linked to a WO. | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Transaction type identifier. For resource transactions this value comes from CST_INTERNAL_TXN_TYPES_VL.. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Transaction source type identifier. For resource transactions this value will come from CST_INTERNAL_TXN_TYPES_VL. This value will always be 0. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Transaction action identifier. For resource transactions this value will come from CST_INTERNAL_TXN_TYPES_VL.. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Identifies the date and time when the resource consumption happened. | ||
| COST_DATE | TIMESTAMP | This is the date at which the resource transaction is costed. This date will be used to derive the applicable rate for the transaction. Resource rate on the resource transactions is derived based on the cost date. This date can be different from the transaction date if the resource transaction is back dated. Cost date rules similar to inventory transaction needs to be followed for resource transactions also i.e. cost date is equal to the last date on which the resource transactions were processed for a cost organization - cost book combination. | |||
| COST_METHOD_CODE | VARCHAR2 | 30 | Cost method associated with the asset cost profile of the primary item. This will be useful when performing standard cost updates to WIP costs for resource transactions. | ||
| COMPONENT_GROUP_ID | NUMBER | 18 | Cost component group derived from the asset cost profile. | ||
| TRANSACTION_QUANTITY | NUMBER | Resource usage in transaction UOM. | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Identifies the unit of measure in which the transaction was performed. | ||
| PRIMARY_QUANTITY | NUMBER | Resource usage in primary UOM. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Identifies the primary UOM of the resource. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Indicates whether resource costs have been created for this resource transaction. Y-yes, N-no and E-error | ||
| PREPROCESSING_STATUS | VARCHAR2 | 30 | Yes | Preprocessing status of the transaction. SUCCESS - success ERROR- error | |
| ERROR_CODE | VARCHAR2 | 30 | FND error code identifying the error message in case the transaction is in error. | ||
| COSTING_STATUS | VARCHAR2 | 1 | Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting etc. C Fully costed E Error N Not processed P Partially costed X Excluded | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Current accounting status of the transaction for display: D Draft accounted E Error F Final accounted N Not accounted X Excluded from accounting Z Not applicable | ||
| 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. | ||
| PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJECTS_ALL_B.PROJECT_ID. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_RESOURCE_TXNS_S_GT_U1 | Unique | COST_ORG_ID, COST_BOOK_ID, NVL("CST_WO_RESOURCE_TXN_ID","RESOURCE_TRANSACTION_ID") |
| CST_RESOURCE_TXNS_S_GT_U2 | Unique | RESOURCE_TRANSACTION_ID |