AFAS Online Data Model
VPLAN_Employee: itgen_aoe_vplan_employee |
Name: VPLAN_Employee
Catalog: AfasOnline
Schema: GetConnector
Label: itgen_aoe_vplan_employee
Documentation:
VPLAN_Employee
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/VPLAN_Employee
Insert Service URL (OData-specific): /connectors/VPLAN_Employee
Update Service URL (OData-specific): /connectors/VPLAN_Employee
Delete Service URL (OData-specific): /connectors/VPLAN_Employee
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
afas_created_at |
datetime |
Aangemaakt op |
|
|
afas_created_at_contract |
datetime |
Aangemaakt op |
|
|
afas_status |
string(100) |
Status dienstverband |
|
|
afas_updated_at |
datetime |
Gewijzigd op |
|
|
afas_updated_at_contract |
datetime |
Gewijzigd op |
|
|
date_of_birth |
datetime |
Geboortedatum |
|
|
end_employment |
datetime |
Datum uit dienst |
|
|
external_ref |
string(15) |
Medewerker |
|
|
firstname |
string(50) |
Voornaam |
|
|
fullname |
string(80) |
Naam |
|
|
gender |
string(100) |
Geslacht |
|
|
infix |
string(15) |
Voorvoegsel |
|
|
job_description |
string(80) |
Functie (vertaalde omschrijving) |
|
|
lastname |
string(80) |
Achternaam |
|
|
note |
string |
Opmerking |
|
|
start_employment |
datetime |
Datum in dienst |
|
|
07-10-2019 20:5017.33.149-BETA+2365
