DAILY: AccountView Journals
read only per partition
- Catalogus:
AccountView - Label: Journals
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel DAILY worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Payments in transit account | |||
ACCT_ |
varchar2 |
Receipts in transit account | |||
BNK_ |
varchar2 |
Bankrekening van het tijdschrift | |||
BNK_ |
varchar2 |
Bankrekening van het tijdschrift | |||
BNK_ |
varchar2 |
Bankcode | |||
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 |
Datum van wijziging | |||
CNG_NR |
int32 |
Nummer wijzigen | |||
CNG_ |
varchar2 |
Employee last modified | |||
CNT_ |
varchar2 |
ISO-landcode | |||
CRED_ |
int64 |
Bank account credit limit | |||
DJ_ |
varchar2 |
Gekoppeld account | |||
DJ_ |
varchar2 |
Tijdschriftcode | |||
DJ_ |
char |
Summarised posting | |||
DJ_EXT |
char |
External journal | |||
DJ_ |
varchar2 |
Naam van het tijdschrift | |||
DJ_ |
decimal |
Journal owner | |||
DJ_ |
char |
Bank reconciliation | |||
DJ_ |
decimal |
Journal type (numeric) | |||
DJ_ |
varchar2 |
Soort tijdschrift | |||
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 |
Datum van inschrijving | |||
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 |