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_ |
varchar2 |
Payments in transit account | |||
ACCT_ |
varchar2 |
Receipts in transit account | |||
BNK_ |
varchar2 |
Journal bank account | |||
BNK_ |
varchar2 |
Journal bank account | |||
BNK_ |
varchar2 |
Bank code | |||
CHECK_ |
varchar2 |
Last used cheque number | |||
CHK_ |
char |
Check page balances | |||
CHK_ |
char |
Check differences | |||
CLT_ |
char |
Blocked for client | |||
CNG_ |
char |
Manual changes blocked | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
CNT_ |
varchar2 |
ISO country code | |||
CRED_ |
int64 |
Bank account credit limit | |||
DJ_ |
varchar2 |
Linked account | |||
DJ_ |
varchar2 |
Journal code | |||
DJ_ |
char |
Summarised posting | |||
DJ_EXT |
char |
External journal | |||
DJ_ |
varchar2 |
Journal name | |||
DJ_ |
decimal |
Journal owner | |||
DJ_ |
char |
Bank reconciliation | |||
DJ_ |
decimal |
Journal type (numeric) | |||
DJ_ |
varchar2 |
Journal type | |||
DJP_ |
char |
Automatically block page | |||
EXCH_ |
decimal |
Exchange status | |||
GREK_ |
char |
Blocked bank account | |||
GROSS_ |
char |
Gross entry | |||
HDR_ |
int32 |
Journal page description | |||
IBAN_ |
varchar2 |
IBAN | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LAY_ |
varchar2 |
Cheque layout | |||
LAY_ |
varchar2 |
Cheque remittance layout | |||
LINE_ |
int32 |
Journal lines description | |||
LST_ |
varchar2 |
Last imported bank statement | |||
NUM_ |
char |
Automatically assign document/invoice numbers | |||
NUM_ |
decimal |
Document/invoice number group | |||
PA_ |
varchar2 |
Partner | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PD_ |
int32 |
Payment reference | |||
SEND_ |
char |
Require new pages to be sent into the workflow | |||
SYS_ |
char |
System validations |