T4_TAXFRM_L_VW(SQL View) |
Index Back |
---|---|
Rel. Lang. for T4_TAXFORM_VW |
SELECT A.BOX , C.LANGUAGE_CD , C.DESCR FROM PS_TAXFORM_BOX A , PS_TAXFORM_BX_LANG C WHERE A.TAXFORM_ID = 'T' AND A.TAXFORM_ID = C.TAXFORM_ID AND A.EFFDT = C.EFFDT AND A.BOX = C.BOX AND A.BOX <> '29' AND A.BOX <> '39A' AND A.BOX <> '41A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_TAXFORM_BOX B WHERE A.TAXFORM_ID = B.TAXFORM_ID) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BOX | Character(4) | VARCHAR2(4) NOT NULL | Box |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |