DAILY: AccountView Journals
read only per partition
- Catalogo:
AccountView - Label: Journals
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella DAILY. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |