OPENITEM: AccountView Open items
read only per partition
- Catalogue :
AccountView - Label: Open items
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table OPENITEM 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 |
|---|---|---|---|---|---|
AG_ |
datetime |
Scheduling date | |||
AG_ |
varchar2 |
Acceptgiro payment reference | |||
AMT_ |
int64 |
Interest/costs | |||
AMT_ |
int64 |
Open amount when marking | |||
AMT_ |
int64 |
Amount payable | |||
AMT_ |
int64 |
Amount payable (negative) | |||
ASTERIK |
varchar2 |
Asterisk for overdue invoice | |||
AUTH_ |
datetime |
Approval date | |||
AUTH_ |
varchar2 |
Approving employee | |||
BANK_ |
varchar2 |
Bank account field name | |||
BANK_ |
varchar2 |
Bank account | |||
CNG_ |
datetime |
Date de la dernière modification | |||
CNG_NR |
int32 |
Modifier le numéro | |||
COLL_ |
datetime |
Date handed over | |||
COMMENT1 |
varchar2 |
Note | |||
COST_ |
varchar2 |
Cost centre code | |||
CR_AMT |
int64 |
Montant du crédit | |||
CRED_ |
decimal |
Délai de paiement en jours | |||
CRED_ |
char |
Supplier | |||
CUR_ |
int64 |
Currency amount (credit) | |||
CUR_ |
varchar2 |
Currency code | |||
CUR_ |
int64 |
Currency amount (debit) | |||
CUR_ |
int64 |
Currency amount interest/costs | |||
CUR_ |
varchar2 |
Currency symbol | |||
DATE_ |
datetime |
Date paid | |||
DD_ACT |
char |
Prélèvement automatique | |||
DEB_ |
char |
Customer | |||
DISC_ |
decimal |
Durée de la remise en jours | |||
DISP_ |
char |
Manually blocked for automatic payment/direct debit | |||
DJ_ |
varchar2 |
Code de la revue | |||
DOC_ID |
varchar2 |
Document code | |||
DOC_ |
int32 |
Document type | |||
DR_AMT |
int64 |
Montant du débit | |||
DR_ |
char |
Debit type | |||
EXT_ID |
varchar2 |
External identification | |||
EXT_ |
decimal |
External source | |||
FIAT_ |
decimal |
Approval priority | |||
GREK_ |
varchar2 |
Transaction type G-account | |||
HAS_ |
char |
Note present | |||
INP_ |
datetime |
Date d'inscription | |||
INV_NR |
varchar2 |
Numéro du document/de la facture | |||
IS_ |
char |
Payment in euros | |||
IT_ |
int64 |
Original amount in euros | |||
IT_ |
int64 |
Paid in euros | |||
ITEM_ |
decimal |
Number of days open | |||
ITEM_ |
int64 |
Open amount | |||
ITEM_ |
int64 |
Open amount in euros | |||
ITEM_ |
int64 |
Open amount (credit) | |||
ITEM_ |
int64 |
Currency amount | |||
ITEM_ |
int64 |
Currency amount (payment) | |||
ITEM_ |
int64 |
Currency amount (receipt) | |||
ITEM_ |
int64 |
Currency amount including interest/costs | |||
ITEM_ |
datetime |
Discount due date | |||
ITEM_ |
decimal |
Number of days overdue | |||
ITEM_ |
datetime |
Date d'échéance | |||
ITEM_ |
decimal |
Number of days overdue (negative number of days) | |||
ITEM_ |
int64 |
Original amount (credit) | |||
ITEM_ |
int64 |
Original amount | |||
ITEM_ |
int64 |
Paid | |||
ITEM_ |
int64 |
Amount after discount (credit) | |||
ITEM_ |
int64 |
Amount after discount | |||
ITEM_ |
int64 |
Amount including interest/costs | |||
ITEM_ |
int64 |
Payment discount amount (direct debit) | |||
ITEM_ |
char |
Processed | |||
ITEM_ |
int64 |
Amount receivable | |||
ITEM_ |
int64 |
Montant restant | |||
MAND_ |
char |
Type de prélèvement automatique : professionnel | |||
MAND_ |
datetime |
Date de signature | |||
MAND_ |
varchar2 |
Direct debit mandate reference | |||
MAND_ |
int32 |
Autorisation de prélèvement automatique | |||
MARK_ |
char |
Marked for direct debit | |||
MARK_ |
char |
Marked for payment | |||
OI_ |
decimal |
Approval status | |||
PAGE_ |
varchar2 |
Numéro de page | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PAY_ |
char |
Item handed over | |||
PAY_ |
varchar2 |
Payment reference | |||
PAY_ID |
varchar2 |
Payment file code | |||
PAY_ |
datetime |
Promised payment date | |||
PD_AMT |
int64 |
Montant de la remise sur paiement | |||
PD_PCT |
decimal |
Pourcentage de remise sur le paiement | |||
PG_BLK |
char |
Bloqué pour le paiement automatique | |||
PMT_ |
decimal |
Amount payable FC | |||
PMT_ |
decimal |
Amount payable FC (-) | |||
PMT_ |
varchar2 |
Numéro d'article pour le transport | |||
PMT_ |
char |
Paiement par chèque | |||
PMT_ |
char |
Tous les frais bancaires sont à la charge du bénéficiaire | |||
PMT_ |
char |
Frais prélevés par d'autres banques pour le compte du titulaire du compte | |||
PMT_ |
varchar2 |
Payment currency code | |||
PMT_ |
varchar2 |
Description du DNB | |||
PMT_ |
char |
Paiement international urgent | |||
PMT_ |
varchar2 |
Code article | |||
PMT_ |
varchar2 |
Code d'instruction de paiement 1 | |||
PMT_ |
varchar2 |
Code d'instruction de paiement 2 | |||
PMT_ |
varchar2 |
Code d'instruction de paiement 3 | |||
PMT_ |
varchar2 |
Code d'instruction de paiement 4 | |||
PMT_ |
varchar2 |
Déclaration des opérations de change | |||
POST_ |
decimal |
Write-off code | |||
PROJ_ |
varchar2 |
Code du projet | |||
REM_ |
char |
Bloqué pour les rappels | |||
REM_ |
decimal |
Number of times reminded | |||
REM_ |
datetime |
Date of last reminder | |||
REM_ |
decimal |
Number of days since last reminder | |||
SUB_NR |
varchar2 |
Numéro de client/fournisseur | |||
SUM_ |
int64 |
Overdue outstanding amount in euros | |||
SUM_ |
int64 |
Overdue outstanding amount | |||
TO_PAY |
int64 |
To be paid | |||
TRANSPORT |
varchar2 |
Carried-forward amount | |||
TRN_ |
datetime |
Date de la facture | |||
TRN_ |
varchar2 |
Description de la facture |