MU_IDMU_CHG_NUMSEQ_NUMPrompt Table: MU_TP_SETUP_TBL
Prompt Table: MU_TP_SETUP_DTL
Prompt Table: %EDITTABLE
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
MU_SETUP_CHG(SQL Table) |
Index Back |
|---|---|
MU Definition ChangesDetails of the changes to be processed via Mass Update. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MU_ID |
Character(15) | VARCHAR2(15) NOT NULL | Mass Update ID |
| 2 | MU_CHG_NUM |
Number(3,0) | SMALLINT NOT NULL | Change Number |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | MU_SECTION | Character(20) | VARCHAR2(20) NOT NULL |
Section
Prompt Table: MU_TP_SETUP_TBL |
| 5 | MU_ELEMENT | Character(20) | VARCHAR2(20) NOT NULL |
Element
Prompt Table: MU_TP_SETUP_DTL |
| 6 | MU_VALUE_CHAR | Character(254) | VARCHAR2(254) NOT NULL |
Character Value
Prompt Table: %EDITTABLE |
| 7 | MU_VALUE_DT | Date(10) | DATE | Date Value |
| 8 | MU_VALUE_NUM | Number(22,6) | DECIMAL(21,6) NOT NULL | Numeric Value |
| 9 | MU_VALUE_BOOL | Character(1) | VARCHAR2(1) NOT NULL |
Boolean Value
Y/N Table Edit Default Value: N |
| 10 | MU_COPY_FWD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Copy Forward
Y/N Table Edit Default Value: N |
| 11 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |