AFAS Online Data Model
Profit_Subscriptions: itgen_aoe_profit_subscriptions |
Name: Profit_Subscriptions
Catalog: AfasOnline
Schema: GetConnector
Label: itgen_aoe_profit_subscriptions
Documentation:
Profit_Subscriptions
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/Profit_Subscriptions
Insert Service URL (OData-specific): /connectors/Profit_Subscriptions
Update Service URL (OData-specific): /connectors/Profit_Subscriptions
Delete Service URL (OData-specific): /connectors/Profit_Subscriptions
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CreateDate |
datetime |
Aangemaakt op |
|
|
DateEnd |
datetime |
Einddatum |
|
|
DateEndSub |
datetime |
Einddatum abonnement |
|
|
DateStart |
datetime |
Begindatum |
|
|
DateStartSub |
datetime |
Begindatum abonnement |
|
|
DebtorId |
string(16) |
Verkooprelatie |
|
|
Indentity |
int32 |
Regelnummer |
|
|
InvoicesUntil |
datetime |
Gefactureerd t/m |
|
|
Itemcode |
string(40) |
Itemcode |
|
|
ItemType |
string(20) |
Type item code |
|
|
ModifiedDate |
datetime |
Gewijzigd op |
|
|
OriginalPrice |
decimal |
Originele prijs basisvaluta |
|
|
PresentationSeqno |
int32 |
Presentatievolgorde |
|
|
ProjectId |
string(15) |
Project |
|
|
Quantity |
decimal |
Aantal |
|
|
SalesAmount |
decimal |
Verkoopbedrag basisvaluta |
|
|
SalesDiscount |
decimal |
Kortingsbedrag verkoop basisvaluta |
|
|
SubscriptionNr |
int32 |
Nummer abonnement |
|
|
UnitIdFin |
int32 |
Administratie |
|
|
ValueIntIdSu |
string(20) |
Type abonnement code |
|
|
07-10-2019 20:5017.33.149-BETA+2365
