CST_WO_RESOURCE_TXNS_GT
Transaction Global temporary table exposed for external systems, e.g. MFG, to transfer resource transaction information related to a work order. External systems will directly write to this table and then invoke a plsql api to transfer the data from their system to cost management.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_RESOURCE_TXNS_GT_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". | ||
| 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 code. Currently only value supported 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. | ||
| STATUS_CODE | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Indicates the transfer status of this row. SUCCESS or ERROR depending on whether the row was successfully posted to the interface table. | ||
| ERROR_MESSAGE_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. FND error message name identifying the error that occurred during import. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Internal, should not be populated by interfacing application. Token name. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Token Value. | ||
| MESSAGE_TEXT | VARCHAR2 | 240 | Internal, should not be populated by interfacing application. Expanded, token substituted MESSAGE_TEXT from the FND table. | ||
| 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. | ||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | Manufacturing organization identifier in which the work order is created for this resource transaction. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WO_RESOURCE_TXNS_GT_PK | Unique | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |