FUS_ACCTYPE_VW2

(SQL View)
 Index Back

SELECT 'A' ,'Asset' FROM PS_INSTALLATION UNION SELECT 'E' ,'Expense' FROM PS_INSTALLATION UNION SELECT 'L' ,'Liability' FROM PS_INSTALLATION UNION SELECT 'O' ,'Owners Equity' FROM PS_INSTALLATION UNION SELECT 'R' ,'Revenue' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FUS_ACCT_TYPE Character(254) VARCHAR2(254) NOT NULL Fusion Account Type
2 FUS_ACCT_DESCR Character(30) VARCHAR2(30) NOT NULL Fusion Acct Type Description