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 |
Banknummer afwijkend | fetched only when named, Bankaccount |
||
bcid |
varchar2 |
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 |
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 |
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 |
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 |
Betaalvoorwaarde | fetched only when named, PaCd |
||
prid |
varchar2 |
Project | fetched only when named, PrId |
||
prst |
varchar2 |
Projectfase | fetched only when named, PrSt |
||
rate |
number |
Valutakoers | fetched only when named, Rate |
||
rfcs |
varchar2 |
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, U137 |
||
unfi |
int32 |
Administratie | fetched only when named, UnFi |
||
v1cd |
varchar2 |
Code verbijzonderingsas 1 | fetched only when named, V1Cd |
||
v2cd |
varchar2 |
Code verbijzonderingsas 2 | fetched only when named, V2Cd |
||
v3cd |
varchar2 |
Code verbijzonderingsas 3 | fetched only when named, V3Cd |
||
v4cd |
varchar2 |
Code verbijzonderingsas 4 | fetched only when named, V4Cd |
||
v5cd |
varchar2 |
Code verbijzonderingsas 5 | fetched only when named, V5Cd |
||
vadu |
varchar2 |
Btw-plicht | fetched only when named, VaDu |
||
vain |
varchar2 |
Cyclus facturering | fetched only when named, VaIn |
||
vals |
varchar2 |
Type licentie | fetched only when named, VaLs |
||
vapc |
varchar2 |
Programmatuurcode | fetched only when named, VaPc |
||
vare |
varchar2 |
Cyclusverlenging | fetched only when named, VaRe |
||
vars |
varchar2 |
Reden beëindiging | fetched only when named, VaRs |
||
vasu |
varchar2 |
Type abonnement | fetched only when named, VaSu |
||
vave |
varchar2 |
Versie | fetched only when named, VaVe |