PeopleSoft 9
Asset Management

Table Name MASTER_ITEM_TBL

Table Description
MASTER_ITEM_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
INV_ITEM_ID char(18) Yes No
ITM_STATUS_EFFDT PSDATE No No
ITM_STATUS_CURRENT char(1) No No
ITM_STAT_DT_FUTURE PSDATE No No
ITM_STATUS_FUTURE char(1) No No
DESCR char(30) No No
DESCR60 char(60) No No
DESCRSHORT char(10) No No
UNIT_MEASURE_STD char(3) No No
INV_ITEM_GROUP char(15) No No
INV_PROD_FAM_CD char(10) No No
CATEGORY_ID char(5) No No
DATE_ADDED PSDATE No No
ORIG_OPRID char(30) No No
APPROVAL_OPRID char(30) No No
APPROVAL_DATE PSDATE No No
LAST_MAINT_OPRID char(30) No No
LAST_DTTM_UPDATE PSDATETIME No No
CHANGE_FIELD char(18) No No
INVENTORY_ITEM char(1) No No
LOT_CONTROL char(1) No No
SERIAL_CONTROL char(1) No No
SHIP_SERIAL_CNTRL char(1) No No
NON_OWN_FLAG char(1) No No
APPROV_REQUIRED char(1) No No
APPROV_SUBMITTED char(1) No No
DENIAL_REASON char(250) No No
STAGED_DATE_FLAG char(1) No No
DIST_CFG_FLAG char(1) No No
PRDN_CFG_FLAG char(1) No No
CFG_CODE_OPT char(1) No No
CFG_COST_OPT char(1) No No
CFG_LOT_OPT char(1) No No
CP_TEMPLATE_ID char(10) No No
CP_TREE_DIST char(18) No No
CP_TREE_PRDN char(18) No No
CM_GROUP char(15) No No
MATERIAL_RECON_FLG char(1) No No
USG_TRCKNG_METHOD char(2) No No
CONSIGNED_FLAG char(1) No No
PL_PRIO_FAMILY char(10) No No
ITEM_FIELD_C30_A char(30) No No
ITEM_FIELD_C30_B char(30) No No
ITEM_FIELD_C30_C char(30) No No
ITEM_FIELD_C30_D char(30) No No
ITEM_FIELD_C1_A char(1) No No
ITEM_FIELD_C1_B char(1) No No
ITEM_FIELD_C1_C char(1) No No
ITEM_FIELD_C1_D char(1) No No
ITEM_FIELD_C10_A char(10) No No
ITEM_FIELD_C10_B char(10) No No
ITEM_FIELD_C10_C char(10) No No
ITEM_FIELD_C10_D char(10) No No
ITEM_FIELD_C2 char(2) No No
ITEM_FIELD_C4 char(4) No No
ITEM_FIELD_C6 char(6) No No
ITEM_FIELD_C8 char(8) No No
ITEM_FIELD_N12_A decimal(15,3) No No
ITEM_FIELD_N12_B decimal(15,3) No No
ITEM_FIELD_N12_C decimal(15,3) No No
ITEM_FIELD_N12_D decimal(15,3) No No
ITEM_FIELD_N15_A decimal(15) No No
ITEM_FIELD_N15_B decimal(15) No No
ITEM_FIELD_N15_C decimal(15) No No
ITEM_FIELD_N15_D decimal(15) No No
PROMISE_OPTION char(1) No No
DEVICE_TRACKING char(1) No No
SERIAL_IN_PRDN char(1) No No
TRACE_USAGE char(1) No No
TRACE_CHANGE char(1) No No
PHYSICAL_NATURE char(1) No No
Index
Name Type Unique Member
PS_MASTER_ITEM_TBL PK Yes
PS0MASTER_ITEM_TBL IE1 No
PS1MASTER_ITEM_TBL IE2 No
PS2MASTER_ITEM_TBL IE3 No
PS3MASTER_ITEM_TBL IE4 No
Member(s) of "PS_MASTER_ITEM_TBL" Index
SETID
INV_ITEM_ID
Member(s) of "PS0MASTER_ITEM_TBL" Index
DESCR
SETID
INV_ITEM_ID
Member(s) of "PS1MASTER_ITEM_TBL" Index
INV_ITEM_GROUP
SETID
INV_ITEM_ID
Member(s) of "PS2MASTER_ITEM_TBL" Index
INV_PROD_FAM_CD
SETID
INV_ITEM_ID
Member(s) of "PS3MASTER_ITEM_TBL" Index
CATEGORY_ID
SETID
INV_ITEM_ID

Published December 16, 2006