CST_RESOURCE_TRANSACTIONS_GT
This transaction temporary table will be used to hold the generated resource transactions before they are finally inserted into the CST_RESOURCE_TRANSACTIONS table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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_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 unit of measure. | |||
| 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. | ||
| EQUIPMENT_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the equipment instance record. | ||
| LABOR_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the labor instance record. | ||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
| 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. | ||
| PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJ_ELEMENTS_B.PROJ_ELEMENT_ID (however uses an alias of TASK_ID). | ||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which a project-related transaction is incurred. | |||
| PJC_ORGANIZATION_ID | NUMBER | 18 | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is available to be billed to customers. Valid values are Y or N. | ||
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization. Valid values are Y or N. | ||
| PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project-related classification of the worked performed. | ||
| PJC_CONTRACT_ID | NUMBER | 18 | Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
| PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
| BASIS_TYPE | VARCHAR2 | 30 | Indicates the basis type for the resource/component usage rate. Fixed rate means that the resource/component is used once as per the resource usage rate for the entire batch. Variable rate means that for each item produced, the resource/component is used as per the resource usage rate specified. A value of 1 indicate 'Variable'. A value of 2 indicate 'Fixed'. | ||
| ASSEMBLY_ASSET_ID | NUMBER | 18 | The work order asset for which the resource transactions are performed. | ||
| SERVICE_WIP_FLAG | VARCHAR2 | 1 | This column is stamped only for transactions associated to maintenance work orders. This indicates if this transaction is to be costed as Service WIP in place of maintenance expense. | ||
| DEBRIEF_LINE_ID | NUMBER | 18 | This column is stamped only for transactions associated to maintenance work orders from RCL (Service Logistics). This identifies the debrief line id. |