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