fbsubscription: AFAS Profit itgen_aoe_fbsubscription
insert update delete REST
- Katalog:
AfasOnline - Schema:
UpdateConnector - Bezeichnung: itgen_aoe_fbsubscription
Abonnement
Mit insert, update und delete können Daten abgerufen und geändert werden.
API-Quelle
- Endpunkt:
/connectors/FbSubscription - Metadaten:
metainfo/update/FbSubscription
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 353 |
| Anzahl der Vollscan-Zeilen pro Minute | 65,100 |
| Anzahl der Query-Zeilen pro Minute | 169 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle fbsubscription sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | 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 |