AFAS Online Data Model
Profit_SalesorderLines: Sales Order Lines |
Name: Profit_SalesorderLines
Catalog: AfasOnline
Schema: GetConnector
Label: Sales Order Lines
Documentation:
Profit_SalesorderLines
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/Profit_SalesorderLines
Insert Service URL (OData-specific): /connectors/Profit_SalesorderLines
Update Service URL (OData-specific): /connectors/Profit_SalesorderLines
Delete Service URL (OData-specific): /connectors/Profit_SalesorderLines
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AmtRowDiscount |
decimal |
Bedrag regelkorting |
|
|
AmtTotal |
decimal |
Regelbedrag |
|
|
CreateDate |
datetime |
Aangemaakt op |
|
|
CurrencyId |
string(3) |
Valuta |
|
|
CustomerReference |
string(100) |
Opdrachtnummer/referentie |
|
|
DebtorId |
string(16) |
Verkooprelatie |
|
|
Description |
string(255) |
Omschrijving |
|
|
ItemCodeId |
string(40) |
Itemcode |
|
|
ItemTypeCode |
string(20) |
Type item code |
|
|
LineGuid |
string(38) |
GUID regel |
|
|
LineStatusCode |
string(20) |
Regel status code |
|
|
ModifiedDate |
datetime |
Gewijzigd op |
|
|
OrderDate |
datetime |
Datum |
|
|
OrderNumber |
string(12) |
Ordernummer |
|
|
PiecePerUnit |
decimal |
Aantal eenheden |
|
|
PriceNet |
decimal |
Nettoprijs |
|
|
PricePerUnit |
decimal |
Prijs per eenheid |
|
|
SeqNo |
int32 |
Volgnummer |
|
|
Status |
string(100) |
Status |
|
|
UnitId |
string(15) |
Eenheid |
|
|
07-10-2019 20:5017.33.149-BETA+2365
