CNAO_SUBSI_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.CNAO_ACCOUNT , B.SUBSDRY_ITM_ID , B.SUBSDRY_ITM_NM , B.RECNAME , B.DESCR254 FROM PS_CNAO_ACCOUNT A , PS_CNAO_SUBSI_ITM B WHERE ((A.ACCT_CUST_FLAG='Y' AND B.SUBSDRY_ITM_TP='C') OR (A.ACCT_SUPL_FLAG='Y' AND B.SUBSDRY_ITM_TP='S') OR (A.ACCT_DEPT_FLAG='Y' AND B.SUBSDRY_ITM_TP='D') OR (A.ACCT_EMPL_FLAG='Y' AND B.SUBSDRY_ITM_TP='E')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNAO_ACCOUNT | Character(20) | VARCHAR2(20) NOT NULL | CNAO Account |
| 3 | SUBSDRY_ITM_ID | Character(5) | VARCHAR2(5) NOT NULL | Subsidiary Item ID |
| 4 | SUBSDRY_ITM_NM | Character(200) | VARCHAR2(200) NOT NULL | Subsidiary Item Name |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |