BUSINESS_UNIT_GLLEDGERDISTRIBUTION_TYPEIMPAIR_FLGACCOUNTALTACCTCNAO_BSINFO_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.BUSINESS_UNIT_GL , B.LEDGER , D.DISTRIBUTION_TYPE , (CASE WHEN D.DISTRIBUTION_TYPE='FA' AND B.IMPAIR_FLG='Y' AND D.COST_TYPE=B.IMP_COST_TYPE THEN 'Y' ELSE 'N' END) ,D.ACCOUNT , D.ALTACCT , A.SETID , A.CHARTFIELD FROM PS_BU_BOOK_TBL B , PS_SET_CNTRL_REC S , PS_CNAO_GL_RULE A , PS_SET_CNTRL_REC S1 , PS_DIST_TMPLLN_TBL D WHERE B.DISTRIBUTION_SW='Y' AND S.SETCNTRLVALUE=B.BUSINESS_UNIT_GL AND S.RECNAME='CNAO_GL_RULE' AND S.SETID=A.SETID AND S1.SETCNTRLVALUE=B.BUSINESS_UNIT AND S1.RECNAME='DIST_TMPL_TBL' AND S1.SETID= D.SETID AND D.ACCT_ENT_TMPL_ID=B.ACCT_ENT_TMPL_ID AND D.DISTRIBUTION_TYPE IN ('AD','FA') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 3 | DISTRIBUTION_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Distribution Type |
| 4 | IMPAIR_FLG |
Character(1) | VARCHAR2(1) NOT NULL | Impairment Process |
| 5 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 6 | ALTACCT |
Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |