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 |