invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

OPENITEM: AccountView Open items

read only per partition

  • Catalogus: AccountView
  • Label: Open items

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel OPENITEM 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
AG_DATE datetime Scheduling date
AG_PAYREF varchar2(19) Acceptgiro payment reference
AMT_INT int64 Interest/costs
AMT_MARK int64 Open amount when marking
AMT_PAY int64 Amount payable
AMT_PAYN int64 Amount payable (negative)
ASTERIK varchar2(1) Asterisk for overdue invoice
AUTH_DATE datetime Approval date
AUTH_EMP varchar2(10) Approving employee
BANK_ACCT varchar2(10) Bank account field name
BANK_ACCTV varchar2(42) Bank account
CNG_DATE datetime Datum van laatste wijziging
CNG_NR int32 Nummer wijzigen
COLL_DATE datetime Date handed over
COMMENT1 varchar2(4) Note
COST_CODE varchar2(10) Cost centre code
CR_AMT int64 Kredietbedrag
CRED_DAYS decimal Betalingstermijn in dagen
CRED_SHOW char Supplier
CUR_CAMT int64 Currency amount (credit)
CUR_CODE varchar2(3) Currency code
CUR_DAMT int64 Currency amount (debit)
CUR_INT int64 Currency amount interest/costs
CUR_SIGN varchar2(1) Currency symbol
DATE_PAID datetime Date paid
DD_ACT char Automatische incasso
DEB_SHOW char Customer
DISC_DAYS decimal Kortingsperiode in dagen
DISP_INV char Manually blocked for automatic payment/direct debit
DJ_CODE varchar2(3) Tijdschriftcode
DOC_ID varchar2(32) Document code
DOC_TYPE int32 Document type
DR_AMT int64 Afschrijvingsbedrag
DR_TYPE char Debit type
EXT_ID varchar2(32) External identification
EXT_TYPE decimal External source
FIAT_PRIO decimal Approval priority
GREK_TYPE varchar2(1) Transaction type G-account
HAS_COMM char Note present
INP_DATE datetime Datum van inschrijving
INV_NR varchar2(12) Document-/factuurnummer
IS_EURO char Payment in euros
IT_ORIGD_E int64 Original amount in euros
IT_PAID_EU int64 Paid in euros
ITEM_AGE decimal Number of days open
ITEM_BAL int64 Open amount
ITEM_BAL_E int64 Open amount in euros
ITEM_BALC int64 Open amount (credit)
ITEM_CAMT int64 Currency amount
ITEM_CAMTC int64 Currency amount (payment)
ITEM_CAMTD int64 Currency amount (receipt)
ITEM_CPAYI int64 Currency amount including interest/costs
ITEM_DSCDT datetime Discount due date
ITEM_EXPDS decimal Number of days overdue
ITEM_EXPDT datetime Vervaldatum
ITEM_EXPPG decimal Number of days overdue (negative number of days)
ITEM_ORIGC int64 Original amount (credit)
ITEM_ORIGD int64 Original amount
ITEM_PAID int64 Paid
ITEM_PAYC int64 Amount after discount (credit)
ITEM_PAYD int64 Amount after discount
ITEM_PAYI int64 Amount including interest/costs
ITEM_PDPG int64 Payment discount amount (direct debit)
ITEM_PROC char Processed
ITEM_REC int64 Amount receivable
ITEM_REST int64 Resterend bedrag
MAND_B2B char Type automatische incasso: zakelijk
MAND_DATE datetime Datum van ondertekening
MAND_ID varchar2(35) Direct debit mandate reference
MAND_SEQ int32 Machtiging voor automatische incasso
MARK_DD char Marked for direct debit
MARK_PG char Marked for payment
OI_STAT decimal Approval status
PAGE_NR varchar2(10) Paginanummer
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PAY_COLL char Item handed over
PAY_DESC varchar2(130) Payment reference
PAY_ID varchar2(10) Payment file code
PAY_PROM datetime Promised payment date
PD_AMT int64 Bedrag van de betalingskorting
PD_PCT decimal Kortingspercentage bij betaling
PG_BLK char Geblokkeerd voor automatische betaling
PMT_AMT decimal Amount payable FC
PMT_AMTN decimal Amount payable FC (-)
PMT_ARTS varchar2(2) Artikelnummer voor doorvoer
PMT_CHQ char Betaling per cheque
PMT_CRECV char Alle bankkosten komen ten laste van de begunstigde
PMT_CSEND char Kosten van andere banken ten laste van de hoofdsom
PMT_CURR varchar2(3) Payment currency code
PMT_DESC varchar2(80) Beschrijving voor DNB
PMT_FAST char Dringende buitenlandse betaling
PMT_GOODS varchar2(2) Goederencode
PMT_ORD1 varchar2(2) Betalingsinstructiecode 1
PMT_ORD2 varchar2(2) Betalingsinstructiecode 2
PMT_ORD3 varchar2(2) Betalingsinstructiecode 3
PMT_ORD4 varchar2(2) Betalingsinstructiecode 4
PMT_TYPE varchar2(2) Verslaglegging inzake deviezen
POST_TYPE decimal Write-off code
PROJ_CODE varchar2(10) Projectcode
REM_BLK char Geblokkeerd vanwege herinneringen
REM_CNT decimal Number of times reminded
REM_DATE datetime Date of last reminder
REM_DAYS decimal Number of days since last reminder
SUB_NR varchar2(10) Klant-/leveranciersnummer
SUM_BAL_EU int64 Overdue outstanding amount in euros
SUM_IT_BAL int64 Overdue outstanding amount
TO_PAY int64 To be paid
TRANSPORT varchar2(16) Carried-forward amount
TRN_DATE datetime Factuurdatum
TRN_DESC varchar2(40) Omschrijving van de factuur