Please enable JavaScript to view this site.

Navigation: Catalog: AfasOnline > Schemas > Schema: GetConnector > Tables

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