PeopleSoft 9
Asset Management

Table Name ASSET_WARRANTY

Table Description
ASSET_WARRANTY
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
WRTY_SEQ_NUM smallint Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
VENDOR_ID char(10) No No
CNTCT_SEQ_NUM int No No
WARRANTY_NUM char(30) No No
WARRANTY_NAME char(40) No Yes
END_DT PSDATE No No
COVERAGE TEXT No No
Index
Name Type Unique Member
PS_ASSET_WARRANTY PK Yes
Member(s) of "PS_ASSET_WARRANTY" Index
BUSINESS_UNIT
ASSET_ID
WRTY_SEQ_NUM
EFFDT

Published December 16, 2006