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 |