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_ |
varchar2 |
ABC category | |||
AG_ |
varchar2 |
Item group code | |||
ART_ |
varchar2 |
Artikelcode | |||
ART_ |
varchar2 |
Item code (draggable) | |||
ART_ |
decimal |
Number of packages/packaging | |||
ART_ |
varchar2 |
Item description | |||
ART_ |
varchar2 |
Item description 2 | |||
ART_ |
varchar2 |
Item type | |||
ART_ |
varchar2 |
Sales unit | |||
ART_WT |
decimal |
Net weight in kilograms | |||
ART_ |
decimal |
Gross weight in kilograms | |||
ARTQ_ |
decimal |
Sales per week | |||
ASS_ |
char |
Licence item | |||
ASS_ |
char |
Main edition | |||
ASS_ |
char |
Multiple licence item | |||
ASS_ |
char |
Do not export | |||
BASE_ |
varchar2 |
Base item | |||
C_ |
varchar2 |
Item list field 1 | |||
C_ |
varchar2 |
Item list field 2 | |||
C_ |
varchar2 |
Item list field 3 | |||
C_ |
varchar2 |
Item list field 4 | |||
C_ |
varchar2 |
Item list field 5 | |||
CI_ |
decimal |
CI sales per week | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
COMMENT1 |
varchar2 |
Item note | |||
CORD_ |
decimal |
Calculated reorder level | |||
CORD_ |
decimal |
Calculated order size | |||
CUR_ |
varchar2 |
Purchase currency code | |||
CUR_ |
varchar2 |
Sales currency code | |||
CUST_ |
decimal |
Service level | |||
DECL_ |
datetime |
Decline date | |||
DEL_ |
decimal |
Lead time in days (purchase) | |||
DESC_ |
varchar2 |
Reliability weeks of stock | |||
END_ |
datetime |
Phase-out date | |||
EST_ |
decimal |
Expected demand | |||
EST_ |
int32 |
Deviation in expected demand | |||
GROW_ |
datetime |
Growth date | |||
GRP_ |
varchar2 |
Shop group code | |||
ICOM_ |
varchar2 |
IS goods code | |||
IMG_ |
varchar2 |
Binary data large image | |||
IMG_ |
varchar2 |
Large image | |||
IMG_ |
varchar2 |
Binary data normal image | |||
IMG_ |
varchar2 |
Default image | |||
IMG_ |
varchar2 |
Binary data small image | |||
IMG_ |
varchar2 |
Small image | |||
INFO_ |
varchar2 |
URL for more info | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
INTR_ |
datetime |
Introduction date | |||
INV_ |
int64 |
Stock costs per piece | |||
INV_ |
int64 |
Stock value | |||
LOC_ |
varchar2 |
Warehouse location | |||
MAT_ |
datetime |
Maturity date | |||
MAX_ |
decimal |
Maximum stock | |||
MIN_ |
decimal |
Minimum stock | |||
MIN_ |
decimal |
Minimum order size | |||
NO_ |
char |
Do not explode on sales order | |||
NO_MFG |
char |
Do not explode as component in production order | |||
ORD_ |
int64 |
Ordering costs | |||
ORD_ |
varchar2 |
Formula | |||
ORD_ |
decimal |
Reorder level | |||
ORD_ |
decimal |
Order limit | |||
ORD_ |
char |
Multiple of min. order size | |||
ORD_ |
decimal |
Order size | |||
PACK_ |
varchar2 |
Packaging | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_ |
varchar2 |
Cost type code | |||
PHASE |
varchar2 |
Life cycle phase | |||
PICK_ |
varchar2 |
Warehouse picking strategy | |||
PO_DAY |
int32 |
Order day | |||
PO_ |
int32 |
Order time | |||
PO_ |
int32 |
Order interval | |||
PO_ |
decimal |
Order method | |||
PU_ |
int32 |
Quantity per package purchase | |||
PU_ |
varchar2 |
Purchase unit | |||
PX_ |
int64 |
Valuation price | |||
PX_GR |
char |
Sales price including VAT | |||
PX_ |
int64 |
New standard price | |||
PX_ |
int64 |
Purchase price | |||
PX_ |
int64 |
Price for monthly service settlement | |||
PX_ |
int64 |
Verkaufspreis | |||
PX_ |
int64 |
Amount (calculated field) | |||
QT1_ |
varchar2 |
Quotation group code | |||
QTY_ |
decimal |
Quantity processed | |||
QTY_ |
decimal |
Quantity available | |||
QTY_ |
decimal |
Quantity economic | |||
QTY_ |
decimal |
Quantity free | |||
QTY_ |
decimal |
Quantity deferred | |||
QTY_ |
decimal |
Quantity in process | |||
QTY_ |
decimal |
To be ordered | |||
QTY_PO |
decimal |
Quantity ordered (purchase) | |||
QTY_ |
decimal |
Quantity received (purchase) | |||
QTY_ |
decimal |
Quantity reserved | |||
QTY_ |
decimal |
Quantity on backorder (sales) | |||
QTY_ |
decimal |
Quantity shipped (sales) | |||
QTY_SO |
decimal |
Quantity on order (sales) | |||
QTY_ |
decimal |
Number of stock movements | |||
QTY_ |
decimal |
Quantity technical | |||
QTY_ |
decimal |
Quantity in work in progress | |||
QTYB_ |
decimal |
Quantity processed, blocked | |||
QTYB_ |
decimal |
Quantity available, blocked | |||
QTYB_ |
decimal |
Quantity economic, blocked | |||
QTYB_ |
decimal |
Quantity free, blocked | |||
QTYB_ |
decimal |
Quantity deferred, blocked | |||
QTYB_ |
decimal |
Quantity in process, blocked | |||
QTYB_ |
decimal |
Quantity ordered, blocked (purchase) | |||
QTYB_ |
decimal |
Quantity received, blocked (purchase) | |||
QTYB_ |
decimal |
Quantity reserved, blocked | |||
QTYB_ |
decimal |
Quantity on backorder, blocked (sales) | |||
QTYB_ |
decimal |
Quantity shipped, blocked (sales) | |||
QTYB_ |
decimal |
Quantity on order, blocked (sales) | |||
QTYB_ |
decimal |
Number of stock movements, blocked | |||
QTYB_ |
decimal |
Quantity technical, blocked | |||
QTYB_ |
decimal |
Quantity in work in progress, blocked | |||
QTYF_ |
decimal |
Quantity processed, not blocked | |||
QTYF_ |
decimal |
Quantity available, not blocked | |||
QTYF_ |
decimal |
Quantity economic, not blocked | |||
QTYF_ |
decimal |
Quantity free, not blocked | |||
QTYF_ |
decimal |
Quantity deferred, not blocked | |||
QTYF_ |
decimal |
Quantity in process, not blocked | |||
QTYF_ |
decimal |
Quantity ordered, not blocked (purchase) | |||
QTYF_ |
decimal |
Quantity received, not blocked (purchase) | |||
QTYF_ |
decimal |
Quantity reserved, not blocked | |||
QTYF_ |
decimal |
Quantity on backorder, not blocked (sales) | |||
QTYF_ |
decimal |
Quantity shipped, not blocked (sales) | |||
QTYF_ |
decimal |
Quantity on order, not blocked (sales) | |||
QTYF_ |
decimal |
Number of stock movements, not blocked | |||
QTYF_ |
decimal |
Quantity technical, not blocked | |||
QTYF_ |
decimal |
Quantity in work in progress, not blocked | |||
REC_ |
char |
Blocked | |||
REC_ |
char |
Stock item | |||
REC_ |
char |
Maintain stock value in general ledger | |||
RPT_ |
varchar2 |
Reporting group 1 | |||
RPT_ |
varchar2 |
Reporting group 2 | |||
RPT_ |
varchar2 |
Reporting group 3 | |||
SAF_ |
decimal |
Safety stock | |||
SBS_ |
char |
Invoice once in subscription | |||
SHIP_ |
decimal |
Lead time in days (sales) | |||
SL_ |
varchar2 |
Subledger 1 | |||
SL_ |
varchar2 |
Subledger 2 | |||
SL_ |
varchar2 |
Subledger 3 | |||
STCK_ |
decimal |
Weeks of stock based on forecast | |||
STCK_ |
decimal |
Stock turnover rate | |||
STOCK_ |
decimal |
Stock type quantity display | |||
SUP_AC |
varchar2 |
Supplier item code | |||
SUP_NR |
varchar2 |
Supplier code | |||
SVC_ |
char |
Service | |||
TGT_ |
decimal |
Target stock | |||
UNIT_ |
int32 |
Quantity per package sales | |||
UNT_ |
varchar2 |
Base unit | |||
UNT_ |
varchar2 |
Purchase unit | |||
UNT_ |
varchar2 |
Purchase price unit | |||
UNT_ |
varchar2 |
Sales unit | |||
UNT_ |
varchar2 |
Sales price unit | |||
VAT_ |
varchar2 |
VAT code purchase | |||
VAT_ |
varchar2 |
VAT code sales | |||
WHS_ |
varchar2 |
Warehouse code | |||
WK_ |
decimal |
Weeks of stock based on history |