BUSINESS_UNITINTFC_IDINTFC_LINE_NUMPROCESS_INSTANCEASSET_IDBOOKERRNUMINTFC_ERROR(SQL Table) |
Index Back |
|---|---|
INTFC_ERRORCreated to store possible multiple errors for a transaction while running AMIF1000 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INTFC_ID |
Number(8,0) | INTEGER NOT NULL | Interface ID |
| 3 | INTFC_LINE_NUM |
Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 4 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 6 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 7 | ERRNUM |
Number(5,0) | INTEGER NOT NULL | Error Number |
| 8 | INTFC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Trans Load Type |
| 9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |