GPCH_RP_AL021(SQL Table) |
Index Back |
---|---|
Results Record for GPCHAL02Results Record for GPCHAL02 |
# | 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 | GPCH_RP_CR_LINE | Character(2) | VARCHAR2(2) NOT NULL | Calc Reconciliation Report Line |
5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
6 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
7 | GPCH_AL_NBR01_07 | Number(7,0) | INTEGER NOT NULL | Numeric Field used in Calc Reconciliation Report. |
8 | GPCH_RP_AMNT01_12 | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Amount |