DAILY: AccountView Journals
read only per partition
- Catálogo:
AccountView - Label: Journals
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla DAILY. 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 |
|---|---|---|---|---|---|
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 |