WIE_MATERIAL_TRANSACTIONS_INT
This is the interface table for work order material transactions. Production progress updates, in terms of material consumption and production, are interfaced from either third party systems or from contract manufacturers via this interface table. All material transactions are eventually sent as inventory updates and reservation changes to Logistics.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
WIE_MTL_TRANSACTIONS_INT_PK |
INTERFACE_ROW_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of a material transaction interface record. Its value is an application generated unique id. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
INTERFACE_BATCH_CODE | VARCHAR2 | 30 | Represents the user identified code for the interface batch. | ||
INTERFACE_BATCH_ID | NUMBER | 18 | Represents the internal interface batch identifier. This is used to group a batch of interface records for processing. When interface records are brought in via services or the UI, the system will internally generate this value. | ||
INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Yes | Represents the progress of the interface processing with statuses such as ready for processing or currently in process as well as the various flavors of completion statuses. Valid values exist in the lookup with lookup type = ORA_WIE_INTERFACE_STATUS. | |
TXN_HEADER_NUMBER | VARCHAR2 | 18 | This is a user loaded key that uniquely identifies the transaction within the batch. This user key will be used as a handle to connect the child entities (i.e. the WIE_TRANSACTION_LOTS_INT and WIE_TRANSACTION_SERIALS_INT tables) to this parent transaction table. | ||
PARENT_HEADER_NUMBER | VARCHAR2 | 18 | This is a user loaded key that is used to allow reporting of lot or serial controlled components to an orderless transaction. This field will link the material transaction record to the orderless transaction record to create the parent/child relationship. | ||
ORGANIZATION_CODE | VARCHAR2 | 30 | The organization code that represents the manufacturing plant to which this material transaction is performed. | ||
ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this material transaction is performed. | ||
WORK_CENTER_ID | NUMBER | 18 | The identifier of the work center to which this material transaction is being performed. This is an internally derived column for the purpose of transferring data to inventory. | ||
WORK_ORDER_NUMBER | VARCHAR2 | 120 | Represents the user-facing identifier of the work order. Material transactions are always performed in the context of a work order. | ||
WORK_ORDER_ID | NUMBER | 18 | Represents the internal identifier of the work order. Material transactions are always performed in the context of a work order. | ||
WORK_ORDER_TYPE | VARCHAR2 | 30 | Indicates the type of this work order. Valid values exist in the lookup with lookup type = ORA_WIE_WO_TYPE. | ||
WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | The subtype will be populated for non-standard work. This is used to derive the appropriate costing account for non-standard work. Valid values exist in the lookup with lookup type = ORA_WIE_WO_SUB_TYPE. | ||
WO_OPERATION_SEQ_NUMBER | NUMBER | Represents the work order operation sequence from which this material transaction is being performed. | |||
WO_OPERATION_ID | NUMBER | 18 | The internal identifier of the operation from which the primary product quantity is transacted. | ||
WO_MATERIAL_SEQ_NUMBER | NUMBER | Work Order Operation Material Sequence Number | |||
INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | The user key for the inventory item number. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | The primary product identifier defined on the work order. This is an internal column and is de-normalized. | ||
ITEM_REVISION | VARCHAR2 | 18 | Revision of the item when the item is revision controlled. | ||
OUTPUT_TYPE | VARCHAR2 | 30 | Type of output produced by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_OUTPUT_MATERIAL. | ||
TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Defines the nature of the material transaction. Valid values are listed in the lookup with lookup type = ORA_WIE_MTL_TXN_TYPE. | |
TRANSACTION_DATE | TIMESTAMP | Yes | Date when the material transaction is performed. | ||
TRANSACTION_QUANTITY | NUMBER | Yes | Material quantity that is being transacted. | ||
REQUIRED_QUANTITY | NUMBER | Material quantity that is required for pull components or orderless transactions. | |||
ISSUED_QUANTITY | NUMBER | Represents the previously issued quantity based on an aggregation of data from the INV_MATERIAL_TXNS table. This is a calculated column used by the UI to quickly display the previously issued quantity. | |||
BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the item quantity is fixed (i.e. quantity per lot produced) or variable (i.e. quantity per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. | ||
TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the material quantity being transacted. | ||
TRANSACTION_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure of the material quantity being transacted. | ||
SECONDARY_TRANSACTION_QUANTITY | NUMBER | Represents the secondary quantity for a material transaction if the item is dual UOM enabled. | |||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | Represents the secondary UOM for a material transaction if the item is dual UOM enabled. | ||
SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the secondary unit of measure for a material transaction if the item is dual UOM enabled. | ||
REASON_CODE | VARCHAR2 | 30 | Indicates the reason code for the material transaction. Primarily used when material is being scrapped. | ||
SUBINVENTORY_CODE | VARCHAR2 | 18 | Subinventory where the material is drawn from or where the products are completed. | ||
LOCATOR_SEGMENT1 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT2 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT3 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT4 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT5 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT6 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT7 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT8 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT9 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT10 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT11 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT12 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT13 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT14 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT15 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT16 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT17 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT18 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT19 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_SEGMENT20 | VARCHAR2 | 40 | Represents the locator flexfield segment. | ||
LOCATOR_ID | NUMBER | The inventory locator where the materials are drawn from or where the products are completed to. | |||
WORK_METHOD_CODE | VARCHAR2 | 30 | Represents the work method code for which this material transaction is applicable. | ||
WORK_METHOD_ID | NUMBER | 18 | Represents the work method for which this material transaction is applicable. It is a foreign key to the WIS_WORK_METHODS_B table. | ||
WORK_DEFINITION_CODE | VARCHAR2 | 30 | Represents the user key to the work definition. | ||
WORK_DEFINITION_ID | NUMBER | 18 | Represents the work definition identifier which is a foreign key to the WIS_WORK_DEFINITIONS table. | ||
WORK_DEFINITION_VERSION | NUMBER | Represents the user key of the work definition version. | |||
WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Represents the work definition version identifier which is a foreign key to the WIS_WD_VERSIONS table. | ||
SOLD_TO_LEGAL_ENTITY_ID | NUMBER | 18 | The legal entity identifier of the enterprise that is procuring goods/services from the supplier. | ||
SOLD_TO_LEGAL_ENTITY_NAME | VARCHAR2 | 240 | The legal entity name of the enterprise that is procuring goods/services from the supplier. | ||
PO_NUMBER | VARCHAR2 | 30 | The user key to the Fusion Purchase Order Number. | ||
PO_HEADER_ID | NUMBER | 18 | The Fusion Purchase Order Identifier. The system key. | ||
PO_LINE_NUMBER | NUMBER | The Fusion Purchase Order Line Number. The user key. | |||
PO_LINE_ID | NUMBER | 18 | The Fusion Purchase Order Line Number. The system key identifier. | ||
SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | Indicates the type of source system (i.e. internal or external) from which data is being imported. Valid values exist in the lookup with lookup type = ORA_WIE_SOURCE_SYSTEM_TYPE. | ||
SOURCE_SYSTEM_ID | NUMBER | Represents the identifier of the source system. If the source system type = "INTERNAL" this value equates to the application id. If "EXTERNAL", then it is the source system as defined in the trading community (TCA) source systems table. | |||
SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | A code used to indicate the source system from which data is being imported. Depending on the source system type, this value could represent an internal Fusion product code or the actual trading community (TCA) source system reference. | ||
SOURCE_HEADER_REF | VARCHAR2 | 240 | Represents the source system's user-facing header reference identifier. | ||
SOURCE_HEADER_REF_ID | NUMBER | 18 | Represents the source system's internal header reference identifier. | ||
SOURCE_LINE_REF | VARCHAR2 | 240 | Represents the source system's user-facing line reference identifier. | ||
SOURCE_LINE_REF_ID | NUMBER | 18 | Represents the source system's internal line reference identifier. | ||
WO_OP_TXN_INTERFACE_ROW_ID | NUMBER | 18 | This is an internal column that is used to link backflush material transaction interface records to an associated operation transaction interface record. | ||
WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | To complete the interface cycle, the operation transaction processor updates the operation_transaction_id in this table after successfully processing the transactions. | ||
ASSEMBLY_SERIAL_NUMBER | VARCHAR2 | 80 | The parent assembly serial number for which the material transaction is performed. | ||
ASSET_ID | NUMBER | 18 | The reference to the component asset when the material issued or returned is tracked in the asset repository. | ||
PARENT_ASSET_ID | NUMBER | 18 | Parent asset identifier of the component that is being removed or installed. | ||
PARENT_LOT_NUMBER | VARCHAR2 | 80 | The lot number for the parent asset on which the material is issued to or returned from. | ||
PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | Parent serial number of the component that is being removed or installed. | ||
PARENT_INVENTORY_ITEM_ID | NUMBER | 18 | Parent item of the component that is being removed or installed. | ||
DEFER_GEN_RELATIONSHIP_FLAG | VARCHAR2 | 1 | Flag indicating that the relationship processing in the MFG->ALM genealogy integration are to be deferred. | ||
INV_TRANSACTION_INTERFACE_ID | NUMBER | 18 | This is the identifier of the record that is written into the INV_TRANSACTIONS_INTERFACE table to process the completion (or the return) material transaction. | ||
INV_TRANSACTION_HEADER_ID | NUMBER | 18 | This is the TRANSACTION_HEADER_ID that we populate in INV_TRANSACTIONS_INTERFACE. This acts as a group handle in invoking the online inventory API. When the move transaction process is also writing backflush component consumption records in INV_TRANSACTIONS_INTERFACE, we will populate the same TRANSACTION_HEADER_ID value for the backflush transaction. | ||
INV_TRANSACTION_BATCH_ID | NUMBER | 18 | This is an internal inventory interface identifier that can be used to group logical transactions that must be processed in a logical unit. This controls the behavior of whether the logical unit should be processed together as a set. This column is used for internal processing. | ||
INV_TRANSACTION_ID | NUMBER | 18 | Upon successful processing of the material transaction by the inventory material transaction process online API, we record the successful INV_MATERIAL_TXNS.TRANSACTION_ID in this column. The INV online API returns this value. | ||
TRANSACTION_NOTE | VARCHAR2 | 4000 | This column is exclusive to the work orderless completion transaction. This note is captured upon performing the orderless completion/return/scrap transactions. This note is assigned to the last operation transaction that is created based on the work definition data. Users will be able to review operation transactions and the last operation transaction for orderless completions will contain this transaction note. | ||
TXN_SORT_ORDER | NUMBER | This is an internal column used by the Material Transaction train stop in the Dispatch List UI and Work Order Less Completion UI. The internal routine that gathers the backflush materials (both issue and return) materials that are tied to the operation transaction populates this column with a sequence number that is used when displaying the material rows on the UI. | |||
WORKER_ID | NUMBER | The partition number for multi-threading. | |||
USE_COMMON_INVENTORY_FLAG | VARCHAR2 | 1 | Flag to determine whether material should be issued/returned from common inventory or from the project associated with the work order. A value of Y indicates material should be issued/returned from common inventory. A value of N indicates material should be issued/returned from the project associated with the work order. | ||
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_PROJECT_NUMBER | VARCHAR2 | 25 | The number assigned to a project. | ||
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_TASK_NUMBER | VARCHAR2 | 100 | The identifying number for a task which is a subdivision of project work. | ||
INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes. | ||
PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions. | ||
TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions. | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions. | ||
INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality. | ||
INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality. | ||
INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
REPAIR_TXN_CODE_ID | NUMBER | 18 | Foreign key reference to CSE condition events. | ||
REPAIR_TXN_CODE | VARCHAR2 | 30 | The unique code which identifies the repair transaction CSE condition event. | ||
ASSEMBLY_ASSET_ID | NUMBER | 18 | The work order asset for which the material transactions are performed. | ||
DISCRIMINATOR | VARCHAR2 | 30 | Discriminator value for achieving entity level polymorphism. | ||
INV_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
INV_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
INV_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
INV_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
LOAD_REQUEST_ID | NUMBER | 18 | This column is used when loading data from the csv file to the interface table using the central ESS program. This is the request id for the job that did the move from UCM to the interface table. | ||
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 | Status |
---|---|---|---|---|
WIE_MTL_TRANSACTIONS_INT_N01 | Non Unique | Default | WORK_ORDER_ID | |
WIE_MTL_TRANSACTIONS_INT_N02 | Non Unique | Default | WORK_ORDER_NUMBER, ORGANIZATION_CODE | |
WIE_MTL_TRANSACTIONS_INT_N03 | Non Unique | Default | WORK_ORDER_NUMBER, ORGANIZATION_ID | |
WIE_MTL_TRANSACTIONS_INT_N04 | Non Unique | Default | INV_TRANSACTION_HEADER_ID | Obsolete |
WIE_MTL_TRANSACTIONS_INT_N05 | Non Unique | Default | REQUEST_ID, INTERFACE_STATUS_CODE, TRANSACTION_TYPE_CODE | |
WIE_MTL_TRANSACTIONS_INT_N06 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, PARENT_HEADER_NUMBER | |
WIE_MTL_TRANSACTIONS_INT_N07 | Non Unique | Default | WORKER_ID, INTERFACE_STATUS_CODE, TRANSACTION_TYPE_CODE | |
WIE_MTL_TRANSACTIONS_INT_N08 | Non Unique | Default | INV_TRANSACTION_ID, INTERFACE_STATUS_CODE, TRANSACTION_TYPE_CODE | |
WIE_MTL_TRANSACTIONS_INT_N09 | Non Unique | Default | INV_TRANSACTION_HEADER_ID, INTERFACE_STATUS_CODE, TRANSACTION_TYPE_CODE | |
WIE_MTL_TRANSACTIONS_INT_N10 | Non Unique | Default | LAST_UPDATE_DATE, INTERFACE_STATUS_CODE | |
WIE_MTL_TRANSACTIONS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |