Process Manufacturing Product Development - FM_ACTV_MST | Activity master. Defines activities which are performed in operations. |
---|---|
Column Name | Descritpion |
ACTIVITY | Code for the activity. |
TRANS_CNT | Not currently used |
LAST_UPDATE_LOGIN | Standard who column |
ACTIVITY_DESC | Description of the activity. |
COST_ANALYSIS_CODE | The cost analysis code for this activity, for example, is this a value added or non-value added activity. |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
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 |
Process Manufacturing Product Development - FM_ARES_MST | Operation-specific alternate resource factors |
---|---|
Column Name | Descritpion |
OPRN_ID | The surrogate key for the operation for which alternate resource factors are defined. |
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 |
PRIMARY_RESOURCE | The resource usually used for the operation. |
ALTERNATE_RESOURCE | The alternate resource for the operation. |
SETUP_FACTOR | The factor by which setup time is multiplied when using the alternate resource. For example, this would be 2 if the alternate resource requires double the setup time of the primary resource. |
RUNTIME_FACTOR | The factor by which runtime is multiplied when using the alternate resource. For example, this would be 2 if the alternate resource requires double the runtime of the primary resource. |
POSTOP_FACTOR | The factor by which postop time is multiplied when using the alternate resource. For example, this would be 2 if the alternate resource requires double the postop time of the primary resource. |
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 |
Process Manufacturing Product Development - FM_CONF_TBL | FM effectivity configuration. Controls how formula effectivities are created. |
---|---|
Column Name | Descritpion |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
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 |
LAST_UPDATE_LOGIN | Standard who column |
FMCONF_ID | Surrogate key for fm_conf_tbl. |
ORGN_CODE | Organization for which effectivity behavior is defined. May also be blank, meaning ALL organizations. |
FORMULA_USE | The formula can be used for: 0=Production,1=MRP,2=Costing,3=MSDS. |
EFF_BEHAV | How effectivity is created: 0=Effectivity must be entered manually, 1=Maintain effectivity form is brought up when going from Products form to ingredients or by-products,2=Automatically created with the organization specified |
ORGN_DEFAULT | Default for organization on effectivity record: 0=Use user's default organization,1=Use blank for ALL organizations |
CONFLICT_RES | Controls how overlapping effectvities are handled on the creation of a new effectivity: 0=Do not modify other effectivities,1=Lower the preference (increase preference number) so new effectivity is preferred,2=Reset end dates for other effe |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - FM_FMCT_CLS | Formula control classes -NOT USED- |
---|---|
Column Name | Descritpion |
FMCONTROL_CLASS | Used to group formulas together for security purposes |
LAST_UPDATE_LOGIN | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
FMCONTROL_CLASS_DESC | Description of Class |
TRANS_CNT | 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 |
Process Manufacturing Product Development - FM_FORM_CLS | Formula classes - used to group formulas. |
---|---|
Column Name | Descritpion |
FORMULA_CLASS | Code identifying the formula class. |
LAST_UPDATE_LOGIN | Standard who column |
FORMULA_CLASS_DESC | Description of the formula class. |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
TRANS_CNT | 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 |
Process Manufacturing Product Development - FM_FORM_EFF | Formula/routing effectivities. Conditions under which a Formula/Routing can be used |
---|---|
Column Name | Descritpion |
FMEFF_ID | Surrogate key for this effectivity row. |
INV_MAX_QTY | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. |
MIN_QTY | The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. |
MAX_QTY | The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. |
STD_QTY | Standard batch size for this rec. |
ITEM_UM | UOM for min_qty and max_qty. |
PREFERENCE | Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column. |
ROUTING_ID | Surrogate key for the routing/routing version to be used, if any. |
FORMULA_ID | Surrogate key for the formula /formula version to be used. |
CUST_ID | Surrogate key for the customer for which this effectivity is used, if any. |
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. |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
TRANS_CNT | Not currently used |
LAST_UPDATE_LOGIN | Standard who column |
ORGN_CODE | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. |
ITEM_ID | Surrogate key for the item which is produced by the formula. |
FORMULA_USE | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. |
END_DATE | The end date of the effectivity. |
START_DATE | The start date of the effectivity. |
INV_MIN_QTY | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. |
Process Manufacturing Product Development - FM_FORM_MST | Formula header table |
---|---|
Column Name | Descritpion |
FORMULA_ID | Surrogate for formula_no + formula_vers. |
IN_USE | Not currently used |
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 |
INACTIVE_IND | Inactive indicator. 0=Active, 1=Inactive. |
FORMULA_NO | Alphanumeric formula name or number. |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
FORMULA_VERS | Formula version. |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
FORMULA_TYPE | 0=std formula; 1=packaged item formula (these are not currently used). |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
SCALE_TYPE | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
ATTRIBUTE16 | Descriptive flexfield segment |
ATTRIBUTE17 | Descriptive flexfield segment |
ATTRIBUTE18 | Descriptive flexfield segment |
FORMULA_DESC1 | Formula description. |
ATTRIBUTE19 | Descriptive flexfield segment |
ATTRIBUTE20 | Descriptive flexfield segment |
ATTRIBUTE21 | Descriptive flexfield segment |
ATTRIBUTE22 | Descriptive flexfield segment |
ATTRIBUTE23 | Descriptive flexfield segment |
FORMULA_DESC2 | Formula comment. |
ATTRIBUTE24 | Descriptive flexfield segment |
ATTRIBUTE25 | Descriptive flexfield segment |
ATTRIBUTE26 | Descriptive flexfield segment |
ATTRIBUTE27 | Descriptive flexfield segment |
ATTRIBUTE28 | Descriptive flexfield segment |
FORMULA_CLASS | Formula class. No programatic support (fm_form_cls). |
ATTRIBUTE29 | Descriptive flexfield segment |
ATTRIBUTE30 | Descriptive flexfield segment |
ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
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. |
FMCONTROL_CLASS | Not currently used. (fn_fmct_cls). |
Process Manufacturing Product Development - FM_IBOM_DTL | Detail table for Indented Bill of Materials Report |
---|---|
Column Name | Descritpion |
TOP_FORMULA_ID | Surrogate key to reference fm_form_mst for top level formula being exploded |
FORMULA_QTY | Quantity from formula line |
STD_QTY | Standard quantity |
I_QTY_UOM | Unit of measure in which the quantities are expressed |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
EXPLODE_SEQ | The sequence number used to determine in what order formulas should be exploded |
INVENTORY_ITEM_ID | This is the inv item id |
FORMULA_ID | Surrogate key to fm_form_mst for the formula which contains the item |
ITEM_ID | Surrogate key used to reference ic_item_mst for item in the Bill of Materials |
LINE_TYPE | 1=product; -1=ingredient; 2=byprod. |
LINE_NO | List order on screen within a line_type. |
LINE_DESC | Formula line description |
LEVEL_NUM | How many levels deep this formula is from the top formula |
SCALE_QTY | Quantity for line when scaled to quantity for top level formula |
Process Manufacturing Product Development - FM_IBOM_HDR | Header table used for Indented Bill Of Materials report |
---|---|
Column Name | Descritpion |
TOP_FORMULA_ID | Surrogate key to fm_form_mst for top level formula being exploded |
MAX_EXPLODE_LEVELS | Maximum level that formula can be exploded out to. |
EXPLODED_BY | Name of person who ran the formula explosion |
EXPLODED_DATE | Date formula was exploded |
STATUS_CODE | Stores the formulae statuses |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
ITEM_ID | Surrogate key used to reference ic_item_mst for product number |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
SCALE_PERCENT | Percentage used to scale formula up or down |
ORGN_CODE | Organization code for the IBOM report |
FORMULA_USE | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. |
VALIDITY_ORGANIZATION_TYPE | Column indicates the validity level of the Organization for the IBOM report |
ORGANIZATION_ID | This is the inv organization ID |
EFFECTIVITY_DATE | Date used to select for selection of appropriate effectivity record |
INVENTORY_ITEM_ID | This is the inv item id |
FORMULA_QTY | Quantity from formula line |
DISPLAY_QTY | To indicate whether to display the qty or not |
REPORT_QTY | Quantity for which the report is run - Quantity for top level formula |
EXPLODE_IND | To indicate explode all ingredients or phantom ingredients only |
REPORT_UOM | Unit of measure in which report_qty is expressed |
SCALE_ALLOWED | To indicate whether scaling is allowed |
USE_INACTIVE_FLAG | 0 = Don't use inactive flag; 1 = Use inactive flag |
Process Manufacturing Product Development - FM_MATL_DTL | Formula material details - contains products,byproducts and ingredient information |
---|---|
Column Name | Descritpion |
FORMULALINE_ID | Surrogate key for the formula line. |
SCALE_TYPE | 0=fixed, no scaling; 1=proportional scaling. |
COST_ALLOC | If product, fractional cost absorption. |
LAST_UPDATED_BY | Standard who column |
CREATED_BY | Standard who column |
PHANTOM_TYPE | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
LAST_UPDATE_DATE | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ATTRIBUTE1 | Descriptive Flexfield Segment |
REWORK_TYPE | Not currently used. |
ATTRIBUTE2 | Descriptive Flexfield Segment |
ATTRIBUTE3 | Descriptive Flexfield Segment |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
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 |
TPFORMULA_ID | Surrogate key indicating the lab formula/version from which the technical parameters of an item are calculated. |
ATTRIBUTE14 | Descriptive Flexfield Segment |
ATTRIBUTE15 | Descriptive Flexfield Segment |
FORMULA_ID | Surrogate key for the formula/version. |
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 |
IAFORMULA_ID | Stores the Ingredient Contribution Formula ID that will be entered on the technical data selection screen. |
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 |
SCALE_UOM | Unit of Measure Scale |
CONTRIBUTE_STEP_QTY_IND | Indicator to specify if the item contributes to step quantity. If item is defined as a packaging item, then the item cannot contribute to the step quantity, therefore, the value is N, for No. (Y = The item contributes to step quantity, Def |
LINE_TYPE | 1=product; -1=ingredient; 2=byprod. |
CONTRIBUTE_YIELD_IND | Indicator to specify if the item ( product or ingredient ) contributes to yield. If item is defined as a packaging item, then the item cannot contribute to yield, therefore, the value is N, for No. (Y = The item contributes to yield, Defaul |
SCALE_MULTIPLE | The multiples of the batch uom used for scaling in multiples. ( 0 = Scaling does not scale by multiples, > 0 = Scale by multiples, value must be a whole number, < 0 = Invalid value) |
SCALE_ROUNDING_VARIANCE | Percentage + / - of the variance of scale multiple allowed when scaling; default is zero. |
ROUNDING_DIRECTION | Applied to ingredients for either rounding up or down the scaled quantity value |
BY_PRODUCT_TYPE | The type of byproduct being yielded |
BUFFER_IND | Buffer indicator |
INVENTORY_ITEM_ID | Inventory item id |
ORGANIZATION_ID | Inventory organization id |
DETAIL_UOM | Inventory item uom |
REVISION | Inventory Item Revision |
INGREDIENT_END_DATE | Ingredient Effective End Date |
PROD_PERCENT | Column for Product Percentage |
LINE_NO | List order on screen within a line_type. |
ITEM_ID | Surrogate key for the item on the formula line. |
QTY | Item qty produced or consumed. |
ITEM_UM | Uom of qty. |
RELEASE_TYPE | 0=automatic release; 1=partial release |
SCRAP_FACTOR | Scrap factor decimal used to calculate required qty. |
Process Manufacturing Product Development - FM_OPRN_CLS | Formula operation class. Used to group operations. |
---|---|
Column Name | Descritpion |
OPRN_CLASS | Code identifying the operation class. |
LAST_UPDATE_LOGIN | Standard who column |
OPRN_CLASS_DESC | Description of the operation class. |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
TRANS_CNT | 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 |
Process Manufacturing Product Development - FM_OPRN_DTL | Operation details. Specifies the resources, activities and their usage. |
---|---|
Column Name | Descritpion |
OPRN_ID | Surrogate key for the operation. |
COST_ANALYSIS_CODE | The cost analysis code. Defaults from the activity, but can be overridden. |
ATTRIBUTE15 | Descriptive Flexfield Segment |
ATTRIBUTE16 | Descriptive Flexfield Segment |
COST_CMPNTCLS_ID | Surrogate key for a cost component class. Defaults from the resource, but can be overridden. |
ATTRIBUTE17 | Descriptive Flexfield Segment |
ATTRIBUTE18 | Descriptive Flexfield Segment |
RESOURCE_COUNT | Number of resources to use. |
ATTRIBUTE19 | Descriptive Flexfield Segment |
ATTRIBUTE20 | Descriptive Flexfield Segment |
RESOURCE_USAGE | Usage for 1 resource to do process_qty. |
ATTRIBUTE21 | Descriptive Flexfield Segment |
ATTRIBUTE22 | Descriptive Flexfield Segment |
USAGE_UM | Uom for resource usage. |
ATTRIBUTE23 | Descriptive Flexfield Segment |
ATTRIBUTE24 | Descriptive Flexfield Segment |
OFFSET_INTERVAL | Time offset from operation start. |
ATTRIBUTE25 | Descriptive Flexfield Segment |
ATTRIBUTE26 | Descriptive Flexfield Segment |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
ATTRIBUTE27 | Descriptive Flexfield Segment |
ATTRIBUTE28 | Descriptive Flexfield Segment |
ATTRIBUTE29 | Descriptive Flexfield Segment |
ATTRIBUTE30 | Descriptive Flexfield Segment |
LAST_UPDATED_BY | Standard who column |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
ACTIVITY | The activity performed by the resource to create the operation line. |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
RESOURCES | The resource used in the operation line. |
ATTRIBUTE1 | Descriptive Flexfield Segment |
ATTRIBUTE2 | Descriptive Flexfield Segment |
OPRN_LINE_ID | Surrogate key for the operation line. |
ATTRIBUTE3 | Descriptive Flexfield Segment |
ATTRIBUTE4 | Descriptive Flexfield Segment |
PROCESS_QTY | Qty processed per resource_usage. |
ATTRIBUTE5 | Descriptive Flexfield Segment |
ATTRIBUTE6 | Descriptive Flexfield Segment |
DEP_OPRN_LINE_ID | Not currently used. |
ATTRIBUTE7 | Descriptive Flexfield Segment |
ATTRIBUTE8 | Descriptive Flexfield Segment |
POC_CTL_CLASS | Not currently used. |
ATTRIBUTE9 | Descriptive Flexfield Segment |
ATTRIBUTE10 | Descriptive Flexfield Segment |
PRIM_RSRC_IND | 0=Non-primary resource, 1=Primary resource, 2=Auxilliary |
ATTRIBUTE11 | Descriptive Flexfield Segment |
ATTRIBUTE12 | Descriptive Flexfield Segment |
SCALE_TYPE | 0=Non-scalable, 1=Linear scaling. |
ATTRIBUTE13 | Descriptive Flexfield Segment |
ATTRIBUTE14 | Descriptive Flexfield Segment |
Process Manufacturing Product Development - FM_OPRN_MST | Operation master |
---|---|
Column Name | Descritpion |
OPRN_ID | Surrogate key for the operation. |
ATTRIBUTE15 | Descriptive Flexfield Segment |
ATTRIBUTE16 | Descriptive Flexfield Segment |
ATTRIBUTE17 | Descriptive Flexfield Segment |
ATTRIBUTE18 | Descriptive Flexfield Segment |
ATTRIBUTE19 | Descriptive Flexfield Segment |
ATTRIBUTE20 | Descriptive Flexfield Segment |
INACTIVE_IND | Not currently used. |
ATTRIBUTE21 | Descriptive Flexfield Segment |
ATTRIBUTE22 | Descriptive Flexfield Segment |
DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
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 |
ATTRIBUTE29 | Descriptive Flexfield Segment |
ATTRIBUTE30 | Descriptive Flexfield Segment |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
OPRN_NO | Operation name. |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATE_DATE | Standard who column |
OPRN_DESC | Description of the operation. |
ATTRIBUTE1 | Descriptive Flexfield Segment |
ATTRIBUTE2 | Descriptive Flexfield Segment |
OPRN_VERS | Not currently used. |
ATTRIBUTE3 | Descriptive Flexfield Segment |
ATTRIBUTE4 | Descriptive Flexfield Segment |
PROCESS_QTY_UM | UOM in which process qty is measured. |
ATTRIBUTE5 | Descriptive Flexfield Segment |
ATTRIBUTE6 | Descriptive Flexfield Segment |
OPRN_CLASS | Operation class (for grouping only). |
ATTRIBUTE7 | Descriptive Flexfield Segment |
ATTRIBUTE8 | Descriptive Flexfield Segment |
POC_CTL_CLASS | Not currently used. |
ATTRIBUTE9 | Descriptive Flexfield Segment |
ATTRIBUTE10 | Descriptive Flexfield Segment |
IN_USE | Not currently used |
ATTRIBUTE11 | Descriptive Flexfield Segment |
ATTRIBUTE12 | Descriptive Flexfield Segment |
ATTRIBUTE13 | Descriptive Flexfield Segment |
ATTRIBUTE14 | Descriptive Flexfield Segment |
Process Manufacturing Product Development - FM_ROUT_CLS | Routing class - used to group routings. |
---|---|
Column Name | Descritpion |
ROUTING_CLASS | Code for the routing class. |
LAST_UPDATE_LOGIN | Standard who column |
ROUTING_CLASS_DESC | Description of the routing class. |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
TRANS_CNT | Not currently used |
DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
CREATION_DATE | Standard who column |
Process Manufacturing Product Development - FM_ROUT_DEP | Routing step dependencies |
---|---|
Column Name | Descritpion |
ROUTINGSTEP_NO | Routingstep_no from fm_rout_dtl |
ROUTING_ID | Surrogate key for the routing for which step dependencies are defined. |
DEP_TYPE | Dependency type (0=normal; 1=rework, not currently used). |
REWORK_CODE | Not currently used. |
STANDARD_DELAY | Period between start of dep_step and step. |
MINIMUM_DELAY | Minimum delay between start of dep_step and step. Not currently used. |
MAX_DELAY | Maximum delay between start of dep_step and step . Not currently used. |
TRANSFER_QTY | Not currently used. |
ITEM_UM | Not currently used. |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
LAST_UPDATED_BY | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATION_DATE | Standard who column |
DEP_ROUTINGSTEP_NO | Routingstep_no from fm_rout_dtl that is dependent upon the previously entered routingstep_no |
LAST_UPDATE_LOGIN | Standard who column |
TRANSFER_PCT | Transfer Percentage |
CHARGEABLE_IND | Indicator to apply the dependency based on charge. Valid values are - 0 or NULL (implies not to apply based on charge), 1 (indicates to apply based on charge) |
ROUTINGSTEP_NO_UOM | Routing step no uom in 3 characters |
Process Manufacturing Product Development - FM_ROUT_DTL | Routing details |
---|---|
Column Name | Descritpion |
ROUTING_ID | Surrogate key for the routing. |
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 |
X_COORDINATE | X Coordinate for Recipe Designer |
ATTRIBUTE27 | Descriptive Flexfield Segment |
ATTRIBUTE28 | Descriptive Flexfield Segment |
Y_COORDINATE | Y Coordinate for Recipe Designer |
ATTRIBUTE29 | Descriptive Flexfield Segment |
ATTRIBUTE30 | Descriptive Flexfield Segment |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Segment |
LAST_UPDATED_BY | Standard who column |
MINIMUM_TRANSFER_QTY | Minimum amount of material that must be produced at a given production operation and resource, that will be transferred to the next operation and resource before it can begin processing |
CREATED_BY | Standard who column |
ROUTINGSTEP_NO | Step number of routing step. |
LAST_UPDATE_DATE | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ATTRIBUTE1 | Descriptive Flexfield Segment |
ATTRIBUTE2 | Descriptive Flexfield Segment |
ROUTINGSTEP_ID | Surrogate key for the routing step. |
ATTRIBUTE3 | Descriptive Flexfield Segment |
ATTRIBUTE4 | Descriptive Flexfield Segment |
OPRN_ID | Surrogate key for the operation performed in this step. |
ATTRIBUTE5 | Descriptive Flexfield Segment |
ATTRIBUTE6 | Descriptive Flexfield Segment |
STEP_QTY | Quantity processed by the routing step. |
ATTRIBUTE7 | Descriptive Flexfield Segment |
ATTRIBUTE8 | Descriptive Flexfield Segment |
STEPRELEASE_TYPE | Step release type. 0=Automatic, 1=Manual. |
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 |
Process Manufacturing Product Development - FM_ROUT_HDR | Routing header |
---|---|
Column Name | Descritpion |
ROUTING_ID | Surrogate key for routing_no+routing_vers. |
ATTRIBUTE15 | Descriptive Flexfield Segment |
ATTRIBUTE16 | Descriptive Flexfield Segment |
ATTRIBUTE17 | Descriptive Flexfield Segment |
ATTRIBUTE18 | Descriptive Flexfield Segment |
DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
ATTRIBUTE19 | Descriptive Flexfield Segment |
ATTRIBUTE20 | Descriptive Flexfield Segment |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
ATTRIBUTE21 | Descriptive Flexfield Segment |
ATTRIBUTE22 | Descriptive Flexfield Segment |
INACTIVE_IND | Not currently used. |
ATTRIBUTE23 | Descriptive Flexfield Segment |
ATTRIBUTE24 | Descriptive Flexfield Segment |
IN_USE | Not currently used |
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 |
ROUTING_NO | Routing name. |
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 |
ROUTING_VERS | Routing version. |
ATTRIBUTE1 | Descriptive Flexfield Segment |
ATTRIBUTE2 | Descriptive Flexfield Segment |
ROUTING_DESC | Routing description. |
ATTRIBUTE3 | Descriptive Flexfield Segment |
ATTRIBUTE4 | Descriptive Flexfield Segment |
ROUTING_CLASS | User defined class for routings. |
ATTRIBUTE5 | Descriptive Flexfield Segment |
ATTRIBUTE6 | Descriptive Flexfield Segment |
ROUTING_QTY | Used in ratio with formula and batch qty to scale individual step requirements. |
ATTRIBUTE7 | Descriptive Flexfield Segment |
ATTRIBUTE8 | Descriptive Flexfield Segment |
ITEM_UM | Uom of routing qty. |
ATTRIBUTE9 | Descriptive Flexfield Segment |
ATTRIBUTE10 | Descriptive Flexfield Segment |
ATTRIBUTE11 | Descriptive Flexfield Segment |
ATTRIBUTE12 | Descriptive Flexfield Segment |
ATTRIBUTE13 | Descriptive Flexfield Segment |
ATTRIBUTE14 | Descriptive Flexfield Segment |
Process Manufacturing Product Development - FM_ROUT_MTL | Routing Steps to Formula Lines Association |
---|---|
Column Name | Descritpion |
ROUTING_ID | Surrogate key for the routing. |
LAST_UPDATE_DATE | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
FORMULALINE_ID | Surrogate key of the formula line to which a routing step is associated. |
FORMULA_ID | Surrogate key for the formula. |
ROUTINGSTEP_NO | Number of the routing step to which a formula line is associated. |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
LAST_UPDATED_BY | Standard who column |
CREATED_BY | Standard who column |
Process Manufacturing Product Development - FM_TEXT_HDR | Table used to store text types for Formula Model |
---|---|
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_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
Process Manufacturing Product Development - FM_TEXT_TBL_TL | FM 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 |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | 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 that the text is stored in |
SOURCE_LANG | Source Language Code |
LAST_UPDATED_BY | Standard who column |
Process Manufacturing Product Development - GMD_QC_ASSAY_CLASS | Quality Assay Class. Assay classes are quality test groupings. |
---|---|
Column Name | Descritpion |
ASSAY_CLASS | Assay class |
TEXT_CODE | Edit text code |
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 |
ASSAY_CLASS_DESC | Assay class description |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | 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 |
CREATED_BY | Standard who column |
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 |
LAST_UPDATED_BY | Standard who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
MIGRATION_STATUS | Record migration status |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
TRANS_CNT | Transaction count |
DELETE_MARK | Mark for purge |
Process Manufacturing Product Development - GMD_COA_DETAILS | Certificate of Analysis report details information |
---|---|
Column Name | Descritpion |
GMD_COA_ID | distinct number of the header |
MAX_SPEC | Maximum of spec target numeric range |
UOM | Assay unit code for test |
RSLT_TEXT_CODE | Result text key to GMD text table |
SPEC_TEXT_CODE | Specification text key to GMD text table |
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 |
TEST_UNIT | Test Unit |
QC_RESULT_ID | key to results table. Uniquely identifies the result. |
TEST_METHOD | Test Method Code |
INV_UOM | This is UOM |
RESULT_DATE | Date result was logged. |
QC_SPEC_ID | Key to spec assay line which provides target |
ASSAY_CODE | Name of test |
ASSAY_DESC | Description of test |
RESULT | Text or numeric result of test |
SPECIFICATION | Target from specification |
MIN_SPEC | Minimum of spec target numeric range |
Process Manufacturing Product Development - GMD_COA_HEADERS | Certificate of Analysis report header information |
---|---|
Column Name | Descritpion |
GMD_COA_ID | Distinct number of the header |
CUST_NAME | Name of customer |
BOL_ID | Key to bill of lading |
BOL_NO | Bill of lading number |
ITEM_ID | Key to item |
ITEM_NO | Item number |
ITEM_DESC1 | Item description |
WHSE_CODE | Warehouse code |
WHSE_NAME | Warehouse name |
LOT_ID | Key to lot and any sublot |
LOT_NO | Lot number |
ORDER_ID | Key to customer order |
LOT_DESC | Lot description |
SUBLOT_NO | Sublot number |
ORDER_QTY1 | Order quantity in the primary UOM |
ORDER_UM1 | Primary UOM |
ORDER_QTY2 | Order quantity in the secondary UOM |
ORDER_UM2 | Secondary UOM |
SHIP_QTY1 | Shipping quantity in the primary UOM |
SHIP_QTY2 | Shipping quantity in the secondary UOM |
REPORT_TITLE | Certificate of Analysis or Certificate of Conformance |
OPM_CUST_ID | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. |
CREATED_BY | Standard who column |
LINE_ID | Key to customer order line |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
SESSION_ID | session id of coa run |
SHIP_UOM1 | This is the Unit of Measure for Shipping Quantity 1 |
SHIP_UOM2 | This is the Unit of Measure for Shipping Quantity 2 |
INVENTORY_ITEM_ID | This is Inventory Item ID |
ITEM_DESCRIPTION | This is Item Description |
ITEM_NUMBER | This is Item Number |
ORGN_CODE | Organization which can use the specification. May be global |
LOT_DESCRIPTION | This is Lot Description |
LOT_NUMBER | This is Lot Number |
ORDER_INV_UOM | This is Order Inv UOM |
ORDER_UOM1 | This is Order UOM 1 |
ORDER_UOM2 | This is Order UOM 2 |
ORGANIZATION_CODE | This is Organization Code |
ORGANIZATION_ID | This is Organization ID |
REVISION | This is Revision |
SHIP_QTY_UOM1 | This is Ship Qty UOM 1 |
SHIP_QTY_UOM2 | This is Ship Qty UOM 2 |
ORDER_NO | Order number |
SPEC_HDR_TEXT_CODE | This is Spec header text code |
SUBINVENTORY | This is Subinventory |
CUSTPO_NO | Customer purchase number |
SHIPDATE | Order ship date |
CUST_ID | Customer ID |
CUST_NO | Customer number |
Process Manufacturing Product Development - GMD_COA_RSLT_TEXT | Certificate of Analysis result text |
---|---|
Column Name | Descritpion |
GMD_COA_ID | Distinct number of the header |
TEXT_CODE | Result text key to the GMD text table |
PARAGRAPH_CODE | Defined in the sy_para_cds |
LINE_NO | Line number which allows multiple lines of descriptive text for underlying record. -1=line is used to recreate key of underlying record; 1<=descriptive text |
TEXT | Text associated with this result. |
Process Manufacturing Product Development - GMD_COA_SPEC_TEXT | Certificate of Analysis Specification text |
---|---|
Column Name | Descritpion |
GMD_COA_ID | Distinct number of the header |
TEXT_CODE | Result text key to the GMD text table |
PARAGRAPH_CODE | Defined in the sy_para_cds |
LINE_NO | Line number which allows multiple lines of descriptive text for underlying record. -1=line is used to recreate key of underlying record; 1<=descriptive text |
TEXT | Text associated with this specification. |
Process Manufacturing Product Development - GMD_FORMULA_ANALYSIS_DTL | Formula analysis detail table |
---|---|
Column Name | Descritpion |
FORMULA_ID | Formula for which analysis has been run. |
DIRECT_VOLUME | Direct contribution of item in the formula in VOLUME uom type. |
DIRECT_VOLUME_PERCENT | Direct contribution in percent of item in the formula in VOLUME uom type. |
INDIRECT_VOLUME | Indirect contribution of item in the formula in VOLUME uom type. |
INDIRECT_VOLUME_PERCENT | Indirect contribution in percent of item in the formula in VOLUME uom type. |
ORGANIZATION_ID | This is the inv organization ID |
LABORATORY_ID | This is the inv laboratory id |
INVENTORY_ITEM_ID | This is the inv item id |
LINE_NO | added line number to table GMD_FORMULA_ANALYSIS_DTL |
ORGN_CODE | Organization under which analysis was run. |
ITEM_ID | Item involved in the formula analysis. |
TECHNICAL_CLASS | Item involved in the formula analysis. |
TECHNICAL_SUB_CLASS | Technical Sub Class of item. |
DIRECT_WEIGHT | Direct contribution of item in the formula in MASS uom type. |
DIRECT_WEIGHT_PERCENT | Direct contribution in percent of item in the formula in MASS uom type. |
INDIRECT_WEIGHT | Indirect contribution of item in the formula in MASS uom type. |
INDIRECT_WEIGHT_PERCENT | Indirect contribution in percent of item in the formula in MASS uom type. |
Process Manufacturing Product Development - GMD_FORMULA_ANALYSIS_HDR | Formula Analysis Header table. |
---|---|
Column Name | Descritpion |
FORMULA_ID | Formula for which analysis has been run |
ANALYSIS_UOM | This is the analysis UOM. |
ORGANIZATION_ID | THIS IS THE INV ORGANIZATION ID |
LABORATORY_ID | This is the inv laboratory id |
ANALYSIS_HDR_UOM | This is the Analysis UOM Column post-convergence |
ORGN_CODE | Organization under which analysis was run. |
EXPLOSION_RULE | Explosion rule used for intermediates during analysis.Valid options are: 0 = Use Production Formulas, 1 = Use Laboratory Formulas |
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 |
ANALYSIS_QTY | This is the analysis qty. |
Process Manufacturing Product Development - FM_FORM_MST_B | Formula header base table |
---|---|
Column Name | Descritpion |
FORMULA_ID | Surrogate for formula_no + formula_vers. |
IN_USE | Not currently used |
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 |
INACTIVE_IND | Inactive indicator. 0=Active, 1=Inactive. |
TOTAL_INPUT_QTY | Total Input Quantity |
TOTAL_OUTPUT_QTY | Total Output Quantity |
FORMULA_STATUS | Formula Status |
OWNER_ID | Owner Identifier |
PROJECT_ID | Project Identifier |
OWNER_ORGANIZATION_ID | Inventory organization id |
MASTER_FORMULA_ID | Parent formula id |
YIELD_UOM | This is the column to hold the value of yield uom |
AUTO_PRODUCT_CALC | Column for Calculate Product Qty Flag |
ORGN_CODE | Organization Code |
FORMULA_UOM | Formula Unit of Measure |
FORMULA_NO | Alphanumeric formula name or number. |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
FORMULA_VERS | Formula version. |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
ATTRIBUTE8 | Descriptive flexfield segment |
FORMULA_TYPE | 0=std formula; 1=packaged item formula |
ATTRIBUTE9 | Descriptive flexfield segment |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
SCALE_TYPE | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
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 |
FORMULA_CLASS | Formula class. No programatic support (fm_form_cls). |
ATTRIBUTE29 | Descriptive flexfield segment |
ATTRIBUTE30 | Descriptive flexfield segment |
ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
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. |
FMCONTROL_CLASS | Not currently used. (fn_fmct_cls). |
Process Manufacturing Product Development - FM_FORM_MST_TL | Formula header translation table |
---|---|
Column Name | Descritpion |
LANGUAGE | Language code the formula is stored in |
FORMULA_DESC1 | Formula Description |
FORMULA_DESC2 | Formula Description |
SOURCE_LANG | Source Language Code |
CREATED_BY | Standard WHO Columns |
CREATION_DATE | Standard WHO Columns |
LAST_UPDATED_BY | Standard WHO Columns |
LAST_UPDATE_DATE | Standard WHO Columns |
FORMULA_ID | Formula Identifier |
LAST_UPDATE_LOGIN | Standard WHO Columns |
Process Manufacturing Product Development - GMD_PROCESS_LOSS | Routing Process Loss |
---|---|
Column Name | Descritpion |
ROUTING_CLASS | Routing Class Name |
MAX_QUANTITY | Maximum Quantity |
PROCESS_LOSS | Process loss in percentage |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
TEXT_CODE | Text code value |
Process Manufacturing Product Development - GMD_RECIPE_EFF_ASSOC | Recipe-Effectivity Association Table |
---|---|
Column Name | Descritpion |
FMEFF_ID | Surrogate key for this effectivity row. |
INV_MAX_QTY | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. |
MIN_QTY | The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. |
MAX_QTY | The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. |
STD_QTY | Standard batch size for this rec. |
ITEM_UM | UOM for min_qty and max_qty. |
PREFERENCE | Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column. |
ROUTING_ID | Surrogate key for the routing/routing version to be used, if any. |
FORMULA_ID | Surrogate key for the formula /formula version to be used. |
CUST_ID | Surrogate key for the customer for which this effectivity is used, if any. |
CREATION_DATE | Standard who column |
RECIPE_ID | Recipe ID |
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. |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
TRANS_CNT | Not currently used |
LAST_UPDATE_LOGIN | Standard who column |
ORGN_CODE | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. |
RECIPE_VALIDITY_RULE_ID | Recipe Validity rule ID |
ITEM_ID | Surrogate key for the item which is produced by the formula. |
OPM_CUST_ID | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. |
FORMULA_USE | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. |
END_DATE | The end date of the effectivity. |
START_DATE | The start date of the effectivity. |
INV_MIN_QTY | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. |
Process Manufacturing Product Development - GMD_LAB_FORMULA_ASSOC | Association for lab values that get converted to formulas |
---|---|
Column Name | Descritpion |
OLD_FORMULA_ID | Old formula id |
OLD_FORMULA_NO | Old Formula number |
OLD_FORMULA_VERS | old formula version |
NEW_FORMULA_VERS | New formula version |
MIGRATED | FLag indicatind sucessful migration |
OLD_TP_FORMULA_ID | Id for old technical parameter based formula id |
NEW_TP_FORMULA_ID | Id for new technical parameter based formula id |
NEW_FORMULA_ID | New formula id |
NEW_FORMULA_NO | New formula version |
Process Manufacturing Product Development - GMD_LAB_ORGN_ASSOC | Association for lab types that get converted to orgn codes |
---|---|
Column Name | Descritpion |
MIGRATED | Flag indicating if the lab - orgn migation has been successful |
LAB_TYPE | Lab type or Lab Name |
Process Manufacturing Product Development - GMD_MIGRATION | Stores error messages during data migration from 11i to 11i+ |
---|---|
Column Name | Descritpion |
MIGRATION_ID | Migration ID |
SOURCE_TABLE | Old datamodel table name from which the data is migrated |
TARGET_TABLE | New datamodel table name to which the data is migrated |
SOURCE_ID | Id for the instance of the old table |
TARGET_ID | Id for the instance in the New table |
MESSAGE_TEXT | Error text message associated during migration |
Process Manufacturing Product Development - GMD_OPERATION_ACTIVITIES | Operation Activity details |
---|---|
Column Name | Descritpion |
OPRN_ID | Surrogate for oprn_no + oprn_vers |
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 |
ACTIVITY | Operation activity |
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 |
OFFSET_INTERVAL | Offset time interval |
ATTRIBUTE28 | Descriptive Flexfield segment |
ATTRIBUTE29 | Descriptive Flexfield segment |
ATTRIBUTE30 | Descriptive Flexfield segment |
ATTRIBUTE_CATEGORY | Descriptive Flexfield segment |
ACTIVITY_FACTOR | Activity factor |
SEQUENCE_DEPENDENT_IND | Allow user to select sequence dependent activities. 1 - Activity is Sequence dependent 0 - Not sequence dependent |
BREAK_IND | Breakable indicator for the activity |
MAX_BREAK | Maximum breakable amount |
DELETE_MARK | Mark for purge |
TEXT_CODE | Edit text code |
MATERIAL_IND | Material Indicator |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
OPRN_LINE_ID | Operations line ID |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
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 |
Process Manufacturing Product Development - GMD_OPERATION_RESOURCES | Operation Resource details |
---|---|
Column Name | Descritpion |
OPRN_LINE_ID | Operations line ID |
ATTRIBUTE3 | Descriptive flexfield segement |
ATTRIBUTE4 | Descriptive flexfield segement |
ATTRIBUTE5 | Descriptive flexfield segement |
ATTRIBUTE6 | Descriptive flexfield segement |
ATTRIBUTE7 | Descriptive flexfield segement |
ATTRIBUTE8 | Descriptive flexfield segement |
ATTRIBUTE9 | Descriptive flexfield segement |
ATTRIBUTE10 | Descriptive flexfield segement |
ATTRIBUTE11 | Descriptive flexfield segement |
ATTRIBUTE12 | Descriptive flexfield segement |
RESOURCES | Operation resources |
ATTRIBUTE13 | Descriptive flexfield segement |
ATTRIBUTE14 | Descriptive flexfield segement |
ATTRIBUTE15 | Descriptive flexfield segement |
ATTRIBUTE16 | Descriptive flexfield segement |
ATTRIBUTE17 | Descriptive flexfield segement |
ATTRIBUTE18 | Descriptive flexfield segement |
ATTRIBUTE19 | Descriptive flexfield segement |
ATTRIBUTE20 | Descriptive flexfield segement |
ATTRIBUTE21 | Descriptive flexfield segement |
ATTRIBUTE22 | Descriptive flexfield segement |
RESOURCE_USAGE | Usage of resources |
ATTRIBUTE23 | Descriptive flexfield segement |
ATTRIBUTE24 | Descriptive flexfield segement |
ATTRIBUTE25 | Descriptive flexfield segement |
ATTRIBUTE26 | Descriptive flexfield segement |
ATTRIBUTE27 | Descriptive flexfield segement |
ATTRIBUTE28 | Descriptive flexfield segement |
ATTRIBUTE29 | Descriptive flexfield segement |
ATTRIBUTE30 | Descriptive flexfield segement |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
RESOURCE_COUNT | Count of resources |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
PROCESS_PARAMETER_1 | Process parameter 1 |
PROCESS_PARAMETER_2 | Process parameter 2 |
PROCESS_PARAMETER_3 | Process parameter 3 |
PROCESS_PARAMETER_4 | Process parameter 4 |
PROCESS_PARAMETER_5 | Process parameter 5 |
RESOURCE_USAGE_UOM | Usage uom in 3 characters |
RESOURCE_PROCESS_UOM | process uom in 3 characters |
USAGE_UM | Usage UOM |
RESOURCE_CAPACITY_UOM | capacity uom in 3 characters |
PROCESS_QTY | Process quantity |
PROCESS_UOM | Process UOM |
PRIM_RSRC_IND | Primary resource indicator |
SCALE_TYPE | Scale type |
COST_ANALYSIS_CODE | Cost analysis code |
COST_CMPNTCLS_ID | Component class ID |
OFFSET_INTERVAL | Offset time interval |
DELETE_MARK | Mark for purge |
TEXT_CODE | Edit text code |
MIN_CAPACITY | Minimum capacity |
MAX_CAPACITY | Maximum capacity |
CAPACITY_UOM | Capacity UOM |
ATTRIBUTE_CATEGORY | Descriptive flexfield segement |
ATTRIBUTE1 | Descriptive flexfield segement |
ATTRIBUTE2 | Descriptive flexfield segement |
Process Manufacturing Product Development - GMD_RECIPES_B | Recipe header base table. |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
RECIPE_STATUS | The Status of the Recipe header (different than the status on the Validity Rules). The combination of the Recipe and Validity Rule status will be used to determine what a Recipe can be used for. See the GMD_STATUS table for a list of poss |
FIXED_PROCESS_LOSS | Fixed Process Loss: Quantity define in this will be distributed across all material lines |
FIXED_PROCESS_LOSS_UOM | Fixed Process Loss: UOM |
PLANNED_PROCESS_LOSS | The Planned Process Loss, derived from the Routing or Routing Class tables, if defined. |
TEXT_CODE | The link to the Text associated to the Recipe header. Recipe Text is stored in FM_TEXT_TBL_TL. |
DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Context |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
RECIPE_NO | Recipe Number - Along with Recipe Version, part of the Alternate Key for the Recipe. |
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 |
RECIPE_VERSION | Recipe Version - Along with Recipe Number, part of the Alternate Key for the Recipe. |
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 |
ATTRIBUTE30 | Descriptive Flexfield segment |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
OWNER_ORGN_CODE | OPM Organization code that owns this Recipe. Users who wish to modify this Recipe must have access to this organization. |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
OWNER_ID | User ID of the Recipe owner. |
OWNER_LAB_TYPE | Laboratory associated with the Recipe (optional). |
CREATION_ORGN_CODE | OPM Organization code of the user that created this Recipe. Listed for the purpose of Recipe history & auditability. |
CALCULATE_STEP_QUANTITY | Determines whether or not Step Quantities will be automatically calculated for this Recipe. Step Material Association and Step Dependencies are necessary for this calculation to be accurate. |
FORMULA_ID | The Formula ID associated with this Recipe. A Formula is required in order to create a Recipe. |
CREATION_ORGANIZATION_ID | Inventory Organization id |
OWNER_ORGANIZATION_ID | Inventory Organization id |
ROUTING_ID | The Routing ID associated with this Recipe. It is optional to associate a Routing with a Recipe. |
CONTIGUOUS_IND | This is the contiguous indicator column description |
RECIPE_TYPE | This is the recipe type classification column |
PROJECT_ID | Project ID field. Not used yet, but will be used to associate a Recipe with a Project in a future release. |
ENHANCED_PI_IND | This is the Enahnced PI Indicator column. Y- Yes, N- No |
MASTER_RECIPE_ID | This column stores the source recipe id when a recipe is copied |
Process Manufacturing Product Development - GMD_RECIPES_TL | Recipe Translation Table |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
LANGUAGE | The Language associated with this row of data. Derived from FND_LANGUAGES table. |
RECIPE_DESCRIPTION | Recipe Description. |
SOURCE_LANG | The Language in which the Recipe was originally created. Derived from FND_LANGUAGES table. |
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 - GMD_RECIPE_CUSTOMERS | This table stores recipe customer data |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
TEXT_CODE | The link to the Text associated to the Recipe Customer data. Recipe Text is stored in FM_TEXT_TBL_TL. |
CUSTOMER_ID | Designates any Customers that are associated to this Recipe. From OP_CUST_MST.CUSTOMER_ID. |
OPM_CUST_ID | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. |
ORG_ID | Organization id |
CREATED_BY | Standard who column |
SITE_ID | Customer site id |
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 - GMD_RECIPE_ROUTING_STEPS | This table stores updates to routing steps at the recipe level. |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
ATTRIBUTE18 | Descriptive flexfield segment |
ATTRIBUTE19 | Descriptive flexfield segment |
ATTRIBUTE20 | Descriptive flexfield segment |
ATTRIBUTE21 | Descriptive flexfield segment |
ATTRIBUTE22 | Descriptive flexfield segment |
ATTRIBUTE23 | Descriptive flexfield segment |
TEXT_CODE | The link to the Text associated to the Recipe Routing Steps. Recipe Text is stored in FM_TEXT_TBL_TL. |
ATTRIBUTE24 | Descriptive flexfield segment |
ATTRIBUTE25 | Descriptive flexfield segment |
MASS_QTY | The Step Quantity measured in the GMD: UOM Mass Type |
ATTRIBUTE26 | Descriptive flexfield segment |
ATTRIBUTE27 | Descriptive flexfield segment |
MASS_REF_UOM | The Primary Unit of Measure for the GMD: UOM Mass Type |
ATTRIBUTE28 | Descriptive flexfield segment |
ATTRIBUTE29 | Descriptive flexfield segment |
VOLUME_QTY | The Step Quantity measured in the GMD: UOM Volume Type |
ATTRIBUTE30 | Descriptive flexfield segment |
ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
VOLUME_REF_UOM | The Primary Unit of Measure for the GMD: UOM Volume Type |
MASS_STD_UOM | Mass standard uom colum is used to convert all the uoms to mass uom based on the mass profile value |
VOLUME_STD_UOM | Volume standard uom column is used to convert all the uoms to volumen uom based on the mass profile value |
ATTRIBUTE1 | Descriptive flexfield segment |
ROUTINGSTEP_ID | The Routing Step ID for this Step. |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
STEP_QTY | The Step Quantity within the Recipe. This is where the user can override the this value at the Recipe level. |
ATTRIBUTE4 | Descriptive flexfield segment |
ATTRIBUTE5 | Descriptive flexfield segment |
CREATED_BY | Standard who column |
ATTRIBUTE6 | Descriptive flexfield segment |
ATTRIBUTE7 | Descriptive flexfield segment |
CREATION_DATE | Standard who column |
ATTRIBUTE8 | Descriptive flexfield segment |
ATTRIBUTE9 | Descriptive flexfield segment |
LAST_UPDATED_BY | Standard who column |
ATTRIBUTE10 | Descriptive flexfield segment |
ATTRIBUTE11 | Descriptive flexfield segment |
LAST_UPDATE_DATE | Standard who column |
ATTRIBUTE12 | Descriptive flexfield segment |
ATTRIBUTE13 | Descriptive flexfield segment |
LAST_UPDATE_LOGIN | Standard who column |
ATTRIBUTE14 | Descriptive flexfield segment |
ATTRIBUTE15 | Descriptive flexfield segment |
ATTRIBUTE16 | Descriptive flexfield segment |
ATTRIBUTE17 | Descriptive flexfield segment |
Process Manufacturing Product Development - GMD_RECIPE_ORGN_RESOURCES | This table stores updates to operation resources at the recipe level. |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
PROCESS_PARAMETER_5 | Process Parameter 5. This is where the user records the fifth Process Parameter to be used with this Recipe. |
ATTRIBUTE13 | Descriptive flexfield segement |
ATTRIBUTE14 | Descriptive flexfield segement |
ATTRIBUTE15 | Descriptive flexfield segement |
ATTRIBUTE16 | Descriptive flexfield segement |
CREATION_DATE | Standard who column |
ATTRIBUTE17 | Descriptive flexfield segement |
ATTRIBUTE18 | Descriptive flexfield segement |
CREATED_BY | Standard who column |
ATTRIBUTE19 | Descriptive flexfield segement |
ATTRIBUTE20 | Descriptive flexfield segement |
LAST_UPDATED_BY | Standard who column |
ATTRIBUTE21 | Descriptive flexfield segement |
ATTRIBUTE22 | Descriptive flexfield segement |
LAST_UPDATE_DATE | Standard who column |
ATTRIBUTE23 | Descriptive flexfield segement |
ATTRIBUTE24 | Descriptive flexfield segement |
LAST_UPDATE_LOGIN | Standard who column |
ATTRIBUTE25 | Descriptive flexfield segement |
ATTRIBUTE26 | Descriptive flexfield segement |
ATTRIBUTE27 | Descriptive flexfield segement |
ATTRIBUTE28 | Descriptive flexfield segement |
ATTRIBUTE29 | Descriptive flexfield segement |
ATTRIBUTE30 | Descriptive flexfield segement |
ATTRIBUTE_CATEGORY | Descriptive flexfield segement |
PROCESS_UOM | Unit of Measure for the Process Quantity of this Resource |
ORGN_CODE | The OPM Organization this data is being overriden for. |
USAGE_UM | Unit of Measure for the Usage of this Resource |
RESOURCE_USAGE | Rate at which the Process Quantity is measured (throughput). |
PROCESS_QTY | The Quantity of material Processed within this Step-Activity-Resource. |
ORGANIZATION_ID | Inventory Organization Id |
PROCESS_UM | Process UOM |
USAGE_UOM | Usage UOM |
ROUTINGSTEP_ID | The Routing Step ID that this Activity is associated with. |
TEXT_CODE | The link to the Text associated to the Recipe Resources. Recipe Text is stored in FM_TEXT_TBL_TL. |
MIN_CAPACITY | Minimum Capacity that this Resource can handle. This is where the user can override the this value at the Recipe level. |
MAX_CAPACITY | Maximum Capacity that this Resource can handle. This is where the user can override the this value at the Recipe level. |
OPRN_LINE_ID | The Operation Line ID that this Activity is associated with. |
ATTRIBUTE1 | Descriptive flexfield segement |
ATTRIBUTE2 | Descriptive flexfield segement |
RESOURCES | The Recipe specific Resource derived from the Operation Resources table. |
ATTRIBUTE3 | Descriptive flexfield segement |
ATTRIBUTE4 | Descriptive flexfield segement |
PROCESS_PARAMETER_1 | Process Parameter 1. This is where the user records the first Process Parameter to be used with this Recipe. |
ATTRIBUTE5 | Descriptive flexfield segement |
ATTRIBUTE6 | Descriptive flexfield segement |
PROCESS_PARAMETER_2 | Process Parameter 2. This is where the user records the second Process Parameter to be used with this Recipe. |
ATTRIBUTE7 | Descriptive flexfield segement |
ATTRIBUTE8 | Descriptive flexfield segement |
PROCESS_PARAMETER_3 | Process Parameter 3. This is where the user records the third Process Parameter to be used with this Recipe. |
ATTRIBUTE9 | Descriptive flexfield segement |
ATTRIBUTE10 | Descriptive flexfield segement |
PROCESS_PARAMETER_4 | Process Parameter 4. This is where the user records the fourth Process Parameter to be used with this Recipe. |
ATTRIBUTE11 | Descriptive flexfield segement |
ATTRIBUTE12 | Descriptive flexfield segement |
Process Manufacturing Product Development - GMD_RECIPE_STEP_MATERIALS | This table stores step material information at the recipe level. |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
ATTRIBUTE12 | Descriptive Flexfield |
ATTRIBUTE13 | Descriptive Flexfield |
ATTRIBUTE14 | Descriptive Flexfield |
ATTRIBUTE15 | Descriptive Flexfield |
ATTRIBUTE16 | Descriptive Flexfield |
ATTRIBUTE17 | Descriptive Flexfield |
ATTRIBUTE18 | Descriptive Flexfield |
ATTRIBUTE19 | Descriptive Flexfield |
ATTRIBUTE20 | Descriptive Flexfield |
ATTRIBUTE21 | Descriptive Flexfield |
ATTRIBUTE22 | Descriptive Flexfield |
ATTRIBUTE23 | Descriptive Flexfield |
ATTRIBUTE24 | Descriptive Flexfield |
ATTRIBUTE25 | Descriptive Flexfield |
ATTRIBUTE26 | Descriptive Flexfield |
ATTRIBUTE27 | Descriptive Flexfield |
ATTRIBUTE28 | Descriptive Flexfield |
MINIMUM_TRANSFER_QTY | The offset for the dependent routing to start. The quantity is based in the same UOM of the product that is being associated to the routing step |
ATTRIBUTE29 | Descriptive Flexfield |
ATTRIBUTE30 | Descriptive Flexfield |
FORMULALINE_ID | The Formula Line ID associated with the Step. |
MINIMUM_DELAY | The minimum delay in hours after the MTQ point |
ROUTINGSTEP_ID | The Routing Step ID associated with this Formula Line. |
MAXIMUM_DELAY | The maximum delay in hours after the MTQ point |
TEXT_CODE | The link to the Text associated to the Recipe Step Materials. Recipe Text is stored in FM_TEXT_TBL_TL. |
ATTRIBUTE_CATEGORY | Descriptive Flexfield structure defining column |
ATTRIBUTE1 | Descriptive Flexfield |
CREATION_DATE | Standard who column |
ATTRIBUTE2 | Descriptive Flexfield |
ATTRIBUTE3 | Descriptive Flexfield |
CREATED_BY | Standard who column |
ATTRIBUTE4 | Descriptive Flexfield |
ATTRIBUTE5 | Descriptive Flexfield |
LAST_UPDATED_BY | Standard who column |
ATTRIBUTE6 | Descriptive Flexfield |
ATTRIBUTE7 | Descriptive Flexfield |
LAST_UPDATE_DATE | Standard who column |
ATTRIBUTE8 | Descriptive Flexfield |
ATTRIBUTE9 | Descriptive Flexfield |
LAST_UPDATE_LOGIN | Standard who column |
ATTRIBUTE10 | Descriptive Flexfield |
ATTRIBUTE11 | Descriptive Flexfield |
Process Manufacturing Product Development - GMD_RECIPE_PROCESS_LOSS | Stores process loss at the recipe level. |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
RECIPE_PROCESS_LOSS_ID | Recipe Process Loss ID - Unique Identifier for this organization specific row within a Recipe |
ORGN_CODE | The OPM Organization this data is being overriden for. |
TEXT_CODE | The link to the Text associated to the Recipe Process Loss. Recipe Text is stored in FM_TEXT_TBL_TL. |
ORGANIZATION_ID | Inventory Organization id |
PROCESS_LOSS | The Process Loss anticipated for this Recipe. This is where the user can override the this value at the Recipe level. |
CONTIGUOUS_IND | This is the contiguous indicator column description |
FIXED_PROCESS_LOSS | Fixed Process Loss: Quantity define in this will be distributed across all material lines |
CREATION_DATE | Standard who column |
FIXED_PROCESS_LOSS_UOM | Fixed Process Loss: UOM |
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_RECIPE_VALIDITY_RULES | Stores quantity and effective dates for variou uses and/or organizations (formerly effectivities). |
---|---|
Column Name | Descritpion |
RECIPE_VALIDITY_RULE_ID | Validity Rule ID - Primary Key, Unique Identifier for a Recipe Validity Rule |
MAX_QTY | The maximum qty for which this Validity Rule can be used, expressed in the UOM entered in the item_um column (derived from the Formula Material line). |
FIXED_PROCESS_LOSS_UOM | Fixed Process Loss: UOM |
STD_QTY | The Standard Batch size for this Validity Rule. |
ITEM_UM | Unit of Measure for the Min and Max Quantity (derived from the Formula). |
INV_MIN_QTY | The minimum qty for which this Validity Rule can be used, expressed in the primary UOM of an item. |
INV_MAX_QTY | The maximum qty for which this Validity Rule can be used, expressed in the primary UOM of an item. |
TEXT_CODE | The link to the Text associated to the Validity Rule. Recipe Text is stored in FM_TEXT_TBL_TL. |
ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
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 |
ORGN_CODE | The OPM Organization this Validity Rule is specific to. This can be left blank, in which case a Global Validity Rule is defined. |
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 |
ITEM_ID | The Item ID (Product) that this Validity Rule is for. |
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 |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
RECIPE_USE | What this Validity Rule is to be used for. Production, Costing, Planning, MSDS, Technical. Formerly known as Formula Use on the Effectivity. |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
PREFERENCE | Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column. |
VALIDITY_RULE_STATUS | The Status of the Recipe Validity Rule. The combination of the Recipe and Validity Rule status will be used to determine what a Recipe can be used for. See the GMD_STATUS table for a list of possible Status's. |
LAB_TYPE | The Laboratory associated with this Validity Rule (optional). |
START_DATE | The start date of the Validity Rule (cannot be used before this date). |
PLANNED_PROCESS_LOSS | This is the process loss for the validity rule based on the standard quantity |
ORGANIZATION_ID | This is the inv organization id |
END_DATE | The end date of the Validity Rule (cannot be used after this date). This field can be updated even if the Validity Rule is Frozen in order to prevent it from being used anymore. |
INVENTORY_ITEM_ID | This is the inv item id |
REVISION | This is the inv item revision |
MIN_QTY | The minimum qty for which this Validity Rule can be used, expressed in the UOM entered in the item_um column (derived from the Formula Material line). |
DETAIL_UOM | This is the inv item uom in 3 characters |
FIXED_PROCESS_LOSS | Fixed Process Loss: Quantity define in this will be distributed across all material lines |
Process Manufacturing Product Development - GMD_RECIPE_ORGN_ACTIVITIES | This table stores updates to operation activity details at the recipe level. |
---|---|
Column Name | Descritpion |
RECIPE_ID | Recipe ID - Primary Key, Unique Identifier for a Recipe |
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 |
ORGN_CODE | The OPM Organization this data is being overriden for. |
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 |
ROUTINGSTEP_ID | The Routing Step ID that this Activity is associated with. |
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 |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
OPRN_LINE_ID | The Operation Line ID that this Activity is associated with. |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ACTIVITY_FACTOR | The Activity Factor - how many times an Activity is performed. This is where the user can override the this value at the Recipe level. |
TEXT_CODE | The link to the Text associated to the Recipe Activities. Recipe Text is stored in FM_TEXT_TBL_TL. |
ORGANIZATION_ID | Inventory Organization id |
ATTRIBUTE_CATEGORY | Descriptive flexfield segement |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
Process Manufacturing Product Development - GMD_REPLACE | Used for Mass Search and Replace |
---|---|
Column Name | Descritpion |
QUERY | To be used internally by mass replace operation to retrieve rows that needs to be replaced. |
REQUEST_ID | Request ID |
Process Manufacturing Product Development - GMD_FORMULA_SECURITY | Formula Security table |
---|---|
Column Name | Descritpion |
FORMULA_ID | Formula Identifier |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ORGANIZATION_ID | This is the organization id column for the security profile |
OTHER_ORGANIZATION_ID | This is the other organization id column for the security profile |
ACCESS_TYPE_IND | Specifies the user's access is Update or View |
ORGN_CODE | Formula's Owning Organization. Formula Security access is controlled by the Formula's Owning Organization. |
USER_ID | User Identifier. Formula Security can be contorlled at the user level. User specified must be associated with the Formula's Owning Organization or Other Organization if specified. |
FORMULA_SECURITY_ID | Formula Security Unique Identifier |
RESPONSIBILITY_ID | Responsibility Identifier |
OTHER_ORGN | Organization other than the formula's owning organization. A user can be given access to the owning organization's formula if they are associated with the other organization specified. |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_SECURITY_CONTROL | Defines the level Formula Security is contorlled per OPM Organization |
---|---|
Column Name | Descritpion |
OBJECT_TYPE | Object Formula Security is applied; for example, Formula. |
ORGN_CODE | Formula Owning Organization given access to Formula Security. |
USER_IND | Indicator to determine if users can be specified for Formula Security. Valid values Y, N. |
RESPONSIBILITY_IND | Responsibility IND for security control consideration 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 |
ORGANIZATION_ID | This is the organization id column for the security control |
Process Manufacturing Product Development - GMD_SECURITY_PROFILES | Security Profiles give access to the object specified data. For example, a Security Profile gives access to a User for Formula data. |
---|---|
Column Name | Descritpion |
OBJECT_TYPE | Object the Security Profile applies; for example, Formula. |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ORGANIZATION_ID | This is the organization ID column for the security profile |
OTHER_ORGANIZATION_ID | This is the other organization id column for the security profile. |
ASSIGN_METHOD_IND | Indicates the method Formula Security is assigned to a user. Automatically when a formula is created or manually by the creator of the formula. |
ACCESS_TYPE_IND | Indicates the access type given the user or responsibility; Update or View. |
ORGN_CODE | Object's Owning Organization which controls security access to the object. A user must be associated with the organization to have access the organization's object data. |
SECURITY_PROFILE_ID | Security Profile Unique Identifier |
USER_ID | User Identifier of the individual user assigned access the owning organization's object data. |
RESPONSIBILITY_ID | Responsibility Identifier of the Responsibility assigned access to the Owning Organization Object data. |
OTHER_ORGN | Organization other than the formula's owning organization. A user can be given access to the owning organization's formula if they are associated with the other organization specified. |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
Process Manufacturing Product Development - GMD_STATUS_B | Base table for status code definitions. |
---|---|
Column Name | Descritpion |
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 |
UPDATEABLE | Y = Objects can be updated with this status, N = Objects can not be updated with this status |
ATTRIBUTE30 | Descriptive flexfield segment |
DELETE_MARK | Mark for purge |
STATUS_TYPE | Status type |
VERSION_ENABLED | Y = Versioning available at this status N = Versioning unavailable at this status |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
STATUS_CODE | Status code |
ATTRIBUTE_CATEGORY | Descriptive flexfield segment |
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 |
Process Manufacturing Product Development - GMD_STATUS_NEXT | This table stores information in regards to which status codes the current status can be changed to. |
---|---|
Column Name | Descritpion |
TARGET_STATUS | Status user wants to move entity to |
REWORK_STATUS | Status sent to if approval failed |
PENDING_STATUS | Entity has this status while workflow is in process |
WORKFLOW_INDICATOR | 1=current and target status relevent to enabled and disabled wf, 2=requires WF approval, 3=does not require WF approval |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
CURRENT_STATUS | Current Status of Entity |
Process Manufacturing Product Development - GMD_STATUS_TL | Status Code Translation Table |
---|---|
Column Name | Descritpion |
LANGUAGE | Language |
MEANING | Status meaning |
DESCRIPTION | Status description |
SOURCE_LANG | Source language |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
STATUS_CODE | Status code |
Process Manufacturing Product Development - GMD_ACTIVITIES_B | Activities base table. Defines activities which are performed in operations. |
---|---|
Column Name | Descritpion |
ACTIVITY | Code for the activity. |
TRANS_CNT | Not currently used |
LAST_UPDATE_LOGIN | Standard who column |
ACTIVITY_DESC | Description of the activity. |
COST_ANALYSIS_CODE | The cost analysis code for this activity, for example, is this a value added or non-value added activity. |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
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 |
Process Manufacturing Product Development - GMD_FORMULA_CLASS_B | Formula classes base table - used to group formulas. |
---|---|
Column Name | Descritpion |
FORMULA_CLASS | Code identifying the formula class. |
LAST_UPDATE_LOGIN | Standard who column |
FORMULA_CLASS_DESC | Description of the formula class. |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
TRANS_CNT | 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 |
Process Manufacturing Product Development - GMD_OPERATION_CLASS_B | Operation class base table. Used to group operations. |
---|---|
Column Name | Descritpion |
OPRN_CLASS | Code identifying the operation class. |
LAST_UPDATE_LOGIN | Standard who column |
OPRN_CLASS_DESC | Description of the operation class. |
CREATION_DATE | Standard who column |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
TRANS_CNT | 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 |
Process Manufacturing Product Development - GMD_ROUTING_CLASS_B | Routing class base table - used to group routings. |
---|---|
Column Name | Descritpion |
ROUTING_CLASS | Code for the routing class. |
LAST_UPDATE_LOGIN | Standard who column |
UOM | Unit of Measure |
ROUTING_CLASS_DESC | Description of the routing class. |
ROUTING_CLASS_UOM | Routing class uom in 3 characters |
FIXED_PROCESS_LOSS | Fixed Process Loss: Quantity define in this will be distributed across all material lines |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
TRANS_CNT | Not currently used |
DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
CREATION_DATE | Standard who column |
Process Manufacturing Product Development - GMD_ROUTINGS_B | Routing header base table. |
---|---|
Column Name | Descritpion |
ROUTING_ID | Surrogate key for routing_no+routing_vers. |
ATTRIBUTE15 | Descriptive Flexfield Segment |
ATTRIBUTE16 | Descriptive Flexfield Segment |
ATTRIBUTE17 | Descriptive Flexfield Segment |
ATTRIBUTE18 | Descriptive Flexfield Segment |
DELETE_MARK | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
ATTRIBUTE19 | Descriptive Flexfield Segment |
ATTRIBUTE20 | Descriptive Flexfield Segment |
TEXT_CODE | ID which joins any rows of text in this table to the Text Table for this Module |
ATTRIBUTE21 | Descriptive Flexfield Segment |
ATTRIBUTE22 | Descriptive Flexfield Segment |
INACTIVE_IND | Not currently used. |
ATTRIBUTE23 | Descriptive Flexfield Segment |
ATTRIBUTE24 | Descriptive Flexfield Segment |
IN_USE | Not currently used |
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 |
EFFECTIVE_START_DATE | Date from which this routing is valid |
EFFECTIVE_END_DATE | Date to which this Routing is valid |
ROUTING_NO | Routing name. |
CREATION_DATE | Standard who column |
OWNER_ID | User id for this routings Owner |
PROJECT_ID | Associated Project id |
CREATED_BY | Standard who column |
ROUTING_STATUS | Status Code for this routing |
PROCESS_LOSS | Planned process loss forthis routing |
OWNER_ORGN_CODE | Orgn code for Owner |
ENFORCE_STEP_DEPENDENCY | This column indicates if the step dependencies have to be enforced in the batches |
OWNER_ORGANIZATION_ID | Owner Organization of the routing |
ROUTING_UOM | Routing UOM in 3 characters |
CONTIGUOUS_IND | This is the contiguous indicator value column |
FIXED_PROCESS_LOSS | Fixed Process Loss: Quantity define in this will be distributed across all material lines |
FIXED_PROCESS_LOSS_UOM | Fixed Process Loss: UOM |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
ROUTING_VERS | Routing version. |
ATTRIBUTE1 | Descriptive Flexfield Segment |
ATTRIBUTE2 | Descriptive Flexfield Segment |
ROUTING_DESC | Routing description. |
ATTRIBUTE3 | Descriptive Flexfield Segment |
ATTRIBUTE4 | Descriptive Flexfield Segment |
ROUTING_CLASS | User defined class for routings. |
ATTRIBUTE5 | Descriptive Flexfield Segment |
ATTRIBUTE6 | Descriptive Flexfield Segment |
ROUTING_QTY | Used in ratio with formula and batch qty to scale individual step requirements. |
ATTRIBUTE7 | Descriptive Flexfield Segment |
ATTRIBUTE8 | Descriptive Flexfield Segment |
ITEM_UM | Uom of routing qty. |
ATTRIBUTE9 | Descriptive Flexfield Segment |
ATTRIBUTE10 | Descriptive Flexfield Segment |
ATTRIBUTE11 | Descriptive Flexfield Segment |
ATTRIBUTE12 | Descriptive Flexfield Segment |
ATTRIBUTE13 | Descriptive Flexfield Segment |
ATTRIBUTE14 | Descriptive Flexfield Segment |
Process Manufacturing Product Development - GMD_OPERATIONS_B | Operations base table. |
---|---|
Column Name | Descritpion |
OPRN_NO | Alphanumeric operation name or number |
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 |
OPRN_VERS | Operation version |
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 |
OPRN_DESC | Operation description |
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 |
OPERATION_STATUS | Operation status |
OWNER_ORGN_CODE | Owner organization code |
PROCESS_QTY_UM | Process quantity UOM |
MINIMUM_TRANSFER_QTY | Minimum amount of material that must be produced at a given production operation and resource, that will be transferred to the next operation and resource before it can begin processing |
OWNER_ORGANIZATION_ID | Inventory organizaion id |
PROCESS_QTY_UOM | Process qty uom in 3 characters |
OPRN_CLASS | Operation class |
POC_CTL_CLASS | Not used. |
IN_USE | Record in use |
INACTIVE_IND | Inactive indicator |
EFFECTIVE_START_DATE | Operation effective start date |
OPRN_ID | Surrogate for oprn_no + oprn_vers. |
EFFECTIVE_END_DATE | Operation effective end date |
DELETE_MARK | Mark for purge |
TEXT_CODE | Edit text 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 |
ATTRIBUTE1 | Descriptive Flexfield segment |
ATTRIBUTE2 | Descriptive Flexfield segment |
ATTRIBUTE3 | Descriptive Flexfield segment |
Process Manufacturing Product Development - GMD_ACTIVITIES_TL | Activities Translation Table |
---|---|
Column Name | Descritpion |
ACTIVITY | Activity |
ACTIVITY_DESC | Description of the Activity |
LANGUAGE | Language column |
SOURCE_LANG | Source Language Column |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
Process Manufacturing Product Development - GMD_FORMULA_CLASS_TL | Formula Class translation table |
---|---|
Column Name | Descritpion |
FORMULA_CLASS | Formula Class ID |
LANGUAGE | Language in which the Description for the Formula Class |
FORMULA_CLASS_DESC | Formula Class Description |
SOURCE_LANG | Source Language in which the Description for the Formula Class |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_OPERATIONS_TL | Operations translation table. |
---|---|
Column Name | Descritpion |
OPRN_ID | surrogate key for oprn_no |
OPRN_DESC | Description of the oprn_no |
LANGUAGE | Language column |
SOURCE_LANG | Source Language Column |
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 |
Process Manufacturing Product Development - GMD_OPERATION_CLASS_TL | Translation table for Operation Class |
---|---|
Column Name | Descritpion |
OPRN_CLASS | Operation Class |
OPRN_CLASS_DESC | Operation Class Description |
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 |
LANGUAGE | Installed Language code |
SOURCE_LANG | Base Language code |
Process Manufacturing Product Development - GMD_ROUTINGS_TL | Routings header translations table |
---|---|
Column Name | Descritpion |
ROUTING_ID | Routing ID |
ROUTING_DESC | Routing Description |
LANGUAGE | Installed Language code |
SOURCE_LANG | Base Language code |
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 |
Process Manufacturing Product Development - GMD_ROUTING_CLASS_TL | Translation Table for routing class |
---|---|
Column Name | Descritpion |
ROUTING_CLASS | Routing Class |
ROUTING_CLASS_DESC | Routing Class Description |
LAST_UPDATE_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LANGUAGE | Installed Language code |
SOURCE_LANG | Base Language code |
Process Manufacturing Product Development - GMD_GRADES_B | 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 |
MIGRATED_IND | Column indicating if the record has been migrated to discrete.1 = YesNULL = No |
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 - GMD_GRADES_TL | QC Units Translation Table |
---|---|
Column Name | Descritpion |
QC_GRADE | QC Grade |
QC_GRADE_DESC | QC Grade Translated Description |
SOURCE_LANG | Language in which the Grade was originally defined. Derived from FND_LANGUAGES |
LANGUAGE | Language for this Grade 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_OPRN_PROCESS_PARAMETERS | Table associating process parameters to operation resource |
---|---|
Column Name | Descritpion |
OPRN_LINE_ID | Column which identifies the Operation line, Foregn key to GMD_OPERATION_RESOURCES.OPRN_LINE_ID |
LAST_UPDATE_DATE | Standard "Row Who" column |
LAST_UPDATED_BY | Standard "Row Who" column |
RESOURCES | Column which identifies the Resources, Foreign key to cr_rsrc_mst.resources |
PARAMETER_ID | Column which identifies the Process Parameter Set name. Foreign Key to gmp_process_parameter_set_b. process_parameter_set |
TARGET_VALUE | Ideal Value for this process parameter. Not required if a Min and max Values are specified |
MINIMUM_VALUE | Minimum value for this Process Parameter. Not required if a Target or a Maximum value is provided |
MAXIMUM_VALUE | Maximum value for this Process Parameter. Not required if a Target or a Maximum value is provided |
CREATION_DATE | Standard "Row Who" column |
LAST_UPDATE_LOGIN | Standard "Row Who" column |
CREATED_BY | Standard "Row Who" column |
Process Manufacturing Product Development - GMD_RECIPE_PROCESS_PARAMETERS | Table associating process parameters to Recipe orgn resource |
---|---|
Column Name | Descritpion |
RECIPE_ID | Column which identifies the recipe id, Foregn key to GMD_RECIPES_B.RECIPE_ID |
CREATION_DATE | Standard "Row Who" column |
LAST_UPDATE_LOGIN | Standard "Row Who" column |
CREATED_BY | Standard "Row Who" column |
LAST_UPDATE_DATE | Standard "Row Who" column |
LAST_UPDATED_BY | Standard "Row Who" column |
ORGANIZATION_ID | Column which identifies the organization |
ORGN_CODE | Column which identifies the orgn code, Foregn key to SY_ORGN_MST.ORGN_CODE |
ROUTINGSTEP_ID | Column which identifies the Routing line, Foregn key to FM_ROUT_DTL.ROUTINGSTEP_ID |
OPRN_LINE_ID | Column which identifies the Operation line, Foregn key to GMD_OPERATION_RESOURCES.OPRN_LINE_ID |
RESOURCES | Column which identifies the Resources, Foreign key to cr_rsrc_mst.resources |
PARAMETER_ID | Column which identifies the Process Parameter Set name. Foreign Key to gmp_process_parameter_set_b. process_parameter_set |
TARGET_VALUE | Ideal Value for this process parameter. Not required if a Min and max Values are specified |
MINIMUM_VALUE | Minimum value for this Process Parameter. Not required if a Target or a Maximum value is provided |
MAXIMUM_VALUE | Maximum value for this Process Parameter. Not required if a Target or a Maximum value is provided |
Process Manufacturing Product Development - GMD_ACTIONS_B | OPM Quality Actions |
---|---|
Column Name | Descritpion |
ACTION_CODE | Action Code |
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 |
ATTRIBUTE8 | Descriptive Flexfield column |
ATTRIBUTE9 | Descriptive Flexfield column |
ATTRIBUTE10 | Descriptive Flexfield column |
ACTION_INTERVAL | Action interval |
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 |
ATTRIBUTE18 | Descriptive Flexfield column |
ATTRIBUTE19 | Descriptive Flexfield column |
ATTRIBUTE20 | Descriptive Flexfield column |
DELETE_MARK | Indicator for logical delete |
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 |
ATTRIBUTE28 | Descriptive Flexfield column |
ATTRIBUTE29 | Descriptive Flexfield column |
ATTRIBUTE30 | Descriptive Flexfield column |
TEXT_CODE | Edit Text |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
MIGRATED_IND | Column indicating if the record has been migrated to discrete.1 = YesNULL = No |
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_ACTIONS_TL | OPM Quality Translation table |
---|---|
Column Name | Descritpion |
ACTION_CODE | Action Code |
ACTION_DESC | Action 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_HOLD_REASONS_B | OPM Quality Hold reasons |
---|---|
Column Name | Descritpion |
QCHOLD_RES_CODE | Hold reason Code |
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 | Indicator for 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 |
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_HOLD_REASONS_TL | OPM Quality Hold Reasons |
---|---|
Column Name | Descritpion |
QCHOLD_RES_CODE | Hold reason code |
QCHOLD_RES_DESC | Hold reason code 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_QC_STATUS_B | OPM Quality Status |
---|---|
Column Name | Descritpion |
STATUS_CODE | Status code |
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 |
ATTRIBUTE13 | Descriptive Flexfield column |
UPDATEABLE | Updateable |
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 |
ATTRIBUTE23 | Descriptive Flexfield column |
STATUS_TYPE | Status type |
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 |
DELETE_MARK | Delete mark |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
VERSION_ENABLED | Version enabled |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
ENTITY_TYPE | Entity type |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
ATTRIBUTE1 | Descriptive Flexfield column |
ATTRIBUTE2 | Descriptive Flexfield column |
ATTRIBUTE3 | Descriptive Flexfield column |
Process Manufacturing Product Development - GMD_QC_STATUS_NEXT | OPM Quality target Status codes |
---|---|
Column Name | Descritpion |
CURRENT_STATUS | Status code |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
ENTITY_TYPE | Represents Type of entity this status belongs to |
TARGET_STATUS | Target Status |
REWORK_STATUS | Status used when notification for status change is rejected |
PENDING_STATUS | Status used when workflow is pending |
WORKFLOW_INDICATOR | workflow indicator |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_QC_STATUS_TL | OPM Quality Status translation |
---|---|
Column Name | Descritpion |
STATUS_CODE | Status code |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATED_BY | Standard who column |
LANGUAGE | Language code the description is stored in |
MEANING | Meaning |
ENTITY_TYPE | Entity type |
DESCRIPTION | Description |
SOURCE_LANG | Source Language Code |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_QUALITY_CONFIG | OPM Quality Configuration |
---|---|
Column Name | Descritpion |
ORGN_CODE | Organization |
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 |
INV_TRANS_REASON_CODE | Reason code for updating inventory |
RESAMPLE_ACTION_CODE | Resample Action Code |
RETEST_ACTION_CODE | Retest Action Code |
CHOOSE_SPEC | This column is used by samples to allow or disallow manual specification selections |
AUTO_SAMPLE_IND | Auto Sample Creation Indicator |
DELAYED_LOT_ENTRY | This column contains the default value which is used when creating a Spec VR |
CONTROL_BATCH_STEP_IND | Batch Step Indicator |
ORGANIZATION_ID | This is the Organization ID |
EXACT_SPEC_MATCH_IND | This is whether to require an exact spec match |
INCLUDE_OPTIONAL_TEST_RSLT_IND | This is whether to use optional tests results in sample disposition |
IN_SPEC_LOT_STATUS_ID | This is the in-spec-status indicator |
OUT_OF_SPEC_LOT_STATUS_ID | This is the out-of-spec status indicator |
QUALITY_LAB_IND | This is the Quality Lab Indicator |
SAMPLE_ASSIGNMENT_TYPE | This is the sample number generation type |
SAMPLE_LAST_ASSIGNED | This is the last assigned sample number |
SPEC_VERSION_CONTROL_IND | This is whether there is spec version control |
SS_ASSIGNMENT_TYPE | This is the stability study number generation type |
CONTROL_LOT_ATTRIB_IND | Lot Attribute Indicator |
SS_LAST_ASSIGNED | This is the last stability study number |
TRANSACTION_REASON_ID | This is the Transaction Reason ID |
DISTRIBUTION_ACCOUNT_ID | This is Distribution Account ID |
MIGRATED_IND | Indicates Status of the Migration of this table |
AUTO_COMPLETE_BATCH_STEP | Auto Complete Batch Step Indicator |
DEFAULT_SPECIFICATION_STATUS | Status of new specification version when created through Mass Search and Replace |
MANAGE_VALIDITY_RULES_IND | Indicated handling of validity rules when a new specification version is created through Mass Search and Replace |
DELAYED_LPN_ENTRY | This is the column for the delayed License Plate Number entry indicator |
OUT_OF_SPEC_LOT_STATUS | out-Spec Lot Status |
IN_SPEC_LOT_STATUS | in spec lot status |
SAMPLE_INV_TRANS_IND | Sample Inventory transaction indicator |
API_ROUND_TRUN_IND | Api truction or rounding |
LOT_OPTIONAL_ON_SAMPLE | lot optional on sample |
TEXT_CODE | Edit text |
Process Manufacturing Product Development - GMD_SAMPLING_PLANS_B | OPM Quality Sampling Plan |
---|---|
Column Name | Descritpion |
SAMPLING_PLAN_ID | Sampling plan ID |
TEXT_CODE | text code |
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 |
ATTRIBUTE8 | Descriptive Flexfield column |
SAMPLING_PLAN_NAME | Sampling plan name |
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 |
ATTRIBUTE18 | Descriptive Flexfield column |
SAMPLE_CNT_REQ | Sample count requirement |
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 |
ATTRIBUTE28 | Descriptive Flexfield column |
SAMPLE_QTY | Sample Quantity |
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 |
ARCHIVE_CNT_REQ | Archive Sample Count |
ARCHIVE_QTY | Archive Sample Qty |
RESERVE_CNT_REQ | Reserve Samples Required for Sampling Plan |
SAMPLE_UOM | Sample unit of measure |
RESERVE_QTY | Reserve Sample Qty |
SAMPLE_QTY_UOM | Sample Quantity UOM |
MIGRATED_IND | 'Used to indicate if 12 migration was successful for this field' |
FREQUENCY_TYPE | Frequency type |
FREQUENCY_CNT | Frequency count |
FREQUENCY_PER | Frequency per |
DELETE_MARK | delete mark |
Process Manufacturing Product Development - GMD_SAMPLING_PLANS_TL | OPM Quality Sampling Plan translation table |
---|---|
Column Name | Descritpion |
SAMPLING_PLAN_ID | Sampling Plan Identifier |
SAMPLING_PLAN_DESC | sampling Plan description |
LANGUAGE | Language code the description is stored in |
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_QC_TESTS_B | OPM QC Test |
---|---|
Column Name | Descritpion |
TEST_ID | Test unique Identifier; db-seq |
BELOW_SPEC_MIN | Value defines the experimental error range |
ABOVE_SPEC_MIN | Value defines the experimental error range |
BELOW_SPEC_MAX | Value defines the experimental error range |
ABOVE_SPEC_MAX | Value defines the experimental error range |
BELOW_MIN_ACTION_CODE | Action Code for this range |
ABOVE_MIN_ACTION_CODE | action code for this range |
BELOW_MAX_ACTION_CODE | Action Code for this range |
ABOVE_MAX_ACTION_CODE | Action Code for this range |
EXPRESSION | Expression |
DISPLAY_PRECISION | Decimal precision of saved value |
TEST_CODE | Test code |
REPORT_PRECISION | Decimal precision used to display value. |
PRIORITY | Test priority;H = high, N = normal, L = low |
TEST_OPRN_ID | Test Operation ID |
TEST_OPRN_LINE_ID | Test Operation Line ID |
TEST_PROVIDER_CODE | Test provider code |
DELETE_MARK | Delete mark |
TEXT_CODE | Text code |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
ATTRIBUTE1 | Descriptive Flexfield column |
ATTRIBUTE2 | Descriptive Flexfield column |
TEST_METHOD_ID | Test Method |
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 |
TEST_CLASS | Test Class |
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 |
TEST_TYPE | Test Unit |
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 |
TEST_UNIT | Test unit |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
TEST_PROVIDER_ID | Test Provider Identification |
TEST_GROUP_ORDER | Order number of the test in a test group |
MIN_VALUE_NUM | Min target value for numeric range test type |
MAX_VALUE_NUM | Max target value for numeric range test type |
EXP_ERROR_TYPE | NUM = Number PCT = Percent |
Process Manufacturing Product Development - GMD_QC_TESTS_TL | OPM QC Test |
---|---|
Column Name | Descritpion |
TEST_ID | Test unique Identifier; db-seq |
LANGUAGE | Translation Language code |
TEST_DESC | Test Description |
SOURCE_LANG | Translation 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_QC_TEST_VALUES_B | OPM Test values |
---|---|
Column Name | Descritpion |
TEST_VALUE_ID | Surrogate ID db-seq |
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 |
ATTRIBUTE8 | Descriptive Flexfield column |
ATTRIBUTE9 | Descriptive Flexfield column |
ATTRIBUTE10 | Descriptive Flexfield column |
TEST_ID | Test Identifier |
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 |
ATTRIBUTE18 | Descriptive Flexfield column |
ATTRIBUTE19 | Descriptive Flexfield column |
ATTRIBUTE20 | Descriptive Flexfield column |
MIN_NUM | Numeric range FROM value recorded in qc units specified in test_unit |
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 |
ATTRIBUTE28 | Descriptive Flexfield column |
ATTRIBUTE29 | Descriptive Flexfield column |
ATTRIBUTE30 | Descriptive Flexfield column |
MAX_NUM | Numeric range TO value recorded in qc units specified in test_unit. |
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 |
VALUE_CHAR | Varchar value for list of values or text range |
TEXT_RANGE_SEQ | Text range sequence |
EXPRESSION_REF_TEST_ID | ID of Referenced test for expression test type |
TEXT_CODE | Edit Text |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
Process Manufacturing Product Development - GMD_QC_TEST_VALUES_TL | OPM Test values Translation table |
---|---|
Column Name | Descritpion |
TEST_VALUE_ID | Surrogate test Value ID db-seq |
LAST_UPDATE_LOGIN | Standard who column |
DISPLAY_LABEL_NUMERIC_RANGE | Display label for numeric range values or list of values |
LANGUAGE | Translation Language Code |
TEST_VALUE_DESC | Test Value Description |
SOURCE_LANG | Translation Language Code |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_CUSTOMER_TESTS_B | Customer Tests |
---|---|
Column Name | Descritpion |
TEST_ID | Test Identifier |
CUST_ID | Customer ID. |
REPORT_PRECISION | report precision |
TEXT_CODE | Standard who 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 |
Process Manufacturing Product Development - GMD_CUSTOMER_TESTS_TL | Customer Tests Translation table |
---|---|
Column Name | Descritpion |
TEST_ID | Test ID |
LAST_UPDATE_LOGIN | Standard who column |
CUST_ID | Customer ID |
LANGUAGE | Language |
CUST_TEST_DISPLAY | Customer test display |
SOURCE_LANG | Source language |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_COMPOSITE_RESULTS | OPM Quality Composite results |
---|---|
Column Name | Descritpion |
COMPOSITE_RESULT_ID | Composite Results |
HIGH_NUM | Higher Numeric range |
RANGE | Statistical range |
STANDARD_DEVIATION | Statistics Standard deviation |
SAMPLE_TOTAL | Sample total |
SAMPLE_CNT_USED | Sample count Used |
NON_VALIDATED_RESULT | Non Validated result |
TEST_ID | Test Identifier |
DELETE_MARK | Logically delete record indicator |
TEXT_CODE | Text code |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Attribute Category |
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 |
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 |
MEAN | Statistical mean |
ATTRIBUTE17 | Descriptive Flexfield column |
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 |
ATTRIBUTE28 | Descriptive Flexfield column |
ATTRIBUTE29 | Descriptive Flexfield column |
ATTRIBUTE30 | Descriptive Flexfield column |
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 |
MODE_NUM | Mode number |
HIGH_CHAR | Highest Character value |
LOW_CHAR | Lowest Character value |
MEDIAN_CHAR | Median Character Value |
MEDIAN_NUM | Median Numeric Value |
COMPOSITE_SPEC_DISP_ID | Composite Specification Disposition Identification |
IN_SPEC_IND | Composite Specification Indicator |
WF_RESPONSE | Workflow Response |
VALUE_IN_REPORT_PRECISION | Report Precision |
PARENT_COMPOSITE_RESULT_ID | Result Associated From |
MODE_CHAR | Mode character |
LOW_NUM | Lower Value |
Process Manufacturing Product Development - GMD_RESULTS | OPM Quality Results |
---|---|
Column Name | Descritpion |
TEST_KIT_SUBLOT_NO | Solvent Sublot no |
RESULT_ID | Results unique identifier |
TESTER | User id of person who performed test |
TESTER_ID | Tester Identification |
TEST_PROVIDER_ID | Test Provider Identification |
AD_HOC_PRINT_ON_COA_IND | Test Provider Identification |
SEQ | Sequence |
RESULT_VALUE_CHAR | Char result value |
TEST_PROVIDER_CODE | Test Provider code |
ASSAY_RETEST | Assay Retest |
DELETE_MARK | Logical delete indicator |
SAMPLE_ID | Identifies the sample the test results is recorded |
TEXT_CODE | Text Code |
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 |
ATTRIBUTE8 | Descriptive Flexfield column |
TEST_ID | Test performed the results are recorded |
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 |
ATTRIBUTE18 | Descriptive Flexfield column |
TEST_REPLICATE_CNT | Number of times test performed on same sample |
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 |
UPDATE_INSTANCE_ID | To store e-signature instance identification |
ATTRIBUTE28 | Descriptive Flexfield column |
QC_LAB_ORGN_CODE | QC Lab orgn code where test was performed |
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 |
ACTUAL_RESOURCE | Actual Resource. |
ACTUAL_RESOURCE_INSTANCE | Actual Resource Instance. |
PLANNED_RESOURCE | Planned Resource. |
RESULT_VALUE_NUM | Numeric result value |
PLANNED_RESOURCE_INSTANCE | Planned Resource Instance. |
PLANNED_RESULT_DATE | Planned Result Date. |
TEST_BY_DATE | Test By Date. |
CONSUMED_QTY | Consumed Qty |
PARENT_RESULT_ID | Result Associated From |
RESERVE_SAMPLE_ID | Reserve Sample |
TEST_METHOD_ID | Test Method |
TEST_QTY | Test Qty |
TEST_UOM | Test UOM |
ORGANIZATION_ID | Organization ID |
TEST_QTY_UOM | Test Quantity UOM |
LAB_ORGANIZATION_ID | Laboratory Organization |
RESULT_DATE | Date result occurred |
TEST_KIT_LOT_NUMBER | Test Kit Lot Number |
TEST_KIT_INV_ITEM_ID | Test Kit Inventory Item |
MIGRATED_IND | Indicates Status of the Migration of this table |
TEST_KIT_ITEM_ID | Item id of solvent used in the testing procedure |
TEST_KIT_LOT_NO | Solvents Lot no |
Process Manufacturing Product Development - GMD_SPEC_RESULTS | OPM Quality Specification Results |
---|---|
Column Name | Descritpion |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
UPDATE_INSTANCE_ID | To Store e-signature Instance Identification |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ADDITIONAL_TEST_IND | Indicates test is not part of the current spec. |
RESULT_ID | Results |
IN_SPEC_IND | In-Spec Indicator |
EVENT_SPEC_DISP_ID | Event Specification Display Identification |
EVALUATION_IND | Evaluation Indicator |
VALUE_IN_REPORT_PRECISION | Report precision |
ACTION_CODE | Action Code |
WF_RESPONSE | Workflow Indicator |
DELETE_MARK | Logically delete record indicator |
CREATION_DATE | Standard who column |
Process Manufacturing Product Development - GMD_COMPOSITE_SPEC_DISP | OPM Quality Composite Specification Display |
---|---|
Column Name | Descritpion |
COMPOSITE_SPEC_DISP_ID | Composite Specification Display Identifier |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
DELETE_MARK | Delete Mark |
LATEST_IND | Composite specification Identification |
EVENT_SPEC_DISP_ID | Event specification disposition ID |
LOT_STATUS | Current lot_status at time of sample disposition |
DISPOSITION | Disposition |
CREATION_DATE | Standard who column |
UPDATE_ALL_LOCATIONS_IND | Update lot_status of all locations matching lot_status of location specified in sample |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_COMPOSITE_RESULT_ASSOC | OPM Quality Composite Result Association |
---|---|
Column Name | Descritpion |
COMPOSITE_RESULT_ID | Composite Results Identification |
RESULT_ID | Result Identification |
EXCLUDE_IND | Exclude Indicator |
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_EVENT_SPEC_DISP | OPM Quality Event Specification Display |
---|---|
Column Name | Descritpion |
EVENT_SPEC_DISP_ID | Event Specification Display Identifier |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
SAMPLING_EVENT_ID | Sampling Event Identification |
SPEC_ID | Specification Identifier |
SPEC_VR_ID | Specification Validity Rule |
DISPOSITION | Disposition |
SPEC_USED_FOR_LOT_ATTRIB_IND | Spec use for lot attribute |
DELETE_MARK | Logical delete indicator. Values 1=deleted, 0=undelete |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_SAMPLES | OPM Quality Samples |
---|---|
Column Name | Descritpion |
TIME_POINT_ID | This is time the sample is expected to remain within its specification |
VARIANT_ID | This is the storage condition defined by a unique combination of the stability study's storage condition, test interval plan and package |
REMAINING_QTY | Quantity of Sample left |
RETAIN_AS | Contains value for retain as, Archive or Reserved |
EXPIRATION_DATE | Samples expiration date |
INVENTORY_ITEM_ID | Item id |
LAB_ORGANIZATION_ID | Lab Organization |
LOCATOR_ID | Locator |
LOT_NUMBER | Lot |
ORGANIZATION_ID | Sample Organization |
PARENT_LOT_NUMBER | Parent Lot |
REVISION | Item Revision |
SAMPLE_QTY_UOM | Sample UOM |
SOURCE_LOCATOR_ID | Source Locator |
SOURCE_SUBINVENTORY | Source Subinventory |
LOT_ID | Lot Identifier |
STORAGE_LOCATOR_ID | Storage Locator |
STORAGE_ORGANIZATION_ID | Storage Organization |
STORAGE_SUBINVENTORY | Storage Subinventory |
SUBINVENTORY | Subinventory |
MIGRATED_IND | Indicates Status of the Migration of this table |
MATERIAL_DETAIL_ID | This is the material detail for batch |
LPN_ID | 'This is the column for the License Plate Number id |
LOT_NO | Items Lot No of Sample |
SAMPLE_ID | Sample Unique Identifier; db-seq |
BATCH_ID | Batch Identifier |
RECIPE_ID | Recipe Identifier |
FORMULA_ID | Formula Identifier |
FORMULALINE_ID | Formual Line Identifier |
ROUTING_ID | Routing Identifier |
OPRN_ID | Operation Identifier |
CHARGE | Charge |
CUST_ID | Customer Identifier |
SAMPLE_NO | Sampling Number |
ORDER_ID | Order Identifier |
ORDER_LINE_ID | Order Line Identifier |
ORG_ID | Organization Identifier |
SUPPLIER_ID | Supplier Identifier |
SAMPLE_QTY | Sample Quantity |
SAMPLE_UOM | Sample Unit Of Measure |
SOURCE | Source |
SAMPLER_ID | Sampler Identifier |
DATE_DRAWN | Sample drawn |
SAMPLE_DESC | Sampling Description |
SOURCE_COMMENT | Source Comments |
STORAGE_WHSE | Storage Warehouse |
STORAGE_LOCATION | Storage Location |
EXTERNAL_ID | External Identifier |
SAMPLE_APPROVER_ID | Sample Approver Identifier |
INV_APPROVER_ID | Inventory Approver Identifier |
PRIORITY | Priority |
SAMPLE_INV_TRANS_IND | Sample Inventory Transaction Indicator |
DELETE_MARK | Indicator for logical delete |
TEXT_CODE | Edit Text code |
TYPE | I = (individual) C = (Composite) |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Attribute Category |
ATTRIBUTE1 | Descriptive Flexfield Segment |
ATTRIBUTE2 | Descriptive Flexfield Segment |
ATTRIBUTE3 | Descriptive Flexfield Segment |
ATTRIBUTE4 | Descriptive Flexfield Segment |
ATTRIBUTE5 | Descriptive Flexfield Segment |
UPDATE_ALL_LOCATIONS_IND | Update lot_status of all locations matching lot_status of location specified in sample |
ATTRIBUTE6 | Descriptive Flexfield Segment |
ATTRIBUTE7 | Descriptive Flexfield Segment |
ATTRIBUTE8 | Descriptive Flexfield Segment |
ATTRIBUTE9 | Descriptive Flexfield Segment |
QC_LAB_ORGN_CODE | Quality Lab Organization |
ATTRIBUTE10 | Descriptive Flexfield Segment |
ATTRIBUTE11 | Descriptive Flexfield Segment |
ATTRIBUTE12 | Descriptive Flexfield Segment |
ATTRIBUTE13 | Descriptive Flexfield Segment |
ATTRIBUTE14 | Descriptive Flexfield Segment |
ATTRIBUTE15 | Descriptive Flexfield Segment |
SAMPLING_EVENT_ID | SAMPLING EVENT ID |
ATTRIBUTE16 | Descriptive Flexfield Segment |
ATTRIBUTE17 | Descriptive Flexfield Segment |
ATTRIBUTE18 | Descriptive Flexfield Segment |
ATTRIBUTE19 | Descriptive Flexfield Segment |
ITEM_ID | Item Identifier |
ATTRIBUTE20 | Descriptive Flexfield Segment |
ATTRIBUTE21 | Descriptive Flexfield Segment |
ATTRIBUTE22 | Descriptive Flexfield Segment |
ATTRIBUTE23 | Descriptive Flexfield Segment |
ATTRIBUTE24 | Descriptive Flexfield Segment |
ATTRIBUTE25 | Descriptive Flexfield Segment |
STEP_NO | Step Number |
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 |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
STEP_ID | Step Identification |
SUPPLIER_SITE_ID | Supplier Site Identification |
WHSE_CODE | Warehouse code |
ORGN_CODE | Organization code |
PO_HEADER_ID | Purchase Order Header Identification |
PO_LINE_ID | Purchase Order Line Identification |
RECEIPT_ID | Receipt Identification |
RECEIPT_LINE_ID | Receipt Line Identification |
SAMPLE_DISPOSITION | Sample Disposition |
SHIP_TO_SITE_ID | Ship to Site Identification |
SUPPLIER_LOT_NO | Supplier Lot Number |
LOT_RETEST_IND | Lot Retest Indicator |
SAMPLE_INSTANCE | Current Instance of the Sample Created |
SUBLOT_NO | Sublot Number |
SOURCE_WHSE | Warehouse where the sample quantity should be stored |
SOURCE_LOCATION | Location where the sample quantity should be stored |
LOCATION | Location is whse when sample is taken from a warehouse |
DATE_RECEIVED | Date when sample is received in to lab for testing. |
DATE_REQUIRED | Date sample analysis is required by. |
INSTANCE_ID | This is the resource instance being monitored |
RESOURCES | This is the resource being monitored |
RETRIEVAL_DATE | This is the date the Sample is pulled for testing |
SAMPLE_TYPE | This refers to whether a sample is an Item or Monitoring sample type |
Process Manufacturing Product Development - GMD_SAMPLE_SPEC_DISP | OPM Quality Sample Specification Display |
---|---|
Column Name | Descritpion |
EVENT_SPEC_DISP_ID | Event Specification Display Identifier |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
SAMPLE_ID | Sample Identifier |
LOT_STATUS | Current lot_status at time of sample disposition |
DELETE_MARK | Indicator for logical delete |
DISPOSITION | Disposition |
CREATION_DATE | Standard who column |
UPDATE_ALL_LOCATIONS_IND | Update lot_status of all locations matching lot_status of location specified in sample |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_SAMPLING_EVENTS | OPM Quality Sampling Event |
---|---|
Column Name | Descritpion |
LOT_ID | Lot Identifier |
SAMPLING_EVENT_ID | Sampling Event Identifier |
LOT_NO | Lot Number |
SUBLOT_NO | Sublot Number |
WHSE_CODE | Warehouse |
LOCATION | Location |
BATCH_ID | Batch Identifier |
RECIPE_ID | Recipe Identifier |
FORMULA_ID | Formula Identifier |
FORMULALINE_ID | Formula Line Identifier |
ROUTING_ID | Routing Identifier |
ORIGINAL_SPEC_VR_ID | Original Specification Validity Rule Identification |
OPRN_ID | Operation Identifier |
CHARGE | Charge |
CUST_ID | Customer Identifier |
ORDER_ID | Order Identifier |
ORDER_LINE_ID | Order Line Identifier |
ORG_ID | Organization Identifier |
SUPPLIER_ID | Supplier Identification |
DISPOSITION | This column contains final result value |
PO_LINE_ID | Purchase Line Identifier |
RECEIPT_LINE_ID | Recipt Line Identifier |
SUPPLIER_LOT_NO | Supplier Lot Number |
COMPLETE_IND | Indicates if all samples for this instance of a specification are complete |
SAMPLE_ID_TO_EVALUATE | Sample Identifier to evaluate |
COMPOSITE_ID_TO_EVALUATE | Composite Identifier to evaluate |
TEXT_CODE | Edit text code |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
SAMPLE_REQ_CNT | Required number of sample to be taken |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
SUPPLIER_SITE_ID | Supplier Site Identifier |
SHIP_TO_SITE_ID | Ship to site Identification |
STEP_ID | Step Identification |
STEP_NO | Routing Step Number |
LOT_RETEST_IND | Lot Retest Indicator |
RECOMPOSITE_IND | Indicates whether the sampling event needs to be recomposited. |
RECEIPT_ID | Receipt Identification |
SAMPLE_ACTIVE_CNT | Number of active samples taken, samples not marked for purge, not canceled. |
SAMPLE_TAKEN_CNT | Current number of samples taken |
INSTANCE_ID | This is the resource instance being monitored |
RESOURCES | This is the resource being monitored |
SAMPLE_TYPE | This refers to whether a sample is an Item or Monitoring sample type |
TIME_POINT_ID | This is time the sample is expected to remain within its specification |
VARIANT_ID | This is the storage condition defined by a unique combination of the stability study's storage condition, test interval plan and package |
ORGN_CODE | This is the organization that owns the Sampling Event |
ARCHIVED_TAKEN | No of Archive samples taken for the sampling event |
RESERVED_TAKEN | No of Reserved samples taken for the sampling event |
INVENTORY_ITEM_ID | Item id |
PO_HEADER_ID | Purchase Order Header Identification |
LOCATOR_ID | Locator |
SAMPLING_PLAN_ID | Sampling Plan Identification |
LOT_NUMBER | Lot |
ORGANIZATION_ID | Sample Organization |
PARENT_LOT_NUMBER | Parent Lot |
REVISION | Item Revision |
SUBINVENTORY | Subinventory |
MIGRATED_IND | Indicates Status of the Migration of this table |
PLAN_ID | This is part of the key for QA records for Receiving Inspection |
COLLECTION_ID | This is part of the key for QA records for Receiving Inspection |
OCCURRENCE | This is part of the key for QA records for Receiving Inspection |
MATERIAL_DETAIL_ID | This is the material detail for batch |
LPN_ID | 'This is the column for the License Plate Number id |
EVENT_TYPE_CODE | Identifies the event triggering a sample to be taken, ex. Batch, Lot expiration |
EVENT_ID | Identifier of event triggering a sample to be taken. |
SOURCE | Valid values C, S, W, I, R (customer, supplier, WIP, inv, receiving) |
ITEM_ID | Item Identification |
Process Manufacturing Product Development - GMD_SAMPLES_LAB | OPM Quality Samples Lab |
---|---|
Column Name | Descritpion |
QC_LAB_ORGN_CODE | Quality Lab Organization |
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 |
ATTRIBUTE13 | Descriptive Flexfield column |
ATTRIBUTE14 | Descriptive Flexfield column |
ATTRIBUTE15 | Descriptive Flexfield column |
SAMPLE_ID | Sample Identifier |
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 |
ATTRIBUTE23 | Descriptive Flexfield column |
ATTRIBUTE24 | Descriptive Flexfield column |
ATTRIBUTE25 | Descriptive Flexfield column |
TEXT_CODE | Edit Text |
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 |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
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 |
Process Manufacturing Product Development - GMD_SPEC_MAPPING | Table used to map old spec definition to new definition |
---|---|
Column Name | Descritpion |
QC_SPEC_ID | Specification line id from old table |
SPEC_ID | Specification header id in new table |
TEST_ID | Specification test id (detail line) in new table |
QC_REC_TYPE | Type of specification I:Inventory W:Wip C:Customer S:Supplier |
SPEC_VR_ID | Validity rule id for specification header |
START_DATE | First date that specification was valid |
END_DATE | Last date that specification was valid |
VR_SPEC_ID | new validity rule id |
Process Manufacturing Product Development - GMD_CUSTOMER_SPEC_VRS | OPM Work-in-Process Specification validity rules |
---|---|
Column Name | Descritpion |
SPEC_VR_ID | Specification validity rule identifier; db-seq |
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 |
COA_TYPE | Certificate of Analysis type |
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 |
SPEC_ID | Specification identifier |
DELETE_MARK | Logical delete |
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 |
ORGN_CODE | Organization |
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 |
CUST_ID | Customer Identification |
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 |
ORDER_ID | Order Identification |
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 |
ORGANIZATION_ID | This is the organization ID |
ERECORD_SPEC_VR_ID | Original Erec key for record this was created from |
MIGRATED_IND | Indicates Status of the Migration of this table |
ORDER_LINE | Order Line |
ORDER_LINE_ID | Order Line Identification |
SHIP_TO_SITE_ID | Ship to site ID |
ORG_ID | Organization ID |
Process Manufacturing Product Development - GMD_INVENTORY_SPEC_VRS | OPM Quality Inventory Specification Validity Rules |
---|---|
Column Name | Descritpion |
SPEC_VR_ID | Specification validity rule identifier; db-seq |
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 |
CONTROL_LOT_ATTRIB_IND | A = Auto, W = WorkFlow Null = No |
LOT_OPTIONAL_ON_SAMPLE | Lot optional on sample |
IN_SPEC_LOT_STATUS | In specification lot status |
OUT_OF_SPEC_LOT_STATUS | Outside specification lot status |
CONTROL_BATCH_STEP_IND | Control batch step indicator |
COA_TYPE | Certificate of Analysis type |
SPEC_ID | Specification identifier |
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 |
ATTRIBUTE3 | Descriptive Flexfield column |
ATTRIBUTE4 | Descriptive Flexfield column |
ORGN_CODE | Organization |
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 |
ATTRIBUTE13 | Descriptive Flexfield column |
ATTRIBUTE14 | Descriptive Flexfield column |
LOT_ID | Lot Identification |
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 |
ATTRIBUTE23 | Descriptive Flexfield column |
ATTRIBUTE24 | Descriptive Flexfield column |
LOT_NO | Lot Number |
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 |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
SUBLOT_NO | Sublot |
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 |
PARENT_LOT_NUMBER | This is parent lot number |
LOT_NUMBER | This is lot number |
SUBINVENTORY | This is subinventory |
LOCATOR_ID | This is locator 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 |
DELAYED_LPN_ENTRY | This is the column for the delayed License Plate Number entry indicator |
WHSE_CODE | Warehouse |
LOCATION | Location |
SPEC_VR_STATUS | Specification Validity Rule |
Process Manufacturing Product Development - GMD_SPECIFICATIONS_B | OPM Quality Specifications |
---|---|
Column Name | Descritpion |
SPEC_ID | Spec Identification |
DELETE_MARK | Delete Mark |
TEXT_CODE | Text Code |
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 |
SPEC_NAME | Specification Name |
ATTRIBUTE7 | Descriptive Flexfield column |
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 |
SPEC_VERS | Specification Version |
ATTRIBUTE17 | Descriptive Flexfield column |
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 |
ITEM_ID | Item Identification |
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 |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
OVERLAY_IND | Indicator for Overlay Spec |
GRADE | Grade |
SPEC_TYPE | Value for spec type, I(tem) or M(onitoring) |
BASE_SPEC_ID | Base spec id for overlay spec |
INVENTORY_ITEM_ID | Inventory Item ID |
REVISION | Revision |
GRADE_CODE | Grade Code |
OWNER_ORGANIZATION_ID | Owner Organization ID |
MIGRATED_IND | Migrated INdicator |
SPEC_STATUS | Specification Status |
OWNER_ORGN_CODE | This is an obsolete column from R12 onwards. |
OWNER_ID | Owner Identification |
SAMPLE_INV_TRANS_IND | Transact Inventory for Sample |
Process Manufacturing Product Development - GMD_SPECIFICATIONS_TL | OPM Quality Specifications Translation |
---|---|
Column Name | Descritpion |
SPEC_ID | Spec Identification |
LANGUAGE | Language code in which the description is stored in |
SPEC_DESC | Specification 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_SPEC_TESTS_B | OPM Specification tests |
---|---|
Column Name | Descritpion |
SPEC_ID | Specification Identification |
MIN_VALUE_CHAR | Min target value for text range test type |
TARGET_VALUE_CHAR | Target value for Test when test type is LOV or text range |
MAX_VALUE_CHAR | Max target value for text range test type |
TEST_REPLICATE | The number of times a test is repeated for the same sample instance. Defaults to 1 |
CHECK_RESULT_INTERVAL | Frequency result values are checked for out-of-spec condition. |
PRINT_ON_COA_IND | Print on Cerificate of analysis |
USE_TO_CONTROL_STEP | Use to control step |
OUT_OF_SPEC_ACTION | Out of Specification action |
EXP_ERROR_TYPE | NUM = Number PCT = Percent |
BELOW_SPEC_MIN | Below Specification Minimum |
TEST_ID | Test Identification |
ABOVE_SPEC_MIN | above Specification Minimum |
BELOW_SPEC_MAX | Below Specification Maximum |
ABOVE_SPEC_MAX | Above Specification maximum |
BELOW_MIN_ACTION_CODE | Action code for results In the test error region spec min - test error |
ABOVE_MIN_ACTION_CODE | Action code for results In the test error region spec min + test error |
BELOW_MAX_ACTION_CODE | Action code for results In the test error region spec max - test error |
ABOVE_MAX_ACTION_CODE | Action code for results In the test error region spec max + test error |
OPTIONAL_IND | Indicates if a test is optional.Y = YesNull = No |
DISPLAY_PRECISION | Decimal precision of saved value |
REPORT_PRECISION | Decimal precision used to display value |
TEST_METHOD_ID | Test Method Identification |
TEST_PRIORITY | Test priority H = HighN = Normal L = Low |
RETEST_LOT_EXPIRY_IND | Indicates spec is used to retest for lot expiration, etc.Y = Yes |
PRINT_SPEC_IND | Print Specification indicator |
PRINT_RESULT_IND | Print Result indicator |
TEXT_CODE | Edit text code |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Structure ID |
ATTRIBUTE1 | Descriptive Flexfield column |
ATTRIBUTE2 | Descriptive Flexfield column |
ATTRIBUTE3 | Descriptive Flexfield column |
SEQ | Test Step |
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 |
ATTRIBUTE13 | Descriptive Flexfield column |
TEST_QTY | Qty of sample required to perform test. |
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 |
ATTRIBUTE23 | Descriptive Flexfield column |
TEST_UOM | UOM the test sample qty is recorded. |
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 |
LAST_UPDATED_BY | Standard who column |
MIN_VALUE_NUM | Min target value for numeric range test type |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
DAYS | Sample Viability for the Test in Number of Days. |
HOURS | Sample Viability for the Test in Number of Hours. |
MINUTES | Sample Viability for the Test in Number of Minutes. |
SECONDS | Sample Viability for the Test in Number of Seconds. |
VIABILITY_DURATION | Total Sample Viability for the Test. |
FROM_BASE_IND | Indicator for test from base spec |
EXCLUDE_IND | Indicator if the test is excluded from base spec |
MODIFIED_IND | Indicator if the test is modified from base spec |
TARGET_VALUE_NUM | Test target value. |
CALC_UOM_CONV_IND | Indicates whether to calculate UOM Conversion based on the result of the test. |
TO_UOM | UOM to which the conversion is created. |
TEST_QTY_UOM | Test Quanity UOM |
TO_QTY_UOM | To Qty UOM |
MAX_VALUE_NUM | Max target value for numeric range test type |
Process Manufacturing Product Development - GMD_SPEC_TESTS_TL | OPM Specification tests |
---|---|
Column Name | Descritpion |
SPEC_ID | Specification Identification |
LAST_UPDATE_LOGIN | Standard who column |
TEST_ID | Test Identification |
LANGUAGE | Language code the description is stored in |
TEST_DISPLAY | Test Display |
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 |
Process Manufacturing Product Development - GMD_SUPPLIER_SPEC_VRS | OPM Work-in-Process Specification validity rules |
---|---|
Column Name | Descritpion |
SPEC_VR_ID | Specification validity rule identifier; db-seq |
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 |
COA_TYPE | Certificate of Analysis type |
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 |
SPEC_ID | Specification identifier |
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 |
ATTRIBUTE8 | Descriptive Flexfield column |
ORGN_CODE | Organization |
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 |
ATTRIBUTE18 | Descriptive Flexfield column |
SUPPLIER_ID | Supplier Identification |
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 |
ATTRIBUTE28 | Descriptive Flexfield column |
PO_HEADER_ID | Purchase Order Header Identification |
SUPPLIER_SITE_ID | Supplier Site Identification |
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 |
AUTO_SAMPLE_IND | Auto Sample Creation Indicator |
CONTROL_LOT_ATTRIB_IND | Control Lot attrib indicator |
IN_SPEC_LOT_STATUS | In Spec Lot status |
OUT_OF_SPEC_LOT_STATUS | Out Of spec lot status |
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 |
ORG_ID | This is unique ID for operating unit |
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 |
RECEIPT_FREQUENCY | Receipt Frequency |
DELAYED_LPN_ENTRY | This is the column for the delayed License Plate Number entry indicator |
PO_LINE_ID | Purchase Order Line identification |
SPEC_VR_STATUS | Specification Validity Rule |
Process Manufacturing Product Development - GMD_PARAMETERS | Stores the default statuses for Organization |
---|---|
Column Name | Descritpion |
ORGN_CODE | Organization code |
LAST_UPDATE_LOGIN | Standard who column |
CREATED_BY | Standard who column |
PARAMETER_ID | Sequence generated primary key column |
RECIPE_STATUS | Recipe Status |
VALIDITY_RULE_STATUS | Validity Rule status |
FORMULA_STATUS | Formula status |
ROUTING_STATUS | Routing status |
OPERATION_STATUS | Operation status |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
Process Manufacturing Product Development - GMD_TECHNICAL_DATA_DTL | Technical Parameter data detail |
---|---|
Column Name | Descritpion |
TECH_DATA_ID | Foreign key to technical data header |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
TECH_PARM_ID | Foreign key to technical parameters |
SORT_SEQ | sort sequence |
TEXT_DATA | Text data for the parameter |
NUM_DATA | Numeric data for the parameter |
BOOLEAN_DATA | Boolean data value for the parameter |
TEXT_CODE | Edit Text code |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
Process Manufacturing Product Development - GMD_TECHNICAL_DATA_HDR | Technical Parameter data header |
---|---|
Column Name | Descritpion |
TECH_DATA_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 |
INVENTORY_ITEM_ID | This is the Item ID Column |
LOT_ORGANIZATION_ID | This is the Lot Organization ID Column |
ORGANIZATION_ID | This is the Organization ID Column |
LOT_NUMBER | This is the lot number field |
ORGN_CODE | Organization for which the data is being defined |
ITEM_ID | Item for which the data is defined |
LOT_ID | Lot ID |
FORMULA_ID | Formula for which the data is defined |
BATCH_ID | Batch for which the data is defined |
DELETE_MARK | Indicator for marked for purge record |
TEXT_CODE | Edit Text code |
CREATION_DATE | Standard who column |
Process Manufacturing Product Development - GMD_PARSED_EXPRESSION | This table stores the parsed expression for the technical parameter |
---|---|
Column Name | Descritpion |
TECH_EXP_SEQ_ID | Surrogate Key |
LAST_UPDATE_LOGIN | Standard who column |
DATA_TYPE | 'Data type of the technical parameter |
TECH_PARM_ID | Technical Parameter ID |
EXPRESSION_KEY | Key of the expression |
EXPRESSION_TYPE | Type of expression key |
EXPRESSION_PARM_ID | Technical Parameter for keys of type expression |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
Process Manufacturing Product Development - GMD_MSNR_RESULTS | GMD Mass Search and Replace table for storing query results |
---|---|
Column Name | Descritpion |
CONCURRENT_ID | Stores ID that is used by concurrent program for mass replace |
OBJECT_ID | Object Id e.g Formula Id or Recipe Id that is manipulated in Mass search and Replace |
OBJECT_NAME | Object Name e.g Formula No or Recipe No that is manipulated in Mass search and Replace |
OBJECT_VERS | Object Version e.g Formula Vers or Recipe Version that is manipulated in Mass search and Replace |
OBJECT_DESC | Object description e.g Formula Description or Recipe Description |
OBJECT_STATUS_CODE | Object Status e.g Formula Status or Recipe Status |
OBJECT_STATUS_DESC | Object Status Description e.g Approved for General Use or New or On-Hold |
OBJECT_SELECT_IND | Incates if the object is selected for Mass Replace. Valid values are 0 and 1 |
Process Manufacturing Product Development - GMD_SS_MATERIAL_SOURCES | Stability Study Material Sources |
---|---|
Column Name | Descritpion |
SOURCE_ID | Primary key generated from sequence |
SAMPLE_QTY_UOM | Sample quantity unit of measure required from the source |
SAMPLING_EVENT_ID | Sample group to which this source belongs to |
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 |
SS_ID | SS ID |
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 |
PLANT_CODE | Plant code where the production for the material will be done |
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 |
BATCH_ID | Batch ID |
ATTRIBUTE27 | Descriptive flexfield segment |
ATTRIBUTE28 | Descriptive flexfield segment |
ATTRIBUTE29 | Descriptive flexfield segment |
ATTRIBUTE30 | Descriptive flexfield segment |
DELETE_MARK | Logical delete mark |
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 |
RECIPE_ID | Recipe |
RECIPE_NO | Recipe Number |
LOT_NUMBER | Lot Number |
SAMPLE_QUANTITY_UOM | Sample Quantity UOM |
SOURCE_ORGANIZATION_ID | Surrogate for Source organization |
MIGRATED_IND | Indicates Status of the Migration of this table |
LOT_ID | Lot ID |
LOT_NO | Lot Number |
YIELD_DATE | Yield date of the batch |
SAMPLE_QTY | Sample quantity required from the source |
Process Manufacturing Product Development - GMD_STABILITY_STUDIES_B | Stability Study |
---|---|
Column Name | Descritpion |
SS_ID | Primary key created from sequence |
MATERIAL_SOURCES_CNT | Number of material source counts |
STORAGE_CONDITIONS_CNT | Number of storage conditions count |
PACKAGES_CNT | Number of packages count |
NOTIFICATION_LEAD_TIME | Lead time for notification |
NOTIFICATION_LEAD_TIME_UNIT | Unit of Lead time for notification |
TESTING_GRACE_PERIOD | Testing grace period |
TESTING_GRACE_PERIOD_UNIT | Testing grace period unit |
SCHEDULED_START_DATE | Scheduled start date |
SCHEDULED_END_DATE | Scheduled end date |
REVISED_START_DATE | Revised start date |
ORGN_CODE | Orgn code to which this stability study belongs to |
REVISED_END_DATE | Revised end date |
ACTUAL_START_DATE | Actual start date |
ACTUAL_END_DATE | Actual end date |
RECOMMENDED_SHELF_LIFE | Recommended shelf life of the product |
RECOMMENDED_SHELF_LIFE_UNIT | Recommended shelf life unit of the product |
STORAGE_SPEC_ID | Storage specification ID |
TEXT_CODE | Text code |
ATTRIBUTE_CATEGORY | Descriptive flexfield category |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
SS_NO | Stability study name |
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 |
STATUS | Stability study status |
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 |
STORAGE_PLAN_ID | Storage plan for the stability study |
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 |
DELETE_MARK | Logical delete mark |
CREATION_DATE | Standard who column |
ITEM_ID | Item for stability study |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
INVENTORY_ITEM_ID | Surrogate for inventory item |
LAB_ORGANIZATION_ID | Surrogate for Lab Organization id |
ORGANIZATION_ID | Surrogate for Organization id |
REVISION | Revision |
MIGRATED_IND | Indicates Status of the Migration of this table |
BASE_SPEC_ID | Base specification |
QC_LAB_ORGN_CODE | QC lab |
OWNER | Owner of the study |
Process Manufacturing Product Development - GMD_STORAGE_PLANS_B | Stability Study Storage Plan |
---|---|
Column Name | Descritpion |
STORAGE_PLAN_ID | Primary key created from sequence |
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 |
STORAGE_PLAN_NAME | Storage plan name |
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 |
BASE_TEST_INTERVAL_PLAN_ID | Base test interval plan for the storage condition |
ATTRIBUTE25 | Descriptive flexfield segment |
ATTRIBUTE26 | Descriptive flexfield segment |
ATTRIBUTE27 | Descriptive flexfield segment |
ATTRIBUTE28 | Descriptive flexfield segment |
ATTRIBUTE29 | Descriptive flexfield segment |
ATTRIBUTE30 | Descriptive flexfield segment |
DELETE_MARK | Logical delete mark |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
TEXT_CODE | Text code |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ATTRIBUTE_CATEGORY | Descriptive flexfield category |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
ATTRIBUTE4 | Descriptive flexfield segment |
Process Manufacturing Product Development - GMD_STORAGE_PLAN_DETAILS | Stability Study Storage Plan Details |
---|---|
Column Name | Descritpion |
STORAGE_PLAN_DETAIL_ID | Primary key created from sequence |
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 |
STORAGE_PLAN_ID | The storage plan to which this row belongs |
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 |
STORAGE_SPEC_ID | Storage specification of storage plan detail |
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 |
RESOURCES | Resources |
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 |
STORAGE_LOCATOR_ID | Surrogate for storage location |
STORAGE_ORGANIZATION_ID | Surrogate for storage organization |
STORAGE_SUBINVENTORY | Storage Subinventory |
MIGRATED_IND | Indicates Status of the Migration of this table |
WHSE_CODE | Warehouse code for the storage condition plan |
LOCATION | Location for storage condition plan |
TEST_INTERVAL_PLAN_ID | Test interval plan for storage condition |
TEXT_CODE | Text code |
ATTRIBUTE_CATEGORY | Descriptive flexfield category |
Process Manufacturing Product Development - GMD_STORAGE_PLANS_TL | Stability Study Storage Plan Translation table |
---|---|
Column Name | Descritpion |
STORAGE_PLAN_ID | Primary key created from sequence |
LANGUAGE | Language |
DESCRIPTION | Description for the storage condition |
SOURCE_LANG | Source language for storage 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_STABILITY_STUDIES_TL | Stability Study Translation table |
---|---|
Column Name | Descritpion |
SS_ID | Stability study id |
LANGUAGE | Language |
DESCRIPTION | Stability study description |
SOURCE_LANG | Source language |
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_SS_VARIANTS | Stability Study Variants |
---|---|
Column Name | Descritpion |
VARIANT_ID | Primary key generated from sequence |
RETAINED_SAMPLES | Retained samples |
STORAGE_SPEC_ID | Specification of storage in which sample will be kept |
RESOURCES | Resources |
RESOURCE_INSTANCE_ID | Resource instance |
STORAGE_WHSE_CODE | Storage warehouse code |
STORAGE_LOCATION | Storage location |
PACKAGE_ID | Package ID |
TEXT_CODE | Text code |
ATTRIBUTE_CATEGORY | Descriptive flexfield category |
VARIANT_NO | Variant name |
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 |
SS_ID | Stability study for variant |
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 |
MATERIAL_SOURCE_ID | Source of material for variant |
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 |
STORAGE_PLAN_DETAIL_ID | Storage plan for variant |
DELETE_MARK | Logical delete mark |
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 |
SAMPLE_QTY | Sample Quantity for variant |
SAMPLE_QTY_UOM | Sample Quantity UOM for variant |
ACTUAL_END_DATE | End date of the variant |
SAMPLING_EVENT_ID | Sampling event id for the variant |
DEFAULT_SPEC_ID | Default spec for variant |
STORAGE_DATE | Storage date of time point samples |
SAMPLE_QUANTITY_UOM | Sample Quantity UOM |
STORAGE_LOCATOR_ID | Surrogate for Storage locator |
STORAGE_ORGANIZATION_ID | Surrogate for Storage organization |
STORAGE_SUBINVENTORY | Storage Subinventory |
MIGRATED_IND | Indicates Status of the Migration of this table |
SCHEDULED_START_DATE | Scheduled start date |
SAMPLES_PER_TIME_POINT | Samples per time points |
Process Manufacturing Product Development - GMD_SS_STORAGE_HISTORY | Stability Study Variant Storage History |
---|---|
Column Name | Descritpion |
STORAGE_HISTORY_ID | Primary key generated from sequence |
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 |
VARIANT_ID | Variant |
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 |
RESOURCES | Resources |
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 |
CREATION_DATE | Standard who column |
RESOURCE_INSTANCE_ID | Resource instance ID |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
END_DATE | End date of storage |
START_DATE | Start date of storage |
LOCATOR_ID | Surrogate for Locator |
ORGANIZATION_ID | Surrogate for Storage organization |
SUBINVENTORY | Storage Subinventory |
MIGRATED_IND | Indicates Status of the Migration of this table |
WHSE_CODE | Warehouse Code |
LOCATION | Location |
TEXT_CODE | Text code |
ATTRIBUTE_CATEGORY | Descriptive flexfield category |
ATTRIBUTE1 | Descriptive flexfield segment |
Process Manufacturing Product Development - GMD_SS_TIME_POINTS | Stability Study Time Points |
---|---|
Column Name | Descritpion |
TIME_POINT_ID | Primary key generated from sequence |
SPEC_ID | Spec id for the time point |
SAMPLING_EVENT_ID | Sampling event ID |
SCHEDULED_DATE | Scheduled date |
ACTUAL_DATE | Actual date |
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 |
VARIANT_ID | Variant of time point |
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 |
PERIOD_ID | Period used for time point |
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 |
YEARS_FROM_START | Years from start of time interval |
ATTRIBUTE25 | Descriptive flexfield segment |
ATTRIBUTE26 | Descriptive flexfield segment |
ATTRIBUTE27 | Descriptive flexfield segment |
ATTRIBUTE28 | Descriptive flexfield segment |
ATTRIBUTE29 | Descriptive flexfield segment |
ATTRIBUTE30 | Descriptive flexfield segment |
DELETE_MARK | Logical delete mark |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
LAST_UPDATED_BY | Standard who column |
MONTHS_FROM_START | Months from start of time interval |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
SAMPLES_PER_TIME_POINT | Samples per time points |
NAME | Name of time interval |
WF_SENT | for workflow notification |
WEEKS_FROM_START | Weeks from start of time interval |
DAYS_FROM_START | Days from start of time interval |
HOURS_FROM_START | Hours from start of time interval |
ADDITIONAL_IND | This test is added on time points form |
Process Manufacturing Product Development - GMD_SS_STORAGE_PACKAGE | Stability Study Variant Storage Package |
---|---|
Column Name | Descritpion |
PACKAGE_ID | Primary key generated from sequence |
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 |
FORMULA_ID | Formula for package |
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 |
QUANTITY | Quantity of package |
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 |
DELETE_MARK | Logical delete mark |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
UOM | Unit of measure of package quantity |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ITEM_ID | Item for the package |
PACKAGE_NAME | Name of the package |
INVENTORY_ITEM_ID | Surrogate for Inventory item |
ORGANIZATION_ID | Surrogate for organization |
QUANTITY_UOM | Quantity Uom code |
REVISION | Revision |
MIGRATED_IND | Indicates Status of the Migration of this table |
TEXT_CODE | Text code |
ATTRIBUTE_CATEGORY | Descriptive flexfield category |
ATTRIBUTE1 | Descriptive flexfield segment |
ATTRIBUTE2 | Descriptive flexfield segment |
ATTRIBUTE3 | Descriptive flexfield segment |
Process Manufacturing Product Development - GMD_MONITORING_SPEC_VRS | OPM Quality for Monitoring Spec Validity Rule |
---|---|
Column Name | Descritpion |
SPEC_VR_ID | Unique Key for the table |
RESOURCE_INSTANCE_ID | Resource for resource monitoring validity rule |
SPEC_VR_STATUS | Status of validity rule |
START_DATE | Start date for validity rule |
END_DATE | End date for validity rule |
SAMPLING_PLAN_ID | Sampling Plan for monitoing spec validity rule |
DELETE_MARK | Indicator for logical delete |
TEXT_CODE | Text code for edit text functionality |
ATTRIBUTE_CATEGORY | Descriptive Flexfield Category |
ATTRIBUTE1 | Descriptive Flexfield Segment |
ATTRIBUTE2 | Descriptive Flexfield Segment |
SPEC_ID | GMD_SPECIFICATIONS_B.SPEC_ID |
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 |
RULE_TYPE | (L)ocation or (R)resource |
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 |
LOCT_ORGN_CODE | Orgn code for the warehouse and location to be monitored |
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 |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LOCATOR_ORGANIZATION_ID | This is the locator organization ID |
SUBINVENTORY | This is the subinventory |
LOCATOR_ID | This is the locator ID |
RESOURCE_ORGANIZATION_ID | This is the resource organization ID |
ERECORD_SPEC_VR_ID | Original Erec key for record this was created from |
MIGRATED_IND | Indicates Status of the Migration of this table |
WHSE_CODE | ware house code location monitoring validity rule |
LOCATION | location for location monitoring validity rule |
RESOURCES | Resource for resource monitoring validity rule |
RESOURCE_ORGN_CODE | Resource for resource monitoring validity rule |
Process Manufacturing Product Development - GMD_RECIPE_GENERATION | Recipe Generation for automatic creation |
---|---|
Column Name | Descritpion |
RECIPE_GENERATION_ID | Primary Key |
START_DATE_TYPE | Indicator of the start date |
END_DATE | End date of validity rule |
END_DATE_TYPE | Indicator of the end date |
NUM_OF_DAYS | Number of days |
COST_CALENDAR | Used in cost validity rules |
MANAGING_VALIDITY_RULES | Managing duplicates |
RECIPE_NAMING_CONVENTION | Whether using product or formula name |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
RECIPE_USE_PROD | A Production validity rule will be created |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
ORGANIZATION_ID | Organization ID column is used to identify the organization |
RECIPE_USE_PLAN | A Planning validity rule will be created |
RECIPE_USE_COST | A Costing validity rule will be created |
RECIPE_USE_REG | A Regulatory validity rule will be created |
RECIPE_USE_TECH | A Technical validity rule will be created |
CREATION_TYPE | How it will be created |
ORGN_CODE | Organization code |
START_DATE | Start date of validity rule |
Process Manufacturing Product Development - GMD_MASS_SAMPLES | Sample IDs for Mass Results Entry |
---|---|
Column Name | Descritpion |
SEQ_ID | Sequence Number for the Mass Result Entry Session |
SAMPLE_ID | Sample ID |
Process Manufacturing Product Development - GMD_STABILITY_SPEC_VRS | Stability Study Validity Rules |
---|---|
Column Name | Descritpion |
SPEC_VR_ID | Specficiation Validity Rule ID |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
SPEC_ID | Specification ID |
SPEC_VR_STATUS | Specification Validity Rule Status |
START_DATE | Specification Validity Rule Start Date |
END_DATE | Specification Validity Rule End Date |
SAMPLING_PLAN_ID | Sampling Plan ID |
DELETE_MARK | Delete Mark; 0 = Active, 1 = Deleted |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
Process Manufacturing Product Development - GMD_FORMULA_SECURITY_TEMP | |
---|---|
Column Name | Descritpion |
FORMULA_ID | |
OTHER_ORGANIZATION_ID | |
ASSIGN_METHOD_IND | |
ACTIVATED_IND | |
ACCESS_TYPE_IND | |
ORGN_CODE | |
USER_ID | |
RESPONSIBILITY_ID | |
OTHER_ORGN | |
ORGANIZATION_ID |
Process Manufacturing Product Development - GMD_LCF_CATEGORY_DTL_GTMP | |
---|---|
Column Name | Descritpion |
LINE_ID | |
VALUE_IND | |
QTY | |
CATEGORY_ID |
Process Manufacturing Product Development - GMD_LCF_CATEGORY_HDR_GTMP | |
---|---|
Column Name | Descritpion |
CATEGORY_ID | |
CATEGORY_NAME | |
CATEGORY_SET_ID | |
CATEGORY_SET_NAME | |
MIN_PCT | |
MAX_PCT |
Process Manufacturing Product Development - GMD_LCF_DETAILS_GTMP | |
---|---|
Column Name | Descritpion |
ENTITY_ID | |
LOCATION | |
LOCATOR_ID | |
LOT_NUMBER | |
EXPIRATION_DATE | |
QTY | |
MIN_QTY | |
MAX_QTY | |
PRIMARY_QTY | |
SECONDARY_QTY | |
CONV_FACTOR | |
LINE_ID | |
DETAIL_UOM | |
PRIMARY_UOM | |
SECONDARY_UOM | |
GRADE_CODE | |
QTY_MASS | |
MASS_UOM | |
QTY_VOL | |
VOL_UOM | |
EXPAND_IND | |
FORMULALINE_ID | |
LINE_TYPE | |
MATERIAL_DETAIL_ID | |
SPRD_LINE_ID | |
PARENT_LINE_ID | |
BUFFER_IND | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
ORGANIZATION_ID | |
LINE_NO | |
ROLLUP_IND | |
INVENTORY_ITEM_ID | |
CONCATENATED_SEGMENTS | |
DESCRIPTION | |
SUBINVENTORY_CODE |
Process Manufacturing Product Development - GMD_OPTIMIZER_HDR_GTMP | |
---|---|
Column Name | Descritpion |
ENTITY_ID | |
MAINTAIN_TYPE | |
YIELD | |
INVENTORY_ITEM_ID | |
PRODUCT | |
PRODUCT_QTY | |
PRODUCT_UOM |
Process Manufacturing Product Development - GMD_LCF_TECH_DATA_GTMP | |
---|---|
Column Name | Descritpion |
LINE_ID | |
TECH_PARM_ID | |
TECH_PARM_NAME | |
VALUE | |
NUM_DATA | |
QCASSY_TYP_ID |
Process Manufacturing Product Development - GMD_MATERIAL_HEADER_GTMP | |
---|---|
Column Name | Descritpion |
ENTITY_ID | |
SPRD_NAME | |
BATCH_NO | |
FORMULA_NO | |
FORMULA_VERS | |
FORMULA_DESC1 | |
TEXT_CODE | |
ORGINAL_TEXT_CODE | |
MAINTAIN_TYPE | |
CREATED_BY | |
CREATION_DATE | |
ORGANIZATION_ID | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
LAB_ORGANIZATION_ID | |
BATCH_ID | |
FORMULA_ID | |
SPRD_ID | |
PLANT_ORGANIZATION_ID | |
MOVE_ORDER_HEADER_ID | |
UPDATE_INVENTORY_IND |
Process Manufacturing Product Development - GMD_MASS_RESULTS_GT | |
---|---|
Column Name | Descritpion |
SAMPLING_EVENT_ID | |
RESULT_ID | |
TEST_ID | |
TEST_METHOD_ID | |
TEST_REPLICATE_CNT | |
TEST_QTY | |
RESULT_VALUE_NUM | |
RESULT_DATE | |
TESTER_ID | |
SEQ | |
RESULT_VALUE_CHAR | |
SAMPLE_ACTIVE_CNT | |
LAST_UPDATE_DATE | |
EVALUATION_IND | |
ACTION_CODE | |
IN_SPEC_IND | |
ADDITIONAL_TEST_IND | |
VALUE_IN_REPORT_PRECISION | |
EVENT_SPEC_DISP_ID | |
SPEC_ID | |
SPEC_VR_ID | |
MIN_VALUE_NUM | |
SAMPLE_ID | |
TARGET_VALUE_NUM | |
MAX_VALUE_NUM | |
MIN_VALUE_CHAR | |
TARGET_VALUE_CHAR | |
MAX_VALUE_CHAR | |
TEST_REPLICATE | |
OUT_OF_SPEC_ACTION | |
EXP_ERROR_TYPE | |
BELOW_SPEC_MIN | |
ABOVE_SPEC_MIN | |
SAMPLE_NO | |
BELOW_SPEC_MAX | |
ABOVE_SPEC_MAX | |
BELOW_MIN_ACTION_CODE | |
ABOVE_MIN_ACTION_CODE | |
BELOW_MAX_ACTION_CODE | |
ABOVE_MAX_ACTION_CODE | |
OPTIONAL_IND | |
DISPLAY_PRECISION | |
REPORT_PRECISION | |
TEST_CODE | |
SAMPLE_DESC | |
TEST_DESC | |
TEST_CLASS | |
TEST_TYPE | |
TEST_UNIT | |
TEST_MIN_VALUE_NUM | |
TEST_MAX_VALUE_NUM | |
EXPRESSION | |
TEST_METHOD_CODE | |
TEST_METHOD_DESC | |
TEST_SELECTED | |
SOURCE | |
UPDATE_ALLOWED | |
RECORD_UPDATED | |
INVENTORY_ITEM_ID | |
LOT_NUMBER | |
SUBINVENTORY | |
ORGANIZATION_CODE | |
SOURCE_SUBINVENTORY | |
ORGANIZATION_ID | |
LAB_ORGANIZATION_ID | |
LOCATOR_ID | |
RESOURCES | |
TEST_QTY_UOM | |
SOURCE_LOCATOR_ID | |
PARENT_LOT_NUMBER | |
SAMPLE_TYPE | |
UPDATE_INSTANCE_ID |
Process Manufacturing Product Development - GMD_SAMPLE_REPLICATES_GT | |
---|---|
Column Name | Descritpion |
SAMPLE_ID | |
SAMPLE_NO | |
TEST_REPLICATE_CNT | |
ORGANIZATION_ID |
Process Manufacturing Product Development - GMD_SPEC_MAPPING_GTMP | |
---|---|
Column Name | Descritpion |
QC_SPEC_ID | |
SPEC_ID | |
TEST_ID | |
QC_REC_TYPE | |
SPEC_VR_ID | |
START_DATE | |
END_DATE | |
VR_SPEC_ID |
Process Manufacturing Product Development - GMD_QC_SPEC_MST_GTMP | |
---|---|
Column Name | Descritpion |
QC_SPEC_ID | |
ROUTING_ID | |
OLD_TO_DATE | |
MIGRATION_STATUS | |
ROUTINGSTEP_ID | |
OPRN_ID | |
DOC_TYPE | |
DOC_ID | |
DOCLINE_ID | |
CUST_ID | |
CUST_SPECIFICATION | |
CUST_CERTIFICATION | |
VENDOR_ID | |
QCASSY_TYP_ID | |
VENDOR_SPECIFICATION | |
VENDOR_CERTIFICATION | |
BATCH_ID | |
ASSAY_CODE | |
TEXT_SPEC | |
TARGET_SPEC | |
MIN_SPEC | |
MAX_SPEC | |
QCUNIT_CODE | |
FROM_DATE | |
ORGN_CODE | |
TO_DATE | |
OUTACTION_CODE | |
OUTACTION_INTERVAL | |
PREFERENCE | |
PRINT_COA_SHIPPED | |
PRINT_COA_INVOICED | |
VENDOR_COA_REQUIRED | |
TEST_OPRN_ID | |
TEST_OPRN_LINE_ID | |
TEST_PROVIDER_CODE | |
ITEM_ID | |
DELETE_MARK | |
TEXT_CODE | |
TRANS_CNT | |
CREATION_DATE | |
LAST_UPDATE_LOGIN | |
CREATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY | |
ROUTINGSTEP_NO | |
ATTRIBUTE1 | |
LOT_ID | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
WHSE_CODE | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
ATTRIBUTE15 | |
ATTRIBUTE16 | |
ATTRIBUTE17 | |
ATTRIBUTE18 | |
ATTRIBUTE19 | |
ATTRIBUTE20 | |
ATTRIBUTE21 | |
LOCATION | |
ATTRIBUTE22 | |
ATTRIBUTE23 | |
ATTRIBUTE24 | |
ATTRIBUTE25 | |
ATTRIBUTE26 | |
ATTRIBUTE27 | |
ATTRIBUTE28 | |
ATTRIBUTE29 | |
ATTRIBUTE30 | |
ATTRIBUTE_CATEGORY | |
FORMULA_ID | |
OPM_CUST_ID | |
CHARGE | |
OUTSIDE_SPEC_MIN | |
INSIDE_SPEC_MIN | |
INSIDE_SPEC_MAX | |
OUTSIDE_SPEC_MAX | |
ERROR_VAL_TYPE | |
OUTSIDE_MIN_ACTION_CODE | |
INSIDE_MIN_ACTION_CODE | |
INSIDE_MAX_ACTION_CODE | |
FORMULALINE_ID | |
OUTSIDE_MAX_ACTION_CODE | |
MIN_CHAR | |
MAX_CHAR | |
ORDER_HEADER_ID | |
ORDER_LINE_NO | |
ORDER_ORG_ID | |
QC_REC_TYPE | |
SHIP_TO_SITE_ID | |
SPEC_HDR_ID | |
OLD_FROM_DATE |
Process Manufacturing Product Development - GMD_OPTIMIZER_LINE_GTMP | |
---|---|
Column Name | Descritpion |
ENTITY_ID | |
LOT_NUMBER | |
EXPIRATION_DATE | |
QTY | |
DETAIL_UOM | |
PRIMARY_QTY | |
PRIMARY_UOM | |
SECONDARY_QTY | |
SECONDARY_UOM | |
QTY_MASS | |
MASS_UOM | |
LINE_ID | |
QTY_VOL | |
VOL_UOM | |
BUFFER_IND | |
ROLLUP_IND | |
PARENT_LINE_ID | |
LINE_TYPE | |
LINE_NO | |
INVENTORY_ITEM_ID | |
CONCATENATED_SEGMENTS | |
DESCRIPTION | |
REVISION |
Process Manufacturing Product Development - GMD_MATERIAL_DETAILS_GTMP | |
---|---|
Column Name | Descritpion |
ENTITY_ID | |
LOCATION | |
LOT_ID | |
LOT_NO | |
SUBLOT_NO | |
EXPIRE_DATE | |
QTY | |
ITEM_UM | |
DUALUM_IND | |
BATCHSTEP_NO | |
PRIMARY_QTY | |
LINE_ID | |
PRIMARY_UM | |
SECONDARY_QTY | |
SECONDARY_UM | |
QC_GRADE | |
QTY_MASS | |
MASS_UOM | |
QTY_VOL | |
VOL_UOM | |
TEXT_CODE | |
ORGINAL_TEXT_CODE | |
LINE_TYPE | |
EXPAND_IND | |
TPFORMULA_ID | |
FORMULALINE_ID | |
MATERIAL_DETAIL_ID | |
SPRD_LINE_ID | |
PARENT_LINE_ID | |
TRANS_ID | |
LOT_CTL | |
LOCT_CTL | |
SUBLOT_CTL | |
LINE_NO | |
GRADE_CTL | |
BUFFER_IND | |
ACTION_CODE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
PLANT_CODE | |
RESERVATION_ID | |
ROLLUP_IND | |
TRANSACTION_ID | |
INVENTORY_ITEM_ID | |
CONCATENATED_SEGMENTS | |
DESCRIPTION | |
REVISION | |
REVISION_QTY_CONTROL_CODE | |
SUBINVENTORY_CODE | |
LOCATOR_ID | |
LOT_NUMBER | |
EXPIRATION_DATE | |
ITEM_ID | |
DETAIL_UOM | |
TRACKING_QUANTITY_IND | |
SECONDARY_DEFAULT_IND | |
PRIMARY_UOM | |
SECONDARY_UOM | |
GRADE_CODE | |
MOVE_ORDER_LINE_ID | |
LOT_CONTROL_CODE | |
LOCATION_CONTROL_CODE | |
GRADE_CONTROL_FLAG | |
ITEM_NO | |
ORGANIZATION_ID | |
PLANT_ORGANIZATION_ID | |
PROD_PERCENT | |
ITEM_DESC1 | |
WHSE_CODE |
Process Manufacturing Product Development - GMD_SPREAD_ERRORS_GTMP | |
---|---|
Column Name | Descritpion |
ENTITY_ID | |
EXPRESSION_TYPE | |
LINE_ID | |
LINE_TYPE | |
INVENTORY_ITEM_ID | |
CONCATENATED_SEGMENTS | |
LOT_NUMBER | |
TECH_PARM_ID | |
TECH_PARM_NAME | |
ERROR_MESSAGE |
Process Manufacturing Product Development - GMD_MIGRATE_PARMS | Quality Migration Setup Table |
---|---|
Column Name | Descritpion |
DEFAULT_STABILITY_STUDY_ORG | Default Stability Study Organization Code |
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 - GMD_PARAMETERS_DTL | GMD parameters line table |
---|---|
Column Name | Descritpion |
PARAMETER_ID | Parameter id - Primary key |
CREATED_BY | Standard who column |
PARAMETER_LINE_ID | Parameter line id |
PARAMETER_TYPE | parameter_type - indicates if its a formula or routing or recipe etc |
PARAMETER_NAME | Parameter name |
PARAMETER_VALUE | Parameter value |
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 - GMD_PARAMETERS_HDR | used instead of profiles |
---|---|
Column Name | Descritpion |
PARAMETER_ID | Parameter id - Primary Key |
ORGANIZATION_ID | Inventory Organization ID |
LAB_IND | Lab indicator |
PLANT_IND | Plant Indicator |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
CREATED_BY | Standard Who Column |
Process Manufacturing Product Development - GMD_COA_SPEC_HDR_TEXT | Certificate of Analysis report header text information |
---|---|
Column Name | Descritpion |
GMD_COA_ID | Distinct number of the header |
TEXT_CODE | Result text key to the GMD text table |
PARAGRAPH_CODE | Defined in the sy_para_cds |
LINE_NO | Line number which allows multiple lines of descriptive text for underlying record. -1=line is used to recreate key of underlying record; 1<=descriptive text |
TEXT | Text associated with this result. |
Process Manufacturing Product Development - GMD_ITEM_SUBSTITUTION_HDR_TL | This is translate table for the Item Substitution |
---|---|
Column Name | Descritpion |
SUBSTITUTION_ID | Substitution Identifier |
LANGUAGE | Language |
SUBSTITUTION_DESCRIPTION | Substitution Description |
SOURCE_LANG | Source Language |
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_ITEM_SUBSTITUTION_DTL | Substitution Detail table holds the replacement item(s) for the original item in the Substitution Table |
---|---|
Column Name | Descritpion |
SUBSTITUTION_LINE_ID | Substitution Line Identifier |
LAST_UPDATE_LOGIN | Standard Who column |
INVENTORY_ITEM_ID | Replacement Inventory Item |
DETAIL_UOM | Replacement Unit of Measure |
SUBSTITUTION_ID | Substitution Identifier |
ITEM_ID | Item Identifier |
UNIT_QTY | Unity Quantity |
ITEM_UOM | Item UOM |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard Who column |
Process Manufacturing Product Development - GMD_FORMULA_SUBSTITUTION | Formula Substitution table holds the valid formulas which are valid for the context item substitution |
---|---|
Column Name | Descritpion |
FORMULA_SUBSTITUTION_ID | Formula Substitution Id |
SUBSTITUTION_ID | Substitution Id |
FORMULA_ID | Formula Id |
ASSOCIATED_FLAG | Associate Flag |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
Process Manufacturing Product Development - GMD_ITEM_SUBSTITUTION_HDR_B | This is master table for the Item Substitution, which holds the item substitution details |
---|---|
Column Name | Descritpion |
SUBSTITUTION_ID | Substitution Identifier |
OWNER_ORGN_CODE | Owner Organization Code |
REPLACEMENT_UOM_TYPE | Replacement UOM type |
ATTRIBUTE_CATEGORY | Descriptive Flex field |
ATTRIBUTE1 | Descriptive Flex field |
ATTRIBUTE2 | Descriptive Flex field |
ATTRIBUTE3 | Descriptive Flex field |
ATTRIBUTE4 | Descriptive Flex field |
ATTRIBUTE5 | Descriptive Flex field |
ATTRIBUTE6 | Descriptive Flex field |
ATTRIBUTE7 | Descriptive Flex field |
SUBSTITUTION_NAME | Substitution Name |
ATTRIBUTE8 | Descriptive Flex field |
ATTRIBUTE9 | Descriptive Flex field |
ATTRIBUTE10 | Descriptive Flex field |
ATTRIBUTE11 | Descriptive Flex field |
ATTRIBUTE12 | Descriptive Flex field |
ATTRIBUTE13 | Descriptive Flex field |
ATTRIBUTE14 | Descriptive Flex field |
ATTRIBUTE15 | Descriptive Flex field |
ATTRIBUTE16 | Descriptive Flex field |
ATTRIBUTE17 | Descriptive Flex field |
ATTRIBUTE18 | Descriptive Flex field |
ATTRIBUTE19 | Descriptive Flex field |
ATTRIBUTE20 | Descriptive Flex field |
ATTRIBUTE21 | Descriptive Flex field |
ATTRIBUTE22 | Descriptive Flex field |
ATTRIBUTE23 | Descriptive Flex field |
ATTRIBUTE24 | Descriptive Flex field |
ATTRIBUTE25 | Descriptive Flex field |
ATTRIBUTE26 | Descriptive Flex field |
ATTRIBUTE27 | Descriptive Flex field |
SUBSTITUTION_STATUS | Substitution Version |
ATTRIBUTE28 | Descriptive Flex field |
ATTRIBUTE29 | Descriptive Flex field |
ATTRIBUTE30 | Descriptive Flex field |
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 |
ORIGINAL_INVENTORY_ITEM_ID | Original Inventory Item |
ORIGINAL_UOM | Original Inventory Item Unit of Measure |
ORIGINAL_ITEM_ID | Original Item Id. |
OWNER_ORGANIZATION_ID | Owner Organization |
ORIGINAL_ITEM_UOM | Orginal Item UOM |
SUBSTITUTION_VERSION | Substitution Version |
ORIGINAL_QTY | Original Quantity |
PREFERENCE | Preference |
START_DATE | Start Date |
END_DATE | End Date |
Process Manufacturing Product Development - GMD_FORMULATION_SPECS | LCF - Formulation Specification table |
---|---|
Column Name | Descritpion |
FORMULATION_SPEC_ID | Primary Key, Unique Identifier for a Formulation Specification |
START_DATE | Active Start date for the Formulation Specification |
END_DATE | Active End date for the Formulation Specification |
MIN_INGREDS | Minimum no. of Ingredients column |
MAX_INGREDS | Maximum no. of Ingredients column |
INGRED_PICK_BASE_IND | Ingredient Pick Base indicator. MAT - Material requirement, CMP - Compositional requirement |
PICK_LOT_STRATEGY | Pick Lot Startegy Column |
TECH_PARM_ID | Technical Parameter ID Column |
OBJECTIVE_IND | Objective Indicator. 0 - Minimize, 1 - Maximize |
CREATION_DATE | Standard who column |
CREATED_BY | Standard who column |
SPEC_NAME | Formulation Specification Name |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
TEXT_CODE | The link to the Text associated to the Formulation Specification |
ROUTING_ID | The Routing ID associated with this specification. It is optional to associate a Routing with a Formulation Specification. |
DELETE_MARK | Standard: 0 = Active record (default); 1 = Marked for (logical) deletion. |
SPEC_VERS | Formulation Specification Version |
PRODUCT_ID | Inventory Item ID of the product |
OWNER_ORGANIZATION_ID | Owner Organization id of the Formulation Specification |
SPEC_STATUS | The Status of the Formulation Specification. See the GMD_STATUS table for a list of possible Status |
STD_QTY | Standard Qty column |
STD_UOM | Standard UOM column |
PROCESS_LOSS | Process Loss column |
Process Manufacturing Product Development - GMD_LCF_EXTERNAL_COST | Source for, external cost values |
---|---|
Column Name | Descritpion |
INVENTORY_ITEM_ID | Inventory item |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
LAST_UPDATE_DATE | Standard who column |
COST_ORGANIZATION_ID | Cost Source Organization |
LAB_ORGANIZATION_ID | Laboratory Organization |
QUANTITY | Quantity of the item |
LOT_NUMBER | Lot Number |
UOM | Unit of Measure for the item |
UNIT_COST | Cost of the each Unit |
FROM_DATE | From Date |
TO_DATE | To Date |
Process Manufacturing Product Development - GMD_COMPOSITIONAL_REQS | LCF - Compositional Requirements Table |
---|---|
Column Name | Descritpion |
FORMULATION_SPEC_ID | Surrogate key for the formulation specification/version |
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 |
COMP_REQ_ID | Surrogate key for the compositional requirement line |
SPEC_ATTRIBUTE_ID | Surrogate key for the spec attribute line. Used to determine the type of requirement |
ORDER_NO | Order priority of the detail lines |
MIN_PCT | Minimum Percentage Column |
MAX_PCT | Maximum Percentage Column |
CATEGORY_SET_ID | Category set ID Column |
CATEGORY_ID | Category ID Column |
PLANNED_PCT | Planned Percentage Column |
Process Manufacturing Product Development - GMD_SPECIFICATION_ATTRIBUTES | LCF - Formulation Specification Attributes Table |
---|---|
Column Name | Descritpion |
FORMULATION_SPEC_ID | Surrogate key for the formulation specification/version |
SPEC_ATTRIBUTE_ID | Primary Key, Unique Identifier for a specification requirement type |
LOOKUP_TYPE | Name of the Lookup Code |
LOOKUP_CODE | Name of the Lookup 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_MATERIAL_REQS | LCF - Material Requirements Table |
---|---|
Column Name | Descritpion |
FORMULATION_SPEC_ID | Surrogate key for the formulation specification/version |
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 |
MATL_REQ_ID | Surrogate key for the material requirement line |
SPEC_ATTRIBUTE_ID | Surrogate key for the spec attribute line. Used to determine the type of requirement |
INVENTORY_ITEM_ID | Surrogate key for the item |
LINE_NO | List order on screen |
ITEM_UOM | Item UOM Column |
RANGE_TYPE | Range Type Column. 0 - Percentage, 1 - Quantity |
MIN_QTY | Minimum Qty Column |
MAX_QTY | Maximum Qty Column |
Process Manufacturing Product Development - GMD_CHANGE_DISPOSITION | Change Disposition form history table |
---|---|
Column Name | Descritpion |
CHANGE_DISP_ID | Unique key |
DISPOSITION_FROM | Disposition before the change |
DISPOSITION_TO | Disposition after the change |
PARENT_LOT_NUMBER | Parent Lot |
LOT_NUMBER | Lot |
LOT_STATUS_ID | Lot status after the change |
GRADE_CODE | Grade after the change |
REASON_ID | Change reason |
HOLD_DATE | Hold Date |
ORGANIZATION_ID | Sample Organization |
SAMPLE_ID | Sample |
SAMPLING_EVENT_ID | Sampling Event |
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_CHANGE_LOTS | Change Disposition form history - Lots affected |
---|---|
Column Name | Descritpion |
CHANGE_DISP_ID | Unique key to gmd_change_disposition table |
LOT_NUMBER | Lot |
FROM_LOT_STATUS_ID | Lot status before the change |
FROM_GRADE_CODE | Lot Grade before the change |
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 |
No hay comentarios:
Publicar un comentario