OPENITEM: AccountView Open items
read only per partition
- Catálogo:
AccountView - Label: Open items
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla OPENITEM. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |