OPENITEM: AccountView Open items
read only per partition
- Catalogus:
AccountView - Label: Open items
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel OPENITEM 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 |
|---|---|---|---|---|---|
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 |
Datum van laatste wijziging | |||
CNG_NR |
int32 |
Nummer wijzigen | |||
COLL_ |
datetime |
Date handed over | |||
COMMENT1 |
varchar2 |
Note | |||
COST_ |
varchar2 |
Cost centre code | |||
CR_AMT |
int64 |
Kredietbedrag | |||
CRED_ |
decimal |
Betalingstermijn in dagen | |||
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 |
Automatische incasso | |||
DEB_ |
char |
Customer | |||
DISC_ |
decimal |
Kortingsperiode in dagen | |||
DISP_ |
char |
Manually blocked for automatic payment/direct debit | |||
DJ_ |
varchar2 |
Tijdschriftcode | |||
DOC_ID |
varchar2 |
Document code | |||
DOC_ |
int32 |
Document type | |||
DR_AMT |
int64 |
Afschrijvingsbedrag | |||
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 |
Datum van inschrijving | |||
INV_NR |
varchar2 |
Document-/factuurnummer | |||
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 |
Vervaldatum | |||
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 |
Resterend bedrag | |||
MAND_ |
char |
Type automatische incasso: zakelijk | |||
MAND_ |
datetime |
Datum van ondertekening | |||
MAND_ |
varchar2 |
Direct debit mandate reference | |||
MAND_ |
int32 |
Machtiging voor automatische incasso | |||
MARK_ |
char |
Marked for direct debit | |||
MARK_ |
char |
Marked for payment | |||
OI_ |
decimal |
Approval status | |||
PAGE_ |
varchar2 |
Paginanummer | |||
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 |
Bedrag van de betalingskorting | |||
PD_PCT |
decimal |
Kortingspercentage bij betaling | |||
PG_BLK |
char |
Geblokkeerd voor automatische betaling | |||
PMT_ |
decimal |
Amount payable FC | |||
PMT_ |
decimal |
Amount payable FC (-) | |||
PMT_ |
varchar2 |
Artikelnummer voor doorvoer | |||
PMT_ |
char |
Betaling per cheque | |||
PMT_ |
char |
Alle bankkosten komen ten laste van de begunstigde | |||
PMT_ |
char |
Kosten van andere banken ten laste van de hoofdsom | |||
PMT_ |
varchar2 |
Payment currency code | |||
PMT_ |
varchar2 |
Beschrijving voor DNB | |||
PMT_ |
char |
Dringende buitenlandse betaling | |||
PMT_ |
varchar2 |
Goederencode | |||
PMT_ |
varchar2 |
Betalingsinstructiecode 1 | |||
PMT_ |
varchar2 |
Betalingsinstructiecode 2 | |||
PMT_ |
varchar2 |
Betalingsinstructiecode 3 | |||
PMT_ |
varchar2 |
Betalingsinstructiecode 4 | |||
PMT_ |
varchar2 |
Verslaglegging inzake deviezen | |||
POST_ |
decimal |
Write-off code | |||
PROJ_ |
varchar2 |
Projectcode | |||
REM_ |
char |
Geblokkeerd vanwege herinneringen | |||
REM_ |
decimal |
Number of times reminded | |||
REM_ |
datetime |
Date of last reminder | |||
REM_ |
decimal |
Number of days since last reminder | |||
SUB_NR |
varchar2 |
Klant-/leveranciersnummer | |||
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 |
Factuurdatum | |||
TRN_ |
varchar2 |
Omschrijving van de factuur |