invantive documentation
Invantive Support ForumsLog In / Sign Up

fbsubscription_fbsubscriptionlines: AFAS Profit itgen_aoe_fbsubscription_fbsubscriptionlines

insert REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_fbsubscription_fbsubscriptionlines

Abonnement: FbSubscriptionLines

Can retrieve data and change data using insert.

API Source

  • Endpoint: /connectors/FbSubscription
  • Metadata: metainfo/update/FbSubscription

Performance Characteristics

Characteristic Value
Average access latency (ms) 353
Full scan rows per minute 65,100
Point query rows per minute 169

The result can be cached on the client.

Table Columns

The columns of the table fbsubscription_fbsubscriptionlines are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
crfr datetime Crediteren vanaf fetched only when named, CrFr
crsi char Verkoop crediteren fetched only when named, CrSi
daen datetime Einddatum fetched only when named, DaEn
dapu datetime Aanschafdatum fetched only when named, DaPu
dast datetime Begindatum fetched only when named, DaSt
dcpr number Kortingspercentage fetched only when named, DcPr
dipr number % Korting verkoop fetched only when named, DiPr
disc number Korting basisvaluta fetched only when named, Disc
id int32 Regelnummer fetched only when named, Id
infr datetime Factureren vanaf fetched only when named, InFr
ispc char Korting op basis van % fetched only when named, IsPc
isps char Verkoopkorting op basis van % fetched only when named, IsPS
itcd varchar2(40) Itemcode fetched only when named, ItCd
nfdi varchar2(15) Korting vreemde valuta fetched only when named, NFDi
nfpr varchar2(15) Afwijkende prijs vreemde valuta fetched only when named, NFPr
pric number Afwijkende prijs basisvaluta fetched only when named, Pric
qu number Aantal fetched only when named, Qu
sadi number Kortingsbedrag verkoop basisvaluta fetched only when named, SaDi
sapr number Afw. verkoopprijs basisvaluta fetched only when named, SaPr
sfdi varchar2(15) Kortingsbedrag verkoop vreemde valuta fetched only when named, SFDi
sfpr varchar2(15) Afw. verkoop prijs vreemde valuta fetched only when named, SFPr
sucr char Abonnement crediteren fetched only when named, SuCr
u900377e747f3e088a7452c99a82a5427 varchar2 Opmerking fetched only when named, U900377E747F3E088A7452C99A82A5427
v1cd varchar2(16) Code verbijzonderingsas 1 fetched only when named, V1Cd
v2cd varchar2(16) Code verbijzonderingsas 2 fetched only when named, V2Cd
v3cd varchar2(16) Code verbijzonderingsas 3 fetched only when named, V3Cd
v4cd varchar2(16) Code verbijzonderingsas 4 fetched only when named, V4Cd
v5cd varchar2(16) Code verbijzonderingsas 5 fetched only when named, V5Cd
vait varchar2(10) Type item fetched only when named, VaIt
vars varchar2(20) Reden beëindiging fetched only when named, VaRs