SCR_SRC_RECSCR_DFT_RECSCR_SYS_DATA(SQL Table) |
Index Back |
|---|---|
Supplier Change Req Sys DataThis table is used to process all the records on the Chage Request pages. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ORDERNO | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 2 | SCR_SRC_REC |
Character(15) | VARCHAR2(15) NOT NULL | Soruce Record |
| 3 | SCR_DFT_REC |
Character(15) | VARCHAR2(15) NOT NULL | Draft Record |
| 4 | SCR_MST_REC | Character(15) | VARCHAR2(15) NOT NULL | Master Copy |
| 5 | SCR_CMP_REC | Character(15) | VARCHAR2(15) NOT NULL | Compare View |
| 6 | SCR_UPD_REC | Character(15) | VARCHAR2(15) NOT NULL | Update Record |
| 7 | SCR_WRK_REC | Character(15) | VARCHAR2(15) NOT NULL | |
| 8 | SCR_REMOVE | Character(1) | VARCHAR2(1) NOT NULL | Remove Contact |
| 9 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 10 | NUM_CHILDREN | Number(3,0) | SMALLINT NOT NULL | Number of children |
| 11 | RECNAME_0 | Character(15) | VARCHAR2(15) NOT NULL | Level 0 Record |
| 12 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Record 1 Name |
| 13 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
| 14 | PAGE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Page Name |
| 15 | CHECK_ROWS_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Check For Rows |
| 16 | PREPROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Pre-Process in chunks |