AFAS Online Data Model
Profit_Salesorders: Sales Orders |
Name: Profit_Salesorders
Catalog: AfasOnline
Schema: GetConnector
Label: Sales Orders
Documentation:
Profit_Salesorders
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/Profit_Salesorders
Insert Service URL (OData-specific): /connectors/Profit_Salesorders
Update Service URL (OData-specific): /connectors/Profit_Salesorders
Delete Service URL (OData-specific): /connectors/Profit_Salesorders
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CurrencyId |
string(3) |
Valuta |
|
|
CustomerReference |
string(100) |
Opdrachtnummer/referentie |
|
|
DebtorId |
string(16) |
Verkooprelatie |
|
|
Discount |
decimal |
Factuurkorting |
|
|
Gross |
decimal |
Brutobedrag |
|
|
InvoiceTotal |
decimal |
Factuurtotaal |
|
|
OrderDate |
datetime |
Datum |
|
|
OrderNumber |
string(12) |
Ordernummer |
|
|
Ordersoort |
string(10) |
Type order |
|
|
Quantity |
decimal |
Totaalaantal |
|
|
Status |
string(100) |
Status |
|
|
TotalAmount |
decimal |
Totaalbedrag |
|
|
VAT |
decimal |
Btw-bedrag |
|
|
07-10-2019 20:5017.33.149-BETA+2365
