SETIDDROP_ACCT_TYPEITEM_TYPELANGUAGE_CDDROPITEMVWLNG(SQL View) |
Index Back |
|---|---|
Charge Item Type View |
| SELECT a.setid , b.account_type_sf , a.item_type ,a.language_cd , a.descr FROM ps_ITEM_TYPE_LNG a ,PS_ITEM_TYPE_TBL Y , ps_item_acct_type b WHERE a.setid=b.setid AND a.item_type=b.item_type AND a.effdt=b.effdt AND a.effdt=( SELECT MAX(c.effdt) FROM ps_ITEM_TYPE_LNG c WHERE a.setid=c.setid AND a.item_type=c.item_type AND c.effdt <= %CurrentDateIn AND Y.eff_status='A' AND c.SETID=Y.SETID AND c.ITEM_TYPE=Y.ITEM_TYPE AND c.EFFDT=Y.EFFDT) AND Y.item_type_cd = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DROP_ACCT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Drop Account Type |
| 3 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |