SETIDINV_ITEM_IDLANGUAGE_CDEFFDTN=N
Y=Y
N=N
Y=Y
INV_ITEM_LVW(SQL View) |
Index Back |
|---|---|
Inventory Item Language View |
| SELECT a.setid , a.inv_item_id , c.language_cd , a.effdt , a.haz_class_cd , a.stor_rules_id , c.descr , b.serial_control , b.lot_control , b.ship_serial_cntrl FROM ps_inv_items a , PS_MASTER_ITEM_TBL b , ps_master_itm_lang c WHERE b.setid = a.setid AND b.inv_item_id = a.inv_item_id AND B.SETID = C.SETID AND B.INV_ITEM_ID = C.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | HAZ_CLASS_CD | Character(4) | VARCHAR2(4) NOT NULL | Hazard Code |
| 6 | STOR_RULES_ID | Character(4) | VARCHAR2(4) NOT NULL | Storage Rule ID |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 9 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 10 | SHIP_SERIAL_CNTRL | Character(1) | VARCHAR2(1) NOT NULL | Shipping Serial Control |