PV_VER_IDX_FLDS(SQL Table) |
Index Back |
|---|---|
Online Update Fields8/30/07 - JK - Added Record Description. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RECORDNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC |
| 2 | FIELD_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 3 | PV_USED_IN |
Character(1) | VARCHAR2(1) NOT NULL |
Used in Component
A=Approval C=Item Copy I=Item Defn P=Purchasing |
| 4 | LEVELNUM | Number(5,0) | INTEGER NOT NULL | Level Number |
| 5 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Level 1 Record |
| 6 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Level 2 Record |
| 7 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |