DOS_PROD_RPT_HEADER
Header table for Contract Manufacturing Portal.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOS_PROD_RPT_HEADER_PK |
REPORT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REPORT_ID | NUMBER | 18 | Yes | The primary key for Report Header table, the report identifier. | |
| HEADER_NUMBER | VARCHAR2 | 120 | Yes | This identifies a report that may contain several progress report lines for one or more Purchase Order lines. There may be more than one report with the same Header Number if revisions are uploaded. | |
| UPLOAD_DATE | TIMESTAMP | Yes | The date when the report was uploaded. | ||
| SUPPLIER_ID | NUMBER | 18 | Yes | This column is used as the supplier identifier. | |
| SUPPLIER_NUMBER | VARCHAR2 | 360 | Yes | This column identifies a supplier by unique name. | |
| SUPPLIER_SITE_ID | NUMBER | 18 | Yes | Used for data security; available from Purchase Order. | |
| SUPPLIER_SITE_CODE | VARCHAR2 | 240 | This column denotes the supplier site code. | ||
| REPORT_REVISION_NUMBER | VARCHAR2 | 20 | Yes | Revision number of the report, if multiple reports are uploaded for the same WO/PO combination. This will be used when collaboration is enabled between a Contract Manufacturer and the OEM. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Fusion Organization ID in which the Contract Manufacturer is placed. | |
| ORGANIZATION_CODE | VARCHAR2 | 18 | Fusion Organization code in which the Contract Manufacturer is placed. | ||
| WORK_ORDER_ID | NUMBER | 18 | OEM Work Order ID that is provided in the Purchase Order to the Contract Manufacturer. | ||
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Yes | OEM Work Order number that is provided in the Purchase Order to the Contract Manufacturer. SCO will use it to update the right Work Order in Fusion. | |
| PURCHASE_ORDER_ID | NUMBER | 18 | Yes | OEM reference ID for the purchase order. | |
| PURCHASE_ORDER_NUMBER | VARCHAR2 | 120 | Yes | OEM reference number for the purchase order; alphanumeric allowed. | |
| SOLD_TO_LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Indicates the ID of the OEM legal entity that holds the contract to the contract manufacturer. | |
| SOLD_TO_LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Yes | OEM legal entity that holds the contract to the contract manufacturer. | |
| CM_INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Contract Manufacturer Item Identifier | |
| CM_INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Contract Manufacturer Item number. | ||
| CM_ITEM_REVISION | VARCHAR2 | 72 | Contract Manufacturer Item Revision. | ||
| WO_INVENTORY_ITEM_ID | NUMBER | 18 | Work Order Product ID which is outsourced. | ||
| WO_INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Work Order Product number which is outsourced. | ||
| WO_ITEM_REVISION | VARCHAR2 | 72 | Work Order Product revision which is outsourced. | ||
| BATCH_CODE | VARCHAR2 | 30 | This column indicates the batch code. | ||
| SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | Indicates the source code of the request. | ||
| DUE_DATE | TIMESTAMP | Indicates the due date of the report. | |||
| PROCESSING_STATUS | VARCHAR2 | 30 | Yes | Indicates the status of interfacing to manufacturing. | |
| ACTIVE_FLAG | VARCHAR2 | 1 | Yes | Indicates the active version of the Report, if report is versioned. | |
| REPORT_PREPARER | VARCHAR2 | 50 | Preparer of the report (not necessarily one who uploads file). | ||
| 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_HEADER_N1 | Non Unique | Default | SUPPLIER_SITE_ID |
| DOS_PROD_RPT_HEADER_N2 | Non Unique | Default | SUPPLIER_ID |
| DOS_PROD_RPT_HEADER_U1 | Unique | Default | REPORT_ID |
| DOS_PROD_RPT_HEADER_U2 | Unique | Default | UPLOAD_DATE, PURCHASE_ORDER_NUMBER, WORK_ORDER_NUMBER |