T5BS3

Employee information except reductions ( level 3 ) | #transactional | #language | Component: Belgium
Column Name Description
MANDT Client
DECID SI Declaration identifier
STREF Reference pointing to the detailed declaration info
RSZCA Employer Class (SI Employer Category) (00036)
RSZNR SI Registration Number (employer) (00011)
RSZKN Worker Code (SI Employee Category) (00037)
PERNR Personnel Number
Column Name Description
Column Name Description
Column Name Description
GBDAT Date of Birth
DECES SI declaration date of death
PENS SI declaration date of retirement
ESCE SI declaration date of entry
SORT SI declaration date of leaving
DEBST Begindate in employee category
FINST Enddate in employee category
DTRIM File creation date
FTRIM End of three months period
ARBER Expiration Date of Work Permit
Column Name Description
GESCH Gender Key Show values
STQUA Student capacity Show values
Column Name Description Domain name
STRAV Worker's range number CHAR5
RSZRR INSS - National ID Number (00024)
GBORT Birthplace PAD_ORT01
RSZGL Country code for place of birth CHAR5
DDREC Correction proposal code CHAR1
NSSOC Employer number with Social Office CHAR15
RSZLA Language Key SPRAS
NACHN Last Name PAD_NACHN
VORNA First Name PAD_VORNM
STRAS Street and House Number TEXT30
HSNMR House Number PAD_HSNMR
ORT01 City PAD_ORT01
POSTA Identification of an apartment in a building PAD_HSNMR
PSTLZ Postal Code PSTLZ
RSZBL Sender SI country code CHAR5
FRONT Border worker CHAR1
ARTIS Artist CHAR1
CHOM Unemployed CHAR1
INTER International address version ID NATION
TDOMI Domestic worker CHAR1
TREMP Employment notion CHAR1
NSTAG Training employee CHAR1
NOPEP Notion first professional experiance
BVFAM Marital Status BVFAM
RSZNA Obsolete: SI Nationality RSZNA
BVECH Partner's Profession BVECH
FAMSA Type of Family Record SUBTY
BESTE Frequency of payment CHAR1
BEGPC Joint Commission (00046) BEGPC
BECNR Contract Number CHAR15
BEANN Contract duration CHAR2
CTTYP Contract Type CTTYP
NSUIT Activity range number CHAR3
SSGE Range number HQ CHAR4
STAMT Student salary P12_AMOUNT_SI
STDAG Number of paid days (students) P12_DAYS_SI
DPD92 Double Holiday Pay after 1992 P12_AMOUNT_SI
COTSP Contribution code CHAR1
MTCOT Special contribution: amount P12_AMOUNT_SI
AMSOL Solidarity contribution on company car P12_AMOUNT_SI
AMELA Contribution extra-legal advantage : amount P12_AMOUNT_SI