OPENITEM: AccountView Open items
read only per partition
- Katalog:
AccountView - Label: Open items
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle OPENITEM sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | 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 last modified | |||
CNG_NR |
int32 |
Change number | |||
COLL_ |
datetime |
Date handed over | |||
COMMENT1 |
varchar2 |
Note | |||
COST_ |
varchar2 |
Cost centre code | |||
CR_AMT |
int64 |
Credit amount | |||
CRED_ |
decimal |
Payment term in days | |||
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 |
Direct debit | |||
DEB_ |
char |
Customer | |||
DISC_ |
decimal |
Discount term in days | |||
DISP_ |
char |
Manually blocked for automatic payment/direct debit | |||
DJ_ |
varchar2 |
Journal code | |||
DOC_ID |
varchar2 |
Document code | |||
DOC_ |
int32 |
Document type | |||
DR_AMT |
int64 |
Debit amount | |||
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 |
Entry date | |||
INV_NR |
varchar2 |
Document/invoice number | |||
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 |
Due date | |||
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 |
Remaining amount | |||
MAND_ |
char |
Direct debit type: business | |||
MAND_ |
datetime |
Signature date | |||
MAND_ |
varchar2 |
Direct debit mandate reference | |||
MAND_ |
int32 |
Direct debit mandate | |||
MARK_ |
char |
Marked for direct debit | |||
MARK_ |
char |
Marked for payment | |||
OI_ |
decimal |
Approval status | |||
PAGE_ |
varchar2 |
Page number | |||
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 |
Payment discount amount | |||
PD_PCT |
decimal |
Payment discount percentage | |||
PG_BLK |
char |
Blocked for automatic payment | |||
PMT_ |
decimal |
Amount payable FC | |||
PMT_ |
decimal |
Amount payable FC (-) | |||
PMT_ |
varchar2 |
Item number for transit | |||
PMT_ |
char |
Payment by cheque | |||
PMT_ |
char |
All bank charges for account of beneficiary | |||
PMT_ |
char |
Charges of other banks for account of principal | |||
PMT_ |
varchar2 |
Payment currency code | |||
PMT_ |
varchar2 |
Description for DNB | |||
PMT_ |
char |
Urgent foreign payment | |||
PMT_ |
varchar2 |
Goods code | |||
PMT_ |
varchar2 |
Payment instruction code 1 | |||
PMT_ |
varchar2 |
Payment instruction code 2 | |||
PMT_ |
varchar2 |
Payment instruction code 3 | |||
PMT_ |
varchar2 |
Payment instruction code 4 | |||
PMT_ |
varchar2 |
Foreign exchange reporting | |||
POST_ |
decimal |
Write-off code | |||
PROJ_ |
varchar2 |
Project code | |||
REM_ |
char |
Blocked for reminders | |||
REM_ |
decimal |
Number of times reminded | |||
REM_ |
datetime |
Date of last reminder | |||
REM_ |
decimal |
Number of days since last reminder | |||
SUB_NR |
varchar2 |
Customer/supplier number | |||
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 |
Invoice date | |||
TRN_ |
varchar2 |
Invoice description |