av_art_line: Visual FoxPro
insert update delete per partition
- Catalog: ``
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
Tabelkolommen
De kolommen van de tabel av_art_line worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AG_ |
varchar2 |
||||
AL_ |
char |
||||
ART_ |
number |
||||
ART_BM |
char |
||||
ART_CA |
char |
||||
ART_ |
varchar2 |
||||
ART_ |
number |
||||
ART_ |
datetime |
||||
ART_ |
varchar2 |
||||
ART_ |
int32 |
||||
ART_PX |
number |
||||
ART_ |
double |
||||
ART_ |
double |
||||
BM_TAG |
varchar2 |
||||
COGS_ |
number |
||||
COGS_ |
char |
||||
COST_ |
varchar2 |
||||
CUR_ |
number |
||||
DISC_ |
number |
||||
DISC_ |
number |
||||
DISC_ |
number |
||||
EMP_NR |
varchar2 |
||||
HDR_ID |
varchar2 |
||||
HDR_ |
number |
||||
ICAT_ |
varchar2 |
||||
ICNT_ |
varchar2 |
||||
ICNT_ |
varchar2 |
||||
INV_NR |
varchar2 |
||||
IS_ |
number |
||||
IS_ |
varchar2 |
||||
IS_ |
number |
||||
IS_ |
number |
||||
ISHP_ |
varchar2 |
||||
ISXF_ |
varchar2 |
||||
ISYS_ |
varchar2 |
||||
ITYP_ |
varchar2 |
||||
LINK_ |
varchar2 |
||||
LOC_ |
varchar2 |
||||
ORD_ |
double |
||||
ORD_ |
double |
||||
ORG_ |
varchar2 |
||||
PC_ |
varchar2 |
||||
PIP_ |
number |
||||
PIP_ |
number |
||||
POL_ID |
varchar2 |
||||
POP_ |
number |
||||
POP_ |
number |
||||
PREF_ |
datetime |
||||
PROJ_ |
varchar2 |
||||
PROJ_ |
varchar2 |
||||
PROJ_ |
int32 |
||||
PX_ |
number |
||||
PXDIF_ |
number |
||||
PXDIF_ |
number |
||||
REC_ |
char |
||||
REC_ID |
varchar2 |
||||
REM_ |
double |
||||
REVA_ |
number |
||||
SPL_ID |
varchar2 |
||||
UNT_ |
varchar2 |
||||
UNT_ |
varchar2 |
||||
UNT_ |
number |
||||
UNT_PX |
number |
||||
VAT_ |
number |
||||
VAT_ |
varchar2 |
||||
VAT_ |
number |
||||
WHS_ |
varchar2 |
||||
XML_ |
varchar2 |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: