av_art_line |
The data in this table is partitioned per value of the column.
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 |
Documentation |
|---|---|---|---|---|
AG_CODE |
string(5) |
|
|
|
AL_PROC |
boolean |
|
|
|
ART_AMT |
decimal |
|
|
|
ART_BM |
boolean |
|
|
|
ART_CA |
boolean |
|
|
|
ART_CODE |
string(15) |
|
|
|
ART_CUR |
decimal |
|
|
|
ART_DATE |
datetime |
|
|
|
ART_DESC1 |
string(40) |
|
|
|
ART_LEVEL |
int32 |
|
|
|
ART_PX |
decimal |
|
|
|
ART_QTY |
double |
|
|
|
ART_QTYU |
double |
|
|
|
BM_TAG |
string(10) |
|
|
|
COGS_AMT |
decimal |
|
|
|
COGS_SUSP |
boolean |
|
|
|
COST_CODE |
string(10) |
|
|
|
CUR_AMT |
decimal |
|
|
|
DISC_AMT |
decimal |
|
|
|
DISC_CUR |
decimal |
|
|
|
DISC_PCT |
decimal |
|
|
|
EMP_NR |
string(10) |
|
|
|
HDR_ID |
string(10) |
|
|
|
HDR_TYPE |
decimal |
|
|
|
ICAT_CODE |
string(1) |
|
|
|
ICNT_SRC |
string(2) |
|
|
|
ICNT_TGT |
string(2) |
|
|
|
INV_NR |
string(10) |
|
|
|
IS_CNTNR |
decimal |
|
|
|
IS_CUSTCD |
string(2) |
|
|
|
IS_MONTH |
decimal |
|
|
|
IS_WEIGHT |
decimal |
|
|
|
ISHP_CODE |
string(1) |
|
|
|
ISXF_CODE |
string(3) |
|
|
|
ISYS_CODE |
string(2) |
|
|
|
ITYP_CODE |
string(1) |
|
|
|
LINK_ID |
string(10) |
|
|
|
LOC_CODE |
string(5) |
|
|
|
ORD_QTY |
double |
|
|
|
ORD_QTYU |
double |
|
|
|
ORG_ORDNR |
string(10) |
|
|
|
PC_CODE |
string(5) |
|
|
|
PIP_AMT |
decimal |
|
|
|
PIP_CUR |
decimal |
|
|
|
POL_ID |
string(10) |
|
|
|
POP_AMT |
decimal |
|
|
|
POP_CUR |
decimal |
|
|
|
PREF_DATE |
datetime |
|
|
|
PROJ_CODE |
string(10) |
|
|
|
PROJ_ID |
string(10) |
|
|
|
PROJ_TYPE |
int32 |
|
|
|
PX_CALC |
decimal |
|
|
|
PXDIF_AMT |
decimal |
|
|
|
PXDIF_CUR |
decimal |
|
|
|
REC_BLK |
boolean |
|
|
|
REC_ID |
string(10) |
|
|
|
REM_QTY |
double |
|
|
|
REVA_AMT |
decimal |
|
|
|
SPL_ID |
string(10) |
|
|
|
UNT_CODE |
string(10) |
|
|
|
UNT_CODEP |
string(10) |
|
|
|
UNT_CUR |
decimal |
|
|
|
UNT_PX |
decimal |
|
|
|
VAT_AMT |
decimal |
|
|
|
VAT_CODE |
string(2) |
|
|
|
VAT_CUR |
decimal |
|
|
|
WHS_CODE |
string(5) |
|
|
|
XML_DATA |
string |
|
|
|
17-09-2025 17:51 Version 25.0.17-PROD+5535
Visual FoxPro Data Model