PI_RESULTS_VW2(SQL View) |
Index Back |
|---|---|
PI Results Table |
| SELECT DISTINCT PI_ID ,ASSET_ID ,MATCH_STATUS ,REVIEW_SW ,PI_ERROR_SW ,PI_ERROR_DEPT_SW ,MESSAGE_SET_NBR ,MESSAGE_NBR ,MESSAGE_NBR02 ,HAND_HELD_OPERATOR ,INV_ASSET_SRC FROM PS_PI_RESULTS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PI_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Physical Inventory ID
Prompt Table: PI_CNTL |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | MATCH_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PI Match Status
0=None 1=Special Depr 2=Accelerated Depr 3=Initial Depr A=All (I,O,U) D=Discard I=Inventory O=Over R=Retire U=Under |
| 4 | REVIEW_SW | Character(1) | VARCHAR2(1) NOT NULL | Manual Review Required |
| 5 | PI_ERROR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Error in Physcial Inventory
Y/N Table Edit |
| 6 | PI_ERROR_DEPT_SW | Character(1) | VARCHAR2(1) NOT NULL |
PI Department Transfer Error
N=No Error In Multi CF Y=Error In Multi CF Y/N Table Edit |
| 7 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 9 | MESSAGE_NBR02 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | HAND_HELD_OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | Scanned By |
| 11 | INV_ASSET_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Asset Source for Inventory
F=Capital - Financial L=Operating Lease N=Non Capital |