TAG_SEL_FAV_VW

(SQL View)
 Index Back

Accounting Tag view


SELECT DISTINCT A.SETID , A.ACCOUNT_CODE ,B.EFFDT , B.EFF_STATUS , B.DESCR , B.TAG_GROUP , A.BALANCE_PCT ,C.OPRID ,E.OPRID , C.OPRCLASS , A.ACCTG_TAG_TYPE , D.OBJECTOWNERID ,E.COMPONENT_ID FROM PS_ACCTG_TAG_HD A , PS_ACCTG_TAG_TBL B , PS_ACCTG_TAG_PERM C , PS_ACCTG_TAG_PROD D ,PS_ACCTG_TAG_FAV E WHERE A.SETID = B.SETID AND A.SETID = c.setid AND A.SETID = D.SETID AND A.account_code = b.account_code AND a.account_code = c.account_code AND a.account_code = d.account_code AND B.EFFDT = D.EFFDT AND D.CHECKED = 'Y' AND B.SETID = E.SETID AND B.account_code = E.account_code AND B.account_code = E.account_code

# 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 ACCOUNT_CODE Character(20) VARCHAR2(20) NOT NULL Accounting Tag
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 TAG_GROUP Character(15) VARCHAR2(15) NOT NULL Accounting Tag Group
7 BALANCE_PCT Character(1) VARCHAR2(1) NOT NULL Balanced Speedchart
N=No
Y=Yes
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
10 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
11 ACCTG_TAG_TYPE Character(1) VARCHAR2(1) NOT NULL Permission for Accounting Tag
C=Permission List
O=User List
U=All Users
12 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
13 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.