invantive documentation
Forum di supporto InvantiveAccedi / Registrati

fbsubscription: AFAS Profit itgen_aoe_fbsubscription

insert update delete REST

  • Catalogo: AfasOnline
  • Schema: UpdateConnector
  • Etichetta: itgen_aoe_fbsubscription

Abbonamento

È possibile recuperare e modificare i dati utilizzando insert, update e delete.

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. 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
altsre char Factuur naar afwijkende verkooprelatie fetched only when named, AltSRe
atin char Incasseren fetched only when named, AtIn
auin char Automatisch factureren fetched only when named, AuIn
bankaccount varchar2(40) Banknummer afwijkend fetched only when named, Bankaccount
bcid varchar2(15) Organisatie/persoon fetched only when named, BcId
cti1 int32 Afwijkende contactpersoon fetched only when named, CtI1
ctpe int32 Contactpersoon fetched only when named, CtPe
cuid varchar2(3) Valuta fetched only when named, CuId
daam int32 Aantal dagen vooraf fetched only when named, DaAm
dare datetime Datum verlenging fetched only when named, DaRe
dast datetime Begindatum factuurcyclus fetched only when named, DaSt
dbid varchar2(16) Verkooprelatie fetched only when named, DbId
inad char Voorschotfactuur fetched only when named, InAd
indi char Verkoop direct factureren fetched only when named, InDi
inva char Prijzen inclusief btw fetched only when named, InVa
lafr datetime Verlaging toegestaan vanaf fetched only when named, LaFr
lina varchar2(50) Naam licentie fetched only when named, LiNa
noct char Uitsluiten van verzamelfactuur fetched only when named, NoCt
noin char Niet factureren fetched only when named, NoIn
nosi char Verkoop niet factureren fetched only when named, NoSi
pacd varchar2(5) Betaalvoorwaarde fetched only when named, PaCd
prid varchar2(15) Project fetched only when named, PrId
prst varchar2(15) Projectfase fetched only when named, PrSt
rate number Valutakoers fetched only when named, Rate
rfcs varchar2(100) Opdrachtnummer/referentie fetched only when named, RfCs
suen datetime Einddatum abonnement fetched only when named, SuEn
sunr int32 Nummer abonnement fetched only when named, SuNr
sust datetime Begindatum abonnement fetched only when named, SuSt
u137e13404fec8c95375ad79c52a0ab69 varchar2 Opmerking abonnement fetched only when named, U137E13404FEC8C95375AD79C52A0AB69
unfi int32 Administratie fetched only when named, UnFi
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
vadu varchar2(3) Btw-plicht fetched only when named, VaDu
vain varchar2(20) Cyclus facturering fetched only when named, VaIn
vals varchar2(20) Type licentie fetched only when named, VaLs
vapc varchar2(20) Programmatuurcode fetched only when named, VaPc
vare varchar2(20) Cyclusverlenging fetched only when named, VaRe
vars varchar2(20) Reden beëindiging fetched only when named, VaRs
vasu varchar2(20) Type abonnement fetched only when named, VaSu
vave varchar2(20) Versie fetched only when named, VaVe