PV_CAT_SOURCE

(SQL Table)
 Index Back

Catalog Source

Rule Based Catalog

  • Related Language Record: PV_CAT_SOURC_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CATALOG_TYPE Character(3) VARCHAR2(3) NOT NULL Catalog Type
    2 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    3 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

    Prompt Table: PSRECDEFN_VW3

    4 PV_ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.
    N=No
    Y=Yes