invantive documentation
Invantive Support ForumsLog In / Sign Up

DAILY: AccountView Journals

read only per partition

  • Catalog: AccountView
  • Label: Journals

Can only retrieve data.

Table Columns

The columns of the table DAILY 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 Marks Documentation
ACCT_PUW varchar2(10) Payments in transit account
ACCT_RUW varchar2(10) Receipts in transit account
BNK_ACCT varchar2(34) Journal bank account
BNK_ACCTV varchar2(42) Journal bank account
BNK_CODE varchar2(10) Bank code
CHECK_NR varchar2(25) Last used cheque number
CHK_BAL char Check page balances
CHK_DIF char Check differences
CLT_BLK char Blocked for client
CNG_BLK char Manual changes blocked
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
CNT_CODE varchar2(2) ISO country code
CRED_LIM int64 Bank account credit limit
DJ_ACCT varchar2(10) Linked account
DJ_CODE varchar2(3) Journal code
DJ_COMB char Summarised posting
DJ_EXT char External journal
DJ_NAME varchar2(40) Journal name
DJ_OWNER decimal Journal owner
DJ_RECON char Bank reconciliation
DJ_TYPE decimal Journal type (numeric)
DJ_TYPEV varchar2(20) Journal type
DJP_BLK char Automatically block page
EXCH_STAT decimal Exchange status
GREK_BANK char Blocked bank account
GROSS_FLG char Gross entry
HDR_DESC int32 Journal page description
IBAN_NR varchar2(34) IBAN
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
LAY_CHECK varchar2(250) Cheque layout
LAY_REMIT varchar2(250) Cheque remittance layout
LINE_DESC int32 Journal lines description
LST_STMT varchar2(5) Last imported bank statement
NUM_AUTO char Automatically assign document/invoice numbers
NUM_GRP decimal Document/invoice number group
PA_CODE varchar2(10) Partner
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PD_DESC int32 Payment reference
SEND_APPR char Require new pages to be sent into the workflow
SYS_VAL char System validations