The following columns have been added to existing tables in this release of HxGN EAM.
Table name |
Column name |
Oracle datatype |
SQL Server datatype |
---|---|---|---|
OCAD_AE_DOCUMENTS |
AE_DOC_SPACES_CFG |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_DOC_ORG |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_DOC_CODE |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_FILENAME_DWG |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_FILENAME_SVG |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_LAYERNAME |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_LAYER_ON |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_LAYER_FROZEN |
NVARCHAR2 |
|
OCAD_AE_LAYERS_STATUS |
AE_LS_LAYER_LOCK |
NVARCHAR2 |
|
R5ACTCHECKLISTS |
ACK_RESULTRENTITY |
VARCHAR2(4) |
nvarchar(4) |
R5ACTCHECKLISTS |
ACK_RESULTENTITYCLASSOPTIONS |
VARCHAR2(500) |
nvarchar(500) |
R5ACTCHECKLISTS |
ACK_RESULTENTITYCODE |
VARCHAR2(30) |
nvarchar(30) |
R5ACTCHECKLISTS |
ACK_RESULTENTITYORG |
VARCHAR2(15) |
nvarchar(15) |
R5ACTIVITIES |
ACT_CUEST |
VARCHAR2(1) |
nvarchar(1) |
R5ACTIVITIES_ARCHIVE |
ACA_CUEST |
VARCHAR2(1) |
nvarchar(1) |
R5ALERTPICKTICKETFIELDMAP |
APF_ALERT |
VARCHAR2(30) |
nvarchar(30) |
R5ALERTPICKTICKETFIELDMAP |
APF_PICKTICKETFIELD |
VARCHAR2(30) |
nvarchar(30) |
R5ALERTPICKTICKETFIELDMAP |
APF_GRIDFIELD |
NUMBER(14,0) |
numeric(14,0) |
R5ALERTPICKTICKETFIELDMAP |
APF_GRIDFIELDDATATYPE |
VARCHAR2(10) |
nvarchar(10) |
R5ALERTPICKTICKETFIELDMAP |
APF_BOILERTEXTNUMBER |
NUMBER(4,0) |
numeric(4,0) |
R5ALERTPICKTICKETFIELDMAP |
APF_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5ALERTPICKTICKETFIELDMAP |
APF_LASTSAVED |
DATE |
datetime |
R5ALERTS |
ALT_ENABLEWOPICKTICKET |
VARCHAR2(1) |
nvarchar(1) |
R5ALERTWOPICKTICKET |
AWP_ALERT |
VARCHAR2(30) |
nvarchar(30) |
R5ALERTWOPICKTICKET |
AWP_STATUS |
VARCHAR2(4) |
nvarchar(4) |
R5ALERTWOPICKTICKET |
AWP_STORE |
VARCHAR2(15) |
nvarchar(15) |
R5ALERTWOPICKTICKET |
AWP_DESC |
VARCHAR2(80) |
nvarchar(80) |
R5ALERTWOPICKTICKET |
AWP_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5ALERTWOPICKTICKET |
AWP_LASTSAVED |
DATE |
datetime |
R5CASEMANAGEMENT |
CSM_DOWNTIMECOST |
NUMBER(24,6) |
numeric(24,6) |
R5CASEMANAGEMENT |
R5CASEMANAGEMENT |
NUMBER(24,6) |
numeric(24,6) |
R5CASEMANAGEMENT |
CSM_TOTALCOST |
NUMBER(24,6) |
numeric(24,6) |
R5CASEMANAGEMENT |
CSM_LOSTPRODUCTIVITYHRS |
NUMBER(24,6) |
numeric(24,6) |
R5CASEMANAGEMENT |
CSM_PROBLEMDESCRIPTION |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_WHATHAPPENED |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_WHY1 |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_WHY2 |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_WHY3 |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_WHY4 |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_WHY5 |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_SOLUTION |
VARCHAR2(4000) |
nvarchar(4000) |
R5CASEMANAGEMENT |
CSM_PROBLEM |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_FAILURE |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_ACTION |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_CAUSE |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_FAILUREMODE |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_SYMPTOM |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_TACTICALCAUSE |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_HUMANFACTOR |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_WORKMANSHIP |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_HUMANOVERSIGHT |
VARCHAR2(8) |
nvarchar(8) |
R5CASEMANAGEMENT |
CSM_METHODOFDETECTION |
VARCHAR2(8) |
nvarchar(8) |
R5CLASSES |
CLS_SEGMENTVALUE |
VARCHAR2(30) |
nvarchar(30) |
R5CLASSES |
CLS_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5CLASSLINEARREFS |
CLR_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5CODESTRUCTURE |
CSR_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5CONTRACTORSIGNOFF |
CSO_ISSIGNED |
VARCHAR2(1) |
nvarchar(1) |
R5CREWS |
CRW_SEGMENTVALUE |
VARCHAR2(30) |
nvarchar(30) |
R5DOCUMENTS |
DOC_ISIMAGE |
VARCHAR2(1) |
nvarchar(1) |
R5ECSESSIONDETAILS |
CSD_EXCLUDEEQUIPMENT |
VARCHAR2(1) |
nvarchar(1) |
R5ECSESSIONDETAILS |
CSD_PARENTEXCLUDED |
VARCHAR2(1) |
nvarchar(1) |
R5ECSESSIONDETAILS |
CSD_ALLOWVARQUANTITY |
VARCHAR2(1) |
nvarchar(1) |
R5ECSESSIONDETAILS |
CSD_DEFAULTQUANTITY |
NUMBER(5,0) |
numeric(5,0) |
R5ECSESSIONDETAILS |
CSD_QUANTITY |
NUMBER(5,0) |
numeric(5,0) |
R5ECSESSIONDETAILS |
CSD_MINQUANTITY |
NUMBER(5,0) |
numeric(5,0) |
R5ECSESSIONDETAILS |
CSD_MAXQUANTITY |
NUMBER(5,0) |
numeric(5,0) |
R5ECSESSIONEQUIPMENT |
CSE_PK |
NUMBER |
numeric(18,0) |
R5ECSESSIONEQUIPMENT |
CSE_PARENTPK |
NUMBER |
numeric(18,0) |
R5ECSESSIONWARNINGS |
CSW_CSEPK |
NUMBER |
numeric(18,0) |
R5ELECARCHIVE |
ELA_FLD445 |
VARCHAR2(256) |
nvarchar(256) |
R5ELECARCHIVE |
ELA_FLD446 |
VARCHAR2(256) |
nvarchar(256) |
R5ELECARCHIVE |
ELA_FLD447 |
VARCHAR2(256) |
nvarchar(256) |
R5ELECARCHIVE_ARCHIVE |
AEA_FLD445 |
VARCHAR2(256) |
nvarchar(256) |
R5ELECARCHIVE_ARCHIVE |
AEA_FLD446 |
VARCHAR2(256) |
nvarchar(256) |
R5ELECARCHIVE_ARCHIVE |
AEA_FLD447 |
VARCHAR2(256) |
nvarchar(256) |
R5EQUIPCONFIGSTRUCTURES |
ECS_ALLOWVARQUANTITY |
VARCHAR2(1) |
nvarchar(1) |
R5EQUIPCONFIGSTRUCTURES |
ECS_DEFAULTQUANTITY |
NUMBER(5,0) |
numeric(5,0) |
R5EQUIPCONFIGSTRUCTURES |
ECS_MINQUANTITY |
NUMBER(5,0) |
numeric(5,0) |
R5EQUIPCONFIGSTRUCTURES |
ECS_MAXQUANTITY |
NUMBER(5,0) |
numeric(5,0) |
R5EQUIPFUNCTIONLEVELS |
EFL_NOUN |
VARCHAR2(8) |
nvarchar(8) |
R5EQUIPFUNCTIONLEVELS |
EFL_VERB |
VARCHAR2(8) |
nvarchar(8) |
R5EQUIPFUNCTIONLEVELS |
EFL_COMPLEMENT |
VARCHAR2(80) |
nvarchar(80) |
R5EQUIPFUNCTIONLEVELS |
EFL_EFFECTINDICATOR |
VARCHAR2(4000) |
nvarchar(4000) |
R5EQUIPFUNCTIONLEVELS |
EFL_EFFECTCONSEQUENCE |
VARCHAR2(4000) |
nvarchar(4000) |
R5EQUIPFUNCTIONLEVELS |
EFL_ORIGCODE |
VARCHAR2(30) |
nvarchar(30) |
R5EVTTESTPOINTS |
ETP_FULLDEVICEREADING |
NUMBER(29,11) |
numeric(29,11) |
R5EVTTESTPOINTS |
ETP_FULLDEVICEREADINGAL |
NUMBER(29,11) |
numeric(29,11) |
R5EVTTESTPOINTS |
ETP_TESTPOINT_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_STANDARD_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_STANDARDAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_OUTPUT_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_OUTPUTAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVICETOLFROM_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVICETOLFROMAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVICETOLTO_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVICETOLTOAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVICEREADING_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVICEREADINGAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVIATION_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_DEVIATIONAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_FULLDEVREADING_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS |
ETP_FULLDEVREADAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_FULLDEVICEREADING |
NUMBER(29,11) |
numeric(29,11) |
R5EVTTESTPOINTS_ARCHIVE |
AET_FULLDEVICEREADINGAL |
NUMBER(29,11) |
numeric(29,11) |
R5EVTTESTPOINTS_ARCHIVE |
AET_TESTPOINT_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_STANDARD_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_STANDARDAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_OUTPUT_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_OUTPUTAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVICETOLFROM_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVICETOLFROMAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVICETOLTO_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVICETOLTOAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVICEREADING_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVICEREADINGAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVIATION_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_DEVIATIONAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_FULLDEVREADING_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5EVTTESTPOINTS_ARCHIVE |
AET_FULLDEVREADAL_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5FUNCTIONS |
FUN_PRODUCT |
VARCHAR2(1) |
nvarchar(1) |
R5GLACCOUNTINGLOV |
GLL_PK |
VARCHAR2(4) |
nvarchar(4) |
R5GLACCOUNTINGLOV |
GLL_MAINENTITY |
VARCHAR2(4) |
nvarchar(4) |
R5GLACCOUNTINGLOV |
GLL_ENTITY |
VARCHAR2(4) |
nvarchar(4) |
R5GLACCOUNTINGLOV |
GLL_COLUMNABB |
VARCHAR2(10) |
nvarchar(10) |
R5GLACCOUNTINGLOV |
GLL_BOTABB |
VARCHAR2(10) |
nvarchar(10) |
R5GLACCOUNTINGLOV |
GLL_FUNCTION |
VARCHAR2(6) |
nvarchar(6) |
R5GLACCOUNTINGLOV |
GLL_BOTNUMBER |
NUMBER(4,0) |
numeric(4,0) |
R5GLACCOUNTINGLOV |
GLL_VALUEFUNCTION |
VARCHAR2(6) |
nvarchar(6) |
R5GLACCOUNTINGSETUP |
GLA_PK |
VARCHAR2(30) |
nvarchar(30) |
R5GLACCOUNTINGSETUP |
GLA_SEGMENTENTITY |
VARCHAR2(4) |
nvarchar(4) |
R5GLACCOUNTINGSETUP |
GLA_SEGMENT |
VARCHAR2(30) |
nvarchar(30) |
R5GLACCOUNTINGSETUP |
GLA_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5GLACCOUNTINGSETUP |
GLA_LEVELSOURCEFIELD1 |
VARCHAR2(4) |
nvarchar(4) |
R5GLACCOUNTINGSETUP |
GLA_LEVELSEGMENTVALUE1 |
VARCHAR2(30) |
nvarchar(30) |
R5GLACCOUNTINGSETUP |
GLA_LEVELSOURCEFIELD2 |
VARCHAR2(4) |
nvarchar(4) |
R5GLACCOUNTINGSETUP |
GLA_LEVELSEGMENTVALUE2 |
VARCHAR2(30) |
nvarchar(30) |
R5GLACCOUNTINGSETUP |
GLA_LEVELSOURCEFIELD3 |
VARCHAR2(4) |
nvarchar(4) |
R5GLACCOUNTINGSETUP |
GLA_LEVELSEGMENTVALUE3 |
VARCHAR2(30) |
nvarchar(30) |
R5GLACCOUNTINGSETUP |
GLA_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5GLACCOUNTINGSETUP |
GLA_LASTSAVED |
DATE |
datetime |
R5GLACCOUNTINGSETUP |
GLA_ACCOUNTED |
VARCHAR2(2) |
nvarchar(2) |
R5INVESTMENTPLANCONDITIONS |
IPC_INVESTMENTPLANNING |
VARCHAR2(30) |
nvarchar(30) |
R5INVESTMENTPLANCONDITIONS |
IPC_INVESTMENTPLANNINGREV |
NUMBER(4,0) |
numeric(4,0) |
R5INVESTMENTPLANCONDITIONS |
IPC_INVESTMENTPLANNING_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5INVESTMENTPLANCONDITIONS |
IPC_OBJECT |
VARCHAR2(30) |
nvarchar(30) |
R5INVESTMENTPLANCONDITIONS |
IPC_OBJECT_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5INVESTMENTPLANCONDITIONS |
IPC_PERIOD |
NUMBER(2,0) |
numeric(2,0) |
R5INVESTMENTPLANCONDITIONS |
IPC_STARTDATE |
DATE |
datetime |
R5INVESTMENTPLANCONDITIONS |
IPC_ENDDATE |
DATE |
datetime |
R5INVESTMENTPLANCONDITIONS |
IPC_STARTSCORE |
NUMBER(24,6) |
numeric(24,6) |
R5INVESTMENTPLANCONDITIONS |
IPC_ENDSCORE |
NUMBER(24,6) |
numeric(24,6) |
R5INVESTMENTPLANCONDITIONS |
IPC_STARTINDEX |
VARCHAR2(8) |
nvarchar(8) |
R5INVESTMENTPLANCONDITIONS |
IPC_ENDINDEX |
VARCHAR2(8) |
nvarchar(8) |
R5INVESTMENTPLANCONDITIONS |
IPC_ENDUSAGE |
NUMBER(24,6) |
numeric(24,6) |
R5INVESTMENTPLANCONDITIONS |
IPC_STARTRATING |
NUMBER(3,0) |
numeric(3,0) |
R5INVESTMENTPLANCONDITIONS |
IPC_ENDRATING |
NUMBER(3,0) |
numeric(3,0) |
R5INVESTMENTPLANCONDITIONS |
IPC_CORRSCORE |
NUMBER(24,6) |
numeric(24,6) |
R5INVESTMENTPLANCONDITIONS |
IPC_CORRSCOREDATE |
DATE |
datetime |
R5INVESTMENTPLANCONDITIONS |
IPC_CORRSCOREUSAGE |
NUMBER(24,6) |
numeric(24,6) |
R5INVESTMENTPLANCONDITIONS |
IPC_SCOREIMPROVEMENT |
NUMBER(24,6) |
numeric(24,6) |
R5INVESTMENTPLANCONDITIONS |
IPC_FINAL |
VARCHAR2(1) |
nvarchar(1) |
R5INVESTMENTPLANCONDITIONS |
IPC_RUNID |
VARCHAR2(100) |
nvarchar(100) |
R5INVESTMENTPLANCONDITIONS |
IPC_CHK |
VARCHAR2(4) |
nvarchar(4) |
R5INVESTMENTPLANCONDITIONS |
IPC_MESSAGE |
VARCHAR2(500) |
nvarchar(500) |
R5INVESTMENTPLANCONDITIONS |
IPC_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5INVESTMENTPLANCONDITIONS |
IPC_LASTSAVED |
DATE |
datetime |
R5INVESTMENTPLANNING |
INP_CONDCALCSTATUS |
VARCHAR2(8) |
nvarchar(8) |
R5INVESTMENTPLANNING |
INP_CONDCALCREQUESTDATE |
DATE |
datetime |
R5INVESTMENTPLANNING |
INP_CONDCALCRUNDATE |
DATE |
datetime |
R5KPISCORES |
KPS_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5MOBILELBSDATA |
LBS_ZCOORDINATE |
NUMBER(24,6) |
numeric(24,6) |
R5MOBILELBSDATA |
LBS_LOCATIONAVAILABLE |
VARCHAR2(1) |
nvarchar(1) |
R5MOBILELBSDATA |
LBS_NETWORKAVAILABLE |
VARCHAR2(1) |
nvarchar(1) |
R5NONCONFORMITYTYPEASPECTS |
NTA_SEVERITY |
VARCHAR2(8) |
nvarchar(8) |
R5OBJECTS |
OBJ_SEGMENTVALUE |
VARCHAR2(30) |
nvarchar(30) |
R5OBJECTS |
OBJ_DEVICETOLFROM_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5OBJECTS |
OBJ_DEVICETOLTO_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5OBJLINEARREF |
LRF_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5OBJTESTPOINTS |
OTP_TESTPOINT_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5OBJTESTPOINTS |
OTP_OUTPUT_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5OBJTESTPOINTS |
OTP_DEVICETOLFROM_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5OBJTESTPOINTS |
OTP_DEVICETOLTO_DECIMALS |
NUMBER(2,0) |
numeric(2,0) |
R5ORGANIZATION |
ORG_RCMLEVEL |
VARCHAR2(4) |
nvarchar(4) |
R5ORGANIZATION |
ORG_RCASERVICECODE |
VARCHAR2(30) |
nvarchar(30) |
R5ORGANIZATION |
ORG_RCASERVICECODE_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5ORGANIZATION |
ORG_DEEPDIVESERVICECODE |
VARCHAR2(30) |
nvarchar(30) |
R5ORGANIZATION |
ORG_DEEPDIVESERVICECODE_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5PICKLISTS |
PIC_UDFCHAR01 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR02 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR03 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR04 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR05 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR06 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR07 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR08 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR09 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR10 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR11 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR12 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR13 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR14 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR15 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR16 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR17 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR18 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR19 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR20 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR21 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR22 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR23 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR24 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR25 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR26 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR27 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR28 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR29 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFCHAR30 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS |
PIC_UDFNUM01 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS |
PIC_UDFNUM02 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS |
PIC_UDFNUM03 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS |
PIC_UDFNUM04 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS |
PIC_UDFNUM05 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS |
PIC_UDFDATE01 |
DATE |
datetime |
R5PICKLISTS |
PIC_UDFDATE02 |
DATE |
datetime |
R5PICKLISTS |
PIC_UDFDATE03 |
DATE |
datetime |
R5PICKLISTS |
PIC_UDFDATE04 |
DATE |
datetime |
R5PICKLISTS |
PIC_UDFDATE05 |
DATE |
datetime |
R5PICKLISTS |
PIC_UDFCHKBOX01 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS |
PIC_UDFCHKBOX02 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS |
PIC_UDFCHKBOX03 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS |
PIC_UDFCHKBOX04 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS |
PIC_UDFCHKBOX05 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS |
PIC_UDFNOTE01 |
VARCHAR2(2000) |
nvarchar(2000) |
R5PICKLISTS |
PIC_UDFNOTE02 |
VARCHAR2(2000) |
nvarchar(2000) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR01 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR02 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR03 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR04 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR05 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR06 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR07 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR08 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR09 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR10 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR11 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR12 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR13 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR14 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR15 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR16 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR17 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR18 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR19 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR20 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR21 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR22 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR23 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR24 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR25 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR26 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR27 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR28 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR29 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFCHAR30 |
VARCHAR2(80) |
nvarchar(80) |
R5PICKLISTS_ARCHIVE |
API_UDFNUM01 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS_ARCHIVE |
API_UDFNUM02 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS_ARCHIVE |
API_UDFNUM03 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS_ARCHIVE |
API_UDFNUM04 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS_ARCHIVE |
API_UDFNUM05 |
NUMBER(24,6) |
numeric(24,6) |
R5PICKLISTS_ARCHIVE |
API_UDFDATE01 |
DATE |
datetime |
R5PICKLISTS_ARCHIVE |
API_UDFDATE02 |
DATE |
datetime |
R5PICKLISTS_ARCHIVE |
API_UDFDATE03 |
DATE |
datetime |
R5PICKLISTS_ARCHIVE |
API_UDFDATE04 |
DATE |
datetime |
R5PICKLISTS_ARCHIVE |
API_UDFDATE05 |
DATE |
datetime |
R5PICKLISTS_ARCHIVE |
API_UDFCHKBOX01 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS_ARCHIVE |
API_UDFCHKBOX02 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS_ARCHIVE |
API_UDFCHKBOX03 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS_ARCHIVE |
API_UDFCHKBOX04 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS_ARCHIVE |
API_UDFCHKBOX05 |
VARCHAR2(1) |
nvarchar(1) |
R5PICKLISTS_ARCHIVE |
API_UDFNOTE01 |
VARCHAR2(2000) |
nvarchar(2000) |
R5PICKLISTS_ARCHIVE |
API_UDFNOTE02 |
VARCHAR2(2000) |
nvarchar(2000) |
R5PMPSESSIONLINES |
PPL_PPOPK |
NUMBER |
int |
R5PPMOBJECTS |
PPO_UDFCHAR46 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR47 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR48 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR49 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR50 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR51 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR52 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR53 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR54 |
VARCHAR2(80) |
nvarchar(80) |
R5PPMOBJECTS |
PPO_UDFCHAR55 |
VARCHAR2(80) |
nvarchar(80) |
R5RELIABILITYRANKINGRANKS |
RRR_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5RISKMATRIXCONSEQUENCES |
RMC_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5RISKMATRIXSETUP |
RMS_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5ROLES |
ROL_MOBILEAPP |
VARCHAR2(8) |
nvarchar(8) |
R5STOCKTAKELINES |
STL_SUBLINE |
NUMBER(8,0) |
numeric(8,0) |
R5STOCKTAKELINES |
STL_OBJECT |
VARCHAR2(30) |
nvarchar(30) |
R5STOCKTAKELINES |
STL_OBJECT_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5STOCKTAKELINES |
STL_ACTION |
VARCHAR2(2) |
nvarchar(2) |
R5STOCKTAKELINES |
STL_WOOBJECT |
VARCHAR2(30) |
nvarchar(30) |
R5STOCKTAKELINES |
STL_WOOBJECT_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5STOCKTAKELINES |
STL_ATTACHTO |
VARCHAR2(30) |
nvarchar(30) |
R5STOCKTAKELINES |
STL_ATTACHTO_ORG |
VARCHAR2(15) |
nvarchar(15) |
R5STOCKTAKELINES |
STL_WITHDRAWSTATUS |
VARCHAR2(4) |
nvarchar(4) |
R5STOCKTAKELINES |
STL_TOBIN |
VARCHAR2(15) |
nvarchar(15) |
R5STOCKTAKELINES |
STL_NOTE |
VARCHAR2(2000) |
nvarchar(2000) |
R5STOCKTAKELINES |
STL_NEWASSETFUNC |
VARCHAR2(1) |
nvarchar(1) |
R5TASKCHECKLISTS |
TCH_RESULTRENTITY |
VARCHAR2(4) |
nvarchar(4) |
R5TASKCHECKLISTS |
TCH_RESULTENTITYCLASSOPTIONS |
VARCHAR2(500) |
nvarchar(500) |
R5TOOLS |
TOO_SEGMENTVALUE |
VARCHAR2(30) |
nvarchar(30) |
R5TRANSLINES |
TRL_STOCKTAKE |
VARCHAR2(30) |
nvarchar(30) |
R5TRANSLINES |
TRL_STOCKTAKEACTION |
VARCHAR2(2) |
nvarchar(2) |
R5TRANSLINES |
TRL_RECEIVEREQ |
VARCHAR2(1) |
nvarchar(1) |
R5TRANSLINES_ARCHIVE |
ATL_STOCKTAKE |
VARCHAR2(30) |
nvarchar(30) |
R5TRANSLINES_ARCHIVE |
ATL_STOCKTAKEACTION |
VARCHAR2(2) |
nvarchar(2) |
R5TRANSLINES_ARCHIVE |
ATL_RECEIVEREQ |
VARCHAR2(1) |
nvarchar(1) |
R5UCODES |
UCO_IMAGE |
VARCHAR2(30) |
nvarchar(30) |
R5USERS |
USR_PWDRESETLINKGENTIME |
DATE |
datetime |
R5USERS |
USR_PWDRESETCOUNT |
NUMBER(1,0) |
numeric(1,0) |
R5USERWIDGETCHART |
UWC_FUNCTION |
VARCHAR2(6) |
nvarchar(6) |
R5USERWIDGETCHART |
UWC_DATASPYID |
NUMBER(14,0) |
numeric(24,0) |
R5USERWIDGETCHART |
UWC_TAB |
VARCHAR2(6) |
nvarchar(6) |
R5USERWIDGETCHART |
UWC_WIDTH |
NUMBER(4,0) |
numeric(4,0) |
R5USERWIDGETCHART |
UWC_HEIGHT |
NUMBER(4,0) |
numeric(4,0) |
R5USERWIDGETCHART |
UWC_COLOR |
VARCHAR2(8) |
nvarchar(8) |
R5USERWIDGETCHART |
UWC_SHAPE |
VARCHAR2(1) |
nvarchar(1) |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_WIDGETID |
VARCHAR2(30) |
nvarchar(30) |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_WIDGETTITLE |
VARCHAR2(80) |
nvarchar(80) |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_CREATED |
DATE |
datetime |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_CREATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_UPDATED |
DATE |
datetime |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_UPDATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5USERWIDGETEQUIPMENTHEALTH |
WEH_LASTSAVED |
DATE |
datetime |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_WIDGETID |
VARCHAR2(30) |
nvarchar(30) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_FUNCTION |
VARCHAR2(6) |
nvarchar(6) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_DATASPYID |
NUMBER(14,0) |
numeric(14,0) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_WIDGETTITLE |
VARCHAR2(80) |
nvarchar(80) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_SHOWPROFILEIMAGE |
VARCHAR2(1) |
nvarchar(1) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_SHOWIMAGEURL |
VARCHAR2(1) |
nvarchar(1) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_CREATED |
DATE |
datetime |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_CREATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_UPDATED |
DATE |
datetime |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_UPDATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5USERWIDGETEQUIPMENTSUMMARY |
WES_LASTSAVED |
DATE |
datetime |
R5USERWIDGETNONCONFORMITY |
UWN_WIDGETID |
VARCHAR2(30) |
nvarchar(30) |
R5USERWIDGETNONCONFORMITY |
UWN_FUNCTION |
VARCHAR2(6) |
nvarchar(6) |
R5USERWIDGETNONCONFORMITY |
UWN_DATASPYID |
NUMBER(14,0) |
numeric(14,0) |
R5USERWIDGETNONCONFORMITY |
UWN_WIDGETTITLE |
VARCHAR2(80) |
nvarchar(80) |
R5USERWIDGETNONCONFORMITY |
UWN_CREATED |
DATE |
datetime |
R5USERWIDGETNONCONFORMITY |
UWN_CREATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETNONCONFORMITY |
UWN_UPDATED |
DATE |
datetime |
R5USERWIDGETNONCONFORMITY |
UWN_UPDATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETNONCONFORMITY |
UWN_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5USERWIDGETNONCONFORMITY |
UWN_LASTSAVED |
DATE |
datetime |
R5USERWIDGETREPORT |
UWR_WIDGETID |
VARCHAR2(30) |
nvarchar(30) |
R5USERWIDGETREPORT |
UWR_FUNCTION |
VARCHAR2(6) |
nvarchar(6) |
R5USERWIDGETREPORT |
UWR_WIDGETTITLE |
VARCHAR2(80) |
nvarchar(80) |
R5USERWIDGETREPORT |
UWR_CREATED |
DATE |
datetime |
R5USERWIDGETREPORT |
UWR_CREATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETREPORT |
UWR_UPDATED |
DATE |
datetime |
R5USERWIDGETREPORT |
UWR_UPDATEDBY |
VARCHAR2(255) |
nvarchar(255) |
R5USERWIDGETREPORT |
UWR_UPDATECOUNT |
NUMBER(38,0) |
numeric(38,0) |
R5USERWIDGETREPORT |
UWR_LASTSAVED |
DATE |
datetime |
TXALERTS |
ALT_ENABLEWOPICKTICKET |
VARCHAR2(1) |
nvarchar(1) |
TXCLONESTATS |
CST_CLONE |
VARCHAR2(6) |
nvarchar(6) |
TXCLONESTATS |
CST_STAT |
VARCHAR2(4000) |
nvarchar(4000) |
U5OCAD_SVG_SEC_CGRID |
OC_CGR_SVG |
VARCHAR2(1) |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_BIM |
VARCHAR2(1) |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_DSH |
VARCHAR2(1) |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_REFSH |
NUMBER(10,0) |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE01 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE02 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE03 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE04 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE05 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE06 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE07 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE08 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE09 |
CLOB |
|
U5OCAD_SVG_SEC_CGRID |
OC_CGR_RULE10 |
CLOB |
|
U5OCAD_SVG_TB_SECURITY |
TB_ENABLE_CTA |
VARCHAR2(1) |