PeopleSoft 9
Asset Management

Table Name ASSET_LICENSE

Table Description
ASSET_LICENSE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
SUPPORT_DOC_TYPE char(1) Yes No
AGENCY_ID char(20) Yes Yes
VENDOR_ID char(10) Yes No
REGISTRATION_NO char(25) No No
INSPECTION_SW char(1) No No
LIC_START_DT PSDATE No No
LIC_END_DT PSDATE No No
REGISTER_NAME char(30) No No
COUNTRY char(3) No No
ADDRESS1 char(55) No No
ADDRESS2 char(55) No No
ADDRESS3 char(55) No No
ADDRESS4 char(55) No No
CITY char(30) No No
NUM1 char(6) No No
NUM2 char(4) No No
HOUSE_TYPE char(2) No No
ADDR_FIELD1 char(2) No No
ADDR_FIELD2 char(4) No No
ADDR_FIELD3 char(4) No No
COUNTY char(30) No No
STATE char(6) No No
POSTAL char(12) No No
GEO_CODE char(11) No No
IN_CITY_LIMIT char(1) No No
JURISDICTION char(5) No No
RENEWAL_DT PSDATE No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_ASSET_LICENSE PK Yes
Member(s) of "PS_ASSET_LICENSE" Index
BUSINESS_UNIT
ASSET_ID
SUPPORT_DOC_TYPE
AGENCY_ID
VENDOR_ID

Published December 16, 2006