BI_DST_IUALL_VW(SQL View) |
Index Back |
---|---|
IU- All Distrib Codes ViewThis view is used in Bill Entry and Interunit Control Panels. In Bill Entry Panels, record level set control field is used. In Interunit Control panels, field level set control field is used on BI_LINE_IU_EXP and BI_LINE_IU_PAY. |
SELECT A.SETID ,A.DST_ID ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT FROM PS_DST_CODE_TBL A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | DST_ID | Character(10) | VARCHAR2(10) NOT NULL | Distribution Code |
3 | EFFDT | Date(10) | DATE | Effective Date |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |