invantive documentation
Invantive SupportforenAnmelden / Eintragen

ARTICLE: AccountView Articles

read only per partition

  • Katalog: AccountView
  • Label: Articles

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle ARTICLE sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
ABC_CODE varchar2(1) ABC category
AG_CODE varchar2(5) Item group code
ART_CODE varchar2(15) Artikelcode
ART_CODE_D varchar2(15) Item code (draggable)
ART_COLLI decimal Number of packages/packaging
ART_DESC1 varchar2(40) Item description
ART_DESC2 varchar2(40) Item description 2
ART_MBM varchar2(20) Item type
ART_UNIT varchar2(5) Sales unit
ART_WT decimal Net weight in kilograms
ART_WTGR decimal Gross weight in kilograms
ARTQ_WK decimal Sales per week
ASS_ART char Licence item
ASS_MAIN char Main edition
ASS_MULT char Multiple licence item
ASS_NOEXP char Do not export
BASE_ART varchar2(15) Base item
C_CRIT_01 varchar2(10) Item list field 1
C_CRIT_02 varchar2(10) Item list field 2
C_CRIT_03 varchar2(10) Item list field 3
C_CRIT_04 varchar2(10) Item list field 4
C_CRIT_05 varchar2(10) Item list field 5
CI_ARTQWK decimal CI sales per week
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
COMMENT1 varchar2(4) Item note
CORD_INV decimal Calculated reorder level
CORD_SIZE decimal Calculated order size
CUR_PCHS varchar2(3) Purchase currency code
CUR_SELL varchar2(3) Sales currency code
CUST_SERV decimal Service level
DECL_DATE datetime Decline date
DEL_DAYS decimal Lead time in days (purchase)
DESC_AQWK varchar2(20) Reliability weeks of stock
END_DATE datetime Phase-out date
EST_DEM decimal Expected demand
EST_DEV int32 Deviation in expected demand
GROW_DATE datetime Growth date
GRP_CODE varchar2(10) Shop group code
ICOM_CODE varchar2(10) IS goods code
IMG_L_DATA varchar2(4) Binary data large image
IMG_LARGE varchar2(4) Large image
IMG_M_DATA varchar2(4) Binary data normal image
IMG_MEDIUM varchar2(4) Default image
IMG_S_DATA varchar2(4) Binary data small image
IMG_SMALL varchar2(4) Small image
INFO_URL varchar2(200) URL for more info
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
INTR_DATE datetime Introduction date
INV_COST int64 Stock costs per piece
INV_VAL int64 Stock value
LOC_CODE varchar2(5) Warehouse location
MAT_DATE datetime Maturity date
MAX_INV decimal Maximum stock
MIN_INV decimal Minimum stock
MIN_SIZE decimal Minimum order size
NO_EXPL char Do not explode on sales order
NO_MFG char Do not explode as component in production order
ORD_COST int64 Ordering costs
ORD_EXP varchar2(5) Formula
ORD_INV decimal Reorder level
ORD_MAX decimal Order limit
ORD_RND char Multiple of min. order size
ORD_SIZE decimal Order size
PACK_CODE varchar2(15) Packaging
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PC_CODE varchar2(5) Cost type code
PHASE varchar2(25) Life cycle phase
PICK_STGY varchar2(25) Warehouse picking strategy
PO_DAY int32 Order day
PO_FREQ int32 Order time
PO_INTERV int32 Order interval
PO_TYPE decimal Order method
PU_SIZE int32 Quantity per package purchase
PU_UNIT varchar2(5) Purchase unit
PX_CALC int64 Valuation price
PX_GR char Sales price including VAT
PX_N_CALC int64 New standard price
PX_PCHS int64 Purchase price
PX_SAAS int64 Price for monthly service settlement
PX_SELL int64 Verkaufspreis
PX_TEMP int64 Amount (calculated field)
QT1_GRP varchar2(10) Quotation group code
QTY_ACT decimal Quantity processed
QTY_AVAIL decimal Quantity available
QTY_ECON decimal Quantity economic
QTY_FREE decimal Quantity free
QTY_JOUR decimal Quantity deferred
QTY_MFG decimal Quantity in process
QTY_ORD_EX decimal To be ordered
QTY_PO decimal Quantity ordered (purchase)
QTY_RECD decimal Quantity received (purchase)
QTY_RES decimal Quantity reserved
QTY_SBO decimal Quantity on backorder (sales)
QTY_SHIP decimal Quantity shipped (sales)
QTY_SO decimal Quantity on order (sales)
QTY_TBJ decimal Number of stock movements
QTY_TECH decimal Quantity technical
QTY_WIP decimal Quantity in work in progress
QTYB_ACT decimal Quantity processed, blocked
QTYB_AVAIL decimal Quantity available, blocked
QTYB_ECON decimal Quantity economic, blocked
QTYB_FREE decimal Quantity free, blocked
QTYB_JOUR decimal Quantity deferred, blocked
QTYB_MFG decimal Quantity in process, blocked
QTYB_PO decimal Quantity ordered, blocked (purchase)
QTYB_RECD decimal Quantity received, blocked (purchase)
QTYB_RES decimal Quantity reserved, blocked
QTYB_SBO decimal Quantity on backorder, blocked (sales)
QTYB_SHIP decimal Quantity shipped, blocked (sales)
QTYB_SO decimal Quantity on order, blocked (sales)
QTYB_TBJ decimal Number of stock movements, blocked
QTYB_TECH decimal Quantity technical, blocked
QTYB_WIP decimal Quantity in work in progress, blocked
QTYF_ACT decimal Quantity processed, not blocked
QTYF_AVAIL decimal Quantity available, not blocked
QTYF_ECON decimal Quantity economic, not blocked
QTYF_FREE decimal Quantity free, not blocked
QTYF_JOUR decimal Quantity deferred, not blocked
QTYF_MFG decimal Quantity in process, not blocked
QTYF_PO decimal Quantity ordered, not blocked (purchase)
QTYF_RECD decimal Quantity received, not blocked (purchase)
QTYF_RES decimal Quantity reserved, not blocked
QTYF_SBO decimal Quantity on backorder, not blocked (sales)
QTYF_SHIP decimal Quantity shipped, not blocked (sales)
QTYF_SO decimal Quantity on order, not blocked (sales)
QTYF_TBJ decimal Number of stock movements, not blocked
QTYF_TECH decimal Quantity technical, not blocked
QTYF_WIP decimal Quantity in work in progress, not blocked
REC_BLK char Blocked
REC_INV char Stock item
REC_VAL char Maintain stock value in general ledger
RPT_GRP1 varchar2(10) Reporting group 1
RPT_GRP2 varchar2(10) Reporting group 2
RPT_GRP3 varchar2(10) Reporting group 3
SAF_STCK decimal Safety stock
SBS_ONCE char Invoice once in subscription
SHIP_DAYS decimal Lead time in days (sales)
SL_CODE1 varchar2(10) Subledger 1
SL_CODE2 varchar2(10) Subledger 2
SL_CODE3 varchar2(10) Subledger 3
STCK_COV decimal Weeks of stock based on forecast
STCK_TO decimal Stock turnover rate
STOCK_TYPE decimal Stock type quantity display
SUP_AC varchar2(15) Supplier item code
SUP_NR varchar2(10) Supplier code
SVC_ART char Service
TGT_INV decimal Target stock
UNIT_SIZE int32 Quantity per package sales
UNT_CODE varchar2(10) Base unit
UNT_PCHS varchar2(10) Purchase unit
UNT_PCHSP varchar2(10) Purchase price unit
UNT_SELL varchar2(10) Sales unit
UNT_SELLP varchar2(10) Sales price unit
VAT_PCHS varchar2(2) VAT code purchase
VAT_SELL varchar2(2) VAT code sales
WHS_CODE varchar2(5) Warehouse code
WK_STCK decimal Weeks of stock based on history