AFAS Online Data Model
Profit_Employees: Employees |
Name: Profit_Employees
Catalog: AfasOnline
Schema: GetConnector
Label: Employees
Documentation:
Profit_Employees
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/Profit_Employees
Insert Service URL (OData-specific): /connectors/Profit_Employees
Update Service URL (OData-specific): /connectors/Profit_Employees
Delete Service URL (OData-specific): /connectors/Profit_Employees
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AddNumber |
string(30) |
Toev. aan huisnr. |
|
|
BirthName |
string(80) |
Geboortenaam |
|
|
BirthNamePartner |
string(80) |
Geb.naam partner |
|
|
BSN |
string(25) |
BSN |
|
|
City |
string(50) |
Woonplaats |
|
|
Country |
string(3) |
Land |
|
|
DateDeceased |
datetime |
Overlijdensdatum |
|
|
DateOfBirth |
datetime |
Geboortedatum |
|
|
EmployeeId |
string(15) |
Medewerker |
|
|
EmployerId |
string(15) |
Werkgever |
|
|
EmploymentEnd |
datetime |
Datum uit dienst |
|
|
EmploymentStart |
datetime |
Datum in dienst |
|
|
EmploymentType |
string(20) |
Code dienstbetrekking |
|
|
EmploymentTypeDesc |
string(100) |
Dienstbetrekking omschr. |
|
|
FirstName |
string(80) |
Roepnaam |
|
|
FTE |
decimal |
Aantal FTE |
|
|
FunctionDesc |
string(50) |
Functie |
|
|
FunctionId |
string(10) |
Code functie |
|
|
Gender |
string(20) |
Geslacht code |
|
|
HourPerWeek |
decimal |
Aantal uren per week |
|
|
HouseNumber |
int32 |
Huisnummer |
|
|
Initials |
string(15) |
Voorletters |
|
|
string(255) |
E-mail werk |
|
|
|
MaritalStatus |
string(20) |
Burgerlijke staat code |
|
|
Mobile |
string(255) |
Mobiel privé |
|
|
NameUse |
string(20) |
Naamgebruik code |
|
|
OrgUnit |
string(10) |
OE code |
|
|
OrgUnitDesc |
string(50) |
OE omschr. |
|
|
PersonId |
string(15) |
PersoonsId |
|
|
Phone |
string(255) |
Telefoonnr. privé |
|
|
PrefixBirthName |
string(15) |
Voorvoegsel geboortenaam |
|
|
PrefixPartner |
string(15) |
Voorvoegsel partner |
|
|
Street |
string(60) |
Straat |
|
|
ZIPCode |
string(15) |
Postcode |
|
|
07-10-2019 20:5017.33.149-BETA+2365
