EG_RTG_HDR_CMP(SQL Table) |
Index Back |
|---|---|
Item Routing Header(type/code)CN#EG750-4.0 dbe (Engineering Routings) - Added new field: RTG_STATE. PeopleCode to support Engineering Routings. |
| # | 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 Prompt Table: SP_BUMGOP_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDITTABLE |
| 3 | RTG_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown Default Value: PR |
| 4 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 5 | RTG_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing Default Value: PR |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | COPY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
COPY_FLAG
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 9 | COPY_TO_PLANNING | Character(1) | VARCHAR2(1) NOT NULL |
Copy Routing to Planning
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 10 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL |
Priority
Default Value: 1 |
| 11 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 12 | EG_RTG_DIFF | Character(10) | VARCHAR2(10) NOT NULL | Differences |