PROCESS_INSTANCE0=Successful
1=Complete with errors
2=Not Complete
AM_IU_TEMP(SQL Table) |
Index Back |
|---|---|
IU Temp |
| # | 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 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | IU_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Processing Status
0=Successful 1=Complete with errors 2=Not Complete |
| 11 | 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 |
| 12 | 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. |