fbdeliverynote_fbdeliverynotelines: AFAS Profit itgen_aoe_fbdeliverynote_fbdeliverynotelines
insert REST
- Catálogo:
AfasOnline - Esquema:
UpdateConnector - Etiqueta: itgen_aoe_fbdeliverynote_fbdeliverynotelines
Pakbon: FbDeliveryNoteLines
Permite recuperar y modificar datos mediante insert.
Fuente de la API
- Punto final:
/connectors/FbDeliveryNote - Metadatos:
metainfo/update/FbDeliveryNote
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 fbdeliverynote_fbdeliverynotelines. 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 |
|---|---|---|---|---|---|
ardc |
number |
Bedrag regelkorting | fetched only when named, ARDc |
||
biun |
varchar2 |
Eenheid | fetched only when named, BiUn |
||
copr |
number |
Kostprijs | fetched only when named, CoPr |
||
coty |
varchar2 |
Type projectkosten | fetched only when named, CoTy |
||
di01 |
int32 |
(ongebruikt) | fetched only when named, Di01 |
||
di02 |
int32 |
(ongebruikt) | fetched only when named, Di02 |
||
di03 |
int32 |
(ongebruikt) | fetched only when named, Di03 |
||
di04 |
int32 |
(ongebruikt) | fetched only when named, Di04 |
||
di05 |
int32 |
(ongebruikt) | fetched only when named, Di05 |
||
ds |
varchar2 |
Omschrijving | fetched only when named, Ds |
||
euse |
char |
Dienstenberekening | fetched only when named, EUSe |
||
grwe |
number |
Totaal brutogewicht | fetched only when named, GrWe |
||
guli |
varchar2 |
GUID regel | fetched only when named, GuLi |
||
itcd |
varchar2 |
Itemcode | fetched only when named, ItCd |
||
maad |
char |
Handmatig bedrag regelkorting | fetched only when named, MaAD |
||
moid |
varchar2 |
Bewakingscode | fetched only when named, MoId |
||
newe |
number |
Totaal nettogewicht | fetched only when named, NeWe |
||
noin |
char |
Niet factureren | fetched only when named, NoIn |
||
prdc |
number |
% Regelkorting | fetched only when named, PRDc |
||
prli |
varchar2 |
Prijslijst | fetched only when named, PrLi |
||
qu |
number |
Aantal | fetched only when named, Qu |
||
quhe |
number |
Hoogte | fetched only when named, QuHe |
||
qule |
number |
Lengte | fetched only when named, QuLe |
||
quun |
number |
Aantal eenheden | fetched only when named, QuUn |
||
quwi |
number |
Breedte | fetched only when named, QuWi |
||
re |
varchar2 |
Opmerking | fetched only when named, Re |
||
sogu |
varchar2 |
GUID bronregel | fetched only when named, SoGu |
||
soor |
varchar2 |
Bijbehorende order | fetched only when named, SoOr |
||
sopq |
varchar2 |
Bijbehorende voorcalculatie | fetched only when named, SoPQ |
||
stl1 |
varchar2 |
Artikeldimensiecode 1 | fetched only when named, StL1 |
||
stl2 |
varchar2 |
Artikeldimensiecode 2 | fetched only when named, StL2 |
||
ue20edd5c425147acb3131f4d30e260ba |
varchar2 |
Medipoint bestelling | fetched only when named, UE20 |
||
upri |
number |
Prijs per eenheid | fetched only when named, Upri |
||
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 |
||
vaad |
varchar2 |
Korting toestaan | fetched only when named, VaAD |
||
vait |
varchar2 |
Type item | fetched only when named, VaIt |
||
varc |
varchar2 |
Btw-tariefgroep | fetched only when named, VaRc |
||
vawt |
varchar2 |
Gewichtseenheid | fetched only when named, VaWt |
||
war |
varchar2 |
Magazijn | fetched only when named, War |