PeopleSoft 9 Asset Management |
Table Name | RETURN_INFO_TBL |
Table Description |
RETURN_INFO_TBL |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | char(5) | Yes | No |
LTAX_OFFICE_CODE | char(5) | Yes | No |
EFFDT | PSDATE | Yes | No |
EFF_STATUS | char(1) | No | No |
OWNER_ID | char(5) | No | Yes |
OWNER_CODE | char(20) | No | No |
RECIPIENT_NAME | char(20) | No | No |
BUSINESS_CATEGORY | char(20) | No | No |
CAPITAL_OF_AMOUNT | smallint | No | No |
YEAROFDATE | smallint | No | No |
MONTHOFYEAR | smallint | No | No |
REPLY_PERSON | char(20) | No | No |
PHONE2 | char(24) | No | No |
LICENSED_TAX_ACTNT | char(20) | No | No |
PHONE3 | char(24) | No | No |
LIFE_REDUCTION | char(1) | No | No |
INCR_DEPR_NOTICE | char(1) | No | No |
TAX_FREE_ASSET | char(1) | No | No |
TAX_EXCEPTION | char(1) | No | No |
SPECIAL_ADV_DEPR | char(1) | No | No |
TAX_ACCOUNT_DEPR | char(1) | No | No |
BLUE_RETURNS | char(1) | No | No |
ADDRESS1 | char(55) | No | No |
ADDRESS2 | char(55) | No | No |
ADDRESS3 | char(55) | No | No |
RENTAL_ASSET | char(1) | No | No |
LESSOR_NAME | char(30) | No | No |
PHONE4 | char(24) | No | No |
BUILDING_CATEGORY | char(1) | No | No |
DESCR_LN1 | char(50) | No | No |
DESCR_LN2 | char(50) | No | No |
DESCR_LN3 | char(50) | No | No |
DESCR_LN4 | char(50) | No | No |
DESCR_LN5 | char(50) | No | No |
DESCR_LN6 | char(50) | No | No |
Index |
Name | Type | Unique | Member |
PS_RETURN_INFO_TBL | PK | Yes |
![]() |
PS0RETURN_INFO_TBL | IE1 | No |
![]() |
Member(s) of "PS_RETURN_INFO_TBL" Index |
SETID |
LTAX_OFFICE_CODE |
EFFDT |
Member(s) of "PS0RETURN_INFO_TBL" Index |
RECIPIENT_NAME |
SETID |
LTAX_OFFICE_CODE |
EFFDT |
Published December 16, 2006 |