invantive documentation
Forum di supporto InvantiveAccedi / Registrati

ARTICLE: AccountView Articles

read only per partition

  • Catalogo: AccountView
  • Label: Articles

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella ARTICLE. 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
ABC_CODE varchar2(1) ABC category
AG_CODE varchar2(5) Item group code
ART_CODE varchar2(15) Codice articolo
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 Prezzo di vendita
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