APS_ITEM_BU_VW(SQL View) |
Index Back |
|---|---|
APS Integ Item Branch View |
| SELECT I.INV_ITEM_ID , I.BUSINESS_UNIT , I.SOURCE_CODE , I.SHELF_LIFE , A.MFG_LEAD_TIME_FLAG , I.MFG_LEADTIME_F , I.MFG_LTRATEF , I.REF_ROUTING_ITEM , I.MG_PRDN_OPTION , I.BOM_CODE , I.RTG_CODE , I.AOQ , A.DEMAND_FENCE_OF , I.SAFETY_STOCK , I.QTY_MAXIMUM , I.REPLENISH_LEAD , I.QTY_AVAILABLE , I.QTY_RESERVED , S.SETID , M.UNIT_MEASURE_STD , A.PUR_ORDER_MULTIPLE , I.PHANTOM_ITEM_FLAG , A.PLANNED_BY FROM PS_BU_ITEMS_INV I , PS_PL_ITEM_ATTRIB A , PS_SET_CNTRL_REC S , PS_MASTER_ITEM_TBL M WHERE I.INV_ITEM_ID = A.INV_ITEM_ID AND I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.ITM_STATUS_CURRENT = '1' AND A.PLANNED_BY IN ('1', '2', '3') AND S.SETCNTRLVALUE = I.BUSINESS_UNIT AND S.RECNAME = 'MASTER_ITEM_TBL' AND I.INV_ITEM_ID = M.INV_ITEM_ID AND M.SETID = S.SETID AND M.CFG_CODE_OPT = 'N' AND M.INVENTORY_ITEM = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SOURCE_CODE | Character(2) | VARCHAR2(2) NOT NULL |
8/5/97 lee - inactivated source code 4 - service
1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning |
| 4 | SHELF_LIFE | Number(4,0) | SMALLINT NOT NULL | Shelf Life (Days) |
| 5 | MFG_LEAD_TIME_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
08/04/99 MACN (CN#MG800-4.0) Converted from Y/N field to translate field.
N=Based on Routings Y=Based on Lead Times |
| 6 | MFG_LEADTIME_F | Number(3,0) | SMALLINT NOT NULL | 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. |
| 7 | MFG_LTRATEF | Character(2) | VARCHAR2(2) NOT NULL |
mfg fixed lead time rate
DY=Days HR=Hours MN=Minutes SC=Seconds |
| 8 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
| 9 | MG_PRDN_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
09/23/98 SCC CN#EN800-4.0: New field
01=Use BOM/Routing Defaults 02=Use Prdn Option Maintenance |
| 10 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 11 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 12 | AOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Average Order Qty |
| 13 | DEMAND_FENCE_OF | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Demand Time Fence [days] |
| 14 | SAFETY_STOCK | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Safety Stock |
| 15 | QTY_MAXIMUM | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Maximum Qty |
| 16 | REPLENISH_LEAD | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Replenish Lead (Days) |
| 17 | QTY_AVAILABLE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Available |
| 18 | QTY_RESERVED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Reserved |
| 19 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 20 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 21 | PUR_ORDER_MULTIPLE | Number(12,4) | DECIMAL(11,4) NOT NULL | jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 |
| 22 | PHANTOM_ITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Phantom Item |
| 23 | PLANNED_BY | Character(1) | VARCHAR2(1) NOT NULL |
Planned By
1=Distribution Planning 2=Master Planning 3=Material Planning 4=Not Planned Default Value: 3 |