OPRIDRUN_CNTL_IDITM_CHG_REC_LISTFIELDNAME%+=Increase By Percentage
+=Increase By Value
-=Decrease By Value
-%=Decrease By Percentage
AB=Value
Default Value: AB
N=No
Y=Yes
RUN_IN_ITMC_LST(SQL Table) |
Index Back |
|---|---|
Item Change - Field DetailsItem Change Process - Field details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | ITM_CHG_REC_LIST |
Character(3) | VARCHAR2(3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template.Contains translate value for Record names for Change Value Page in Item Template. |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | ITEM_TMP_OPR | Character(2) | VARCHAR2(2) NOT NULL |
10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template. Contains Translate Values for Operator
%+=Increase By Percentage +=Increase By Value -=Decrease By Value -%=Decrease By Percentage AB=Value Default Value: AB |
| 7 | ALLOW_MODIFY | Character(1) | VARCHAR2(1) NOT NULL | Allow Modify Comments |
| 8 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 9 | FIELD_01 | Character(1) | VARCHAR2(1) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 10 | FIELD_02 | Character(2) | VARCHAR2(2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 11 | FIELD_03 | Character(3) | VARCHAR2(3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 12 | FIELD_04 | Character(4) | VARCHAR2(4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 13 | FIELD_05 | Character(4) | VARCHAR2(4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 14 | FIELD_06 | Character(5) | VARCHAR2(5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 15 | FIELD_07 | Character(6) | VARCHAR2(6) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 16 | FIELD_08 | Character(8) | VARCHAR2(8) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 17 | FIELD_09 | Character(9) | VARCHAR2(9) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 18 | FIELD_10 | Character(10) | VARCHAR2(10) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 19 | FIELD_11 | Character(10) | VARCHAR2(10) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 20 | FIELD_12 | Character(12) | VARCHAR2(12) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 21 | FIELD_13 | Character(14) | VARCHAR2(14) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 22 | FIELD_14 | Character(15) | VARCHAR2(15) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 23 | FIELD_15 | Character(16) | VARCHAR2(16) NOT NULL | Field name 15 |
| 24 | FIELD_16 | Character(18) | VARCHAR2(18) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 25 | FIELD_17 | Character(20) | VARCHAR2(20) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 26 | FIELD_18 | Character(25) | VARCHAR2(25) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 27 | FIELD_19 | Character(30) | VARCHAR2(30) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 28 | FIELD_20 | Character(30) | VARCHAR2(30) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 29 | FIELD_21 | Character(50) | VARCHAR2(50) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 30 | FIELD_22 | Character(60) | VARCHAR2(60) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 31 | FIELD_23 | Character(80) | VARCHAR2(80) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 32 | FIELD_24 | Character(254) | VARCHAR2(254) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 33 | FIELD_25 | Number(2,0) | SMALLINT NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 34 | FIELD_26 | Number(3,0) | SMALLINT NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 35 | FIELD_27 | Number(4,0) | SMALLINT NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 36 | FIELD_28 | Number(4,1) | DECIMAL(3,1) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 37 | FIELD_29 | Number(5,1) | DECIMAL(4,1) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 38 | FIELD_30 | Number(6,0) | INTEGER NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 39 | FIELD_31 | Number(6,2) | DECIMAL(5,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 40 | FIELD_32 | Number(8,2) | DECIMAL(7,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 41 | FIELD_33 | Number(12,2) | DECIMAL(11,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 42 | FIELD_34 | Number(12,4) | DECIMAL(11,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 43 | FIELD_35 | Number(14,5) | DECIMAL(13,5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 44 | FIELD_36 | Number(15,0) | DECIMAL(15) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 45 | FIELD_37 | Number(15,4) | DECIMAL(14,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 46 | FIELD_38 | Number(16,3) | DECIMAL(15,3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 47 | FIELD_39 | Number(16,4) | DECIMAL(15,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 48 | FIELD_40 | Number(16,5) | DECIMAL(15,5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 49 | FIELD_41 | Number(18,0) | DECIMAL(18) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 50 | FIELD_42 | Signed Number(4,0) | DECIMAL(3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 51 | FIELD_43 | Signed Number(6,0) | DECIMAL(5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 52 | FIELD_44 | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 53 | FIELD_45 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 54 | FIELD_46 | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 55 | FIELD_47 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 56 | FIELD_48 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 57 | FIELD_49 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 58 | FIELD_50 | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 59 | FIELD_51 | Signed Number(22,5) | DECIMAL(20,5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 60 | FIELD_52 | Date(10) | DATE | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 61 | FIELD_53 | Character(250) | VARCHAR2(250) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 62 | FIELD_54 | DateTime(26) | TIMESTAMP | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 63 | FIELD_55 | Number(4,1) | DECIMAL(3,1) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 64 | FIELD_56 | Number(5,1) | DECIMAL(4,1) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 65 | FIELD_57 | Number(6,2) | DECIMAL(5,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 66 | FIELD_58 | Number(5,0) | INTEGER NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 67 | FIELD_59 | Number(8,2) | DECIMAL(7,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 68 | FIELD_60 | Number(12,4) | DECIMAL(11,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 69 | FIELD_61 | Number(14,5) | DECIMAL(13,5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 70 | FIELD_62 | Number(12,2) | DECIMAL(11,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 71 | FIELD_63 | Number(10,0) | DECIMAL(10) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 72 | FIELD_64 | Number(15,4) | DECIMAL(14,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 73 | FIELD_65 | Number(16,5) | DECIMAL(15,5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 74 | FIELD_66 | Number(16,4) | DECIMAL(15,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 75 | FIELD_67 | Number(16,3) | DECIMAL(15,3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 76 | FIELD_68 | Signed Number(4,0) | DECIMAL(3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 77 | FIELD_69 | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 78 | FIELD_70 | Signed Number(6,0) | DECIMAL(5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 79 | FIELD_71 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 80 | FIELD_72 | Signed Number(12,4) | DECIMAL(10,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 81 | FIELD_73 | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 82 | FIELD_74 | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 83 | FIELD_75 | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 84 | FIELD_76 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 85 | FIELD_77 | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 86 | FIELD_78 | Signed Number(22,5) | DECIMAL(20,5) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 87 | FIELD_79 | Signed Number(17,0) | DECIMAL(16) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template |
| 88 | FIELD_80 | Character(7) | VARCHAR2(7) NOT NULL | Field 80 |
| 89 | FIELD_81 | Character(13) | VARCHAR2(13) NOT NULL | Field 81 |
| 90 | FIELD_82 | Character(35) | VARCHAR2(35) NOT NULL | Field 82 |
| 91 | FIELD_ID | Character(24) | VARCHAR2(24) NOT NULL | Config Field Id |
| 92 | VALUE_NUM | Number(14,3) | DECIMAL(13,3) NOT NULL | VALUE NUMBER |