invantive documentation
Invantive SupportforenAnmelden / Eintragen

DAILY: AccountView Journals

read only per partition

  • Katalog: AccountView
  • Label: Journals

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle DAILY 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
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