BI_SORT_BY_F_VW

(SQL View)
 Index Back

Billing Fields for Line Order


SELECT A.FIELDNAME , C.LONGNAME FROM PSRECFIELD A , PSDBFIELD B , PSDBFLDLABL C WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDNAME = C.FIELDNAME AND A.RECNAME IN ('BI_LINE', 'PC_CF1_N_SBR') AND A.FIELDNAME NOT LIKE '%_BSE' AND A.FIELDNAME NOT LIKE '%_XEU' AND A.FIELDNAME NOT IN ('INVOICE_LINE', 'TAX_AMT') AND C.DEFAULT_LABEL = 1

  • Related Language Record: BI_SORTBYF_L_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description