TRANSIT: AccountView Prepayments and accruals
read only per partition
- Catálogo:
AccountView - Label: Prepayments and accruals
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla TRANSIT. 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 |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Account number | |||
AMOUNT |
int64 |
Transaction amount | |||
COST_ |
varchar2 |
Cost centre code | |||
CUR_ |
int64 |
Currency amount | |||
CUR_ |
varchar2 |
Currency code | |||
DIST_ |
varchar2 |
Allocation key | |||
DIST_ |
decimal |
Quantity (allocation key) | |||
DJ_ |
varchar2 |
Journal code | |||
INV_NR |
varchar2 |
Document/invoice number | |||
PAGE_ |
varchar2 |
Page number | |||
PART_ |
varchar2 |
Partner | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_ |
varchar2 |
Cost type code | |||
PD_AMT |
int64 |
Payment discount amount | |||
PD_PCT |
decimal |
Payment discount percentage | |||
PERIOD |
decimal |
Period | |||
PROJ_ |
varchar2 |
Project code | |||
REC_ID |
varchar2 |
Unique code | |||
SRC_ID |
varchar2 |
Source identification | |||
SRC_ |
decimal |
Source type | |||
SUB_NR |
varchar2 |
Customer/supplier number | |||
TRN_ |
datetime |
Change date | |||
TRN_ |
varchar2 |
Prepayment/accrual description | |||
TRN_ |
decimal |
Quantity | |||
TRN_ |
decimal |
Weight | |||
VAT_ |
varchar2 |
Código VAT |