invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

OPENITEM: AccountView Open items

read only per partition

  • Catálogo: AccountView
  • Label: Open items

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla OPENITEM. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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