Alias: IVCTS#

(INF_CV_TRAININGSUPPLIERS)

Training Suppliers

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
SUPPLIER_CODEVarchar2(16)Y
SUPPLIER_STATUSVarchar2(30)Y
ENTITY_CODEVarchar2(16)Y
COUNTRY_CODEVarchar2(16)Y
STATE_PROVINCE_CODEVarchar2(16)Y
SUPPLIER_TYPEVarchar2(30)
SUPPLIER_DESCRIPTIONVarchar2(50)
COMPANY_NAMEVarchar2(50)
CONTACT_NAMEVarchar2(50)
CONTACT_TITLEVarchar2(50)
PHONE_NUMBERVarchar2(20)
SUPPLIER_CATEGORYVarchar2(30)
PHONE_EXTENSIONVarchar2(16)
ALT_PHONE_NUMBERVarchar2(20)
ALT_PHONE_EXTENSIONVarchar2(16)
FAX_NUMBERVarchar2(20)
EMAIL_ADDRESS(Field)Varchar2(50)
ADDRESS_LINE_1Varchar2(50)
ADDRESS_LINE_2Varchar2(50)
LOCALITYVarchar2(50)
ZIP_POSTALVarchar2(16)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.


Notes #

Click to create a new notes page