ACCT_ORG_WRT_VW

(SQL View)
Index Back

Account Writeoff View

View of Account SF

SELECT a.business_unit ,a.ext_org_id ,a.account_nbr ,a.account_term ,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 WHERE a.business_unit=b.business_unit AND a.account_balance > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_SF_NONVW

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