PeopleSoft 9
Asset Management

Table Name ITM_CAT_TBL

Table Description
ITM_CAT_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
CATEGORY_TYPE char(3) Yes No
CATEGORY_CD char(18) Yes No
CATEGORY_ID char(5) Yes No
EFFDT PSDATE Yes No
DESCR char(30) No No
DESCRSHORT char(10) No No
PROFILE_ID char(10) No No
NBR_OF_ITMS int No No
LEAD_TIME smallint No No
INSPECT_CD char(1) No No
INSPECT_UOM_TYPE char(1) No No
ROUTING_ID char(10) No No
REJECT_DAYS smallint No No
ACCOUNT char(10) No No
ALTACCT char(10) No No
UNIT_PRC_TOL decimal(13,5) No No
PCT_UNIT_PRC_TOL decimal(5,2) No No
RECV_REQ char(1) No No
EXT_PRC_TOL decimal(13,5) No No
PCT_EXT_PRC_TOL decimal(5,2) No No
QTY_RECV_TOL_PCT decimal(5,2) No No
RJCT_OVER_TOL_FLAG char(1) No No
PRIMARY_BUYER char(30) No No
RECV_PARTIAL_FLG char(1) No No
CURRENCY_CD char(3) No No
PCT_UNDER_QTY smallint No No
SRC_METHOD char(1) No No
LEAD_TIME_IMP decimal(5,2) No No
PRICE_IMP decimal(5,2) No No
SHIPTO_PR_IMP decimal(5,2) No No
VNDR_PR_IMP decimal(5,2) No No
HIST_END_DT PSDATE No No
HIST_NBR_MTHS smallint No No
HIST_START_DT PSDATE No No
MERCH_AMT_CAT_TOT decimal(26,3) No No
HIST_START_MTH smallint No No
UNIT_PRC_TOL_L decimal(13,5) No No
PCT_UNIT_PRC_TOL_L decimal(5,2) No No
EXT_PRC_TOL_L decimal(13,5) No No
PCT_EXT_PRC_TOL_L decimal(5,2) No No
SHIP_LATE_DAYS smallint No No
CUM_SRC_RUN_LEVEL char(1) No No
EFF_STATUS char(1) No No
MARKETCODE char(2) No No
PHYSICAL_NATURE char(1) No No
VAT_SVC_PERFRM_FLG char(1) No No
ULTIMATE_USE_CD char(8) No No
WF_PRC_TOL_OVR decimal(13,5) No No
WF_PRC_TOL_UND decimal(13,5) No No
WF_PCT_PRC_TOL_OVR decimal(5,2) No No
WF_PCT_PRC_TOL_UND decimal(5,2) No No
RFQ_REQ_FLAG char(1) No No
COMMENTS_LONG TEXT No No
Index
Name Type Unique Member
PS_ITM_CAT_TBL PK Yes
PS0ITM_CAT_TBL IE1 No
PS1ITM_CAT_TBL IE2 No
PSAITM_CAT_TBL IE3 No
Member(s) of "PS_ITM_CAT_TBL" Index
SETID
CATEGORY_TYPE
CATEGORY_CD
CATEGORY_ID
EFFDT
Member(s) of "PS0ITM_CAT_TBL" Index
DESCR
SETID
CATEGORY_TYPE
CATEGORY_CD
CATEGORY_ID
EFFDT
Member(s) of "PS1ITM_CAT_TBL" Index
PRIMARY_BUYER
SETID
CATEGORY_TYPE
CATEGORY_CD
CATEGORY_ID
EFFDT
Member(s) of "PSAITM_CAT_TBL" Index
SETID
CATEGORY_TYPE
CATEGORY_ID
EFFDT

Published December 16, 2006