invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_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 Precio de Costo
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 Cantidad VAT
VAT_CODE varchar2(2) Código VAT
VOUCHER_NR varchar2(15) Document number
WKR_TRN char Transaction charged to free allowance WKR
XML_DATA varchar2(4) Data in XML format