BI_BILLTO_IU_VW

(SQL View)
 Index Back

Active/Nonprspct Bill To Custs

This view includes Interunit flag and Bill To GL Business Unit.

SELECT C.setid , C.cust_id , D.EFFDT , C.name1 , D.INTERUNIT_FLG , D.BUSINESS_UNIT_GL FROM ps_customer C , PS_CUST_OPTION D WHERE C.cust_status = 'A' AND C.bill_to_flg = 'Y' AND C.cust_level <> 'P' AND C.SETID = D.SETID AND C.CUST_ID = D.CUST_ID

  • Related Language Record: BI_BILTOIUV_LNG

    • # 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 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    3 EFFDT Date(10) DATE Effective Date
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
    N=No
    Y=Yes
    6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit