AFAS Online Data Model
Profit_Subscriptions: itgen_aoe_profit_subscriptions |
Name: Profit_Subscriptions
Catalog: AfasOnline
Schema: AfasOnline
Label: itgen_aoe_profit_subscriptions
Documentation:
Profit_Subscriptions
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 |
Verkooprelatie |
|
|
Indentity |
int32 |
Regelnummer |
|
|
InvoicesUntil |
datetime |
Gefactureerd t/m |
|
|
Itemcode |
string |
Itemcode |
|
|
ItemType |
string |
Type item code |
|
|
ModifiedDate |
datetime |
Gewijzigd op |
|
|
OriginalPrice |
decimal |
Originele prijs basisvaluta |
|
|
PresentationSeqno |
int32 |
Presentatievolgorde |
|
|
ProjectId |
string |
Project |
|
|
Quantity |
decimal |
Aantal |
|
|
SalesAmount |
decimal |
Verkoopbedrag basisvaluta |
|
|
SalesDiscount |
decimal |
Kortingsbedrag verkoop basisvaluta |
|
|
SubscriptionNr |
int32 |
Nummer abonnement |
|
|
UnitIdFin |
int32 |
Administratie |
|
|
ValueIntIdSu |
string |
Type abonnement code |
|
|
18-03-2019 16:2017.31.45-BETA+1956
