PeopleSoft 9
Asset Management

Table Name ASSET_LOCATION

Table Description
ASSET_LOCATION
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
EFFDT PSDATE Yes No
EFFSEQ smallint Yes No
LOCATION char(10) No Yes
DOCUMENT_ID char(12) No No
AUTH_STATUS char(1) No No
AUTHORIZATION_NAME char(30) No No
AUTHORIZATION_DT PSDATE No No
AREA_ID CHAR(10) No Yes
Index
Name Type Unique Member
PS_ASSET_LOCATION PK Yes
PS0ASSET_LOCATION IE1 No
Member(s) of "PS_ASSET_LOCATION" Index
BUSINESS_UNIT
ASSET_ID
EFFDT
EFFSEQ
Member(s) of "PS0ASSET_LOCATION" Index
LOCATION
BUSINESS_UNIT
ASSET_ID
EFFDT
EFFSEQ

Published December 16, 2006