My Process Manufacturing Product Development Table Descriptions hand book (I have big hands) part2

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