BUS_UNIT_TBL_PC

(SQL Table)
 Index Back

PC Business Unit Table

PC Business Unit Table

  • Parent Record Of PROJECT PROJECT_LANG TL_PROJ_PC_VW TL_PROJ_PC_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    2 LAST_INTFC_ID Number(8,0) INTEGER NOT NULL Last Interface ID

    Default Value: 10000000

    3 LAST_CONT_NUM_PC Number(8,0) INTEGER NOT NULL Last Contract Number PC
    4 IN_USE_SW Character(1) VARCHAR2(1) NOT NULL Table in use switch

    Default Value: N

    5 CAT_EDIT_OPTION Character(3) VARCHAR2(3) NOT NULL Category Edit Option
    IND=Independent
    OVR=Override
    REL=Related

    Default Value: IND

    6 SUB_EDIT_OPTION Character(3) VARCHAR2(3) NOT NULL SubCategory Edit Option
    IND=Independent
    OVR=Override
    REL=Related

    Default Value: IND

    7 CATEGORY_EDIT Character(15) VARCHAR2(15) NOT NULL Category Edit Table

    Default Value: PROJ_CATG_TBL

    Prompt Table: RECDEFN_VW

    8 SUBCATEGORY_EDIT Character(15) VARCHAR2(15) NOT NULL SubCategory Edit Table

    Default Value: PROJ_SUBCAT_TBL

    Prompt Table: RECDEFN_VW

    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Prompt Table: RT_TYPE_TBL

    11 CUR_EFFDT_TYPE Character(1) VARCHAR2(1) NOT NULL Currency Type Effective Date
    B=Begin Date
    E=End Date
    P=Payment Date
    12 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_DETL_VW

    13 FLEX_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Project Template