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 |