SAC_RECFIELD_VW

(SQL View)
 Index Back

Record Field View


SELECT recname ,fieldname FROM PSRECFIELDALL

  • Parent record: PSRECDEFN_VW

    • # 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD_VW