ACCT_ORG_ALL_VW

(SQL View)
Index Back

Account Org View


SELECT a.business_unit ,a.ext_org_id ,a.account_nbr ,a.account_term ,c.descr ,a.account_type_sf ,a.acct_status ,a.open_dt ,a.account_balance FROM PS_ACCOUNT_ORG_SF a ,ps_bus_unit_tbl_sf b ,ps_ext_org_tbl c WHERE a.business_unit=b.business_unit AND a.ext_org_id = c.ext_org_id AND c.effdt = ( SELECT MAX(effdt) FROM ps_ext_org_tbl c1 WHERE c1.ext_org_id = c.ext_org_id AND c1.effdt <= %CurrentDateIn)

  • Related Language Record: ACCTORGALLVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    3 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    4 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type
    7 ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status
    A=Active
    I=Inactive
    8 OPEN_DT Date(10) DATE Created
    9 ACCOUNT_BALANCE Signed Number(18,2) DECIMAL(16,2) NOT NULL Account Balance