invantive documentation
Forum di supporto InvantiveAccedi / Registrati

fbsubscription_fbsubscriptionlines: AFAS Profit itgen_aoe_fbsubscription_fbsubscriptionlines

insert REST

  • Catalogo: AfasOnline
  • Schema: UpdateConnector
  • Etichetta: itgen_aoe_fbsubscription_fbsubscriptionlines

Abonnement: FbSubscriptionLines

È possibile recuperare e modificare i dati utilizzando insert.

Codice sorgente dell'API

  • Punto finale: /connectors/FbSubscription
  • Metadati: metainfo/update/FbSubscription

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 353
Righe di scansione completa al minuto 65,100
Numero di righe di Query al minuto 169

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella fbsubscription_fbsubscriptionlines. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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