BETC_CDIPAC_RBETC_VW(SQL View) |
Index Back |
|---|---|
Define BETC |
| SELECT A.BETC_CD ,A.DESCR50 ,A.AGENCY_ID1 ,B.DESCR ,A.MAIN_ACCOUNT ,C.DESCR FROM PS_BETC_DEFN_TBL A ,PS_TAS_AGENCY B ,PS_TAS_MAIN_ACCT C WHERE PYMNT_OR_CLLCTN = 'C' AND ACTIVE_INACTIVE = 'A' AND A.AGENCY_ID1 = B.AGENCY_ID1 AND A.MAIN_ACCOUNT = C.MAIN_ACCOUNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BETC_CD |
Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | AGENCY_ID1 | Character(3) | VARCHAR2(3) NOT NULL | TAS agency id |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | MAIN_ACCOUNT | Character(4) | VARCHAR2(4) NOT NULL | Main Account TAS |
| 6 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Main Account Description |