PV_PURCH_ITM_VW(SQL View) |
Index Back |
---|---|
Purchasing Kit TablePurchasing Kit Table |
SELECT A.SETID , A.KIT_ITEM , A.EFFDT , A.CHILD_ITM , A.KIT_QTY , A.ACCOUNT , A.ALTACCT , B.SUBITEM_FLAG , B.DESCR , M.UNIT_MEASURE_STD ,B.DESCR254_MIXED FROM PS_PURCH_KIT_TBL A , PS_PURCH_ITEM_ATTR B , PS_MASTER_ITEM_TBL M WHERE A.SETID = B.SETID AND A.CHILD_ITM = B.INV_ITEM_ID AND A.SETID = M.SETID AND A.CHILD_ITM= M.INV_ITEM_ID AND B.SUBITEM_ONLY <> 'Y' |
# | 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: SETID_TBL |
2 | KIT_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Purchasing Kit ID |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | CHILD_ITM | Character(18) | VARCHAR2(18) NOT NULL |
Component Item
Prompt Table: ITM_PURCH_VW |
5 | KIT_QTY | Number(3,0) | SMALLINT NOT NULL |
Quantity
Default Value: 1 |
6 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: %EDIT_ACCOUNT |
7 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table: %EDIT_ALTACCT |
8 | SUBITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Substitute item Flag
0=No possible substitute 1=Item Sub. at SETID level 2=Item Sub. at Supp level A=Auto Substitution B=Manul and Auto Substitution M=Manual Substitution N=Do Not Use |
9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
10 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
11 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |