invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

fbsubscription_fbsubscriptionlines: AFAS Profit itgen_aoe_fbsubscription_fbsubscriptionlines

insert REST

  • Catálogo: AfasOnline
  • Esquema: UpdateConnector
  • Etiqueta: itgen_aoe_fbsubscription_fbsubscriptionlines

Abonnement: FbSubscriptionLines

Permite recuperar y modificar datos mediante insert.

Fuente de la API

  • Punto final: /connectors/FbSubscription
  • Metadatos: metainfo/update/FbSubscription

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 353
Número de filas escaneadas por minuto 65,100
Número de filas de queries puntuales por minuto 169

El resultado se puede almacenar en la Caché del cliente.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla fbsubscription_fbsubscriptionlines. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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