| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | OZIZV | JOPPD identification/Oznaka izvjesca | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | VRIZV | JOPPD type/Vrsta izvjesca | char | 1 | 0 | | | | Allow NULL? |
| 5 | EEOIB | OIB personal identification number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 6 | CADAT | Correction/Addition date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | OZSTJ | Income recipient identif./ Oznaka stjecatelja/osiguranika | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | OZPRI | Income type/ Oznaka primitka/obveze doprinosa | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | OZMJE | First/last month/ Oznaka prvog/zadnjeg mjeseca | char | 1 | 0 | | | | Allow NULL? |
| 10 | OZVRE | Ident. for full/non-full or half-wrk.time | char | 1 | 0 | | | | Allow NULL? |
| 11 | RAZOD | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | RAZDO | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | OZNPR | Ident. for untaxable payment/ Oznaka neoporez. primitka | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | STAT0 | Status | char | 1 | 0 | | | | Allow NULL? |
| 15 | STAT1 | Status | char | 1 | 0 | | | | Allow NULL? |
| 16 | REDBR | Sequential number | int | 10 | 0 | | | | Allow NULL? |
| 17 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | OZPOD | Submitter identification/ Oznaka podnositelja | char | 1 | 0 | | | | Allow NULL? |
| 19 | MUNCP | Municipality Code HR | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | MUNCR | Municipality of work | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | KATEG | Benefical category | char | 1 | 0 | | | | Allow NULL? |
| 22 | EMDIS | Duty to Employment insur. for disabled | char | 1 | 0 | | | | Allow NULL? |
| 23 | WKHRS | Planned working time in hours | decimal | 5 | 2 | | | | |
| 24 | IZPRI | Total gross amount | decimal | 15 | 2 | | | | |
| 25 | OSNDO | Insurance base/ Osnova za obracun doprinosa | decimal | 15 | 2 | | | | |
| 26 | EEPE1 | Pension insurance contribution | decimal | 15 | 2 | | | | |
| 27 | EEPE2 | Pension insurance level 2/ Doprinos za mirov. osig. stup II | decimal | 15 | 2 | | | | |
| 28 | ERHE | Health insurance/ Doprinos za zdravstveno osiguranje | decimal | 15 | 2 | | | | |
| 29 | ERIN | Injury insurance/ Doprinos za zaštitu zdravlja na radu | decimal | 15 | 2 | | | | |
| 30 | EREM | Employment insurance/ Doprinos za zapošljavanje | decimal | 15 | 2 | | | | |
| 31 | ERPE1 | Pension insurance for beneficiary/ Mirov. osiguranje benef. | decimal | 15 | 2 | | | | |
| 32 | ERPE2 | Pens. insurance for benef. level 2 / Mir. osig. benef. st. 2 | decimal | 15 | 2 | | | | |
| 33 | ERTA | Health insurance for trip abroad/ Zdravstv. osig. inozemst. | decimal | 15 | 2 | | | | |
| 34 | EREMI | Employment insurance for disabled/ Dopr. za zapošl. invalid. | decimal | 15 | 2 | | | | |
| 35 | IZDAT | Cost/ Izdatak | decimal | 15 | 2 | | | | |
| 36 | OSODB | Personal tax relief/ Osobni odbitak | decimal | 15 | 2 | | | | |
| 37 | TAX | Tax amount/ Iznos obracunanog poreza na dohodak | decimal | 15 | 2 | | | | |
| 38 | STAX | Surtax amount/ Iznos obracunanog prireza porezu na dohodak | decimal | 15 | 2 | | | | |
| 39 | IZNPR | Untaxable payment/ Iznos neoporezivog primitka | decimal | 15 | 2 | | | | |
| 40 | OZNAI | Payment method identification/ Oznaka nacina isplate | char | 1 | 0 | | | | Allow NULL? |
| 41 | OBPRI | Income from dependent work/ Obracunani primit. od nesam.rada | decimal | 15 | 2 | | | | |
| 42 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | ORIGN | Version Number Component | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | STAT2 | Status | char | 1 | 0 | | | | Allow NULL? |