SHEET_IDDefault Value: NEXT
LINE_NBRDefault Value: 1
SHEET_ID_RELATEDLINE_NBR2Y/N Table Edit
Default Value: N
Default Value: OPR_DEF_TBL_FS.SETID
Default Value: EX02
Prompt Table: REASON_CD
EX_SHEET_DUP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Report ID
Default Value: NEXT |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 3 | SHEET_ID_RELATED |
Character(10) | VARCHAR2(10) NOT NULL | Journal Report ID |
| 4 | LINE_NBR2 |
Number(5,0) | INTEGER NOT NULL | Line Number |
| 5 | EMPLOYEE_ID | Character(11) | VARCHAR2(11) NOT NULL | EmplID |
| 6 | EX_REVIEWED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Reviewed
Y/N Table Edit Default Value: N |
| 7 | EE_DPLCAT_COMMENT | Character(80) | VARCHAR2(80) NOT NULL | Duplicate Comment |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 9 | REASON_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Reason Type
Default Value: EX02 |
| 10 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: REASON_CD |