DAILY: AccountView Journals
read only per partition
- Catalogue :
AccountView - Label: Journals
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table DAILY sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Payments in transit account | |||
ACCT_ |
varchar2 |
Receipts in transit account | |||
BNK_ |
varchar2 |
Compte bancaire de journal | |||
BNK_ |
varchar2 |
Compte bancaire de journal | |||
BNK_ |
varchar2 |
Code bancaire | |||
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 de modification | |||
CNG_NR |
int32 |
Modifier le numéro | |||
CNG_ |
varchar2 |
Employee last modified | |||
CNT_ |
varchar2 |
Code ISO du pays | |||
CRED_ |
int64 |
Bank account credit limit | |||
DJ_ |
varchar2 |
Compte associé | |||
DJ_ |
varchar2 |
Code de la revue | |||
DJ_ |
char |
Summarised posting | |||
DJ_EXT |
char |
External journal | |||
DJ_ |
varchar2 |
Nom de la revue | |||
DJ_ |
decimal |
Journal owner | |||
DJ_ |
char |
Bank reconciliation | |||
DJ_ |
decimal |
Journal type (numeric) | |||
DJ_ |
varchar2 |
Type de journal | |||
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 |
Date d'inscription | |||
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 |