INF_CV_UNITS
Back to current versionRestore this version

Alias: IVDUN#

(INF_CV_UNITS)
Contract specific information.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
UNIT_CODEVarchar2(16)CODEY
STANDINGVarchar2(30)VARCHAR30
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
DESCRIPTIONVarchar2(50)DESCRIPTIONY
UNIT_STATUSVarchar2(30)VARCHAR30
AGREEMENT_START_DATEDate()DATE
AGREEMENT_END_DATEDate()DATE
UNIT_NAMEVarchar2(50)DESCRIPTION
UNIT_LOCALVarchar2(50)DESCRIPTION
UNIT_SUB_LOCALVarchar2(50)DESCRIPTION
UNIT_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30