TAG_SRCH_VW

(SQL View)
 Index Back

Accounting Tag search

Accounting Tag search record

SELECT A.SETID , A.ACCOUNT_CODE , B.DESCR , B.TAG_GROUP , A.BALANCE_PCT , B.DST_USE , A.ACCTG_LINE_TYPE FROM PS_ACCTG_TAG_HD A , PS_ACCTG_TAG_TBL B WHERE A.SETID = B.SETID AND A.ACCOUNT_CODE = B.ACCOUNT_CODE AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_ACCTG_TAG_TBL C WHERE B.SETID = C.SETID AND B.ACCOUNT_CODE = C.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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 TAG_GROUP Character(15) VARCHAR2(15) NOT NULL Accounting Tag Group
5 BALANCE_PCT Character(1) VARCHAR2(1) NOT NULL Balanced Speedchart
N=No
Y=Yes

Y/N Table Edit

Default Value: N

6 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
7 ACCTG_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Accounting Line Type
M=Multiple Line
S=Single Line

Default Value: M