PROCESS_INSTANCEN=Specific Business Unit
Y=All Business Units
1=Msg Agent
2=Online
3=Batch
4=Auto Gen
5=Message
T=Validate and Transfer
V=Validate Only
E=Error
O=No Change
T=Transfer
U=No Errors
W=Warning
EN_BOM_MSG_AET(SQL Table) |
Index Back |
|---|---|
State table for BOM MSG AE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | ALL_BU | Character(1) | VARCHAR2(1) NOT NULL |
All Business Units
N=Specific Business Unit Y=All Business Units |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | BUSINESS_UNIT_TO | Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
| 7 | PROCESS_INST_STG | Number(10,0) | DECIMAL(10) NOT NULL | Stage Record Process Instance |
| 8 | ALL_EIP_CTL_ID | Character(1) | VARCHAR2(1) NOT NULL | All EIP_CTL_IDs |
| 9 | EIP_CTL_ID_FROM | Character(25) | VARCHAR2(25) NOT NULL | EIP control ID selection |
| 10 | EIP_CTL_ID_TO | Character(25) | VARCHAR2(25) NOT NULL | EIP control ID selection |
| 11 | PROCESS_ERROR | Character(1) | VARCHAR2(1) NOT NULL | Re-process any Errors in Range |
| 12 | EIP_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
EIP Source
1=Msg Agent 2=Online 3=Batch 4=Auto Gen 5=Message |
| 13 | PURGE_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Purge History without Archive |
| 14 | TRANSFER_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Options
T=Validate and Transfer V=Validate Only |
| 15 | STATUS_STRING | Character(100) | VARCHAR2(100) NOT NULL | String Text |
| 16 | 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 |
| 17 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 18 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 19 | EIP_CTL_ID_FROM_NR | Number(25,0) | DECIMAL(25) NOT NULL | EIP control id Numeric |
| 20 | EIP_CTL_ID_TO_NR | Number(25,0) | DECIMAL(25) NOT NULL | EIP Contril id Numeric |