BUSINESS_UNIT_GLDST_CNTRL_IDEX_DST_CNT_VW(SQL View) |
Index Back |
|---|---|
Distribution Accounts ViewDistribution Accounts View |
| SELECT A.BUSINESS_UNIT_GL , D.DST_CNTRL_ID FROM PS_BUS_UNIT_TBL_EX A , PS_DST_CNTRL_TBL D , PS_SET_CNTRL_REC E WHERE E.SETID = D.SETID AND E.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND E.RECNAME = 'DST_CNTRL_TBL' AND D.EFF_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(G.EFFDT) FROM PS_DST_CNTRL_TBL G WHERE G.SETID = D.SETID AND G.DST_CNTRL_ID = D.DST_CNTRL_ID AND G.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | DST_CNTRL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |