VPLAN_SalesOrder: itgen_aoe_vplan_salesorder |
Name: VPLAN_SalesOrder
Catalog: AfasOnline
Schema: GetConnector
Label: itgen_aoe_vplan_salesorder
Documentation:
VPLAN_SalesOrder
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/VPLAN_SalesOrder
Insert Service URL (OData-specific): /connectors/VPLAN_SalesOrder
Update Service URL (OData-specific): /connectors/VPLAN_SalesOrder
Delete Service URL (OData-specific): /connectors/VPLAN_SalesOrder
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
afas_created_at |
datetime |
Aangemaakt op |
|
|
afas_updated_at |
datetime |
Gewijzigd op |
|
|
city |
string(50) |
Woonplaats |
|
|
contact |
string(80) |
Vertegenwoordiger |
|
|
country |
string(3) |
Land |
|
|
date |
datetime |
Datum |
|
|
delivered_date |
datetime |
Werkelijke datum aflevering |
|
|
desired_date |
datetime |
Gewenste leverdatum |
|
|
external_ref |
string(12) |
Nummer |
|
|
houseadd |
string(30) |
Toev. aan huisnr. |
|
|
houseno |
int32 |
Huisnummer |
|
|
note |
string |
Opmerking |
|
|
postcode |
string(15) |
Postcode |
|
|
project |
string(15) |
Project |
|
|
promised_date |
datetime |
Datum levering (toegezegd) |
|
|
relation |
string(16) |
Verkooprelatie |
|
|
relation_ref |
string(100) |
Opdrachtnummer/referentie |
|
|
status |
string(100) |
Status |
|
|
street |
string(60) |
Straat |
|
|
warehouse |
string(15) |
Magazijn |
|
|
07-10-2019 20:5017.33.149-BETA+2365