PO_SSHDCNG_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELD_DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Field Description |
| 2 | FIELD_VALUE_CHAR1 | Character(254) | VARCHAR2(254) NOT NULL | Original Value |
| 3 | FIELD_VALUE_NBR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An accounting template field designated to support the substitution of desired monetary amounts during a |
| 4 | FIELD_VALUE_DATE | Date(10) | DATE | An accounting template field designated to support the substitution of desired dates during accounting b |
| 5 | CHNG_DTTM | DateTime(26) | TIMESTAMP | Change Request Date/Time |
| 6 | ORIG_DUE_TIME | Time(15) | TIMESTAMP | Original Time Due |
| 7 | CHNG_CHAR_VALUE | Character(254) | VARCHAR2(254) NOT NULL | New Field Value |
| 8 | CHNG_NBR_VALUE | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | New Numeric Value |
| 9 | CHNG_DATE_VALUE | Date(10) | DATE | New Date Value |
| 10 | CHNG_DTTM_VALUE | DateTime(26) | TIMESTAMP | Change Date/Time Value |
| 11 | CHNG_TIME_VALUE | Time(15) | TIMESTAMP | Change Time Value |