av_art_hdr: Visual FoxPro
insert update delete per partition
- Catalog: ``
Can retrieve data and change data using insert, update and delete.
Table Columns
The columns of the table av_art_hdr are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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
What changed per release in the tables, columns, attributes and capabilities of the driver: