invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_NR varchar2(10) Account number
ACT_COST int64 Actual costs
ACT_PROC int64 Actual revenues
ADM_CODE varchar2(10) Administration code
AMOUNT int64 Transaction amount
BASE_AMT int64 VAT base amount
CHK_ID varchar2(10) Reconciliation number
CN_ID varchar2(10) Unique consolidation code
COGS_AMT int64 Costi
COGS_QTY decimal Cost price quantity
COST_CODE varchar2(10) Cost centre code
CST_AMT int64 Amount posted
CUR_AMT int64 Currency amount
CUR_CODE varchar2(3) Currency code
DECL_AMT int64 Chargeable amount
DIST_CODE varchar2(10) Allocation key
DIST_QTY decimal Quantity
DJ_CODE varchar2(3) Journal code
EXCH_RATE decimal Exchange rate
GREK_TYPE varchar2(1) Transaction type G-account
INV_DESC varchar2(40) Transaction invoice description
INV_NR varchar2(12) Document/invoice number
ITEM_DESC varchar2(40) Transaction description
ITEM_QTY decimal Quantity (agr)
LINK_ID varchar2(10) Project journal link
MND_PER int32 Months
OBLI_NR varchar2(10) Commitment number
PA_CODE varchar2(10) Partner as dimension
PAGE_NR varchar2(10) Page number (sign)
PAGE_NRV decimal Page number
PART_CODE varchar2(10) Partner
PART_RNG varchar2(20) Partner as dimension
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PC_CODE varchar2(5) Cost type code
PC_DIM varchar2(5) Cost type as dimension
PER_CALC int32 Period calculated
PER_PROJ decimal Project period
PERIOD int32 Period
PROJ_CODE varchar2(10) Project code
QTR_PER int32 Quarters
REC_ID varchar2(10) Unique code
RES_ID varchar2(12) Source identification
REV_AMT int64 Reversed amount
RNG_CODE varchar2(10) Partner administration
SELL_AMT int64 Amount to be invoiced
SELL_QTY decimal Quantity to be invoiced
SRC_ID varchar2(10) Source identification
SRC_TYPE decimal Source type
SUB_NR varchar2(10) Customer/supplier number
TRN_DATE datetime Change date
TRN_DESC varchar2(40) Transaction description
TRN_QTY decimal Quantity (agr)
TRN_WGT decimal Weight
VAT_AMT int64 Importo IVA
VAT_CODE varchar2(2) Codice IVA
VOUCHER_NR varchar2(15) Document number
WKR_TRN char Transaction charged to free allowance WKR
XML_DATA varchar2(4) Data in XML format