TRANSACT: AccountView Journal
read only per partition
- Catálogo:
AccountView - Label: Journal
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla TRANSACT. 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 | |||
ACT_ |
int64 |
Actual costs | |||
ACT_ |
int64 |
Actual revenues | |||
ADM_ |
varchar2 |
Administration code | |||
AMOUNT |
int64 |
Transaction amount | |||
BASE_ |
int64 |
VAT base amount | |||
CHK_ID |
varchar2 |
Reconciliation number | |||
CN_ID |
varchar2 |
Unique consolidation code | |||
COGS_ |
int64 |
Precio de Costo | |||
COGS_ |
decimal |
Cost price quantity | |||
COST_ |
varchar2 |
Cost centre code | |||
CST_ |
int64 |
Amount posted | |||
CUR_ |
int64 |
Currency amount | |||
CUR_ |
varchar2 |
Currency code | |||
DECL_ |
int64 |
Chargeable amount | |||
DIST_ |
varchar2 |
Allocation key | |||
DIST_ |
decimal |
Quantity | |||
DJ_ |
varchar2 |
Journal code | |||
EXCH_ |
decimal |
Exchange rate | |||
GREK_ |
varchar2 |
Transaction type G-account | |||
INV_ |
varchar2 |
Transaction invoice description | |||
INV_NR |
varchar2 |
Document/invoice number | |||
ITEM_ |
varchar2 |
Transaction description | |||
ITEM_ |
decimal |
Quantity (agr) | |||
LINK_ |
varchar2 |
Project journal link | |||
MND_ |
int32 |
Months | |||
OBLI_ |
varchar2 |
Commitment number | |||
PA_ |
varchar2 |
Partner as dimension | |||
PAGE_ |
varchar2 |
Page number (sign) | |||
PAGE_ |
decimal |
Page number | |||
PART_ |
varchar2 |
Partner | |||
PART_ |
varchar2 |
Partner as dimension | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_ |
varchar2 |
Cost type code | |||
PC_DIM |
varchar2 |
Cost type as dimension | |||
PER_ |
int32 |
Period calculated | |||
PER_ |
decimal |
Project period | |||
PERIOD |
int32 |
Period | |||
PROJ_ |
varchar2 |
Project code | |||
QTR_ |
int32 |
Quarters | |||
REC_ID |
varchar2 |
Unique code | |||
RES_ID |
varchar2 |
Source identification | |||
REV_ |
int64 |
Reversed amount | |||
RNG_ |
varchar2 |
Partner administration | |||
SELL_ |
int64 |
Amount to be invoiced | |||
SELL_ |
decimal |
Quantity to be invoiced | |||
SRC_ID |
varchar2 |
Source identification | |||
SRC_ |
decimal |
Source type | |||
SUB_NR |
varchar2 |
Customer/supplier number | |||
TRN_ |
datetime |
Change date | |||
TRN_ |
varchar2 |
Transaction description | |||
TRN_ |
decimal |
Quantity (agr) | |||
TRN_ |
decimal |
Weight | |||
VAT_ |
int64 |
Cantidad VAT | |||
VAT_ |
varchar2 |
Código VAT | |||
VOUCHER_ |
varchar2 |
Document number | |||
WKR_ |
char |
Transaction charged to free allowance WKR | |||
XML_ |
varchar2 |
Data in XML format |