AV_BUS_UNIT_TBL

(SQL Table)
 Index Back

AV Business Unit Table

This is the layout for the table which contains Business Unit information for Advancement.

  • Related Language Record: AVBUSUNITTBLLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: AV_BUS_UNIT_TBL.DESCR

    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    5 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency

    Default Value: AV_INSTALL_INST.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    6 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Default Value: AV_INSTALL_INST.CUR_RT_TYPE

    Prompt Table: RT_TYPE_TBL

    7 TENDER_TYPE Character(6) VARCHAR2(6) NOT NULL Tender Type

    Prompt Table: AV_TENDER_TBL

    8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

    Prompt Table: BUS_UNIT_TBL_GL

    9 MERCHANT_ID Character(12) VARCHAR2(12) NOT NULL Merchant ID

    Prompt Table: AV_NH_MERCH_VW

    10 AV_MERCHANT_ID_HP Character(12) VARCHAR2(12) NOT NULL CR Hosted Merchant ID

    Prompt Table: AV_HST_MERCH_VW