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

ART_LINE: AccountView Item lines

read only per partition

  • Catálogo: AccountView
  • Label: Item lines

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla ART_LINE. 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
ACT_COST int64 Actual costs
ACT_PROC int64 Actual revenues
AG_CODE varchar2(5) Item group code
AL_PROC char Item line processed
ART_AMT int64 Item amount
ART_BM char Composition
ART_CA char Composite item
ART_CODE varchar2(15) Código de artículo
ART_CUR int64 Sales/purchase price per piece FC
ART_DATE datetime Receipt/delivery date
ART_DESC1 varchar2(40) Order line description
ART_LEVEL int32 Composition level
ART_PX int64 Sales/purchase price
ART_QTY decimal Quantity received/delivered
ART_QTYP decimal Quantity received/delivered (price unit)
ART_QTYU decimal Quantity received/delivered (unit)
ART_WEEK int32 Receipt/delivery date (week)
BM_TAG varchar2(10) Unique key item composition
COGS_AMT int64 Cost of sales amount
COGS_QTY decimal Cost price quantity
COGS_SUSP char Cost price posting deferred
COST_CODE varchar2(10) Cost centre code
CST_AMT int64 Amount posted
CUR_AMT int64 Currency amount
DECL_AMT int64 Chargeable amount
DISC_AMT int64 Discount amount
DISC_CUR int64 Discount amount FC
DISC_PCT decimal Discount percentage
EMP_NR varchar2(10) Employee code
HDR_ID varchar2(10) Unique code of header record
HDR_TYPE decimal Stock movement type
ICAT_CODE varchar2(1) IS goods flow category
ICNT_SRC varchar2(2) IS country of origin
ICNT_TGT varchar2(2) IS country of destination
INV_DESC varchar2(40) Transaction invoice description
INV_NR varchar2(10) Document/invoice number
IS_CNTNR decimal IS container
IS_CUSTCD varchar2(2) IS TARIC code (customs code)
IS_MONTH decimal IS dating
IS_WEIGHT decimal IS weight
ISHP_CODE varchar2(1) IS mode of transport
ISXF_CODE varchar2(3) IS statistical factor code
ISYS_CODE varchar2(2) IS regime
ITEM_DESC varchar2(40) Transaction description
ITEM_QTY decimal Quantity
ITYP_CODE varchar2(1) IS transaction code
LINK_ID varchar2(10) Project journal link
LOC_CODE varchar2(5) Warehouse location
ORD_QTY decimal Quantity ordered
ORD_QTYP decimal Quantity ordered (price unit)
ORD_QTYU decimal Quantity ordered (unit)
ORG_ORDNR varchar2(10) Original order number
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PC_CODE varchar2(5) Cost type
PC_DIM varchar2(5) Cost type as dimension
PER_PROJ decimal Project period
PIP_AMT int64 Expected purchase invoice amount
PIP_CUR int64 Expected purchase invoice amount FC
POL_ID varchar2(10) Order line identification
POP_AMT int64 Expected receipt amount
POP_CUR int64 Expected receipt amount FC
PREF_DATE datetime Promised delivery date
PREF_WEEK int32 Promised delivery date (week)
PROJ_CODE varchar2(10) Project code
PROJ_ID varchar2(10) Claim line identification
PROJ_TYPE int32 Project type
PX_CALC int64 Cost price (standard / last / average)
PXDIF_AMT int64 Purchase price difference
PXDIF_CUR int64 Purchase price difference FC
REC_BLK char Blocked
REC_BLKD varchar2(1) Blocked
REC_ID varchar2(10) Unique code
REM_QTY decimal Remaining lot quantity (LIFO/FIFO)
RES_ID varchar2(12) Source identification
REVA_AMT int64 Stock revaluation amount
SELL_AMT int64 Amount to be invoiced
SELL_QTY decimal Quantity to be invoiced
SPL_ID varchar2(10) Sales/purchase line code
TRN_DATE datetime Fecha de Transacción
UNT_CODE varchar2(10) Unit
UNT_CODEP varchar2(10) Price unit
UNT_CUR int64 Sales/purchase price per price unit FC
UNT_PX int64 Sales/purchase price per price unit
VAT_AMT int64 Cantidad VAT
VAT_CODE varchar2(2) Código VAT
VAT_CUR int64 VAT amount FC
WHS_CODE varchar2(5) Warehouse code
XML_DATA varchar2(4) Data in XML format