PeopleSoft 9
Account Payables

Table Name ASSET

Table Description
ASSET
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
ASSET_ID VARCHAR(12) Yes No
ASSET_TYPE VARCHAR(3) No No
ASSET_SUBTYPE VARCHAR(15) No No
PARENT_ID VARCHAR(12) No No
COMPONENT_OF_ID VARCHAR(12) No No
ASSET_ASSIGNED_TO VARCHAR(12) No No
TAGGABLE_SW VARCHAR(1) No No
TAG_NUMBER VARCHAR(12) No No
DESCR VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
ASSET_STATUS VARCHAR(1) No No
FINANCIAL_ASSET_SW VARCHAR(1) No No
REPLACE_SW VARCHAR(1) No No
REPLACE_ASSET_ID VARCHAR(12) No No
CONVERSION_ID VARCHAR(15) No No
NEW_ASSET_SW VARCHAR(1) No No
AVAIL_SW VARCHAR(1) No No
AVAIL_CONTACT VARCHAR(30) No No
AVAIL_PHONE VARCHAR(12) No No
ACQUISITION_CD VARCHAR(1) No No
ACQUISITION_DT PSDATE No No
FINANCING_CD VARCHAR(5) No No
REPLACEMENT_COST decimal(26,3) No No
REPLACE_COST_DT PSDATE No No
LEASE_ASSET_ID VARCHAR(12) No No
PROFILE_ID VARCHAR(10) No No
ASSET_CLASS VARCHAR(10) No No
CAP_NUM VARCHAR(15) No No
CAP_SEQUENCE SMALLINT No No
MFG_ID VARCHAR(50) No No
MANUFACTURER VARCHAR(30) No No
MODEL VARCHAR(30) No No
PROD_VERSION VARCHAR(10) No No
SERIAL_ID VARCHAR(20) No No
PRODUCTION_DT PSDATE No No
PLANT VARCHAR(30) No No
MANUFACTUR_CONTACT VARCHAR(30) No No
BUSINESS_UNIT_JV VARCHAR(5) No No
INDEX_NAME VARCHAR(20) No No
INDEX_DETAIL_NAME VARCHAR(35) No No
LAST_INDEX_VALUE decimal(26,3) No No
COMPOSITE_SW VARCHAR(1) No No
COMPOSITE_ID VARCHAR(12) No No
FERC_CD VARCHAR(10) No No
GROUP_ASSET_FLAG VARCHAR(1) No No
CURRENCY_CD VARCHAR(3) No No
RD_PLANT_ASSET VARCHAR(1) No No
RD_START_DT PSDATE No No
RD_USE_NBV VARCHAR(1) No No
IP_ADDRESS VARCHAR(15) No No
IP_ALIAS VARCHAR(35) No No
COLLATERAL_ASSET VARCHAR(2) No No
CLUSTERED_ASSET VARCHAR(1) No No
LIFE SMALLINT No No
LAST_REVIEW_DT PSDATE No No
AM_AST_UD_CHAR1 VARCHAR(10) No No
AM_AST_UD_CHAR2 VARCHAR(10) No No
AM_AST_UD_DATE1 PSDATE No No
AM_AST_UD_NUM1 decimal(18,3) No No
AM_AST_UD_NUM2 decimal(18,3) No No
LAST_CALC_RPL_COST decimal(26,3) No No
HAZARDOUS_SW VARCHAR(1) No No
SS_STATUS VARCHAR(1) No No
VIN VARCHAR(18) No No
ASSET_RESOURCE_SW VARCHAR(1) No No
ALLOW_OVERBOOK_SW VARCHAR(1) No No
CHARGE_BACK_SW VARCHAR(1) No No
SCHEDULABLE_SW VARCHAR(1) No No
EPL_TMPL_ID VARCHAR(15) No No
REPAIRABLE_FLG VARCHAR(1) No No
REPAIR_STATUS VARCHAR(1) No No
BUSINESS_UNIT_WO VARCHAR(5) No No
SHOP_ID VARCHAR(10) No No
UNOWNED_FLG VARCHAR(1) No No
WO_LOCATION_FLG VARCHAR(1) No No
OFFLINE_FLG VARCHAR(1) No No
ASSET_CRITICALITY VARCHAR(2) No No
CREW_ID VARCHAR(10) No No
AVAIL_FOR_USE VARCHAR(1) No No
IT_UD_CHAR1 VARCHAR(50) No No
IT_UD_CHAR2 VARCHAR(50) No No
IT_UD_DATE1 datetime No No
IN_SERVICE_DT datetime No No
REGION_CD VARCHAR(10) No No
SKU VARCHAR(50) No No
CRM_IPROD_ID VARCHAR(20) No No
CRM_IPROD_SETID VARCHAR(5) No No
CRM_IPROD_STATUS VARCHAR(3) No No
CRM_DEPT_SETID VARCHAR(5) No No
DESCR_LONG VARCHAR(254) No No
LINEAR_ASSET_SW VARCHAR(1) No No
NBR_OF_CPU SMALLINT No No
Index
Name Type Unique Member
PS_ASSET PK Yes
PSAASSET IE10 No
PSBASSET IE3 No
PSCASSET IE4 No
PSDASSET IE5 No
PS0ASSET IE9 No
Member(s) of "PS_ASSET" Index
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSAASSET" Index
ASSET_ID
Member(s) of "PSBASSET" Index
COMPONENT_OF_ID
Member(s) of "PSCASSET" Index
ASSET_TYPE
SERIAL_ID
ASSET_STATUS
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSDASSET" Index
PARENT_ID
BUSINESS_UNIT
ASSET_ID
Member(s) of "PS0ASSET" Index
TAG_NUMBER
BUSINESS_UNIT
ASSET_ID

Published June 06, 2007