1. Tables and Views for SCM
  2. DOS_PROD_RPT_MATERIALS

DOS_PROD_RPT_MATERIALS

Materials table for Contract Manufacturing Portal.

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

DOS_PROD_RPT_MATERIALS_PK

REPORT_MATERIAL_ID

Columns

Name Datatype Length Precision Not-null Comments
REPORT_MATERIAL_ID NUMBER 18 Yes The Primary Key for Materials table, System generated.
REPORT_OPERATION_ID NUMBER 18 Yes The Foreign Key in Materials table to Operations.
REPORT_ID NUMBER 18 Yes The Foreign Key in Materials table to Report Header.
TRANSACTION_DATE TIMESTAMP Yes The column indicates the date of transaction.
TRANSACTION_TYPE VARCHAR2 30 Yes Defines the nature of the material or operation transaction. Valid values are listed in the lookup with lookup_type= ORA_WIE_MTL_TXN_TYPE or OR_WIE_OP_TRANSACTION_TYPE.
TRANSACTION_CODE VARCHAR2 30 Yes This indicates the transaction code for the yield or issue. Valid values from lookup ORA_WIE_INT_BATCH_TYPE
TRANSACTION_NOTE VARCHAR2 4000 This column is exclusive to the WOLC transaction. This note is captured upon performing the WOLC Completion/Return/Scrap transactions. The underlying table in the UI to capture this information is WMTI. The note captured here will then be eventually passed on 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 WOLC will contain this captured transaction note.
INVENTORY_ITEM_NUMBER VARCHAR2 300 Yes The user key for the inventory item number.
ITEM_REVISION VARCHAR2 72 Revision of the item when the item is revision controlled.
TRANSACTION_QUANTITY NUMBER Yes Transactional quantity of the item that was either consumed or yielded.
TRANSACTION_UOM VARCHAR2 3 Yes Transactional unit of measure of the item that was either consumed or yielded.
SECONDARY_TRANSACTION_QUANTITY NUMBER Transactional quantity in the secondary unit of measure of the item that was either consumed or yielded.
SECONDARY_UOM VARCHAR2 3 Secondary unit of measure of the item that was either consumed or yielded.
PO_LINE_ID VARCHAR2 20 The Fusion Purchase Order Line ID. The system key identifier.
PO_LINE_NUMBER VARCHAR2 20 Yes OEM reference number for the purchase order line.
PO_SCHEDULE_ID NUMBER 18 To capture the Purchase Order Schedule Id in a regular Back to Back and the Contract Manufacturing flows.
PO_SCHEDULE_NUMBER VARCHAR2 20 OEM reference number for the purchase order schedule.
SUBINVENTORY VARCHAR2 40 Indicates the manufacturing facility subinventory.
LOCATOR_ID NUMBER 18 The unique Id for the manufacturing facility subinventory location.
LOCATOR VARCHAR2 360 Indicates the manufacturing facility subinventory location.
WORK_ORDER_SUBTYPE VARCHAR2 30 The sub type specifically will be populated for non standard work. This is used as to derive the appropriate costing account for non standard work.
WORK_ORDER_SERIAL VARCHAR2 80 The parent assembly serial number for which the material transaction is performed.
WORK_DEFINITION VARCHAR2 80 Denotes the work definition of making a product.
REASON_CODE VARCHAR2 30 This is only entered for the Scrap transaction for Order less Transaction and Return from Scrap for Order less Transaction.
INVENTORY_ITEM_ID NUMBER 18 Yes The primary product identifier defined in the work order.
PROCESSING_STATUS VARCHAR2 30 Indicates the status of interfacing to manufacturing.
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.
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.

Indexes

Index Uniqueness Tablespace Columns
DOS_PROD_RPT_MATERIALS_U1 Unique Default REPORT_MATERIAL_ID