| Process Manufacturing Product Development - LM_FORM_DAT | OBSOLETE as of 11.5.6 (OPM PF.G) |
|---|---|
| Column Name | Descritpion |
| NUM_DATA | Technical data for numeric technical parameters. |
| BOOLEAN_DATA | Technical data for boolean technical parameters. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| IN_USE | Not currently used |
| LAB_TYPE | Laboratory type. |
| ORGN_CODE | Organization Code |
| FORMULALINE_ID | Surrogate to lab formula detail line. |
| TECH_PARM_NAME | Technical parameter name. |
| SORT_SEQ | Sorting sequence. |
| TEXT_DATA | Technical data for character technical parameters. |
| Process Manufacturing Product Development - LM_FORM_DTL | OBSOLETE as of 11.5.6 (OPM PF.G) |
|---|---|
| Column Name | Descritpion |
| FORMULALINE_ID | Lab formula detail line surrogate. |
| RELEASE_TYPE | 0=automatic release; 1=partial release. |
| ATTRIBUTE15 | Descriptive Flexfield Segment |
| ATTRIBUTE16 | Descriptive Flexfield Segment |
| SCRAP_FACTOR | Scrap factor decimal used to calculate required qty. |
| ATTRIBUTE17 | Descriptive Flexfield Segment |
| ATTRIBUTE18 | Descriptive Flexfield Segment |
| SCALE_TYPE | 0=fixed, no scaling; 1=proportional scaling. |
| ATTRIBUTE19 | Descriptive Flexfield Segment |
| ATTRIBUTE20 | Descriptive Flexfield Segment |
| COST_ALLOC | If product, fractional cost absorption. |
| ATTRIBUTE21 | Descriptive Flexfield Segment |
| ATTRIBUTE22 | Descriptive Flexfield Segment |
| TPFORMULA_ID | Surrogate key indicating the lab formula/version from which the technical parameters of an item are calculated. |
| ATTRIBUTE23 | Descriptive Flexfield Segment |
| ATTRIBUTE24 | Descriptive Flexfield Segment |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ATTRIBUTE25 | Descriptive Flexfield Segment |
| ATTRIBUTE26 | Descriptive Flexfield Segment |
| ATTRIBUTE27 | Descriptive Flexfield Segment |
| ATTRIBUTE28 | Descriptive Flexfield Segment |
| LAST_UPDATED_BY | Standard who column |
| ATTRIBUTE29 | Descriptive Flexfield Segment |
| ATTRIBUTE30 | Descriptive Flexfield Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
| CREATED_BY | Standard who column |
| FORMULA_ID | Surrogate key for a formula/version. |
| LAST_UPDATE_DATE | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LINE_NO | List order on screen within a line_type. |
| ATTRIBUTE1 | Descriptive Flexfield Segment |
| ATTRIBUTE2 | Descriptive Flexfield Segment |
| LINE_TYPE | 1=product; -1=ingredient; 2=byprod. |
| ATTRIBUTE3 | Descriptive Flexfield Segment |
| ATTRIBUTE4 | Descriptive Flexfield Segment |
| ITEM_ID | Item surrogate (ic_item_mst). |
| ATTRIBUTE5 | Descriptive Flexfield Segment |
| ATTRIBUTE6 | Descriptive Flexfield Segment |
| QTY | Item qty produced or consumed. |
| ATTRIBUTE7 | Descriptive Flexfield Segment |
| ATTRIBUTE8 | Descriptive Flexfield Segment |
| ITEM_UM | Uom of qty. |
| ATTRIBUTE9 | Descriptive Flexfield Segment |
| ATTRIBUTE10 | Descriptive Flexfield Segment |
| PHANTOM_TYPE | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
| ATTRIBUTE11 | Descriptive Flexfield Segment |
| ATTRIBUTE12 | Descriptive Flexfield Segment |
| REWORK_TYPE | Future use. 0=not rework; 1=non-netablerework. |
| ATTRIBUTE13 | Descriptive Flexfield Segment |
| ATTRIBUTE14 | Descriptive Flexfield Segment |
| Process Manufacturing Product Development - LM_FORM_MST | OBSOLETE as of 11.5.6 (OPM PF.G) |
|---|---|
| Column Name | Descritpion |
| FORMULA_ID | Surrogate for formula_no+formula_vers. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| ATTRIBUTE27 | Descriptive flexfield segment |
| ATTRIBUTE28 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield segment |
| IN_USE | Not currently used |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| FORMULA_NO | Alphanumeric lab formula name or number. |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| INACTIVE_IND | Indicates whether the formula is active or inactive. 0=Active, 1=Inactive. |
| FORMULA_VERS | Lab formula version. |
| FORMULA_DESC1 | Lab formula description. |
| FORMULA_DESC2 | Lab formula comment. |
| FORMULA_CLASS | Formula class. |
| FMCONTROL_CLASS | Reserved for future use. |
| SCALE_TYPE | Controls scaling behavior of formula. 0=fixed; 1=scaleable. |
| FORMULA_TYPE | Not relevant for lab formulas. 0=std formula; 1=packaged item formula. |
| Process Manufacturing Product Development - LM_ITEM_DAT | Laboratory management item data |
|---|---|
| Column Name | Descritpion |
| LM_ITEM_DAT_ID | Surrogate key for this record |
| NUM_DATA | Technical data for numeric technical parameters. |
| BOOLEAN_DATA | Technical data for boolean technical parameters. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| TRANS_CNT | Not currently used |
| ORGN_CODE | Organization Code |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| LAB_TYPE | Laboratory type. |
| ITEM_ID | Surrogate key for item. |
| LOT_ID | Surrogate key for ic_lots_mst, lot_no and ic_lots_mst, sublot_no. |
| FORMULA_ID | Surrogate key for the lab formula which produced this item, if the item is a product in a llab formula. Items may have different technical parameters values depending on the formula used to produce them. |
| TECH_PARM_NAME | Technical parameter name. |
| SORT_SEQ | Sorting sequence. |
| TEXT_DATA | Technical data for character technical parameters. |
| Process Manufacturing Product Development - LM_LTYP_MST | Laboratory type master |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| TRANS_CNT | Not currently used |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| LAST_UPDATE_LOGIN | Standard who column |
| SHARED_LAB_TYPE | Code identifying another lab type whose technical parameters the lab type shares. |
| LAB_DESCRIPTION | Description of the lab type. |
| LAB_TYPE | Code identifying the lab type. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ACTIVE_IND | 0=Inactive, 1=Active. |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| ATTRIBUTE27 | Descriptive flexfield segment |
| ATTRIBUTE28 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
| SHARED_ORGN_CODE | Code identifying another orgnization code whose technical parameters the organization code shares. |
| Process Manufacturing Product Development - LM_PRLT_ASC | Laboratory technical parameter association |
|---|---|
| Column Name | Descritpion |
| ORGN_CODE | Organization Code |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| TRANS_CNT | Not currently used |
| LAB_TYPE | Laboratory type. |
| TECH_PARM_NAME | Name of the technical paraemeter. |
| SORT_SEQ | Number that determines the order in which technical parameters are sorted for display and calculation. |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - LM_SPRD_DTL | Table to store Lab Spreadsheet detail |
|---|---|
| Column Name | Descritpion |
| LINE_ID | Surrogate id used to access line items on the spreadsheet |
| TPFORMULA_ID | Surrogate id to access lm_form_mst for the formula used for the tech parameter values |
| REVISION | This is the column to identify the item revision |
| SECONDARY_UOM | This is the column to identify the item secondary uom |
| FORMULALINE_ID | Surrogate id used to access lm_form_dtl for the formulaline used for the tech parameters |
| DETAIL_UOM | This is the column to identify the material detail uom |
| GRADE_CODE | This is the column to identify the grade of the material |
| LAB_TYPE | Lab Type for which this spreadsheet was created |
| SUBINVENTORY_CODE | This is the column to identify the subinventory where the material |
| LOT_NUMBER | This is the column to identify the LOT where materil is taken |
| LAST_UPDATE_LOGIN | Standard who column |
| EXPIRATION_DATE | This is the column to identify the lost expiration date |
| MOVE_ORDER_LINE_ID | This is the column to identify the move order |
| PLANT_ORGANIZATION_ID | This is the column to identify if the item is revision controlled |
| REVISION_QTY_CONTROL_CODE | This is the column to identify if the item is revision controlled. |
| LAST_UPDATE_DATE | Standard who column |
| RESERVATION_ID | This is the column to identify if the material is reserved. |
| TRANSACTION_ID | This is the column to identify if the material is transacted |
| LOCATOR_ID | This is the column to identify if the material's location |
| LAST_UPDATED_BY | Standard who column |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| ORGN_CODE | Organization Code |
| SPRD_ID | Surrogate id for the spreadsheet |
| ROLLUP_IND | The rollup indicator for using the technical values |
| MATERIAL_DETAIL_ID | The batch line id for the saved line |
| LINE_TYPE | 1=product; -1=ingredient; 2=byprod. |
| LOT_ID | The lot surrogate, if the saved line is a lot record |
| QC_GRADE | The quality grade of the lot |
| LINE_NO | List order on screen within a line_type. |
| TRANS_ID | The transaction id for allocations saved from batch |
| SECONDARY_QTY | The secondary qty for the line |
| ITEM_ID | Surrogate key used to reference ic_item_mst for item in the Bill of Materials |
| SECONDARY_UM | The secondary um for the line |
| WHSE_CODE | The warehouse for the line allocation |
| QTY | Line quantity on spreadsheet |
| LOCATION | The location for the line allocation |
| BUFFER_IND | Buffer Indicator is used in save simulator |
| ITEM_UM | Unit of measure in which the quantity was expressed |
| PLANT_CODE | Plant code field |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ORGANIZATION_ID | This is the column to identify the lab organization |
| INVENTORY_ITEM_ID | This is the column to identify the item number |
| Process Manufacturing Product Development - LM_SPRD_FLS | Laboratory Spreadsheets files |
|---|---|
| Column Name | Descritpion |
| SPRD_ID | Surrogate key for the operator code/spreadsheet. |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAB_TYPE | The Lab Type from Lab type master |
| ORGN_CODE | Organization Code |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| IN_USE | Not currently used |
| BATCH_ID | The batch for which the spreadsheet is saved |
| MAINTAIN_TYPE | Maintain type is used in save simulator |
| SPRD_NAME | Name which the spreadsheet was saved. |
| MOVE_ORDER_HEADER_ID | This is the column to identify the batch move order header |
| LAB_ORGANIZATION_ID | This is the column to identify the lab organization |
| ACTIVE_IND | Not currently used. |
| FORMULA_ID | The foreign key to Lab form master |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Process Manufacturing Product Development - LM_SPRD_PRM | Table used to store the technical paramter definitions that belong with the spreadsheet |
|---|---|
| Column Name | Descritpion |
| QC_ORGN_CODE | Orgnanization code under which the QC assay was created IF the tech parameter is a QC assay, or null if not |
| QC_ASSAY_NAME | Name of QC assay IF the tech parameter is a QC assay, or null if not |
| DATA_TYPE | The data type of the technical parameter. 0=Character, 1=Numeric, 2=Validation List, 3=Boolean, 4=Expression, 5=Weight Percent, 6=Volume Percent, 7=Specific Gravity, 8=Cost, 9=Equivalent Weight, 10=Quantity per Unit. |
| EXPRESSION_CHAR | The expression used to calculate the technical parameter, for data type 4 (Expression). |
| LM_UNIT_CODE | The unit of measure in which the technical parameter value is expressed. |
| TECH_PARM_ID | The technical parameter surrogate key |
| MAX_VALUE | Parameter maximun value has to be saved to simulator |
| OPTIMIZE_TYPE | Optimize type is used in save simulation |
| PRECISION | Parameter precision has to be saved to simulator |
| MIN_VALUE | Parameter minimum value has to be saved in simulator |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| ORGANIZATION_ID | This is the column to identify the organization for parameters |
| ORGN_CODE | Organization Code |
| SPRD_ID | Surrogate id for spreadsheet |
| LAB_TYPE | Lab type for which the spreadsheet was created |
| TECH_PARM_NAME | Technical parameter name from lm_tech_prm |
| SORT_SEQ | Sort sequence for parameter on the spreadsheet |
| Process Manufacturing Product Development - LM_SPRD_TEC | Table used to store the values of the technical parameters on the spreadsheet |
|---|---|
| Column Name | Descritpion |
| LINE_ID | Surrogate id used to access lm_form_dtl |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| ORGN_CODE | Organization Code |
| TECH_PARM_ID | The technical parameter surrogate key |
| ORGANIZATION_ID | This is the comun to identify the organization for parameter values |
| TECH_PARM_NAME | Technical parameter name from lm_tech_prm |
| SPRD_ID | Surrogate id for spreadsheet |
| SORT_SEQ | Sort sequence for parameter on the spreadsheet |
| TEXT_DATA | Technical data for character technical parameters. |
| NUM_DATA | Technical data for numeric technical parameters. |
| BOOLEAN_DATA | Technical data for boolean technical parameters. |
| LAB_TYPE | Lab type for which the spreadsheet was created |
| Process Manufacturing Product Development - LM_TECH_DTL | Valid values for technical parameters |
|---|---|
| Column Name | Descritpion |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| TRANS_CNT | Not currently used |
| LAB_TYPE | Laboratory type. |
| TECH_PARM_ID | Foreign key from header |
| ORGANIZATION_ID | This is the Organization ID Column |
| ORGN_CODE | Organization Code |
| TECH_PARM_NAME | Name of the technical parameter. |
| VALID_ANS | Valid value for the technical parameter. |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Process Manufacturing Product Development - LM_TECH_HDR | Technical parameters header |
|---|---|
| Column Name | Descritpion |
| LOWERBOUND_NUM | Lowest valid value, for data types 1 and 5-10. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| UPPERBOUND_NUM | Highest valid value, for data types 1 and 5-10. |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| LOWERBOUND_CHAR | Lowest valid value, for data type 0 (Character). |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| ATTRIBUTE27 | Descriptive flexfield segment |
| UPPERBOUND_CHAR | Highest valid value, for data type 0 (Character). |
| ATTRIBUTE28 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield segment |
| MAX_LENGTH | Maximum length, for data type 0 (Character). |
| EXPRESSION_CHAR | The expression used to calculate the technical parameter, for data type 4 (Expression). |
| LM_UNIT_CODE | The unit of measure in which the technical parameter value is expressed. |
| QCASSY_TYP_ID | Surrogate key for this table |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| LAB_TYPE | Laboratory type. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| IN_USE | Not currently used |
| TECH_PARM_NAME | Name of the technical parameter. |
| PARM_DESCRIPTION | Description of the technical parameter. |
| DATA_TYPE | The data type of the technical parameter. 0=Character, 1=Numeric, 2=Validation List, 3=Boolean, 4=Expression, 5=Weight Percent, 6=Volume Percent, 7=Specific Gravity, 8=Cost, 9=Equivalent Weight, 10=Quantity per Unit. |
| SIGNIF_FIGURES | Number of significant figures for the technical parameter value, for data types 1 and 5-10. |
| Process Manufacturing Product Development - LM_TEXT_HDR | Holds text types defined for Lab module |
|---|---|
| Column Name | Descritpion |
| TEXT_CODE | Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| CREATION_DATE | Standard who column |
| Process Manufacturing Product Development - LM_TEXT_TBL_TL | LM Module Text Lines. Descriptive text for all tables in this module. |
|---|---|
| Column Name | Descritpion |
| TEXT_CODE | Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LANG_CODE | Indicates language used in text. |
| PARAGRAPH_CODE | Defined in sy_para_cds. |
| SUB_PARACODE | Defined in sy_para_cds. |
| LINE_NO | Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text. |
| TEXT | Descriptive text. |
| LANGUAGE | Language Code |
| SOURCE_LANG | Source Language |
| CREATION_DATE | Standard who column |
| Process Manufacturing Product Development - QC_ACTN_MST | QC action codes. |
|---|---|
| Column Name | Descritpion |
| ACTION_CODE | Code for the action to be performed. |
| LAST_UPDATED_BY | Standard who column |
| ATTRIBUTE18 | Descriptive Flexfields Segment |
| ATTRIBUTE19 | Descriptive Flexfields Segment |
| LAST_UPDATE_LOGIN | Standard who column |
| ATTRIBUTE20 | Descriptive Flexfields Segment |
| ATTRIBUTE21 | Descriptive Flexfields Segment |
| ATTRIBUTE22 | Descriptive Flexfields Segment |
| ATTRIBUTE23 | Descriptive Flexfields Segment |
| ATTRIBUTE24 | Descriptive Flexfields Segment |
| ATTRIBUTE25 | Descriptive Flexfields Segment |
| ATTRIBUTE26 | Descriptive Flexfields Segment |
| ATTRIBUTE27 | Descriptive Flexfields Segment |
| ATTRIBUTE28 | Descriptive Flexfields Segment |
| ATTRIBUTE29 | Descriptive Flexfields Segment |
| ATTRIBUTE1 | Descriptive Flexfields Segment |
| ATTRIBUTE30 | Descriptive Flexfields Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfields Segment |
| MIGRATION_STATUS | Record migration status |
| ACTION_DESC | Full description of the action code. |
| ATTRIBUTE2 | Descriptive Flexfields Segment |
| ATTRIBUTE3 | Descriptive Flexfields Segment |
| ACTION_INTERVAL | Days between failure to meet spec and performance of action. |
| ATTRIBUTE4 | Descriptive Flexfields Segment |
| ATTRIBUTE5 | Descriptive Flexfields Segment |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| ATTRIBUTE6 | Descriptive Flexfields Segment |
| ATTRIBUTE7 | Descriptive Flexfields Segment |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ATTRIBUTE8 | Descriptive Flexfields Segment |
| ATTRIBUTE9 | Descriptive Flexfields Segment |
| TRANS_CNT | Not currently used |
| ATTRIBUTE10 | Descriptive Flexfields Segment |
| ATTRIBUTE11 | Descriptive Flexfields Segment |
| CREATION_DATE | Standard who column |
| ATTRIBUTE12 | Descriptive Flexfields Segment |
| ATTRIBUTE13 | Descriptive Flexfields Segment |
| CREATED_BY | Standard who column |
| ATTRIBUTE14 | Descriptive Flexfields Segment |
| ATTRIBUTE15 | Descriptive Flexfields Segment |
| LAST_UPDATE_DATE | Standard who column |
| ATTRIBUTE16 | Descriptive Flexfields Segment |
| ATTRIBUTE17 | Descriptive Flexfields Segment |
| Process Manufacturing Product Development - QC_ASSY_TYP | QC assay master. |
|---|---|
| Column Name | Descritpion |
| TEST_PROVIDER_CODE | Not currently used. |
| MIN_VALID | Minimum valid numeric assay result. |
| MAX_VALID | Maximum valid numeric assay result. |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| IN_USE | Not currently used |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| CREATED_BY | Standard who column |
| QCASSY_TYP_ID | Assay Type Identifier |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| ASSAY_CLASS | Class that assay belongs to |
| ORGN_CODE | Code for the organization which uses the assay. Blank for global assays. |
| OUTSIDE_SPEC_MIN | Number or percent representing experimental error fuzzy zone below spec min |
| OUTSIDE_SPEC_MAX | Number or percent representing experimental error fuzzy zone above spec max |
| ASSAY_CODE | Assay code. |
| INSIDE_SPEC_MIN | Number or percent representing experimental error fuzzy zone above spec min |
| INSIDE_SPEC_MAX | Number or percent representing experimental error fuzzy zone below spec max' |
| ERROR_VAL_TYPE | NUM or PCT (from gem_lookups). Defines values in experimental error columns. |
| INSIDE_MAX_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls below spec max |
| OUTSIDE_MIN_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls below spec min |
| ASSAY_DESC | Assay description. |
| OUTSIDE_MAX_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls above spec max |
| INSIDE_MIN_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls below spec max |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ASSAY_TYPE | 0=Character; 1=Numeric range; 2=List of values. |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| QCUNIT_CODE | QC unit of measure code. |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| TEST_OPRN_ID | Not currently used. |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| ATTRIBUTE27 | Descriptive flexfield segment |
| ATTRIBUTE28 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| TEST_OPRN_LINE_ID | Not currently used. |
| ATTRIBUTE30 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
| Process Manufacturing Product Development - QC_ASSY_VAL | Valid QC assay values. |
|---|---|
| Column Name | Descritpion |
| ATTRIBUTE7 | Descriptive Flexfields Segment |
| ATTRIBUTE8 | Descriptive Flexfields Segment |
| ATTRIBUTE9 | Descriptive Flexfields Segment |
| ATTRIBUTE10 | Descriptive Flexfields Segment |
| ATTRIBUTE11 | Descriptive Flexfields Segment |
| ATTRIBUTE12 | Descriptive Flexfields Segment |
| ATTRIBUTE13 | Descriptive Flexfields Segment |
| ATTRIBUTE14 | Descriptive Flexfields Segment |
| VALUE_NUM_MIN | Minimum of numeric sub-range for numeric range with labels assay type |
| ATTRIBUTE15 | Descriptive Flexfields Segment |
| ATTRIBUTE16 | Descriptive Flexfields Segment |
| ATTRIBUTE17 | Descriptive Flexfields Segment |
| ATTRIBUTE18 | Descriptive Flexfields Segment |
| ATTRIBUTE19 | Descriptive Flexfields Segment |
| ATTRIBUTE20 | Descriptive Flexfields Segment |
| ATTRIBUTE21 | Descriptive Flexfields Segment |
| ATTRIBUTE22 | Descriptive Flexfields Segment |
| ATTRIBUTE23 | Descriptive Flexfields Segment |
| ATTRIBUTE24 | Descriptive Flexfields Segment |
| VALUE_NUM_MAX | Maximum of numeric sub-range for numeric range with labels assay type |
| ATTRIBUTE25 | Descriptive Flexfields Segment |
| ATTRIBUTE26 | Descriptive Flexfields Segment |
| QCASSY_VAL_ID | Surrogate key to this record |
| ATTRIBUTE27 | Descriptive Flexfields Segment |
| ATTRIBUTE28 | Descriptive Flexfields Segment |
| ATTRIBUTE29 | Descriptive Flexfields Segment |
| ATTRIBUTE30 | Descriptive Flexfields Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfields Segment |
| ASSAY_VALUE_RANGE_ORDER | Sequence number for values in assay type Text Range |
| QCASSY_TYP_ID | Surrogate key to access qc_assy_typ to get the assay type |
| ORGN_CODE | Organization code. |
| ASSAY_CODE | Assay code. |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| ASSAY_VALUE | Valid value for the assay. |
| ATTRIBUTE1 | Descriptive Flexfields Segment |
| ATTRIBUTE2 | Descriptive Flexfields Segment |
| VALUE_DESC | Description of the value. |
| ATTRIBUTE3 | Descriptive Flexfields Segment |
| ATTRIBUTE4 | Descriptive Flexfields Segment |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ATTRIBUTE5 | Descriptive Flexfields Segment |
| ATTRIBUTE6 | Descriptive Flexfields Segment |
| Process Manufacturing Product Development - QC_GRAD_MST | QC grade code master. |
|---|---|
| Column Name | Descritpion |
| QC_GRADE | Code for the QC grade. |
| LAST_UPDATE_LOGIN | Standard who column |
| ATTRIBUTE18 | Descriptive Flexfield Segment |
| ATTRIBUTE19 | Descriptive Flexfield Segment |
| ATTRIBUTE20 | Descriptive Flexfield Segment |
| ATTRIBUTE21 | Descriptive Flexfield Segment |
| ATTRIBUTE22 | Descriptive Flexfield Segment |
| ATTRIBUTE23 | Descriptive Flexfield Segment |
| ATTRIBUTE24 | Descriptive Flexfield Segment |
| ATTRIBUTE25 | Descriptive Flexfield Segment |
| ATTRIBUTE26 | Descriptive Flexfield Segment |
| ATTRIBUTE27 | Descriptive Flexfield Segment |
| ATTRIBUTE1 | Descriptive Flexfield Segment |
| ATTRIBUTE28 | Descriptive Flexfield Segment |
| ATTRIBUTE29 | Descriptive Flexfield Segment |
| ATTRIBUTE30 | Descriptive Flexfield Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
| QC_GRADE_DESC | Description of the QC grade. |
| ATTRIBUTE2 | Descriptive Flexfield Segment |
| ATTRIBUTE3 | Descriptive Flexfield Segment |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| ATTRIBUTE4 | Descriptive Flexfield Segment |
| ATTRIBUTE5 | Descriptive Flexfield Segment |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ATTRIBUTE6 | Descriptive Flexfield Segment |
| ATTRIBUTE7 | Descriptive Flexfield Segment |
| TRANS_CNT | Not currently used |
| ATTRIBUTE8 | Descriptive Flexfield Segment |
| ATTRIBUTE9 | Descriptive Flexfield Segment |
| CREATION_DATE | Standard who column |
| ATTRIBUTE10 | Descriptive Flexfield Segment |
| ATTRIBUTE11 | Descriptive Flexfield Segment |
| CREATED_BY | Standard who column |
| ATTRIBUTE12 | Descriptive Flexfield Segment |
| ATTRIBUTE13 | Descriptive Flexfield Segment |
| LAST_UPDATE_DATE | Standard who column |
| ATTRIBUTE14 | Descriptive Flexfield Segment |
| ATTRIBUTE15 | Descriptive Flexfield Segment |
| LAST_UPDATED_BY | Standard who column |
| ATTRIBUTE16 | Descriptive Flexfield Segment |
| ATTRIBUTE17 | Descriptive Flexfield Segment |
| Process Manufacturing Product Development - QC_HRES_MST | QC hold reason code master. |
|---|---|
| Column Name | Descritpion |
| QCHOLD_RES_CODE | Code for the QC hold reason. |
| LAST_UPDATE_LOGIN | Standard who column |
| ATTRIBUTE18 | Descriptive Flexfields Segment |
| ATTRIBUTE19 | Descriptive Flexfields Segment |
| ATTRIBUTE20 | Descriptive Flexfields Segment |
| ATTRIBUTE21 | Descriptive Flexfields Segment |
| ATTRIBUTE22 | Descriptive Flexfields Segment |
| ATTRIBUTE23 | Descriptive Flexfields Segment |
| ATTRIBUTE24 | Descriptive Flexfields Segment |
| ATTRIBUTE25 | Descriptive Flexfields Segment |
| ATTRIBUTE26 | Descriptive Flexfields Segment |
| ATTRIBUTE27 | Descriptive Flexfields Segment |
| ATTRIBUTE1 | Descriptive Flexfields Segment |
| ATTRIBUTE28 | Descriptive Flexfields Segment |
| ATTRIBUTE29 | Descriptive Flexfields Segment |
| ATTRIBUTE30 | Descriptive Flexfields Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfields Segment |
| MIGRATION_STATUS | Record migration status |
| QCHOLD_RES_DESC | Description of the QC hold reason. |
| ATTRIBUTE2 | Descriptive Flexfields Segment |
| ATTRIBUTE3 | Descriptive Flexfields Segment |
| CREATION_DATE | Standard who column |
| ATTRIBUTE4 | Descriptive Flexfields Segment |
| ATTRIBUTE5 | Descriptive Flexfields Segment |
| CREATED_BY | Standard who column |
| ATTRIBUTE6 | Descriptive Flexfields Segment |
| ATTRIBUTE7 | Descriptive Flexfields Segment |
| LAST_UPDATE_DATE | Standard who column |
| ATTRIBUTE8 | Descriptive Flexfields Segment |
| ATTRIBUTE9 | Descriptive Flexfields Segment |
| LAST_UPDATED_BY | Standard who column |
| ATTRIBUTE10 | Descriptive Flexfields Segment |
| ATTRIBUTE11 | Descriptive Flexfields Segment |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| ATTRIBUTE12 | Descriptive Flexfields Segment |
| ATTRIBUTE13 | Descriptive Flexfields Segment |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ATTRIBUTE14 | Descriptive Flexfields Segment |
| ATTRIBUTE15 | Descriptive Flexfields Segment |
| TRANS_CNT | Not currently used |
| ATTRIBUTE16 | Descriptive Flexfields Segment |
| ATTRIBUTE17 | Descriptive Flexfields Segment |
| Process Manufacturing Product Development - QC_RSLT_MST | QC results master. |
|---|---|
| Column Name | Descritpion |
| NUM_RESULT | Result for assay_type 1. |
| ATTRIBUTE10 | Descriptive Flexfield Segment |
| ATTRIBUTE11 | Descriptive Flexfield Segment |
| QCUNIT_CODE | Unit of measure for the result. |
| ATTRIBUTE12 | Descriptive Flexfield Segment |
| ATTRIBUTE13 | Descriptive Flexfield Segment |
| ACCEPT_ANYWAY | Indicates whether the results have been accepted. 0=Not accepted, 1=Accepted. |
| ATTRIBUTE14 | Descriptive Flexfield Segment |
| ATTRIBUTE15 | Descriptive Flexfield Segment |
| FINAL_MARK | Indicates whether the results are considered final and will print on certificates of analysis. 0=Not final, 1=Final. |
| ATTRIBUTE16 | Descriptive Flexfield Segment |
| ATTRIBUTE17 | Descriptive Flexfield Segment |
| TEST_PROVIDER_CODE | Not currently used. |
| ATTRIBUTE18 | Descriptive Flexfield Segment |
| ATTRIBUTE19 | Descriptive Flexfield Segment |
| ITEM_ID | Surrogate key for the item for which results are recorded. |
| ATTRIBUTE20 | Descriptive Flexfield Segment |
| ATTRIBUTE21 | Descriptive Flexfield Segment |
| LOT_ID | Surrogate key for the lot/sublot for which results are recorded. |
| ATTRIBUTE22 | Descriptive Flexfield Segment |
| ATTRIBUTE23 | Descriptive Flexfield Segment |
| WHSE_CODE | Warehouse from which the item was taken. |
| ATTRIBUTE24 | Descriptive Flexfield Segment |
| ATTRIBUTE25 | Descriptive Flexfield Segment |
| ATTRIBUTE26 | Descriptive Flexfield Segment |
| LOCATION | Location from which the item was taken. |
| ATTRIBUTE27 | Descriptive Flexfield Segment |
| FORMULA_ID | Surrogate key for the formula for which results are recorded. |
| ATTRIBUTE28 | Descriptive Flexfield Segment |
| ATTRIBUTE29 | Descriptive Flexfield Segment |
| QCASSY_TYP_ID | Surrogate key id used to access qc_assy_typ to get the assay type |
| FORMULALINE_ID | Surrogate key for the formula line for which results are recorded. |
| ATTRIBUTE30 | Descriptive Flexfield Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
| ROUTING_ID | Surrogate key for the routing for which results are recorded. |
| ORDER_HEADER_ID | Order ID used for order-specific customer results. FK = OE_ORDER_HEADERS.ALL.header_id |
| ROUTINGSTEP_ID | Surrogate key for the routing step for which results are recorded. |
| ORDER_LINE | Concatenated order line number used for order-line-specific data. Corresponds to what user sees on Orders forms. |
| OPRN_ID | Surrogate key for the operation for which results are recorded. |
| ORDER_LINE_ID | Order line ID used for order-line-specific customer results. FK =ORDER_LINES_ALL.line_id |
| CUST_ID | Surrogate key for the customer for which results are recorded. |
| ORDER_ORG_ID | Operating unit id used for order-specific customer results. |
| VENDOR_ID | Surrogate key for the vendor for which results are recorded. |
| QC_REC_TYPE | Indicator for item/loc vs customer vs supplier vs production results. Should help performance. |
| BATCH_ID | Surrogate key for the batch for which results are recorded. |
| SHIP_TO_SITE_ID | Ship-to ID/cust-site used for order-specific customer results. FK = HZ_CUST_ACCT_SITES_ALL.cust_acct_site_id |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| MIGRATION_STATUS | Record migration status |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| OLD_QC_SPEC_ID | This column is used for migration |
| TRANS_CNT | Not currently used |
| QC_RESULT_ID | Surrogate key for the result. |
| OPM_CUST_ID | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| ROUTINGSTEP_NO | The routing step number from Formula routing detail |
| CHARGE | Charge associated with sample. |
| QC_SPEC_ID | Surrogate key for the specification to which the result is compared. |
| ASSAY_TESTER | Assay tester |
| WF_RESPONSE | Workflow response |
| ORGN_CODE | Organization code. |
| ASSAY_RETEST | Assay Retest Flag |
| ATTRIBUTE1 | Descriptive Flexfield Segment |
| SAMPLE_ID | Surrogate key for the sample which was tested to yield this result. |
| ATTRIBUTE2 | Descriptive Flexfield Segment |
| ATTRIBUTE3 | Descriptive Flexfield Segment |
| RESULT_DATE | Date on which the result was acquired. |
| ATTRIBUTE4 | Descriptive Flexfield Segment |
| ATTRIBUTE5 | Descriptive Flexfield Segment |
| ASSAY_CODE | Assay for which the sample was tested. |
| ATTRIBUTE6 | Descriptive Flexfield Segment |
| ATTRIBUTE7 | Descriptive Flexfield Segment |
| TEXT_RESULT | Result for assay_types 0 and 2. |
| ATTRIBUTE8 | Descriptive Flexfield Segment |
| ATTRIBUTE9 | Descriptive Flexfield Segment |
| Process Manufacturing Product Development - QC_SMPL_MST | QC sample master. |
|---|---|
| Column Name | Descritpion |
| SAMPLE_ID | Surrogate key for the sample. |
| OPRN_ID | Surrogate key for the operation. |
| ATTRIBUTE11 | Descriptive Flexfield Segment |
| ATTRIBUTE12 | Descriptive Flexfield Segment |
| ITEM_ID | Surrogate key for the item sampled. |
| ATTRIBUTE13 | Descriptive Flexfield Segment |
| ATTRIBUTE14 | Descriptive Flexfield Segment |
| LOT_ID | Surrogate key for the lot/sublot sampled. |
| ATTRIBUTE15 | Descriptive Flexfield Segment |
| ATTRIBUTE16 | Descriptive Flexfield Segment |
| WHSE_CODE | Warehouse in which the item was sampled. |
| ATTRIBUTE17 | Descriptive Flexfield Segment |
| ATTRIBUTE18 | Descriptive Flexfield Segment |
| LOCATION | Location in which the item was sampled. |
| ATTRIBUTE19 | Descriptive Flexfield Segment |
| ATTRIBUTE20 | Descriptive Flexfield Segment |
| CUST_ID | Surrogate key for the customer for whom the item was sampled. |
| ATTRIBUTE21 | Descriptive Flexfield Segment |
| ATTRIBUTE22 | Descriptive Flexfield Segment |
| VENDOR_ID | Surrogate key for the vendor for which the item was sampled. |
| ATTRIBUTE23 | Descriptive Flexfield Segment |
| ATTRIBUTE24 | Descriptive Flexfield Segment |
| SAMPLE_DATE | Date on which the sample was drawn. |
| ATTRIBUTE25 | Descriptive Flexfield Segment |
| ATTRIBUTE26 | Descriptive Flexfield Segment |
| SAMPLED_BY | Operator who drew the sample. |
| ATTRIBUTE27 | Descriptive Flexfield Segment |
| ATTRIBUTE28 | Descriptive Flexfield Segment |
| SAMPLE_QTY | Quantity of material sampled. |
| ATTRIBUTE29 | Descriptive Flexfield Segment |
| ATTRIBUTE30 | Descriptive Flexfield Segment |
| ORGN_CODE | Organization for which the sample is drawn. |
| SAMPLE_UM | Units of the sampled quantity. |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
| EXTERNAL_ID | Alternate sample name. |
| ORDER_HEADER_ID | Order ID used for order-specific customer samples. FK =OE_ORDER_HEADERS_ALL.header_id |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| ORDER_LINE | Concatenated order line number used for order-line-specific customer samples. Corresponds to what user sees on Orders forms. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ORDER_LINE_ID | Order line ID used for order-line-specific customer samples. FK =OE_ORDER_LINES_ALL.line_id |
| TRANS_CNT | Not currently used |
| ORDER_ORG_ID | Operating unit id used for order-specific customer results |
| CREATION_DATE | Standard who column |
| QC_REC_TYPE | Indicator for item/loc vs customer vs supplier vs production samples. Should help performance. |
| SHIP_TO_SITE_ID | Ship-to ID/cust-site used for order-specific customer results. FK =OE_ORDER_HEADERS.ALL.header_id |
| LAST_UPDATE_LOGIN | Standard who column |
| MIGRATION_STATUS | Record migration status |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| SAMPLE_NO | Sample number. |
| LAST_UPDATED_BY | Standard who column |
| ROUTINGSTEP_NO | Routing Step Number |
| CHARGE | Charge |
| OPM_CUST_ID | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. |
| SAMPLE_STATUS | Disposition of sample (e.g. ACCEPTED) |
| SAMPLE_DESC | Sample description. |
| SAMPLE_FINAL_APPROVER | Final Sample Approver |
| SAMPLE_TEST_APPROVER | Sample Test Approver |
| STORAGE_WHSE | Whse code for whse where samples are stored. |
| STORAGE_LOCATION | Location code where samples are stored, or if whse if null, free-form text representing the sample location |
| SAMPLE_SOURCE | Free-form text (for now) representing where a sample came from - inventory, customer return, vendor sample,production line, etc. |
| BATCH_ID | Surrogate key for the batch from which the sample was drawn. |
| ATTRIBUTE1 | Descriptive Flexfield Segment |
| ATTRIBUTE2 | Descriptive Flexfield Segment |
| FORMULA_ID | Surrogate key for the formula. |
| ATTRIBUTE3 | Descriptive Flexfield Segment |
| ATTRIBUTE4 | Descriptive Flexfield Segment |
| FORMULALINE_ID | Surrogate key for the formula line. |
| ATTRIBUTE5 | Descriptive Flexfield Segment |
| ATTRIBUTE6 | Descriptive Flexfield Segment |
| ROUTING_ID | Surrogate key for the routing. |
| ATTRIBUTE7 | Descriptive Flexfield Segment |
| ATTRIBUTE8 | Descriptive Flexfield Segment |
| ROUTINGSTEP_ID | Surrogate key for the routing step. |
| ATTRIBUTE9 | Descriptive Flexfield Segment |
| ATTRIBUTE10 | Descriptive Flexfield Segment |
| Process Manufacturing Product Development - QC_SPEC_MST | QC specification master. |
|---|---|
| Column Name | Descritpion |
| QC_SPEC_ID | Surrogate key for the specification. |
| FORMULALINE_ID | Surrogate key to formula line for which specs are recorded. |
| ATTRIBUTE1 | Descriptive Flexfield Segment |
| ATTRIBUTE2 | Descriptive Flexfield Segment |
| ATTRIBUTE3 | Descriptive Flexfield Segment |
| ATTRIBUTE4 | Descriptive Flexfield Segment |
| ATTRIBUTE5 | Descriptive Flexfield Segment |
| ATTRIBUTE6 | Descriptive Flexfield Segment |
| ATTRIBUTE7 | Descriptive Flexfield Segment |
| ATTRIBUTE8 | Descriptive Flexfield Segment |
| ATTRIBUTE9 | Descriptive Flexfield Segment |
| ATTRIBUTE10 | Descriptive Flexfield Segment |
| ROUTING_ID | Surrogate key to routing for which specs are recorded. |
| ATTRIBUTE11 | Descriptive Flexfield Segment |
| ATTRIBUTE12 | Descriptive Flexfield Segment |
| ATTRIBUTE13 | Descriptive Flexfield Segment |
| ROUTINGSTEP_ID | Surrogate key to routing step for which specs are recorded. |
| ATTRIBUTE14 | Descriptive Flexfield Segment |
| ATTRIBUTE15 | Descriptive Flexfield Segment |
| OPRN_ID | Surrogate key to operation for which specs are recorded. |
| ATTRIBUTE16 | Descriptive Flexfield Segment |
| ATTRIBUTE17 | Descriptive Flexfield Segment |
| DOC_TYPE | Not currently used. |
| ATTRIBUTE18 | Descriptive Flexfield Segment |
| ATTRIBUTE19 | Descriptive Flexfield Segment |
| DOC_ID | Not currently used. |
| ATTRIBUTE20 | Descriptive Flexfield Segment |
| ATTRIBUTE21 | Descriptive Flexfield Segment |
| DOCLINE_ID | Not currently used. |
| ATTRIBUTE22 | Descriptive Flexfield Segment |
| ATTRIBUTE23 | Descriptive Flexfield Segment |
| CUST_ID | Surrogate key to customer for which specs are recorded. |
| ATTRIBUTE24 | Descriptive Flexfield Segment |
| ATTRIBUTE25 | Descriptive Flexfield Segment |
| CUST_SPECIFICATION | Not currently used. |
| ATTRIBUTE26 | Descriptive Flexfield Segment |
| ATTRIBUTE27 | Descriptive Flexfield Segment |
| CUST_CERTIFICATION | Not currently used. |
| ATTRIBUTE28 | Descriptive Flexfield Segment |
| ATTRIBUTE29 | Descriptive Flexfield Segment |
| QCASSY_TYP_ID | Surrogate key id used to access qc_assy_typ to get the assay type |
| VENDOR_ID | Surrogate key for vendor for which specs are recorded. |
| ATTRIBUTE30 | Descriptive Flexfield Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
| VENDOR_SPECIFICATION | Not currently used. |
| ORDER_HEADER_ID | Order ID used for order-specific customer specs. FK =OE_ORDER_HEADERS_ALL.header_id |
| VENDOR_CERTIFICATION | Not currently used. |
| ORDER_LINE_NO | Simple, numeric order line number used for order-line-specific customer specs. FK = OE_ORDER_LINES_ALL.line_no |
| BATCH_ID | Surrogate key for batch for which specs are recorded. |
| ORDER_ORG_ID | Operating unit id used for order-specific customer results. |
| ASSAY_CODE | Assay for which specs are recorded. |
| QC_REC_TYPE | Indicator for item/loc vs customer vs supplier vs production specification. Should help performance. |
| TEXT_SPEC | Specification for assay_type 0 and 2. |
| SHIP_TO_SITE_ID | Indicator for item/loc vs customer vs supplier vs production specification. Should help performance |
| TARGET_SPEC | Specification for assay_type 1. |
| SPEC_HDR_ID | ID which relates all assay lines for one SPEC together. Needed before we create header and detail tables for spec matching. |
| MIN_SPEC | Lower bound for result within spec for assay type 1. |
| MIGRATION_STATUS | Record migration status |
| MAX_SPEC | Upper bound for result within spec for aassay_type 1. |
| OLD_FROM_DATE | This column is used for migration |
| QCUNIT_CODE | Unit of measure code associated with this assay. |
| OLD_TO_DATE | This column is used for migration |
| ORGN_CODE | Organization for which the specs are entered. |
| FROM_DATE | Earliest effective date for the specification. |
| TO_DATE | Latest effective date for the specification. |
| OUTACTION_CODE | Action to be performed upon failing to meet specification. |
| OUTACTION_INTERVAL | Interval (decimal days) between failing result and performance of out of spec action. |
| PREFERENCE | Preference among specs. |
| PRINT_COA_SHIPPED | 0=Do not print certificate of analysis when material is shipped, 1=Print certificate of analysis when material is shipped. |
| PRINT_COA_INVOICED | 0=Do not print certificate of analysis when material is invoiced, 1=Print certificate of analysis when material is invoiced. |
| VENDOR_COA_REQUIRED | 0=Certificate of analysis from vendor is not required, 1=Certificate of analysis from vendor is required. |
| TEST_OPRN_ID | Not currently used. |
| TEST_OPRN_LINE_ID | Not currently used. |
| TEST_PROVIDER_CODE | Not currently used. |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| TRANS_CNT | Not currently used |
| OPM_CUST_ID | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| ITEM_ID | Surrogate key for the item for which specs are recorded. |
| ROUTINGSTEP_NO | Routingstep_no from fm_rout_dtl |
| CHARGE | The charge number for which this specification is effective, relating to the routing step entered. |
| OUTSIDE_SPEC_MIN | Number or percent representing experimental error fuzzy zone below spec min |
| LOT_ID | Surrogate key for the lot/sublot for which specs are recorded. |
| INSIDE_SPEC_MIN | Number or percent representing experimental error fuzzy zone above spec min |
| INSIDE_SPEC_MAX | Number or percent representing experimental error fuzzy zone below spec max' |
| WHSE_CODE | Warehouse for which specs are recorded. |
| OUTSIDE_SPEC_MAX | Number or percent representing experimental error fuzzy zone above spec max |
| ERROR_VAL_TYPE | NUM or PCT (from gem_lookups). Defines values in experimental error columns. |
| LOCATION | Location for which specs are recorded. |
| OUTSIDE_MIN_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls below spec min |
| INSIDE_MIN_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls above spec min |
| FORMULA_ID | Surrogate key to formula for which specs are recorded. |
| INSIDE_MAX_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls below spec max' |
| OUTSIDE_MAX_ACTION_CODE | Action code (from qc_actn_mst) to display when result falls above spec max |
| MIN_CHAR | Minimum value for an assay of type text range |
| MAX_CHAR | Maximum value for an assay of type text range |
| Process Manufacturing Product Development - QC_TEXT_HDR | Holds text types defined for QC module |
|---|---|
| Column Name | Descritpion |
| TEXT_CODE | Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - QC_TEXT_TBL_TL | QC Module Text Lines. Descriptive text for all tables in this module. |
|---|---|
| Column Name | Descritpion |
| TEXT_CODE | Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LANG_CODE | Indicates language used in text. |
| PARAGRAPH_CODE | Defined in sy_para_cds. |
| SUB_PARACODE | Defined in sy_para_cds. |
| LINE_NO | Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text. |
| TEXT | Descriptive text. |
| LANGUAGE | Language Code |
| SOURCE_LANG | Source Language Code |
| CREATION_DATE | Standard who column |
| Process Manufacturing Product Development - QC_UNIT_MST | Units of measure for QC assays. |
|---|---|
| Column Name | Descritpion |
| QCUNIT_CODE | Unit of measure code. |
| ATTRIBUTE18 | Descriptive Flexfields Segment |
| ATTRIBUTE19 | Descriptive Flexfields Segment |
| LAST_UPDATE_LOGIN | Standard who column |
| ATTRIBUTE20 | Descriptive Flexfields Segment |
| ATTRIBUTE21 | Descriptive Flexfields Segment |
| ATTRIBUTE22 | Descriptive Flexfields Segment |
| ATTRIBUTE23 | Descriptive Flexfields Segment |
| ATTRIBUTE24 | Descriptive Flexfields Segment |
| ATTRIBUTE25 | Descriptive Flexfields Segment |
| ATTRIBUTE26 | Descriptive Flexfields Segment |
| ATTRIBUTE27 | Descriptive Flexfields Segment |
| ATTRIBUTE28 | Descriptive Flexfields Segment |
| ATTRIBUTE29 | Descriptive Flexfields Segment |
| ATTRIBUTE1 | Descriptive Flexfields Segment |
| ATTRIBUTE30 | Descriptive Flexfields Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfields Segment |
| QCUNIT_DESC | Full description of the unit of measure code. |
| ATTRIBUTE2 | Descriptive Flexfields Segment |
| ATTRIBUTE3 | Descriptive Flexfields Segment |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| ATTRIBUTE4 | Descriptive Flexfields Segment |
| ATTRIBUTE5 | Descriptive Flexfields Segment |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ATTRIBUTE6 | Descriptive Flexfields Segment |
| ATTRIBUTE7 | Descriptive Flexfields Segment |
| TRANS_CNT | Not currently used |
| ATTRIBUTE8 | Descriptive Flexfields Segment |
| ATTRIBUTE9 | Descriptive Flexfields Segment |
| CREATION_DATE | Standard who column |
| ATTRIBUTE10 | Descriptive Flexfields Segment |
| ATTRIBUTE11 | Descriptive Flexfields Segment |
| CREATED_BY | Standard who column |
| ATTRIBUTE12 | Descriptive Flexfields Segment |
| ATTRIBUTE13 | Descriptive Flexfields Segment |
| LAST_UPDATE_DATE | Standard who column |
| ATTRIBUTE14 | Descriptive Flexfields Segment |
| ATTRIBUTE15 | Descriptive Flexfields Segment |
| LAST_UPDATED_BY | Standard who column |
| ATTRIBUTE16 | Descriptive Flexfields Segment |
| ATTRIBUTE17 | Descriptive Flexfields Segment |
| Process Manufacturing Product Development - GMD_VPD_SECURITY | Reflects whether NPD Security is Active or Inactive |
|---|---|
| Column Name | Descritpion |
| ACTIVE_FORMULA_IND | Formula Security is active Y:Yes,N:No |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - GMD_TECH_PARAMETERS_B | Technical parameters header base table |
|---|---|
| Column Name | Descritpion |
| QCASSY_TYP_ID | Surrogate key for this table |
| LOWERBOUND_NUM | Lowest valid value, for data types 1 and 5-10. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| UPPERBOUND_NUM | Highest valid value, for data types 1 and 5-10. |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| LOWERBOUND_CHAR | Lowest valid value, for data type 0 (Character). |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| ATTRIBUTE27 | Descriptive flexfield segment |
| UPPERBOUND_CHAR | Highest valid value, for data type 0 (Character). |
| ATTRIBUTE28 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield segment |
| TECH_PARM_ID | Surrogate key |
| MAX_LENGTH | Maximum length, for data type 0 (Character). |
| ORGANIZATION_ID | This is Organization Id column |
| EXPRESSION_CHAR | The expression used to calculate the technical parameter, for data type 4 (Expression). |
| COST_FUNCTION | Cost Function for external cost |
| LM_UNIT_CODE | The unit of measure in which the technical parameter value is expressed. |
| COST_SOURCE | Cost Source for external cost |
| COST_TYPE | Cost Type |
| DEFAULT_COST_PARAMETER | Default Cost Parameter Type |
| ORGN_CODE | Organization code |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| LAB_TYPE | Laboratory type. |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| IN_USE | Not currently used |
| TECH_PARM_NAME | Name of the technical parameter. |
| PARM_DESCRIPTION | Description of the technical parameter. |
| DATA_TYPE | The data type of the technical parameter. 0=Character, 1=Numeric, 2=Validation List, 3=Boolean, 4=Expression, 5=Weight Percent, 6=Volume Percent, 7=Specific Gravity, 8=Cost, 9=Equivalent Weight, 10=Quantity per Unit. |
| SIGNIF_FIGURES | Number of significant figures for the technical parameter value, for data types 1 and 5-10. |
| Process Manufacturing Product Development - GMD_TECH_PARAMETERS_TL | Technical parameters header translation table |
|---|---|
| Column Name | Descritpion |
| TECH_PARM_NAME | Name of the technical parameter. |
| SOURCE_LANG | Source Language Column |
| PARM_DESCRIPTION | Description of the technical parameter. |
| ORGN_CODE | Organization |
| CREATION_DATE | Standard who column |
| TECH_PARM_ID | Surrogate Key |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LANGUAGE | Language column |
| Process Manufacturing Product Development - GMD_TESTS_B | |
|---|---|
| Column Name | Descritpion |
| QCASSY_TYP_ID | |
| MIN_VALID | |
| MAX_VALID | |
| DELETE_MARK | |
| TEXT_CODE | |
| IN_USE | |
| CREATION_DATE | |
| LAST_UPDATE_LOGIN | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| ORGN_CODE | |
| ASSAY_CLASS | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ASSAY_CODE | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| ATTRIBUTE16 | |
| ATTRIBUTE17 | |
| ATTRIBUTE18 | |
| ATTRIBUTE19 | |
| ASSAY_DESC | |
| ATTRIBUTE20 | |
| ATTRIBUTE21 | |
| ATTRIBUTE22 | |
| ATTRIBUTE23 | |
| ATTRIBUTE24 | |
| ATTRIBUTE25 | |
| ATTRIBUTE26 | |
| ATTRIBUTE27 | |
| ATTRIBUTE28 | |
| ATTRIBUTE29 | |
| ASSAY_TYPE | |
| ATTRIBUTE30 | |
| ATTRIBUTE_CATEGORY | |
| OUTSIDE_SPEC_MIN | |
| OUTSIDE_SPEC_MAX | |
| INSIDE_SPEC_MIN | |
| INSIDE_SPEC_MAX | |
| ERROR_VAL_TYPE | |
| OUTSIDE_MIN_ACTION_CODE | |
| OUTSIDE_MAX_ACTION_CODE | |
| INSIDE_MIN_ACTION_CODE | |
| QCUNIT_CODE | |
| INSIDE_MAX_ACTION_CODE | |
| POTENCY_UOM | |
| TEST_OPRN_ID | |
| TEST_OPRN_LINE_ID | |
| TEST_PROVIDER_CODE |
| Process Manufacturing Product Development - GMD_TESTS_TL | |
|---|---|
| Column Name | Descritpion |
| QCASSY_TYP_ID | |
| ASSAY_DESC | |
| SOURCE_LANG | |
| LANGUAGE | |
| CREATION_DATE | |
| LAST_UPDATE_LOGIN | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY |
| Process Manufacturing Product Development - GMD_TEST_VALUES_B | |
|---|---|
| Column Name | Descritpion |
| QCASSY_VAL_ID | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| QCASSY_TYP_ID | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| ATTRIBUTE16 | |
| ATTRIBUTE17 | |
| ORGN_CODE | |
| ATTRIBUTE18 | |
| ATTRIBUTE19 | |
| ATTRIBUTE20 | |
| ATTRIBUTE21 | |
| ATTRIBUTE22 | |
| ATTRIBUTE23 | |
| ATTRIBUTE24 | |
| ATTRIBUTE25 | |
| ATTRIBUTE26 | |
| ATTRIBUTE27 | |
| ASSAY_CODE | |
| ATTRIBUTE28 | |
| ATTRIBUTE29 | |
| ATTRIBUTE30 | |
| ATTRIBUTE_CATEGORY | |
| VALUE_NUM_MIN | |
| VALUE_NUM_MAX | |
| ASSAY_VALUE_RANGE_ORDER | |
| VALUE_NUM_LABEL | |
| ASSAY_VALUE | |
| VALUE_DESC | |
| TEXT_CODE | |
| CREATION_DATE | |
| LAST_UPDATE_LOGIN |
| Process Manufacturing Product Development - GMD_TEST_VALUES_TL | |
|---|---|
| Column Name | Descritpion |
| QCASSY_VAL_ID | |
| LAST_UPDATED_BY | |
| QCASSY_TYP_ID | |
| VALUE_DESC | |
| SOURCE_LANG | |
| LANGUAGE | |
| CREATION_DATE | |
| LAST_UPDATE_LOGIN | |
| CREATED_BY | |
| LAST_UPDATE_DATE |
| Process Manufacturing Product Development - GMD_UNITS_B | Units of measure for QC assays. |
|---|---|
| Column Name | Descritpion |
| QCUNIT_CODE | Unit of measure code. |
| ATTRIBUTE18 | Descriptive Flexfields Segment |
| ATTRIBUTE19 | Descriptive Flexfields Segment |
| LAST_UPDATE_LOGIN | Standard who column |
| ATTRIBUTE20 | Descriptive Flexfields Segment |
| ATTRIBUTE21 | Descriptive Flexfields Segment |
| ATTRIBUTE22 | Descriptive Flexfields Segment |
| ATTRIBUTE23 | Descriptive Flexfields Segment |
| ATTRIBUTE24 | Descriptive Flexfields Segment |
| ATTRIBUTE25 | Descriptive Flexfields Segment |
| ATTRIBUTE26 | Descriptive Flexfields Segment |
| ATTRIBUTE27 | Descriptive Flexfields Segment |
| ATTRIBUTE28 | Descriptive Flexfields Segment |
| ATTRIBUTE29 | Descriptive Flexfields Segment |
| ATTRIBUTE1 | Descriptive Flexfields Segment |
| ATTRIBUTE30 | Descriptive Flexfields Segment |
| ATTRIBUTE_CATEGORY | Descriptive Flexfields Segment |
| QCUNIT_DESC | Full description of the unit of measure code. |
| ATTRIBUTE2 | Descriptive Flexfields Segment |
| ATTRIBUTE3 | Descriptive Flexfields Segment |
| DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| ATTRIBUTE4 | Descriptive Flexfields Segment |
| ATTRIBUTE5 | Descriptive Flexfields Segment |
| TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
| ATTRIBUTE6 | Descriptive Flexfields Segment |
| ATTRIBUTE7 | Descriptive Flexfields Segment |
| TRANS_CNT | Not currently used |
| ATTRIBUTE8 | Descriptive Flexfields Segment |
| ATTRIBUTE9 | Descriptive Flexfields Segment |
| CREATION_DATE | Standard who column |
| ATTRIBUTE10 | Descriptive Flexfields Segment |
| ATTRIBUTE11 | Descriptive Flexfields Segment |
| CREATED_BY | Standard who column |
| ATTRIBUTE12 | Descriptive Flexfields Segment |
| ATTRIBUTE13 | Descriptive Flexfields Segment |
| LAST_UPDATE_DATE | Standard who column |
| ATTRIBUTE14 | Descriptive Flexfields Segment |
| ATTRIBUTE15 | Descriptive Flexfields Segment |
| LAST_UPDATED_BY | Standard who column |
| ATTRIBUTE16 | Descriptive Flexfields Segment |
| ATTRIBUTE17 | Descriptive Flexfields Segment |
| Process Manufacturing Product Development - GMD_UNITS_TL | QC Units Translation Table |
|---|---|
| Column Name | Descritpion |
| QCUNIT_CODE | QC Unit Code |
| QCUNIT_DESC | QC Unit Code Translated Description |
| SOURCE_LANG | Language in which the Unit Code was originally defined. Derived from FND_LANGUAGES |
| LANGUAGE | Language for this Unit Code Description. Derived from FND_LANGUAGES |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - GMD_TEST_CLASSES_B | OPM Quality Test Classes |
|---|---|
| Column Name | Descritpion |
| TEST_CLASS | Test Class |
| ATTRIBUTE2 | Descriptive Flexfield column |
| ATTRIBUTE3 | Descriptive Flexfield column |
| ATTRIBUTE4 | Descriptive Flexfield column |
| ATTRIBUTE5 | Descriptive Flexfield column |
| ATTRIBUTE6 | Descriptive Flexfield column |
| ATTRIBUTE7 | Descriptive Flexfield column |
| ATTRIBUTE8 | Descriptive Flexfield column |
| ATTRIBUTE9 | Descriptive Flexfield column |
| ATTRIBUTE10 | Descriptive Flexfield column |
| ATTRIBUTE11 | Descriptive Flexfield column |
| DELETE_MARK | Logical delete |
| ATTRIBUTE12 | Descriptive Flexfield column |
| ATTRIBUTE13 | Descriptive Flexfield column |
| ATTRIBUTE14 | Descriptive Flexfield column |
| ATTRIBUTE15 | Descriptive Flexfield column |
| ATTRIBUTE16 | Descriptive Flexfield column |
| ATTRIBUTE17 | Descriptive Flexfield column |
| ATTRIBUTE18 | Descriptive Flexfield column |
| ATTRIBUTE19 | Descriptive Flexfield column |
| ATTRIBUTE20 | Descriptive Flexfield column |
| ATTRIBUTE21 | Descriptive Flexfield column |
| TEXT_CODE | Edit text |
| ATTRIBUTE22 | Descriptive Flexfield column |
| ATTRIBUTE23 | Descriptive Flexfield column |
| ATTRIBUTE24 | Descriptive Flexfield column |
| ATTRIBUTE25 | Descriptive Flexfield column |
| ATTRIBUTE26 | Descriptive Flexfield column |
| ATTRIBUTE27 | Descriptive Flexfield column |
| ATTRIBUTE28 | Descriptive Flexfield column |
| ATTRIBUTE29 | Descriptive Flexfield column |
| ATTRIBUTE30 | Descriptive Flexfield column |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
| CREATION_DATE | Standard who column |
| TEST_GROUP_ENABLED | Indicator for Test Class is group enabled or not |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| ATTRIBUTE1 | Descriptive Flexfield column |
| Process Manufacturing Product Development - GMD_TEST_CLASSES_TL | OPM Quality test classes translation |
|---|---|
| Column Name | Descritpion |
| TEST_CLASS | Test class |
| TEST_CLASS_DESC | Test Class Description |
| SOURCE_LANG | Source Language Code |
| LANGUAGE | Language code the description is stored in |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - GMD_TEST_METHODS_B | OPM Quality Test Methods |
|---|---|
| Column Name | Descritpion |
| TEST_METHOD_ID | Test method identifier |
| TEST_KIT_ITEM_ID | Test Kit Item |
| TEXT_CODE | Edit Text |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
| ATTRIBUTE1 | Descriptive Flexfield column |
| ATTRIBUTE2 | Descriptive Flexfield column |
| ATTRIBUTE3 | Descriptive Flexfield column |
| ATTRIBUTE4 | Descriptive Flexfield column |
| ATTRIBUTE5 | Descriptive Flexfield column |
| ATTRIBUTE6 | Descriptive Flexfield column |
| ATTRIBUTE7 | Descriptive Flexfield column |
| TEST_METHOD_CODE | Test method code |
| ATTRIBUTE8 | Descriptive Flexfield column |
| ATTRIBUTE9 | Descriptive Flexfield column |
| ATTRIBUTE10 | Descriptive Flexfield column |
| ATTRIBUTE11 | Descriptive Flexfield column |
| ATTRIBUTE12 | Descriptive Flexfield column |
| ATTRIBUTE13 | Descriptive Flexfield column |
| ATTRIBUTE14 | Descriptive Flexfield column |
| ATTRIBUTE15 | Descriptive Flexfield column |
| ATTRIBUTE16 | Descriptive Flexfield column |
| ATTRIBUTE17 | Descriptive Flexfield column |
| TEST_QTY | Test Quanity |
| ATTRIBUTE18 | Descriptive Flexfield column |
| ATTRIBUTE19 | Descriptive Flexfield column |
| ATTRIBUTE20 | Descriptive Flexfield column |
| ATTRIBUTE21 | Descriptive Flexfield column |
| ATTRIBUTE22 | Descriptive Flexfield column |
| ATTRIBUTE23 | Descriptive Flexfield column |
| ATTRIBUTE24 | Descriptive Flexfield column |
| ATTRIBUTE25 | Descriptive Flexfield column |
| ATTRIBUTE26 | Descriptive Flexfield column |
| ATTRIBUTE27 | Descriptive Flexfield column |
| TEST_UOM | Test Unit of Measure |
| ATTRIBUTE28 | Descriptive Flexfield column |
| ATTRIBUTE29 | Descriptive Flexfield column |
| ATTRIBUTE30 | Descriptive Flexfield column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DAYS | Test Duration in Number of Days. |
| HOURS | Test Duration in Number of Hours. |
| DISPLAY_PRECISION | Display Precision |
| MINUTES | Test Duration in Number of Minutes. |
| SECONDS | Test Duration in Number of Seconds. |
| TEST_KIT_INV_ITEM_ID | This is the test kit item ID |
| TEST_QTY_UOM | This is the test quantity unit of measure |
| TEST_KIT_ORGANIZATION_ID | This is test kit organization id |
| MIGRATED_IND | Indicates Status of the Migration of this table |
| TEST_DURATION | Test Duration |
| TEST_REPLICATE | Test Replicate |
| DELETE_MARK | Delete Mark |
| RESOURCES | Resources |
| Process Manufacturing Product Development - GMD_TEST_METHODS_TL | OPM Quality test methods |
|---|---|
| Column Name | Descritpion |
| TEST_METHOD_ID | Test method Identifier |
| LANGUAGE | Language code the description is stored in. |
| TEST_METHOD_DESC | Test method Description |
| SOURCE_LANG | Source Language Code |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - GMD_WIP_SPEC_VRS | OPM Work-in-Process Specification validity rules |
|---|---|
| Column Name | Descritpion |
| SPEC_VR_ID | Specification validity rule identifier; db-seq |
| FORMULA_NO | Formula Number |
| FORMULA_VERS | Formula Version |
| ROUTING_ID | Routing Identification |
| ROUTING_NO | Routing No |
| ROUTING_VERS | Routing Version |
| STEP_ID | Step Identification |
| STEP_NO | Step Number |
| OPRN_ID | Operation Identification |
| OPRN_NO | Operation Number |
| OPRN_VERS | Operation Version |
| SPEC_ID | Specification identifier |
| CHARGE | Charges |
| SPEC_VR_STATUS | Specification Validity Rule |
| START_DATE | Start date |
| END_DATE | End Date |
| SAMPLING_PLAN_ID | Sampling Plan ID |
| SAMPLE_INV_TRANS_IND | Indicates an inv trans is created for the sample amt.Y = Yes, Null = No |
| LOT_OPTIONAL_ON_SAMPLE | Lot optional on sample |
| CONTROL_LOT_ATTRIB_IND | A = Auto, W = WorkFlow Null = No |
| OUT_OF_SPEC_LOT_STATUS | Outside specification lot status |
| IN_SPEC_LOT_STATUS | In specification lot status |
| ORGN_CODE | Organization |
| COA_TYPE | Certificate of Analysis type |
| CONTROL_BATCH_STEP_IND | Control batch step indicator |
| COA_AT_SHIP_IND | Certificate of Analysis type |
| COA_AT_INVOICE_IND | Certificate of Analysis invoice indicator |
| COA_REQ_FROM_SUPL_IND | Certificate of Analysis from supplier |
| DELETE_MARK | Logical delete |
| TEXT_CODE | Edit Text |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
| ATTRIBUTE1 | Descriptive Flexfield column |
| ATTRIBUTE2 | Descriptive Flexfield column |
| BATCH_ID | Batch Identification |
| ATTRIBUTE3 | Descriptive Flexfield column |
| ATTRIBUTE4 | Descriptive Flexfield column |
| ATTRIBUTE5 | Descriptive Flexfield column |
| ATTRIBUTE6 | Descriptive Flexfield column |
| ATTRIBUTE7 | Descriptive Flexfield column |
| ATTRIBUTE8 | Descriptive Flexfield column |
| ATTRIBUTE9 | Descriptive Flexfield column |
| ATTRIBUTE10 | Descriptive Flexfield column |
| ATTRIBUTE11 | Descriptive Flexfield column |
| ATTRIBUTE12 | Descriptive Flexfield column |
| RECIPE_ID | Recipe Identification |
| ATTRIBUTE13 | Descriptive Flexfield column |
| ATTRIBUTE14 | Descriptive Flexfield column |
| ATTRIBUTE15 | Descriptive Flexfield column |
| ATTRIBUTE16 | Descriptive Flexfield column |
| ATTRIBUTE17 | Descriptive Flexfield column |
| ATTRIBUTE18 | Descriptive Flexfield column |
| ATTRIBUTE19 | Descriptive Flexfield column |
| ATTRIBUTE20 | Descriptive Flexfield column |
| ATTRIBUTE21 | Descriptive Flexfield column |
| ATTRIBUTE22 | Descriptive Flexfield column |
| RECIPE_NO | Recipe number |
| ATTRIBUTE23 | Descriptive Flexfield column |
| ATTRIBUTE24 | Descriptive Flexfield column |
| ATTRIBUTE25 | Descriptive Flexfield column |
| ATTRIBUTE26 | Descriptive Flexfield column |
| ATTRIBUTE27 | Descriptive Flexfield column |
| ATTRIBUTE28 | Descriptive Flexfield column |
| ATTRIBUTE29 | Descriptive Flexfield column |
| ATTRIBUTE30 | Descriptive Flexfield column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| RECIPE_VERSION | Recipe Version |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| AUTO_SAMPLE_IND | Auto Sample Creation Indicator |
| DELAYED_LOT_ENTRY | If this column is set to Yes then the lot/sublot columns for samples created with this spec vr may be entered when the final disposition is entered |
| ORGANIZATION_ID | This is organization ID |
| OUT_OF_SPEC_LOT_STATUS_ID | This is OUT OF spec lot status ID |
| IN_SPEC_LOT_STATUS_ID | This is In spec lot status ID |
| ERECORD_SPEC_VR_ID | Original Erec key for record this was created from |
| MIGRATED_IND | Indicates Status of the Migration of this table |
| MATERIAL_DETAIL_ID | 'This is the material detail for batch |
| AUTO_COMPLETE_BATCH_STEP | Auto Complete Batch Step Indicator |
| BATCH_FREQUENCY | Batch Freuency |
| FORMULA_ID | Formula Identification |
| DELAYED_LPN_ENTRY | This is the column for the delayed License Plate Number entry indicator |
| FORMULALINE_ID | Formula Line |
| Process Manufacturing Product Development - GMD_TECHNICAL_SEQUENCE_DTL | Technical Parameter Sort Sequence Detail Table |
|---|---|
| Column Name | Descritpion |
| TECH_SEQ_ID | Surrogate Key |
| TECH_PARM_ID | Foreign Key to GMD_TECH_PARAMETERS_B |
| SORT_SEQ | Sort Sequence for hte parameter |
| TEXT_CODE | Edit Text Code |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - GMD_TECHNICAL_SEQUENCE_HDR | Technical Parameter Sort Sequence Table |
|---|---|
| Column Name | Descritpion |
| TECH_SEQ_ID | Surrogate key |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| INVENTORY_ITEM_ID | This is the Item ID Column |
| ORGANIZATION_ID | This is the Organization ID Column |
| ORGN_CODE | Organization for which sequence is defined |
| ITEM_ID | Item for which the sequence is defined |
| CATEGORY_ID | Category for the sequence |
| DELETE_MARK | Indicator for marked for purge record. 0=Active record (default); 1=Marked for (logical) deletion |
| TEXT_CODE | Text Code |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| Process Manufacturing Product Development - GMD_TEST_INTERVAL_PLANS_TL | Translation table for test interval plans |
|---|---|
| Column Name | Descritpion |
| TEST_INTERVAL_PLAN_ID | Primary key created from sequence |
| LANGUAGE | Language of the test interval plan |
| DESCRIPTION | Description of test time interval plan |
| SOURCE_LANG | Source language of the test interval plan |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Process Manufacturing Product Development - GMD_TEST_INTERVAL_PLAN_PERIODS | Table for test interval plan periods |
|---|---|
| Column Name | Descritpion |
| PERIOD_ID | Primary key created from sequence |
| FROM_BASE | Y,If this test is taken from base test time interval, otherwise N |
| EXCLUDE | Y, If this test is excluded from base test time interval, otherwise N |
| TEXT_CODE | Text code |
| ATTRIBUTE_CATEGORY | Descriptive flexfield category |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| TEST_INTERVAL_PLAN_ID | foreign key to table gmd_test_interval_plans_b |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| NAME | Name of the period |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| YEARS_FROM_START | Years from start of test interval |
| ATTRIBUTE27 | Descriptive flexfield segment |
| ATTRIBUTE28 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield segment |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| MONTHS_FROM_START | Months from start of test interval |
| WEEKS_FROM_START | Weeks from start of test interval |
| DAYS_FROM_START | Days from start of test interval |
| HOURS_FROM_START | Hours from start of test interval |
| SIMULATED_DATE | Simulated date for this period when the test interval falls for the simulated date given in the for test interval plan |
| Process Manufacturing Product Development - GMD_TEST_INTERVAL_PLANS_B | Base table for test interval plans |
|---|---|
| Column Name | Descritpion |
| TEST_INTERVAL_PLAN_ID | Primary Key created from Sequence |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| NAME | Name of the test interval plan |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| BASE_TEST_INTERVAL_PLAN_ID | Base test interval plan for overlay test interval plan |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield segment |
| ATTRIBUTE27 | Descriptive flexfield segment |
| ATTRIBUTE28 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield segment |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| SIMULATION_START_DATE | Simulated start date for test time interval plan |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DELETE_MARK | Logical delete mark |
| TEXT_CODE | Text code |
| ATTRIBUTE_CATEGORY | Descriptive flexfield category |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| Process Manufacturing Product Development - GMD_UOM_CONVERSIONS | UOM Conversions Based on Quality Results. |
|---|---|
| Column Name | Descritpion |
| EVENT_SPEC_DISP_ID | Sample Group Specficiation Disposition ID |
| FROM_UOM_BASE | The unit of measure from where the conversion begins |
| TO_UOM_BASE | The unit of measure the coversion is converting to |
| PROPOSED_CONVERSION_BASE | Proposed UOM Conversion Between the From Base UOM and To Base UOM |
| DELETE_MARK | Delete Mark; 0 = Active, 1 = Deleted |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| RESULT_CONV_ID | Surrogate Key |
| TEST_ID | Test ID |
| FROM_QTY_UOM | UOM before the update |
| FROM_QTY_UOM_BASE | Base UOM before the update |
| TO_QTY_UOM | UOM after the update |
| TO_QTY_UOM_BASE | Base UOM after the update |
| RESULT_ID | Result ID |
| COMPOSITE_RESULT_ID | Composite Result ID |
| FROM_UOM | From UOM |
| TO_UOM | To UOM |
| CURRENT_CONVERSION | Corrent UOM Conversion Between From UOM and To UOM |
| PROPOSED_CONVERSION | Proposed UOM Conversion Between From UOM and To UOM as per the Test Result |
| RECOMMENDED_IND | Set to Y when the Proposed UOM Conversion Between From UOM and To UOM is reflected in OPM Inventory; NULL Otherwise. |
| Process Manufacturing Product Development - GMD_TEST_GROUP_GT | |
|---|---|
| Column Name | Descritpion |
| TEST_GROUP_ORDER | |
| TEST_QTY_UOM | |
| TEST_ID | |
| TEST_CODE | |
| TEST_DESC | |
| TEST_TYPE | |
| TEST_QTY | |
| OLD_TEST_UOM | |
| USED_IN_SPEC | |
| INCLUDE |
| Process Manufacturing Product Development - GMD_VAL_RULE_GTMP | |
|---|---|
| Column Name | Descritpion |
| RECIPE_VALIDITY_RULE_ID | |
| MAX_QTY | |
| STD_QTY | |
| ITEM_UM | |
| INV_MIN_QTY | |
| INV_MAX_QTY | |
| TEXT_CODE | |
| ATTRIBUTE_CATEGORY | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| RECIPE_ID | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ORGN_CODE | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| ATTRIBUTE16 | |
| ATTRIBUTE17 | |
| ATTRIBUTE18 | |
| ATTRIBUTE19 | |
| ATTRIBUTE20 | |
| ATTRIBUTE21 | |
| ATTRIBUTE22 | |
| ATTRIBUTE23 | |
| ITEM_ID | |
| ATTRIBUTE24 | |
| ATTRIBUTE25 | |
| ATTRIBUTE26 | |
| ATTRIBUTE27 | |
| ATTRIBUTE28 | |
| ATTRIBUTE29 | |
| ATTRIBUTE30 | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| RECIPE_USE | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| DELETE_MARK | |
| VALIDITY_RULE_STATUS | |
| LAB_TYPE | |
| PLANNED_PROCESS_LOSS | |
| ORGANIZATION_ID | |
| INVENTORY_ITEM_ID | |
| REVISION | |
| DETAIL_UOM | |
| PREFERENCE | |
| UNIT_COST | |
| TOTAL_COST | |
| START_DATE | |
| END_DATE | |
| MIN_QTY |
| Process Manufacturing Product Development - GMD_TECHNICAL_REQS | LCF - Technical Requirements Table |
|---|---|
| Column Name | Descritpion |
| FORMULATION_SPEC_ID | Surrogate key for the formulation specification/version |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| TECH_REQ_ID | Surrogate key for the technical requirement line |
| SPEC_ATTRIBUTE_ID | Surrogate key for the spec attribute line. Used to determine the type of requirement |
| TECH_PARM_ID | Technical Parameter ID Column |
| MIN_VALUE | Minimum value Column |
| MAX_VALUE | Maximum value Column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATED_BY | Standard who column |
