PeopleSoft 9
Account Payables

Table Name PROFILE_TBL

Table Description
PROFILE_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
PROFILE_ID VARCHAR(10) Yes No
DESCR VARCHAR(30) No No
DEFAULT_DESCR VARCHAR(30) No No
FINANCIAL_ASSET_SW VARCHAR(1) No No
TAGGABLE_SW VARCHAR(1) No No
ACQUISITION_CD VARCHAR(1) No No
ASSET_CLASS VARCHAR(10) No No
ASSET_TYPE VARCHAR(3) No No
ASSET_SUBTYPE VARCHAR(15) No No
RD_PLANT_ASSET VARCHAR(1) No No
RD_START_DT PSDATE No No
RD_USE_NBV VARCHAR(1) No No
INDEX_NAME VARCHAR(20) No No
INDEX_DETAIL_NAME VARCHAR(35) No No
ASSET_RESOURCE_SW VARCHAR(1) No No
Index
Name Type Unique Member
PS_PROFILE_TBL PK Yes
Member(s) of "PS_PROFILE_TBL" Index
SETID
PROFILE_ID

Published June 06, 2007