CST_WO_RESOURCE_TXNS_INT
This is the interface table to store the resource transactions related to works orders in the manufacturing systems. This table will temporarily store the resource transaction details from source manufacturing systems. Once preprocessor processes these transactions, they will be persisted in another table and removed from this table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_RESOURCE_TXNS_INT_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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. | |
| 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" PO_RECEIVE is for OSP operation when the services are received from a supplier. Hence it is not in the release 11 scope. | ||
| 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 only possible 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. | ||
| PREPROCESSING_STATUS | VARCHAR2 | 1 | Indicates the preprocessing status of the row. | ||
| 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. | ||
| 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. | ||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Manufacturing organization identifier in which the work order is created for this resource transaction. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WO_RESOURCE_TXNS_INT_N1 | Non Unique | Default | PREPROCESSING_STATUS, EXTERNAL_SYSTEM_REFERENCE, WORK_ORDER_ID, WORK_ORDER_OPERATION_ID |
| CST_WO_RESOURCE_TXNS_INT_PK | Unique | Default | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |