av_art_line: 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_line 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 |
|---|---|---|---|---|---|
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
What changed per release in the tables, columns, attributes and capabilities of the driver: