Please enable JavaScript to view this site.

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

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