EG_ECR_ASDCM_VW(SQL View) |
Index Back |
|---|---|
Eng ECR Assy Doc Maint VW07/07/97 LAJ - Added default of 01 to EG_ECO_TARGET. Deleted field DC_FLOW_ECR. This view is used to select documents associated at the item level on ECRs. It uses the table that is used to store documents for ECOs at the item level as well. CN# EN800-3.0, anna 09/21 added bomtype, rtgtype, bomcode, rtgcode |
| select a.business_unit, a.eco_id, a.eco_state, a.inv_item_id, a.bom_type, a.rtg_type, a.bom_code, a.rtg_code, a.eg_eco_target, %subrec(dc_dc_sbr,a) from PS_EG_ECO_ASSY_DC a where a.eco_state = 'CR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | ECR_ID |
Character(10) | VARCHAR2(10) NOT NULL | ECR Number |
| 3 | ECO_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
ECR / ECO Flag
CO=Engineering Change Order CR=Engineering Chg Request Default Value: CR |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | BOM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
| 6 | RTG_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 7 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 8 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 9 | EG_ECO_TARGET | Character(2) | VARCHAR2(2) NOT NULL |
Affects
01=Manufacturing 02=Engineering 03=Mfg & Eng Default Value: 02 |
| 10 | DC_OBJECT_ID |
Character(16) | VARCHAR2(16) NOT NULL | Document Object ID |
| 11 | DC_FIXED | Character(1) | VARCHAR2(1) NOT NULL |
fixed to specific doc version
N=No Y=Yes Y/N Table Edit Default Value: N |
| 12 | DC_OBJECT_NAME | Character(254) | VARCHAR2(254) NOT NULL | Document Name |
| 13 | DC_TITLE | Character(64) | VARCHAR2(64) NOT NULL | Title |