CST_WO_RESOURCE_TXNS
This is the persistent table used to hold the resource transactions interfaced from source manufacturing systems. This table will act as source of truth for all resource transaction reference in costing downstream tables.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_RESOURCE_TXNS_PK |
CST_WO_RESOURCE_TXN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_WO_RESOURCE_TXN_ID | NUMBER | 18 | Yes | Surrogate ID identifying the resource transaction in costing. | |
| 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. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Code identifying the external system owning this resource transaction. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the resource transaction in the source system. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order in costing. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the operation in the work order tied to this resource. | |
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the plant where the resource was consumed. This attribute will be derived from the work order and de-normalized to improve performance. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the primary product on the work order. This attribute will be derived from the work order and de-normalized to improve performance. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Resource transaction type identifier. For resource transactions it would be a costing internal transaction type defined in CST_INTERNAL_TXN_TYPES_VL. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Resource transaction source type identifier. For resource transactions it would be a costing internal transaction type defined in CST_INTERNAL_TXN_TYPES_VL. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Resource transaction action identifier. For resource transactions it would be a costing internal transaction type defined in CST_INTERNAL_TXN_TYPES_VL. | |
| WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order in the source system. | |
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying the work order operation in the source system. | ||
| WORK_CENTER_ID | NUMBER | 18 | The work center where the resource is charged. | ||
| RESOURCE_ID | NUMBER | 18 | Yes | Surrogate ID identifying the resource. This is a foreign key reference to the resource master at the plant level. | |
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | 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. | ||
| BASIS_TYPE | VARCHAR2 | 10 | Yes | Whether the charging is done on a variable basis (per each unit of the assembly) or fixed per work order. | |
| CHARGE_TYPE | VARCHAR2 | 30 | Whether resource transactions were automatically generated and at what stage. Valid values are "MANUAL", OPERATION_MOVE", "PO_RECEIVE". | ||
| TRANSACTION_QUANTITY | NUMBER | Yes | Quantity of resource to be charged. | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure for the transacted units. | |
| PRIMARY_QUANTITY | NUMBER | Yes | Transaction quantity converted using the primary UOM of the primary product. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | Primary unit of measure for the primary product in the work order. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Date and time when the resource transaction is performed. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifies the transaction type. Currently the only value is RESOURCE. | |
| WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | When the Auto-Transact is checked at the operation level, the operation completion that moves the primary product quantity out of the operation triggers the creation of resource transactions. In such cases, we will have the operation transaction id that triggered this resource transaction. | ||
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | The operation-resource reference from the work order. | ||
| CST_WO_OPERATION_TXN_ID | NUMBER | 18 | Surrogate ID identifying the work order operation transaction in costing that triggered this resource transaction. | ||
| PROCESSED_BY_CA_FLAG | VARCHAR2 | 5 | Flag to indicate whether the row has been processed by cost accounting. | ||
| 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_WO_RESOURCE_TXNS_N1 | Non Unique | Default | CST_WORK_ORDER_ID, CST_WORK_ORDER_OPERATION_ID, TRANSACTION_DATE |
| CST_WO_RESOURCE_TXNS_PK | Unique | Default | CST_WO_RESOURCE_TXN_ID |
| CST_WO_RESOURCE_TXNS_U1 | Unique | Default | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |