BI_BECFG_LINE

(SQL Table)
 Index Back

Bill Entry Line Template

Bill Entry Header Configuration Template

  • Related Language Record: BI_BECFG_LIN_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BILL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Bill entry template ID

    Default Value: BI_BECFG_HDR.BILL_TEMPLATE_ID

    2 TAB_NBR Number(3,0) SMALLINT NOT NULL Tab Number
    3 BI_TAB_FLD Character(30) VARCHAR2(30) NOT NULL Tab Name
    4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    5 BI_HIDE_FIELD_FLG Character(1) VARCHAR2(1) NOT NULL Field hide/unhide flag

    Y/N Table Edit

    6 BI_HIDE_TAB_FLG Character(1) VARCHAR2(1) NOT NULL Tab field hide/unhide flag

    Y/N Table Edit

    7 BI_FIELD_TYPE Character(2) VARCHAR2(2) NOT NULL Field type
    00=Folder Tab
    01=Edit Box
    02=Radio Button
    03=Push Button
    04=Hyperlink
    05=Check Box
    06=Drop Down List Box
    07=Image
    8 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
    B=Both
    N=No
    Y=Yes
    9 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    11 BI_ELEMENT_LABEL Character(80) VARCHAR2(80) NOT NULL Page element label.