TRANSACT: AccountView Journal
read only per partition
- Catalogo:
AccountView - Label: Journal
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella TRANSACT. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Costi | |||
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 |
Importo IVA | |||
VAT_ |
varchar2 |
Codice IVA | |||
VOUCHER_ |
varchar2 |
Document number | |||
WKR_ |
char |
Transaction charged to free allowance WKR | |||
XML_ |
varchar2 |
Data in XML format |