PI_IDPI_LINE_NUMASSET_ID0=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
Y/N Table Edit
PI_RESULTS_TMP(SQL Table) |
Index Back |
|---|---|
PI Results Temp Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PI_ID |
Character(10) | VARCHAR2(10) NOT NULL | Physical Inventory ID |
| 2 | PI_LINE_NUM |
Number(8,0) | INTEGER NOT NULL | PI Line Number |
| 3 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 4 | 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 |
| 5 | REVIEW_SW | Character(1) | VARCHAR2(1) NOT NULL | Manual Review Required |
| 6 | PI_ERROR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Error in Physcial Inventory
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 | HAND_HELD_OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | Scanned By |