BI_ACCUM_TYPE

(SQL Table)
 Index Back

Cumulative Bill Bal Type Tbl

  • Parent record: BI_ACCUM_KEY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BAL_ACCUM_ID Character(10) VARCHAR2(10) NOT NULL Balance Accumulation ID

    Prompt Table: BI_ACCUM_ID

    2 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

    Default Value: OPR_DEF_TBL_BI.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    3 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

    Default Value: OPR_DEF_TBL_BI.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    4 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency

    Prompt Table: BI_EURO_CURR_VW

    5 ACCUM_KEY1_VAL Character(30) VARCHAR2(30) NOT NULL Accumulation Key 1 Value
    6 ACCUM_KEY2_VAL Character(30) VARCHAR2(30) NOT NULL Accumulation Key 2 Value
    7 ACCUM_KEY3_VAL Character(30) VARCHAR2(30) NOT NULL Accumulation Key 3 Value
    8 ACCUM_KEY4_VAL Character(30) VARCHAR2(30) NOT NULL Accumulation Key 4 Value
    9 ACCUM_KEY5_VAL Character(30) VARCHAR2(30) NOT NULL Accumulation Key 5 Value
    10 BALANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Balance Type
    B=Beginning Cumulative Balance
    C=Cumulative Balance Ceiling
    I=Invoiced Cumulative Balance
    N=Uninvoiced Cumulative Balance
    T=Total Cumulative Balance

    Default Value: B