invantive documentation
Forum di supporto InvantiveAccedi / Registrati

EMPLOYEE: AccountView Employees

read only per partition

  • Catalogo: AccountView
  • Label: Employees

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella EMPLOYEE. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
AD_NAME varchar2(40) Full name
ADDRESS1 varchar2(80) Address
BLK_HOURS char Show blocked hours
CITY varchar2(35) City
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
CNT_CODE varchar2(2) ISO country code
COMMENT1 varchar2(4) Note
CON_T_01 decimal Contract hours Sunday
CON_T_02 decimal Contract hours Monday
CON_T_03 decimal Contract hours Tuesday
CON_T_04 decimal Contract hours Wednesday
CON_T_05 decimal Contract hours Thursday
CON_T_06 decimal Contract hours Friday
CON_T_07 decimal Contract hours Saturday
CON_T_NCHK char Do not check contract time
CON_TIME decimal Contract time
COST_CODE varchar2(10) Cost centre code
COUNTRY varchar2(30) Country
DATE_BIRTH datetime Date of birth
DATE_IN datetime Start of employment date
DATE_OUT datetime End of employment date
DEAR varchar2(40) Salutation
DFLT_COST varchar2(10) Default hour type amounts
DFLT_DIST varchar2(10) Default hour type quantities
DFLT_TIME varchar2(10) Default hour type hours
DPT_CODE varchar2(10) Department
EMP_GRP varchar2(10) Employee group
EMP_INV decimal Employee revenue
EMP_NR varchar2(10) Employee code
EMP_PCHS decimal Calculated internal hourly rate
EMP_PROF decimal Total profit per year
EMP_SELL decimal Calculated external hourly rate
EMP_SEX decimal Gender
EXT_DESC varchar2(40) External description
FAX_BUS varchar2(20) Business fax
FAX_PRIV varchar2(20) Private fax
FST_INIT varchar2(10) Initials
FST_NAME varchar2(20) Nome
GRP_CODE varchar2(10) Report group code
HR_IMPPROD decimal Non-productive hours
HR_PROD decimal Productive hours
IMG_FILE varchar2(4) Image
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
IS_WF_EMP char IFA employee
LVE_BUD decimal Leave budget
LVE_DAYS decimal Leave balance
MAIL_BUS varchar2(50) Business email
MAIL_PRIV varchar2(50) Private email
OWN_HOURS varchar2(1) Hours display
OWN_INV varchar2(1) Claim proposal display
OWN_OI varchar2(1) Invoice display
OWN_PROJ varchar2(1) Project display
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PCT_ALLOC decimal Overhead surcharge percentage
PCT_INV decimal Billing target
PCT_PROFIT decimal Profit surcharge percentage
PO_BOX varchar2(80) Postal address
PO_CITY varchar2(35) Postal address city
PO_CODE varchar2(10) Postal address postcode
POSITION varchar2(40) Job title
POST_CODE varchar2(10) Postcode
REC_BLK char Blocked
SAL_YEAR decimal Annual salary
ST_EXTRA varchar2(10) Address addition
ST_NR varchar2(10) House number
ST_REGION varchar2(40) Address region
ST_STREET varchar2(60) Nome della via
TEL_BUS varchar2(20) Business telephone
TEL_MOB varchar2(20) Mobile telephone
TEL_PRIV varchar2(20) Private telephone
TIM_NORM decimal Standard number of hours per year
TIME_SHEET decimal Employee hours entry
USR_ID varchar2(20) Nome Utente
WF_ALLACCT char All general ledger accounts allowed
WF_AUTHAMT int64 Maximum approval amount
WHS_CODE varchar2(5) Default warehouse code
WWW_URL varchar2(80) Website