PROCESS_INSTANCE0=Successful
1=Complete with errors
2=Not Complete
N=Other Source
P=Process Scheduler
Y/N Table Edit
Default Value: N
IU_PROCESS_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | HEADER_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Header Record |
| 4 | UPDATE_HEADER_REC | Character(15) | VARCHAR2(15) NOT NULL | Update Header Record |
| 5 | LINE_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Line Record |
| 6 | UPDATE_LINE_REC | Character(15) | VARCHAR2(15) NOT NULL | Update Line Record |
| 7 | INSERT_LINE_REC | Character(15) | VARCHAR2(15) NOT NULL | Insert Line Record |
| 8 | LINE_WRK_REC | Character(15) | VARCHAR2(15) NOT NULL | Line Work Record |
| 9 | LINE_WRK2_REC | Character(15) | VARCHAR2(15) NOT NULL | Line Work Record 2 |
| 10 | LINE_WRK3_REC | Character(15) | VARCHAR2(15) NOT NULL | Used in IU_PROCESSOR for KLS processing |
| 11 | LINE_WRK4_REC | Character(15) | VARCHAR2(15) NOT NULL | Used in IU_PROCESSOR to get max(journal_line) |
| 12 | LINE_WRK5_REC | Character(15) | VARCHAR2(15) NOT NULL | Used in IU_PROCESSOR for using dense_rank() |
| 13 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 14 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 15 | IU_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Processing Status
0=Successful 1=Complete with errors 2=Not Complete |
| 16 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
| 17 | 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. |
| 18 | IU_WHERE_SQL | Long Character | CLOB | Where SQL |
| 19 | DUMMY_STMT | Character(254) | VARCHAR2(254) NOT NULL | Dummy Statement |
| 20 | DUMMY_STMT2 | Character(254) | VARCHAR2(254) NOT NULL | Used in App Engine, IU_PROCESSOR to store sql statement for rank() function used in IU_PROCESSOR.U300.U300-031 peoplecode. |
| 21 | DUMMY_NUM | Number(6,0) | INTEGER NOT NULL | DUMMY NUM |
| 22 | DUMMY_NUM2 | Number(9,0) | DECIMAL(9) NOT NULL | DUMMY NUM |
| 23 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 24 | LEDGERS_SYNC | Character(1) | VARCHAR2(1) NOT NULL | Keep Ledgers in Sync |
| 25 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
| 26 | RUN_ONLINE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Process run in online mode or not
Y/N Table Edit Default Value: N |