FS_BP_ATAO_AET

(SQL Table)
 Index Back

BP - Translate CF's State Rec

The following state record is used in the FS Budget Processor (FS_BP). This state record contains the state record work fields for the ChartField translation sub-program.

  • Parent record: BU_LED_GRP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    4 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
    0=Budget
    1=Actuals and Recognized
    2=Encumbrance
    3=Pre-Encumbrance
    4=Collected Revenue
    5=Planned
    7=Actuals, Recognize and Collect
    9=Dynamic
    5 KK_AMOUNT_TYPE2 Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
    6 AFFECT_SPEND_OPTN Character(1) VARCHAR2(1) NOT NULL Affect Spending Authority
    7 CALENDAR_BP Character(2) VARCHAR2(2) NOT NULL Budget Period Calendar ID
    8 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
    9 KK_ENABLE_CUM Character(1) VARCHAR2(1) NOT NULL Enable Cumulative Budgeting

    Y/N Table Edit

    Default Value: N

    10 KK_DERIVE_DATES Character(1) VARCHAR2(1) NOT NULL Derive Cumulative Date Range
    0=Derive Yes
    1=Derive No
    2=Default

    Default Value: 1

    11 KK_CUM_CAL_ID Character(2) VARCHAR2(2) NOT NULL Cumulative Calendar

    Prompt Table: CAL_BP_VW
    Set Control Field: SETID1

    12 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    13 SQLROWS_ATAO Number(12,0) DECIMAL(12) NOT NULL Total Rows