BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
SF_RESRC_TYPE10=Crew
30=Machine
50=Tool
SF_RESRC_CODEATTR_GRP_FROMPrompt Table: EN_CHGOVER_G_VW
ATTR_GRP_TOPrompt Table: EN_CHGOVER_G_VW
Y/N Table Edit
Default Value: N
EN_R_CHGOVR_MAT(SQL Table) |
Index Back |
|---|---|
Work Center Changeover MatrixCN#PL800-21.0, 24.0 & 33.0 MACN 5/21/99 - Modified the function resource_dfn in SF_RESRC_TYPE (RowInit). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | SF_RESRC_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Resource Type
10=Crew 30=Machine 50=Tool |
| 3 | SF_RESRC_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Work Center Resource Code |
| 4 | ATTR_GRP_FROM |
Character(10) | VARCHAR2(10) NOT NULL |
Inventory Item From Resource
Prompt Table: EN_CHGOVER_G_VW |
| 5 | ATTR_GRP_TO |
Character(10) | VARCHAR2(10) NOT NULL |
Inventory Item To Resource
Prompt Table: EN_CHGOVER_G_VW |
| 6 | CHG_OVER_REVERSE | Character(1) | VARCHAR2(1) NOT NULL |
Reverse Changeover Points
Y/N Table Edit Default Value: N |
| 7 | CHG_OVER_DOWNTIME | Number(7,2) | DECIMAL(6,2) NOT NULL | Change Over Down Time |
| 8 | PENALTY_FACTOR_WC | Number(9,4) | DECIMAL(8,4) NOT NULL | Penalty Factor for Work Center |