IU_SYS_TR_EX_VW(SQL View) |
Index Back |
---|---|
System Transaction View for EX |
SELECT IU_SYS_TRAN_CD , DESCR FROM PS_IU_SYS_TRAN_TBL WHERE IU_SYS_TRAN_CD LIKE 'EX%' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | IU_SYS_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries. |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |