av_art_hdr: 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_hdr 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 |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
||||
APX_ |
varchar2 |
||||
ASS_ |
varchar2 |
||||
AUTH_ |
varchar2 |
||||
BLK_ |
number |
||||
BLK_ |
number |
||||
BV_AMT |
number |
||||
BV_CUR |
number |
||||
COMMENT1 |
varchar2 |
||||
COMMENT2 |
varchar2 |
||||
COMMENT3 |
varchar2 |
||||
COST_ |
varchar2 |
||||
CPY_ |
varchar2 |
||||
CPY_ |
varchar2 |
||||
CRED_ |
number |
||||
CUR_ |
varchar2 |
||||
DD_ACT |
char |
||||
DEL_ |
varchar2 |
||||
DEL_CP |
varchar2 |
||||
DEL_ |
datetime |
||||
DISC_ |
varchar2 |
||||
DISC_ |
number |
||||
DJ_ |
varchar2 |
||||
DJ_ |
char |
||||
DOC_NR |
varchar2 |
||||
EMP_NR |
varchar2 |
||||
EXCH_ |
double |
||||
EXT_ |
varchar2 |
||||
EXT_ID |
varchar2 |
||||
EXT_ |
int32 |
||||
HDR_ |
number |
||||
INV_CP |
varchar2 |
||||
INV_ |
datetime |
||||
INV_NR |
varchar2 |
||||
LB_AMT |
number |
||||
LB_CUR |
number |
||||
MAND_ |
char |
||||
MAND_ |
datetime |
||||
MAND_ |
varchar2 |
||||
MAND_ |
int32 |
||||
OC_CUR |
number |
||||
ORD_ |
number |
||||
ORD_ |
number |
||||
ORD_ |
datetime |
||||
ORD_NR |
varchar2 |
||||
ORD_ |
number |
||||
PAC_NR |
varchar2 |
||||
PAGE_ |
varchar2 |
||||
PAY_ |
number |
||||
PAY_ |
number |
||||
PAY_ |
number |
||||
PAY_ |
varchar2 |
||||
PCT_ |
varchar2 |
||||
PD_AMT |
number |
||||
PD_PCT |
number |
||||
PD_VAT |
number |
||||
PDA_ |
number |
||||
PDV_ |
number |
||||
PERIOD |
number |
||||
PREF_ |
datetime |
||||
PROJ_ |
varchar2 |
||||
QT_ |
varchar2 |
||||
REC_ID |
varchar2 |
||||
RPL_ |
varchar2 |
||||
RPL_ |
varchar2 |
||||
SBS_NR |
varchar2 |
||||
SC_CUR |
number |
||||
SEL_ |
varchar2 |
||||
SG_ |
varchar2 |
||||
SHIP_ |
number |
||||
SHIP_ |
varchar2 |
||||
SUB_ |
number |
||||
SUB_ |
number |
||||
TRN_ |
char |
||||
TRN_ |
int32 |
||||
TRN_ |
int32 |
||||
VAT_ |
number |
||||
VAT_ |
number |
||||
VAT_ |
number |
||||
VAT_ |
number |
||||
VC_ORD |
varchar2 |
||||
VC_ |
varchar2 |
||||
VO_CUR |
number |
||||
VS_CUR |
number |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: