invantive documentation
Invantive SupportforenAnmelden / Eintragen

OPENITEM: AccountView Open items

read only per partition

  • Katalog: AccountView
  • Label: Open items

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle OPENITEM sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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 Date last modified
CNG_NR int32 Change number
COLL_DATE datetime Date handed over
COMMENT1 varchar2(4) Note
COST_CODE varchar2(10) Cost centre code
CR_AMT int64 Credit amount
CRED_DAYS decimal Payment term in days
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 Direct debit
DEB_SHOW char Customer
DISC_DAYS decimal Discount term in days
DISP_INV char Manually blocked for automatic payment/direct debit
DJ_CODE varchar2(3) Journal code
DOC_ID varchar2(32) Document code
DOC_TYPE int32 Document type
DR_AMT int64 Debit amount
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 Entry date
INV_NR varchar2(12) Document/invoice number
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 Due date
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 Remaining amount
MAND_B2B char Direct debit type: business
MAND_DATE datetime Signature date
MAND_ID varchar2(35) Direct debit mandate reference
MAND_SEQ int32 Direct debit mandate
MARK_DD char Marked for direct debit
MARK_PG char Marked for payment
OI_STAT decimal Approval status
PAGE_NR varchar2(10) Page number
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 Payment discount amount
PD_PCT decimal Payment discount percentage
PG_BLK char Blocked for automatic payment
PMT_AMT decimal Amount payable FC
PMT_AMTN decimal Amount payable FC (-)
PMT_ARTS varchar2(2) Item number for transit
PMT_CHQ char Payment by cheque
PMT_CRECV char All bank charges for account of beneficiary
PMT_CSEND char Charges of other banks for account of principal
PMT_CURR varchar2(3) Payment currency code
PMT_DESC varchar2(80) Description for DNB
PMT_FAST char Urgent foreign payment
PMT_GOODS varchar2(2) Goods code
PMT_ORD1 varchar2(2) Payment instruction code 1
PMT_ORD2 varchar2(2) Payment instruction code 2
PMT_ORD3 varchar2(2) Payment instruction code 3
PMT_ORD4 varchar2(2) Payment instruction code 4
PMT_TYPE varchar2(2) Foreign exchange reporting
POST_TYPE decimal Write-off code
PROJ_CODE varchar2(10) Project code
REM_BLK char Blocked for reminders
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) Customer/supplier number
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 Invoice date
TRN_DESC varchar2(40) Invoice description