WM_AUDIT_CNTRL

(SQL Table)
 Index Back

Audit Control setup table

  • Parent record: BUS_UNIT_TBL_WR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 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
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    5 INCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL include flag

    Y/N Table Edit