SETIDINV_ITEM_IDB=Both
N=No
Y=Yes
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization
1=Active
2=Hold
3=Discontinue
4=Inactive
N=N
Y=Y
2=Perform ATP Reservations
N=N
Y=Y
N=No
Y=Yes
N=No
Y=Yes
ORD_INVMAST_VW(SQL View) |
Index Back |
|---|---|
Inventory Master ViewInventory Master View |
| SELECT I.SETID , I.INV_ITEM_ID , M.CFG_CODE_OPT , M.CFG_COST_OPT , M.CP_TEMPLATE_ID , M.CP_TREE_DIST , M.DIST_CFG_FLAG , M.DESCR , M.ITM_STATUS_CURRENT , M.ITM_STATUS_FUTURE , M.ITM_STAT_DT_FUTURE , M.LOT_CONTROL , M.PRDN_CFG_FLAG , M.PROMISE_OPTION , M.SERIAL_CONTROL , M.UNIT_MEASURE_STD , M.NON_OWN_FLAG , M.INV_ITEM_GROUP , M.INVENTORY_ITEM , I.COMMODITY_CD FROM PS_INV_ITEMS I , PS_MASTER_ITEM_TBL M WHERE I.SETID = M.SETID AND I.INV_ITEM_ID = M.INV_ITEM_ID AND %EffdtCheck(INV_ITEMS Y, I, %CurrentDateIn) |
| # | 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 | CFG_CODE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both N=No Y=Yes |
| 4 | CFG_COST_OPT | Character(1) | VARCHAR2(1) NOT NULL | Configuration Costing |
| 5 | CP_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID Field |
| 6 | CP_TREE_DIST | Character(18) | VARCHAR2(18) NOT NULL | Distribution Model Field |
| 7 | DIST_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Distribution Configuration |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | 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 |
| 10 | ITM_STATUS_FUTURE | Character(1) | VARCHAR2(1) NOT NULL |
Item Status Future
1=Active 2=Hold 3=Discontinue 4=Inactive |
| 11 | ITM_STAT_DT_FUTURE | Date(10) | DATE | Item Date Future |
| 12 | LOT_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Lot Control
N=N Y=Y |
| 13 | PRDN_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Production Configuration |
| 14 | PROMISE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Order Promise Option
2=Perform ATP Reservations |
| 15 | SERIAL_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Serial Control
N=N Y=Y |
| 16 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 17 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes |
| 18 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 19 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 20 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |