BI_IVC_LAYO_VW

(SQL View)
 Index Back

Billing Invoice Layout


SELECT B.SETID , A.SETCNTRLVALUE , B.INVOICE_FORM_ID , B.STATUS , B.DESCR , B.DESCRSHORT , B.LOCATION , B.INCLUDE_AA_TOTAL , B.AA_DETAIL , B.OPRID , B.DTTM_STAMP , B.TERM_SUMMARY , B.TRANS_SORT_1 , B.TRANS_SORT_2 , B.TRANS_SORT_3 , B.TRANS_SORT_4 , B.SUB_TOTAL_BY_1 , B.SUMM_FIELD_1 , B.SUMM_FIELD_2 , B.BILL_SORT_1 , B.BILL_SORT_2 , B.BILL_SORT_3 , B.BILL_SORT_4 , B.REPORT_DEFN_ID , B.TMPLDEFN_ID , B.SSF_EXTR_BNK_INFO , B.SSF_TPC_STDCHG_DEF FROM PS_SET_CNTRL_REC A , PS_BI_IVC_LAYOUT B WHERE A.SETID = B.SETID AND A.RECNAME = 'BI_IVC_LAYOUT'

  • Related Language Record: BI_IVCL_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    3 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Layout ID
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    8 INCLUDE_AA_TOTAL Character(1) VARCHAR2(1) NOT NULL Include Anticipated Aid Total

    Y/N Table Edit

    Default Value: N

    9 AA_DETAIL Character(1) VARCHAR2(1) NOT NULL Anticipated Aid Detail

    Y/N Table Edit

    Default Value: N

    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    11 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 TERM_SUMMARY Character(1) VARCHAR2(1) NOT NULL Term Summary
    A=All Terms
    B=Current and Future Terms
    C=Current Term Only
    F=Future Only

    Default Value: A

    13 TRANS_SORT_1 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 1
    A=Due Date
    B=Item Number All
    C=Item Description
    E=Transaction Date
    G=Amount
    J=Account Number
    K=Term
    L=Session
    M=Academic Year
    P=Student ID (Third Party)
    Q=Student Name (Third Party)
    14 TRANS_SORT_2 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 2

    Prompt Table: BI_SORT_TRAN_VW

    15 TRANS_SORT_3 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 3

    Prompt Table: BI_SORT_TRAN_VW

    16 TRANS_SORT_4 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 4

    Prompt Table: BI_SORT_TRAN_VW

    17 SUB_TOTAL_BY_1 Character(1) VARCHAR2(1) NOT NULL Subtotal By

    Y/N Table Edit

    Default Value: N

    18 SUMM_FIELD_1 Character(1) VARCHAR2(1) NOT NULL Summarization Field 1
    A=Item Number All
    B=Item Description
    C=Item Type
    D=Account Number
    E=Item Nbr - Refund/Payment Only
    F=Item Type Code
    G=Student ID (Third Party)
    H=Student Name (Third Party)
    19 SUMM_FIELD_2 Character(1) VARCHAR2(1) NOT NULL Summarization Field 2

    Prompt Table: BI_SUMM_FLD_VW

    20 BILL_SORT_1 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 1
    A=Name
    B=Zip Code
    C=Total Amount Due
    D=Academic Program
    E=Academic Level
    F=Invoice Number
    G=Campus
    H=Tuition Residency
    I=Academic Load
    J=Student ID
    K=Country
    L=Corporation ID
    M=Student Enrollment Block
    N=Career

    Default Value: A

    21 BILL_SORT_2 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 2

    Prompt Table: BI_SORT_IVC_VW

    22 BILL_SORT_3 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 3

    Prompt Table: BI_SORT_IVC_VW

    23 BILL_SORT_4 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 4

    Prompt Table: BI_SORT_IVC_VW

    24 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

    Prompt Table: PSXPRPTDEFN

    25 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

    Prompt Table: PSXPRPTTMPL_VW

    26 SSF_EXTR_BNK_INFO Character(1) VARCHAR2(1) NOT NULL Extract Bank Information
    27 SSF_TPC_STDCHG_DEF Character(1) VARCHAR2(1) NOT NULL Use Cross Ref Student Charge