SETIDINV_ITEM_IDEFFDTN=N
Y=Y
N=N
Y=Y
INV_ITEM_VW(SQL View) |
Index Back |
|---|---|
Inventory Item Master View |
| SELECT a.setid , a.inv_item_id , a.effdt , a.haz_class_cd , a.stor_rules_id , a.inv_item_height , a.inv_item_length , a.inv_item_width , b.descr , b.serial_control , b.lot_control , b.ship_serial_cntrl FROM ps_inv_items a , PS_MASTER_ITEM_TBL b WHERE b.setid = a.setid AND b.inv_item_id = a.inv_item_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | HAZ_CLASS_CD | Character(4) | VARCHAR2(4) NOT NULL | Hazard Code |
| 5 | STOR_RULES_ID | Character(4) | VARCHAR2(4) NOT NULL | Storage Rule ID |
| 6 | INV_ITEM_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Height |
| 7 | INV_ITEM_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Length |
| 8 | INV_ITEM_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Width |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 11 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 12 | SHIP_SERIAL_CNTRL | Character(1) | VARCHAR2(1) NOT NULL | Shipping Serial Control |