ADB_DEFN_TBL

(SQL Table)
 Index Back

ADB Definition

  • Related Language Record: ADB_DEFN_LANG

  • Parent Record Of ADB_FLDS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ADB Character(10) VARCHAR2(10) NOT NULL Average Daily Balances
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: SP_LEDG_D_NONVW

    5 TARGET_LEDGER Character(10) VARCHAR2(10) NOT NULL Target Ledger

    Prompt Table: SP_LEDG_D_NONVW

    6 DATE_CODE Character(1) VARCHAR2(1) NOT NULL This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.

    Default Value: 3

    Prompt Table: DATE_CD_ADB_VW

    7 ADB_PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
    D=Date to Date
    E=Year to Date
    M=Month to Date
    P=Regular Period
    Q=Quarter to Date
    R=Regular Date
    8 RECNAME_ADB_AMT Character(15) VARCHAR2(15) NOT NULL ADB Target Record Name

    Prompt Table: RECDEFN_VW

    9 RECNAME_ADB_WRK Character(15) VARCHAR2(15) NOT NULL Work Record

    Default Value: LED_ADBTG_TAO

    Prompt Table: RECDEFN_VW

    10 FIELDNAME_ADB_AMT Character(18) VARCHAR2(18) NOT NULL Ledger ADB Amount

    Prompt Table: RECFLD_ADBLD_VW

    11 FLDNAME_ADB_TR_AMT Character(18) VARCHAR2(18) NOT NULL Target ADB Amount

    Prompt Table: RECFIELD_ADB_VW

    12 FLDNAME_ADB_TR_EB Character(18) VARCHAR2(18) NOT NULL Target Ending Balance

    Prompt Table: RECFIELD_ADB_VW

    13 FLDNAME_ADB_TR_AG Character(18) VARCHAR2(18) NOT NULL Target Aggregate Amount

    Prompt Table: RECFIELD_ADB_VW

    14 FIELDNAME_ADB_AMT2 Character(18) VARCHAR2(18) NOT NULL Amount Field 2

    Prompt Table: RECFLD_ADBLD_VW

    15 FLDNAME_ADBTR_AMT2 Character(18) VARCHAR2(18) NOT NULL Target ADB Amount Field

    Prompt Table: RECFIELD_ADB_VW

    16 FLDNAME_ADB_TR_EB2 Character(18) VARCHAR2(18) NOT NULL Target End Balance Field

    Prompt Table: RECFIELD_ADB_VW

    17 FLDNAME_ADB_TR_AG2 Character(18) VARCHAR2(18) NOT NULL Target Aggregate Amount Field

    Prompt Table: RECFIELD_ADB_VW

    18 FIELDNAME_ADB_AMT3 Character(18) VARCHAR2(18) NOT NULL Amount Field 3

    Prompt Table: RECFLD_ADBLD_VW

    19 FLDNAME_ADBTR_AMT3 Character(18) VARCHAR2(18) NOT NULL Target ADB Amount Field

    Prompt Table: RECFIELD_ADB_VW

    20 FLDNAME_ADB_TR_EB3 Character(18) VARCHAR2(18) NOT NULL Target End Balance Field

    Prompt Table: RECFIELD_ADB_VW

    21 FLDNAME_ADB_TR_AG3 Character(18) VARCHAR2(18) NOT NULL Target Aggregate Amount Field

    Prompt Table: RECFIELD_ADB_VW

    22 BALANCED_ADB Character(1) VARCHAR2(1) NOT NULL Balanced ADB

    Y/N Table Edit

    Default Value: N

    23 ADJUST_PD_OPTN Character(1) VARCHAR2(1) NOT NULL Adjustment Period Option
    F=As First Day of Report Period
    L=As Last Day of Report Period
    N=No Adjustment Period
    24 DESCRLONG Long Character CLOB Long Description