FO_BILL_BY_F_VW

(SQL View)
 Index Back

Bill By Field View


SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B WHERE A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND A.RECNAME = 'INTFC_BI' AND A.FIELDNAME IN ( SELECT C.FIELDNAME FROM PSRECFIELD C WHERE C.RECNAME = 'BI_HDR') AND A.FIELDNAME NOT IN ('PC_DISTRIB_STATUS', 'ACCRUE_UNBILLED', 'ADD_DTTM', 'AR_DST_OPT', 'AR_LVL', 'BASE_CURRENCY', 'BILL_TO_COPIES', 'BILL_TO_CUST_ID', 'BILL_TYPE_ID', 'BI_CURRENCY_CD', 'BUSINESS_UNIT', 'BUSINESS_UNIT_TO', 'DST_ID_DFR', 'ENABLE_DFR_REV_FLG', 'ERROR_STATUS_BI', 'GL_LVL', 'HDR_FIELDS_KEY', 'INVOICE', 'LAST_NOTE_SEQ_NUM', 'LAST_UPDATE_DTTM', 'NAME1', 'PROCESS_INSTANCE', 'USER_AMT1', 'USER_AMT2')

  • Related Language Record: BI_BILLBYF_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