SP Installed Item Information
Field Name |
Format |
Source/Value/Description |
SP_ID |
A10 |
CI_FA |
SP_ITEM_HIST_ID |
A10 |
CI_SP_ITEM_HIST |
ITEM_ID |
A10 |
CI_SP_ITEM_HIST |
INSTALL_DTTM |
Date |
CI_SP_ITEM_EVT.EVENT_DTTM |
BADGE_NBR |
A30 |
CI_ITEM |
ITEM_TYPE_CD |
A8 |
CI_ITEM |
ITEM_STATUS_FLG |
A2 |
CI_ITEM |
MFG_CD |
A8 |
CI_ITEM |
MODEL_CD |
A8 |
CI_ITEM |
SERIAL_NBR |
A16 |
CI_ITEM |
RECEIVE_DT |
Date |
CI_ITEM |
ITEM_DESCR |
A254 |
CI_ITEM.DESCR254 |
ITEM_TYPE_DESCR |
A60 |
CI_ITEM_TYPE_L.DESCR |
MFG_DESCR |
A60 |
CI_MFG_L.DESCR |
MODEL_DESCR |
A60 |
CI_MODEL_L.DESCR |