eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_IM_KRS dependencies on CZ_IMP_PROPERTY

Line 366: WHERE run_id=inRUN_ID AND EXISTS(SELECT NULL FROM cz_imp_property

362:
363: -- invalid fsk_localizedtext_3_1
364: CURSOR C5(x_usesurr_itempropertyvalue PLS_INTEGER) IS
365: SELECT orig_sys_ref FROM cz_imp_item_property_value a
366: WHERE run_id=inRUN_ID AND EXISTS(SELECT NULL FROM cz_imp_property
367: WHERE run_id=inRUN_ID AND property_id=a.property_id AND
368: data_type=8 AND deleted_flag='0')
369: AND NOT EXISTS (SELECT NULL FROM cz_imp_localized_texts
370: WHERE run_id=inRUN_ID AND orig_sys_ref = DECODE(x_usesurr_itempropertyvalue,0,a.FSK_LOCALIZEDTEXT_3_1,a.FSK_LOCALIZEDTEXT_3_EXT)

Line 421: AND EXISTS(SELECT NULL FROM cz_imp_property

417: disposition='M',
418: rec_status='PASS'
419: WHERE run_id=inRUN_ID
420: AND orig_sys_ref=iOrigSysRef(i)
421: AND EXISTS(SELECT NULL FROM cz_imp_property
422: WHERE run_id=inRUN_ID AND property_id=iPropertyId(i) AND
423: data_type=8 AND deleted_flag='0')
424: AND EXISTS (SELECT NULL FROM cz_imp_localized_texts
425: WHERE run_id=inRUN_ID AND orig_sys_ref = a.FSK_LOCALIZEDTEXT_3_1

Line 987: SELECT ORIG_SYS_REF,PROPERTY_ID,PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,DELETED_FLAG,DEF_NUM_VALUE,ROWID FROM CZ_IMP_PROPERTY

983: ) IS
984: BEGIN
985: DECLARE
986: CURSOR c_imp_property IS
987: SELECT ORIG_SYS_REF,PROPERTY_ID,PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,DELETED_FLAG,DEF_NUM_VALUE,ROWID FROM CZ_IMP_PROPERTY
988:
989: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
990: ORDER BY 1,ROWID;
991: /* cursor's data found indicator*/

Line 992: sImpName CZ_IMP_PROPERTY.NAME%TYPE;

988:
989: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
990: ORDER BY 1,ROWID;
991: /* cursor's data found indicator*/
992: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
993: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;

Line 993: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;

989: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
990: ORDER BY 1,ROWID;
991: /* cursor's data found indicator*/
992: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
993: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;

Line 994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;

990: ORDER BY 1,ROWID;
991: /* cursor's data found indicator*/
992: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
993: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;

Line 995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;

991: /* cursor's data found indicator*/
992: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
993: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;

Line 996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;

992: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
993: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;

Line 997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;

993: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;

Line 998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;

994: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;

Line 999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;

995: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;

Line 1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;

996: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;

Line 1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;

997: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;

Line 1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;

998: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;

Line 1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;

999: nImpPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;

Line 1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;

1000: nImpPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;

Line 1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;

1001: nImpDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;

Line 1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;

1002: nImpName CZ_IMP_PROPERTY.NAME%TYPE;
1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;

Line 1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;

1003: nImpDataType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;

Line 1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;

1004: nImpDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1012: nOnlDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;

Line 1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;

1005: nImpDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1012: nOnlDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1013: nOnlOrigSysRef CZ_IMP_PROPERTY.NAME%TYPE;

Line 1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;

1006: nImpDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1012: nOnlDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1013: nOnlOrigSysRef CZ_IMP_PROPERTY.NAME%TYPE;
1014:

Line 1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;

1007: nOnlPropUnit CZ_IMP_PROPERTY.PROPERTY_UNIT%TYPE;
1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1012: nOnlDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1013: nOnlOrigSysRef CZ_IMP_PROPERTY.NAME%TYPE;
1014:
1015:

Line 1012: nOnlDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;

1008: nOnlDescText CZ_IMP_PROPERTY.DESC_TEXT%TYPE;
1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1012: nOnlDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1013: nOnlOrigSysRef CZ_IMP_PROPERTY.NAME%TYPE;
1014:
1015:
1016: /* Column Vars */

Line 1013: nOnlOrigSysRef CZ_IMP_PROPERTY.NAME%TYPE;

1009: nOnlName CZ_IMP_PROPERTY.NAME%TYPE;
1010: nOnlDefValue CZ_IMP_PROPERTY.DEF_VALUE%TYPE;
1011: nOnlDeletedFlag CZ_IMP_PROPERTY.DELETED_FLAG%TYPE;
1012: nOnlDefNumValue CZ_IMP_PROPERTY.DEF_NUM_VALUE%TYPE;
1013: nOnlOrigSysRef CZ_IMP_PROPERTY.NAME%TYPE;
1014:
1015:
1016: /* Column Vars */
1017: x_imp_property_f BOOLEAN:=FALSE;

Line 1140: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);

1136: IF( x_onl_property_propertyname_f)THEN
1137: sRecStatus:='DUPL';
1138: sDisposition:='R';
1139: nDups:=nDups+1;
1140: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);
1141: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));
1142: ELSE
1143: /*Insert */
1144: sDisposition:='I';

Line 1141: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));

1137: sRecStatus:='DUPL';
1138: sDisposition:='R';
1139: nDups:=nDups+1;
1140: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);
1141: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));
1142: ELSE
1143: /*Insert */
1144: sDisposition:='I';
1145: nInsertCount:=nInsertCount+1;

Line 1156: UPDATE CZ_IMP_PROPERTY SET

1152: END;
1153: END IF;
1154: END;
1155: END IF;
1156: UPDATE CZ_IMP_PROPERTY SET
1157: PROPERTY_ID=DECODE(sDISPOSITION,'R',PROPERTY_ID,'I',nNextValue+nAllocateCounter,nPropertyId),
1158: --
1159: --Bug #5162016 - use an existing but never before used field to store the on-line property data type.
1160: --For new properties this field will stay null.