ARCHIVE_IDARCHIVE_DTOPEN_MC_ARCH_VW(SQL View) |
Index Back |
|---|---|
AM Open Transactions Archive |
| SELECT ARCHIVE_ID , ARCHIVE_DT FROM PS_OPEN_TRANS_ARCH |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ARCHIVE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID |
| 2 | ARCHIVE_DT |
Date(10) | DATE | Archive Date |