EN_RTG_ERR_TMP(SQL Table) |
Index Back |
|---|---|
Rtg Transfer Error Messages9/97 WTK (CN# EG750-5.0) Created |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BUSINESS_UNIT_TO |
Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | RTG_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing |
| 6 | RTG_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 7 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 8 | MESSAGE_SET_NBR |
Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 9 | MESSAGE_NBR |
Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | COPY_DIRECTION |
Character(2) | VARCHAR2(2) NOT NULL |
Copy From/To
EE=Engineering to Engineering EM=Engineering to Manufacturing ME=Manufacturing to Engineering |
| 11 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 12 | BOM_TRANSFER_STAT | Character(1) | VARCHAR2(1) NOT NULL |
02/01/00 LAJ
Took the word "Transfer" out of the label, since we now display this field for BOM Mass Maintenance Error correction.
Also added new translate (Update) to distiguish between the EG transfer process status and the BOM Mass Maintenance Status
05/18/00 LAJ
Added new label id for BOM results. This is used by the Mass Maint staged results panelgroup.
E=Error O=No Change T=Transfer U=No Errors W=Warning |