invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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_NR varchar2(10)
APX_LIST varchar2(5)
ASS_CODE varchar2(10)
AUTH_HIST varchar2
BLK_AMT number
BLK_CUR number
BV_AMT number
BV_CUR number
COMMENT1 varchar2(40)
COMMENT2 varchar2
COMMENT3 varchar2
COST_CODE varchar2(10)
CPY_PRN varchar2(100)
CPY_PRTYPE varchar2(40)
CRED_DAYS number
CUR_CODE varchar2(3)
DD_ACT char
DEL_ADDR varchar2
DEL_CP varchar2(40)
DEL_DATE datetime
DISC_CODE varchar2(2)
DISC_DAYS number
DJ_CODE varchar2(3)
DJ_POST char
DOC_NR varchar2(10)
EMP_NR varchar2(10)
EXCH_RATE double
EXT_DESC varchar2(40)
EXT_ID varchar2(32)
EXT_TYPE int32
HDR_TYPE number
INV_CP varchar2(40)
INV_DATE datetime
INV_NR varchar2(10)
LB_AMT number
LB_CUR number
MAND_B2B char
MAND_DATE datetime
MAND_ID varchar2(35)
MAND_SEQ int32
OC_CUR number
ORD_COST number
ORD_CUR number
ORD_DATE datetime
ORD_NR varchar2(10)
ORD_TOT number
PAC_NR varchar2(10)
PAGE_NR varchar2(10)
PAY_AMT number
PAY_CUR number
PAY_VAT number
PAY_VATC varchar2(2)
PCT_LIST varchar2(5)
PD_AMT number
PD_PCT number
PD_VAT number
PDA_CUR number
PDV_CUR number
PERIOD number
PREF_DATE datetime
PROJ_CODE varchar2(10)
QT_ORD_NR varchar2(10)
REC_ID varchar2(10)
RPL_DEL varchar2(10)
RPL_INV varchar2(10)
SBS_NR varchar2(10)
SC_CUR number
SEL_CODE varchar2(5)
SG_CODE varchar2(10)
SHIP_COST number
SHIP_MTH varchar2(10)
SUB_CUR number
SUB_TOT number
TRN_BOOK char
TRN_CNT int32
TRN_START int32
VAT_CUR number
VAT_ORD number
VAT_SHIP number
VAT_TOT number
VC_ORD varchar2(2)
VC_SHIP varchar2(2)
VO_CUR number
VS_CUR number

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: