SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
INV_ITEM_IDN=No
Y=Yes
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization
BI_MSTR_ITEM_VW(SQL View) |
Index Back |
|---|---|
Inventory Item View |
| SELECT A.SETID , A.INV_ITEM_ID , A.INVENTORY_ITEM , A.DESCR , A.UNIT_MEASURE_STD , A.ITM_STATUS_CURRENT , B.XLATLONGNAME FROM PS_MASTER_ITEM_TBL A , PSXLATITEM B WHERE B.FIELDNAME = 'ITM_STATUS_CURRENT' AND B.FIELDVALUE = A.ITM_STATUS_CURRENT AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM, B, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 6 | ITM_STATUS_CURRENT | Character(1) | VARCHAR2(1) NOT NULL |
Item Status Current
1=Active 2=Hold 3=Discontinue 4=Inactive 5=Pending Approval 6=Denied Approval 7=Under Initialization |
| 7 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |