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 | COST_ORG_ID | |
| COST_BOOK_ID | NUMBER | 18 | Yes | COST_BOOK_ID | |
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | INVENTORY_ORGANIZATION_ID | |
| RESOURCE_ID | NUMBER | 18 | Yes | RESOURCE_ID | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | INVENTORY_ITEM_ID | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | ITEM_COST_PROFILE_ID | ||
| COST_PROFILE_ID | NUMBER | 18 | COST_PROFILE_ID | ||
| CST_WO_RESOURCE_TXN_ID | NUMBER | 18 | CST_WO_RESOURCE_TXN_ID | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | CST_WORK_ORDER_ID | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | CST_WORK_ORDER_OPERATION_ID | |
| WORK_CENTER_ID | NUMBER | 18 | WORK_CENTER_ID | ||
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | WO_OPERATION_RESOURCE_ID | ||
| 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 | TXN_SOURCE_DOC_TYPE | ||
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | TXN_SOURCE_DOC_NUMBER | ||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | TXN_SOURCE_REF_DOC_TYPE | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | TXN_SOURCE_REF_DOC_NUMBER | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | BASE_TXN_TYPE_ID | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | BASE_TXN_SOURCE_TYPE_ID | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | BASE_TXN_ACTION_ID | |
| TRANSACTION_DATE | TIMESTAMP | Yes | TRANSACTION_DATE | ||
| COST_METHOD_CODE | VARCHAR2 | 30 | COST_METHOD_CODE | ||
| COMPONENT_GROUP_ID | NUMBER | 18 | COMPONENT_GROUP_ID | ||
| TRANSACTION_QUANTITY | NUMBER | TRANSACTION_QUANTITY | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | TRANSACTION_UOM_CODE | ||
| PRIMARY_QUANTITY | NUMBER | PRIMARY_QUANTITY | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | PRIMARY_UOM_CODE | ||
| POSTED_FLAG | VARCHAR2 | 5 | POSTED_FLAG | ||
| PREPROCESSING_STATUS | VARCHAR2 | 30 | Yes | PREPROCESSING_STATUS | |
| ERROR_CODE | VARCHAR2 | 30 | ERROR_CODE | ||
| 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'. |